Foundations Of Geographic Information Systems Assignment Package

profileusaggwp
Assignment4.zip

Assignment 4/Little Rock Metro/LittleRock_Metro.cpg

UTF-8

__MACOSX/Assignment 4/Little Rock Metro/._LittleRock_Metro.cpg

Assignment 4/Little Rock Metro/LittleRock_Metro.dbf

CSAFP10 CBSAFP10 GEOID10 NAME10 NAMELSAD10 LSAD10 MEMI10 MTFCC10 ALAND10 AWATER10 INTPTLAT10 INTPTLON10 GISJOIN Shape_area Shape_len
340 30780 30780 Little Rock-North Little Rock-Conway, AR Little Rock-North Little Rock-Conway, AR Metro Area M1 1 G3110 1.05805942430e+010 2.93548331000e+008 +34.7558188 -092.4007324 G30780 1.08741379044e+010 6.54377630114e+005

__MACOSX/Assignment 4/Little Rock Metro/._LittleRock_Metro.dbf

Assignment 4/Little Rock Metro/LittleRock_Metro.prj

PROJCS["USA_Contiguous_Albers_Equal_Area_Conic",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-96.0],PARAMETER["Standard_Parallel_1",29.5],PARAMETER["Standard_Parallel_2",45.5],PARAMETER["Latitude_Of_Origin",37.5],UNIT["Meter",1.0]]

__MACOSX/Assignment 4/Little Rock Metro/._LittleRock_Metro.prj

Assignment 4/Little Rock Metro/LittleRock_Metro.sbn

__MACOSX/Assignment 4/Little Rock Metro/._LittleRock_Metro.sbn

Assignment 4/Little Rock Metro/LittleRock_Metro.sbx

__MACOSX/Assignment 4/Little Rock Metro/._LittleRock_Metro.sbx

Assignment 4/Little Rock Metro/LittleRock_Metro.shp

__MACOSX/Assignment 4/Little Rock Metro/._LittleRock_Metro.shp

Assignment 4/Little Rock Metro/LittleRock_Metro.shp.UL-PRM6-006.7232.11232.sr.lock

__MACOSX/Assignment 4/Little Rock Metro/._LittleRock_Metro.shp.UL-PRM6-006.7232.11232.sr.lock

Assignment 4/Little Rock Metro/LittleRock_Metro.shp.xml

U.S. Department of Commerce, U.S. Census Bureau, Geography Division 2010 NHGIS: TIGER/Line Shapefile, 2010, 2010 nation, U.S., 2010 Census Metropolitan Statistical Area/Micropolitan Statistical Area (CBSA) National 2010 vector digital data http://www.nhgis.org Minnesota Population Center The NHGIS is a National Institutes of Health and National Science Foundation-sponsored project to create a digital spatial-temporal database of all available historical US aggregate census materials. The available shapefiles on the NHGIS site represent version 2.0 of historical US state/territory boundary files for the 1790 to 2010 decennial censuses and American Community Survey releases. The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line File is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. Metropolitan and Micropolitan Statistical Areas are together termed Core Based Statistical Areas (CBSAs) and are defined by the Office of Management and Budget (OMB) and consist of the county or counties or equivalent entities associated with at least one urban core (urbanized area or urban cluster) of at least 10,000 population, plus adjacent counties having a high degree of social and economic integration with the core as measured through commuting ties with the counties containing the core. Categories of CBSAs are: Metropolitan Statistical Areas, based on urbanized areas of 50,000 or more population, and Micropolitan Statistical Areas, based on urban clusters of at least 10,000 population but less than 50,000 population. The CBSAs for the 2010 Census are those defined by OMB and published in December 2009. These data are based upon work supported by the National Institutes of Health and the National Science Foundation. Its purpose is twofold. First, the NHGIS created and freely distributes a database incorporating all available aggregate census information for the United States between 1790 and 2010. The database contains information for a wide variety of statistical (blocks, block groups, census tracts, metropolitan statistical areas, etc.) and administrative units (places, minor civil divisions, counties, states, etc.). Second, the NHGIS produced and freely distributes boundary files for small areas (census tracts and counties) in the United States. Boundary files for tracts are available for the 1910-2010 decennial censuses and American Community Survey releases, and boundary files for counties and states/territories are available for the 1790-2010 decennial censuses and American Community Survey releases. The boundaries contained in this file do not necessarily represent current legal boundaries. Instead, they represent the boundaries over which the U.S. Census Bureau tabulated and published data at that time. In order for others to use the information in the Census MAF/TIGER database in a geographic information system (GIS) or for other geographic applications, the Census Bureau releases to the public extracts of the database in the form of TIGER/Line Shapefiles. United States,US 201001 201007 publication date Complete TIGER/Line Shapefiles are extracted from the Census MAF/TIGER database. No changes or updates will be made to this version of the TIGER/Line Shapefiles. Future releases of TIGER/Line Shapefiles will reflect updates made to the Census MAF/TIGER database. -179.231086 179.859681 71.441059 17.831509 ISO 19115 Topic Categories boundaries None Nation Polygon Core Based Statistical Area CBSA INCITS.38-200x (R2004),INCITS.31-200x (R2007),INCITS.454-200x,INCITS 455-200x,INCITS 446-2008 United States U.S. None This dataset was produced with an intended application at the state/territory, regional or national level. Appropriate uses include thematic mapping of census data and spatial analysis of census data. These unaltered data may be redistributed by a third party. If these data are altered or incorporated into another dataset, they are not to be redistributed without also: altering the name of the dataset, including a Content Standards for Digital Geospatial Metadata (FGDC-STD-001-1998) compliant metadata file that describes the dataset and reflects the alteration steps that makes the new dataset different from this one, and citing this dataset in the metadata as a source for the altered dataset using the source citation specified below. If these digital data are used in the production of a report or in the compilation of a standalone printed map, then this dataset is to be cited in the report or on the map using the source citation specified below. The following source citation should be used when citing this dataset: Minnesota Population Center. National Historical Geographic Information System: Version 2.0, Minneapolis: MN, University of Minnesota 2011. No fee may be charged for use or distribution. Publications and research reports based on the database must cite it appropriately. Users are requested to send a copy of any publications, research reports, or educational material making use of the data or documentation. Printed matter should be sent to: NHGIS Minnesota Population Center University of Minnesota 50 Willey Hall 225 19th Avenue South Minneapolis, MN 55455. The TIGER/Line Shapefile products are not copyrighted however TIGER/Line and Census TIGER are registered trademarks of the U.S. Census Bureau. These products are free to use in a product or publication, however acknowledgement must be given to the U.S. Census Bureau as the source. The boundary information in the TIGER/Line Shapefiles are for statistical data collection and tabulation purposes only; their depiction and designation for statistical purposes does not constitute a determination of jurisdictional authority or rights of ownership or entitlement and they are not legal land descriptions.Coordinates in the TIGER/Line shapefiles have six implied decimal places, but the positional accuracy of these coordinates is not as great as the six decimal places suggest. Yes, the data are free from Title 13 restrictions Minnesota Population Center mailing address 50 Willey Hall Minneapolis MN 55455 United States 225 19th Ave S 612-625-7375 [email protected] 8859part1 eng Accurate against Federal Information Processing Standards (FIPS), FIPS Publication 6-4, and FIPS-55 at the 100% level for the codes and base names. The remaining attribute information has been examined but has not been fully tested for accuracy. The Census Bureau performed automated tests to ensure logical consistency and limits of shapefiles. Segments making up the outer and inner boundaries of a polygon tie end-to-end to completely enclose the area. All polygons are tested for closure. The Census Bureau uses its internally developed geographic update system to enhance and modify spatial and attribute data in the Census MAF/TIGER database. Standard geographic codes, such as FIPS codes for states, counties, municipalities, county subdivisions, places, American Indian/Alaska Native/Native Hawaiian areas, and congressional districts are used when encoding spatial entities. The Census Bureau performed spatial data tests for logical consistency of the codes during the compilation of the original Census MAF/TIGER database files. Most of the codes for geographic entities except states, counties, urban areas, Core Based Statistical Areas (CBSAs), American Indian Areas (AIAs), and congressional districts were provided to the Census Bureau by the USGS, the agency responsible for maintaining FIPS 55. Feature attribute information has been examined but has not been fully tested for consistency. For the TIGER/Line Shapefiles, the Point and Vector Object Count for the G-polygon SDTS Point and Vector Object Type reflects the number of records in the shapefile attribute table. For multi-polygon features, only one attribute record exists for each multi-polygon rather than one attribute record per individual G-polygon component of the multi-polygon feature. TIGER/Line Shapefile multi-polygons are an exception to the G-polygon object type classification. Therefore, when multi-polygons exist in a shapefile, the object count will be less than the actual number of G-polygons. Data completeness of the TIGER/Line Shapefiles reflects the contents of the Census MAF/TIGER database at the time the TIGER/Line Shapefiles were created. U.S. Department of Commerce, U.S. Census Bureau, Geography Division Unpublished material Census MAF/TIGER database online 201001 201007 publication date MAF/TIGER The selected geographic and cartographic information (line segments) are derived from the U.S. Census Bureau's Master Address File Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) database. TIGER/Line Shapefiles are extracted from the Census MAF/TIGER database by nation, state, county, and entity. Census MAF/TIGER data for all of the aforementioned geographic entities are then distributed among the shapefiles each containing attributes for line, polygon, or landmark geographic data. Census MAF/TIGER 2010 Dataset Copied. Erased coastal water features. Added and calculated GISJOIN. Corrected coastal water features on 12-19-2013 in a number of states. Re-erased coastal water feature using corrected water layer. Correction only affected the geometry of existing features; no features were removed in this process. Federal Information Processing Standards (FIPS), ANSI, and feature names. Vector Simple FALSE 0 FALSE FALSE North American Datum of 1983 in the 48 contiguous states, the District of Columbia, Alaska, Hawaii, Puerto Rico, the Virgin Islands of the United States, and the Pacific Island Areas. Geodetic Reference System 80 6378137 298257 CBSA10.shp 2010 Census Metropolitan Statistical Area/Micropolitan Statistical Area (CBSA) National U.S. Census Bureau Feature Class 0 FID FID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 0 0 0 Feature geometry. Esri Coordinates defining the features. CSAFP10 2010 Census combined statistical area code, if applicable U.S. Census Bureau 100 599 CSAFP10 String 3 0 0 CBSAFP10 2010 Census metropolitan statistical area/micropolitan statistical area code U.S. Census Bureau 10000 49999 CBSAFP10 String 5 0 0 GEOID10 Metropolitan statistical area/micropolitan statistical area identifier, metropolitan statistical area/micropolitan statistical area code U.S. Census Bureau 2010 Census metropolitan statistical area/micropolitan statistical area code found in CBSAFP10 GEOID10 String 5 0 0 NAME10 2010 Census metropolitan statistical area/micropolitan statistical area name U.S. Census Bureau Refer to the online Metropolitan Statistical Area/ Micropolitan Statistical Area file at URL:http://www.census.gov/population/www/estimates/metroarea.html U.S. Census Bureau NAME10 String 100 0 0 NAMELSAD10 2010 Census name and the translated legal/statistical area description for metropolitan statistical area/micropolitan statistical area U.S. Census Bureau Refer to the online Metropolitan Statistical Area/Micropolitan Statistical Area file at URL: http://www.census.gov/population/www/estimates/metroarea.html and the translated legal/statistical area description code for Metropolitan Statistical Area/Micropolitan Statistical Area name that appears in LSAD U.S. Census Bureau NAMELSAD10 String 100 0 0 LSAD10 2010 Census legal/statistical area description code for metropolitan statistical area/micropolitan statistical area U.S. Census Bureau M1 Metropolitan Statistical Area U.S. Census Bureau M2 Micropolitan Statistical Area U.S. Census Bureau LSAD10 String 2 0 0 MEMI10 2010 Census metropolitan/micropolitan status indicator U.S. Census Bureau 1 Metropolitan U.S. Census Bureau 2 Micropolitan U.S. Census Bureau MEMI10 String 1 0 0 MTFCC10 MAF/TIGER feature class code U.S. Census Bureau G3110 Metropolitan and Micropolitan Statistical Area U.S. Census Bureau MTFCC10 String 5 0 0 ALAND10 2010 Census land area (square meters) U.S. Census Bureau 0 to 9,999,999,999,999 Blank U.S. Census Bureau ALAND10 Double 14 14 0 AWATER10 2010 Census water area (square meters) U.S. Census Bureau 0 to 9,999,999,999,999 Blank U.S. Census Bureau AWATER10 Double 14 14 0 INTPTLAT10 2010 Census latitude of the internal point U.S. Census Bureau 00 Blank U.S. Census Bureau INTPTLAT10 String 11 0 0 INTPTLON10 2010 Census longitude of the internal point U.S. Census Bureau 00 Blank U.S. Census Bureau INTPTLON10 String 12 0 0 GISJOIN GISJOIN String 6 0 0 unique identifier for joining to NHGIS tabular data NHGIS Shape_area Shape_area Double 19 0 0 Area of feature in internal units squared. Esri Positive real numbers that are automatically generated. Shape_len Shape_len Double 19 0 0 Minnesota Population Center mailing address 50 Willey Hall Minneapolis MN 55455 United States 225 19th Ave S 612-625-7375 [email protected] No warranty, expressed or implied is made with regard to the accuracy of these data, and no liability is assumed by the U.S. Government in general or the U.S. Census Bureau in specific as to the spatial or attribute accuracy of the data. The act of distribution shall not constitute any such warranty and no responsibility is assumed by the U.S. government in the use of these files. The boundary information in the TIGER/Line Shapefiles is for statistical data collection and tabulation purposes only; their depiction and designation for statistical purposes do not constitute a determination of jurisdictional authority or rights of ownership or entitlement and they are not legal land descriptions. TGRSHP (compressed) PK-ZIP, version 1.93 A or higher http://www.census.gov/geo/www/tiger DVD-ROM (Only if offered offline) ISO 9660 NHGIS files may be accessed without charge. The TIGER/Line shapefiles contain geographic data only and do not include display mapping software or statistical data. For information on how to use the TIGER/Line shapefile data with specific software package users shall contact the company that produced the software. 20100507 Minnesota Population Center mailing address 50 Willey Hall Minneapolis MN 55455 United States 225 19th Ave S 612-625-7375 [email protected] FGDC Content Standards for Digital Geospatial Metadata FGDC-STD-001-1998 8859part1 tl_2010_us_cbsa10.shp.xml eng Microsoft Windows 7 Version 6.1 (Build 7601) Service Pack 1; Esri ArcGIS 10.1.1.3143 US_cbsa_2010 1 -180.000000 180.000000 72.509979 1.316355 US_cbsa_2010 002 0.000 file://\\MPC-5DBDFQ1\C$\Workspace\NHGIS_2010Update\US_cbsa_2010.shp Local Area Network -6858340.773000 3204351.838100 -2078742.008700 3605180.431100 1 Projected GCS_North_American_1983 Linear Unit: Meter (1.000000) <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.1'><WKT>PROJCS[&quot;USA_Contiguous_Albers_Equal_Area_Conic&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Albers&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-96.0],PARAMETER[&quot;Standard_Parallel_1&quot;,29.5],PARAMETER[&quot;Standard_Parallel_2&quot;,45.5],PARAMETER[&quot;Latitude_Of_Origin&quot;,37.5],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;ESRI&quot;,102003]]</WKT><XOrigin>-16901100</XOrigin><YOrigin>-8579000</YOrigin><XYScale>266467840.99085236</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102003</WKID><LatestWKID>102003</LatestWKID></ProjectedCoordinateSystem> USA_Contiguous_Albers_Equal_Area_Conic Merge C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp C:\Workspace\TIGER2010\CBSA\2010\unzipped\merge\tl2010_2010_cbsa.shp "CSAFP10 "CSAFP10" true true false 3 Text 0 0 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,CSAFP10,-1,-1;CBSAFP10 "CBSAFP10" true true false 5 Text 0 0 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,CBSAFP10,-1,-1;GEOID10 "GEOID10" true true false 5 Text 0 0 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,GEOID10,-1,-1;NAME10 "NAME10" true true false 100 Text 0 0 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,NAME10,-1,-1;NAMELSAD10 "NAMELSAD10" true true false 100 Text 0 0 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,NAMELSAD10,-1,-1;LSAD10 "LSAD10" true true false 2 Text 0 0 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,LSAD10,-1,-1;MEMI10 "MEMI10" true true false 1 Text 0 0 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,MEMI10,-1,-1;MTFCC10 "MTFCC10" true true false 5 Text 0 0 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,MTFCC10,-1,-1;ALAND10 "ALAND10" true true false 14 Double 0 14 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,ALAND10,-1,-1;AWATER10 "AWATER10" true true false 14 Double 0 14 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,AWATER10,-1,-1;INTPTLAT10 "INTPTLAT10" true true false 11 Text 0 0 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,INTPTLAT10,-1,-1;INTPTLON10 "INTPTLON10" true true false 12 Text 0 0 ,First,#,C:\Workspace\TIGER2010\CBSA\2010\unzipped\tl_2010_us_cbsa10.shp,INTPTLON10,-1,-1" Project C:\Workspace\TIGER2010\CBSA\2010\unzipped\merge\tl2010_2010_cbsa.shp C:\Users\borah\Documents\NHGIS_dev.sde\nhgis_dev.BORAH.tl2010_2010_cbsa PROJCS['North_America_Albers_Equal_Area_Conic',GEOGCS['GCS_North_American_1983',DATUM['D_North_American_1983',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Albers'],PARAMETER['False_Easting',0.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-96.0],PARAMETER['Standard_Parallel_1',20.0],PARAMETER['Standard_Parallel_2',60.0],PARAMETER['Latitude_Of_Origin',40.0],UNIT['Meter',1.0]] # GEOGCS['GCS_North_American_1983',DATUM['D_North_American_1983',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]] AddField C:\Users\borah\Documents\NHGIS_dev.sde\nhgis_dev.BORAH.tl2010_2010_cbsa GISJOIN TEXT # # 6 # NULLABLE NON_REQUIRED # CalculateField C:\Users\borah\Documents\NHGIS_dev.sde\nhgis_dev.BORAH.tl2010_2010_cbsa GISJOIN ""G" & [GEOID10]" VB # Rename C:\Users\borah\Documents\NHGIS_dev.sde\nhgis_dev.BORAH.tl2010_2010_cbsa C:\Users\borah\Documents\NHGIS_dev.sde\nhgis_dev.BORAH.tl2010_2010_cbsa_Rename FeatureClass Project C:\Users\borah\Documents\NHGIS_dev.sde\nhgis_dev.BORAH.tl2010_2010_cbsa_Rename C:\Users\borah\Documents\NHGIS_dev.sde\nhgis_dev.BORAH.tl2010_2010_cbsa PROJCS['USA_Contiguous_Albers_Equal_Area_Conic',GEOGCS['GCS_North_American_1983',DATUM['D_North_American_1983',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Albers'],PARAMETER['False_Easting',0.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-96.0],PARAMETER['Standard_Parallel_1',29.5],PARAMETER['Standard_Parallel_2',45.5],PARAMETER['Latitude_Of_Origin',37.5],UNIT['Meter',1.0]] # PROJCS['North_America_Albers_Equal_Area_Conic',GEOGCS['GCS_North_American_1983',DATUM['D_North_American_1983',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Albers'],PARAMETER['False_Easting',0.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-96.0],PARAMETER['Standard_Parallel_1',20.0],PARAMETER['Standard_Parallel_2',60.0],PARAMETER['Latitude_Of_Origin',40.0],UNIT['Meter',1.0]] Erase nhgis_dev.BORAH.tl2010_2010_cbsa nhgis_dev.BORAH.US_All_2010_water_final C:\Workspace\NHGIS_2010Update\US_cbsa_2010.shp # CalculateField Z:\istads\data\shape\tl2010\base\nongen\cbsa\US_cbsa_2010.shp Shape_Area "!shape.area@squaremeters! " PYTHON # CalculateField Z:\istads\data\shape\tl2010\base\nongen\cbsa\US_cbsa_2010.shp Shape_Len "!shape.length@METERS! " PYTHON # 20131213 11533800 20131213 11533800 20181016 13190100 1.0 FALSE FGDC CSDGM Metadata Shapefile 0.000 dataset ESRI 10.1.1 0 20131213

__MACOSX/Assignment 4/Little Rock Metro/._LittleRock_Metro.shp.xml

Assignment 4/Little Rock Metro/LittleRock_Metro.shx

__MACOSX/Assignment 4/Little Rock Metro/._LittleRock_Metro.shx

__MACOSX/Assignment 4/._Little Rock Metro

Assignment 4/Policyholders/AAI_Policies.cpg

UTF-8

__MACOSX/Assignment 4/Policyholders/._AAI_Policies.cpg

Assignment 4/Policyholders/AAI_Policies.dbf

CID PolicyID
0 1.00000000000e+004
0 1.00010000000e+004
0 1.00020000000e+004
0 1.00030000000e+004
0 1.00040000000e+004
0 1.00050000000e+004
0 1.00060000000e+004
0 1.00070000000e+004
0 1.00080000000e+004
0 1.00090000000e+004
0 1.00100000000e+004
0 1.00110000000e+004
0 1.00120000000e+004
0 1.00130000000e+004
0 1.00140000000e+004
0 1.00150000000e+004
0 1.00160000000e+004
0 1.00170000000e+004
0 1.00180000000e+004
0 1.00190000000e+004
0 1.00200000000e+004
0 1.00210000000e+004
0 1.00220000000e+004
0 1.00230000000e+004
0 1.00240000000e+004
0 1.00250000000e+004
0 1.00260000000e+004
0 1.00270000000e+004
0 1.00280000000e+004
0 1.00290000000e+004
0 1.00300000000e+004
0 1.00310000000e+004
0 1.00320000000e+004
0 1.00330000000e+004
0 1.00340000000e+004
0 1.00350000000e+004
0 1.00360000000e+004
0 1.00370000000e+004
0 1.00380000000e+004
0 1.00390000000e+004
0 1.00400000000e+004
0 1.00410000000e+004
0 1.00420000000e+004
0 1.00430000000e+004
0 1.00440000000e+004
0 1.00450000000e+004
0 1.00460000000e+004
0 1.00470000000e+004
0 1.00480000000e+004
0 1.00490000000e+004
0 1.00500000000e+004
0 1.00510000000e+004
0 1.00520000000e+004
0 1.00530000000e+004
0 1.00540000000e+004
0 1.00550000000e+004
0 1.00560000000e+004
0 1.00570000000e+004
0 1.00580000000e+004
0 1.00590000000e+004
0 1.00600000000e+004
0 1.00610000000e+004
0 1.00620000000e+004
0 1.00630000000e+004
0 1.00640000000e+004
0 1.00650000000e+004
0 1.00660000000e+004
0 1.00670000000e+004
0 1.00680000000e+004
0 1.00690000000e+004
0 1.00700000000e+004
0 1.00710000000e+004
0 1.00720000000e+004
0 1.00730000000e+004
0 1.00740000000e+004
0 1.00750000000e+004
0 1.00760000000e+004
0 1.00770000000e+004
0 1.00780000000e+004
0 1.00790000000e+004
0 1.00800000000e+004
0 1.00810000000e+004
0 1.00820000000e+004
0 1.00830000000e+004
0 1.00840000000e+004
0 1.00850000000e+004
0 1.00860000000e+004
0 1.00870000000e+004
0 1.00880000000e+004
0 1.00890000000e+004
0 1.00900000000e+004
0 1.00910000000e+004
0 1.00920000000e+004
0 1.00930000000e+004
0 1.00940000000e+004
0 1.00950000000e+004
0 1.00960000000e+004
0 1.00970000000e+004
0 1.00980000000e+004
0 1.00990000000e+004
0 1.01000000000e+004
0 1.01010000000e+004
0 1.01020000000e+004
0 1.01030000000e+004
0 1.01040000000e+004
0 1.01050000000e+004
0 1.01060000000e+004
0 1.01070000000e+004
0 1.01080000000e+004
0 1.01090000000e+004
0 1.01100000000e+004
0 1.01110000000e+004
0 1.01120000000e+004
0 1.01130000000e+004
0 1.01140000000e+004
0 1.01150000000e+004
0 1.01160000000e+004
0 1.01170000000e+004
0 1.01180000000e+004
0 1.01190000000e+004
0 1.01200000000e+004
0 1.01210000000e+004
0 1.01220000000e+004
0 1.01230000000e+004
0 1.01240000000e+004
0 1.01250000000e+004
0 1.01260000000e+004
0 1.01270000000e+004
0 1.01280000000e+004
0 1.01290000000e+004
0 1.01300000000e+004
0 1.01310000000e+004
0 1.01320000000e+004
0 1.01330000000e+004
0 1.01340000000e+004
0 1.01350000000e+004
0 1.01360000000e+004
0 1.01370000000e+004
0 1.01380000000e+004
0 1.01390000000e+004
0 1.01400000000e+004
0 1.01410000000e+004
0 1.01420000000e+004
0 1.01430000000e+004
0 1.01440000000e+004
0 1.01450000000e+004
0 1.01460000000e+004
0 1.01470000000e+004
0 1.01480000000e+004
0 1.01490000000e+004
0 1.01500000000e+004
0 1.01510000000e+004
0 1.01520000000e+004
0 1.01530000000e+004
0 1.01540000000e+004
0 1.01550000000e+004
0 1.01560000000e+004
0 1.01570000000e+004
0 1.01580000000e+004
0 1.01590000000e+004
0 1.01600000000e+004
0 1.01610000000e+004
0 1.01620000000e+004
0 1.01630000000e+004
0 1.01640000000e+004
0 1.01650000000e+004
0 1.01660000000e+004
0 1.01670000000e+004
0 1.01680000000e+004
0 1.01690000000e+004
0 1.01700000000e+004
0 1.01710000000e+004
0 1.01720000000e+004
0 1.01730000000e+004
0 1.01740000000e+004
0 1.01750000000e+004
0 1.01760000000e+004
0 1.01770000000e+004
0 1.01780000000e+004
0 1.01790000000e+004
0 1.01800000000e+004
0 1.01810000000e+004
0 1.01820000000e+004
0 1.01830000000e+004
0 1.01840000000e+004
0 1.01850000000e+004
0 1.01860000000e+004
0 1.01870000000e+004
0 1.01880000000e+004
0 1.01890000000e+004
0 1.01900000000e+004
0 1.01910000000e+004
0 1.01920000000e+004
0 1.01930000000e+004
0 1.01940000000e+004
0 1.01950000000e+004
0 1.01960000000e+004
0 1.01970000000e+004
0 1.01980000000e+004
0 1.01990000000e+004
0 1.02000000000e+004
0 1.02010000000e+004
0 1.02020000000e+004
0 1.02030000000e+004
0 1.02040000000e+004
0 1.02050000000e+004
0 1.02060000000e+004
0 1.02070000000e+004
0 1.02080000000e+004
0 1.02090000000e+004
0 1.02100000000e+004
0 1.02110000000e+004
0 1.02120000000e+004
0 1.02130000000e+004
0 1.02140000000e+004
0 1.02150000000e+004
0 1.02160000000e+004
0 1.02170000000e+004
0 1.02180000000e+004
0 1.02190000000e+004
0 1.02200000000e+004
0 1.02210000000e+004
0 1.02220000000e+004
0 1.02230000000e+004
0 1.02240000000e+004
0 1.02250000000e+004
0 1.02260000000e+004
0 1.02270000000e+004
0 1.02280000000e+004
0 1.02290000000e+004
0 1.02300000000e+004
0 1.02310000000e+004
0 1.02320000000e+004
0 1.02330000000e+004
0 1.02340000000e+004
0 1.02350000000e+004
0 1.02360000000e+004
0 1.02370000000e+004
0 1.02380000000e+004
0 1.02390000000e+004
0 1.02400000000e+004
0 1.02410000000e+004
0 1.02420000000e+004
0 1.02430000000e+004
0 1.02440000000e+004
0 1.02450000000e+004
0 1.02460000000e+004
0 1.02470000000e+004
0 1.02480000000e+004
0 1.02490000000e+004
0 1.02500000000e+004
0 1.02510000000e+004
0 1.02520000000e+004
0 1.02530000000e+004
0 1.02540000000e+004
0 1.02550000000e+004
0 1.02560000000e+004
0 1.02570000000e+004
0 1.02580000000e+004
0 1.02590000000e+004
0 1.02600000000e+004
0 1.02610000000e+004
0 1.02620000000e+004
0 1.02630000000e+004
0 1.02640000000e+004
0 1.02650000000e+004
0 1.02660000000e+004
0 1.02670000000e+004
0 1.02680000000e+004
0 1.02690000000e+004
0 1.02700000000e+004
0 1.02710000000e+004
0 1.02720000000e+004
0 1.02730000000e+004
0 1.02740000000e+004
0 1.02750000000e+004
0 1.02760000000e+004
0 1.02770000000e+004
0 1.02780000000e+004
0 1.02790000000e+004
0 1.02800000000e+004
0 1.02810000000e+004
0 1.02820000000e+004
0 1.02830000000e+004
0 1.02840000000e+004
0 1.02850000000e+004
0 1.02860000000e+004
0 1.02870000000e+004
0 1.02880000000e+004
0 1.02890000000e+004
0 1.02900000000e+004
0 1.02910000000e+004
0 1.02920000000e+004
0 1.02930000000e+004
0 1.02940000000e+004
0 1.02950000000e+004
0 1.02960000000e+004
0 1.02970000000e+004
0 1.02980000000e+004
0 1.02990000000e+004
0 1.03000000000e+004
0 1.03010000000e+004
0 1.03020000000e+004
0 1.03030000000e+004
0 1.03040000000e+004
0 1.03050000000e+004
0 1.03060000000e+004
0 1.03070000000e+004
0 1.03080000000e+004
0 1.03090000000e+004
0 1.03100000000e+004
0 1.03110000000e+004
0 1.03120000000e+004
0 1.03130000000e+004
0 1.03140000000e+004
0 1.03150000000e+004
0 1.03160000000e+004
0 1.03170000000e+004
0 1.03180000000e+004
0 1.03190000000e+004
0 1.03200000000e+004
0 1.03210000000e+004
0 1.03220000000e+004
0 1.03230000000e+004
0 1.03240000000e+004
0 1.03250000000e+004
0 1.03260000000e+004
0 1.03270000000e+004
0 1.03280000000e+004
0 1.03290000000e+004
0 1.03300000000e+004
0 1.03310000000e+004
0 1.03320000000e+004
0 1.03330000000e+004
0 1.03340000000e+004
0 1.03350000000e+004
0 1.03360000000e+004
0 1.03370000000e+004
0 1.03380000000e+004
0 1.03390000000e+004
0 1.03400000000e+004
0 1.03410000000e+004
0 1.03420000000e+004
0 1.03430000000e+004
0 1.03440000000e+004
0 1.03450000000e+004
0 1.03460000000e+004
0 1.03470000000e+004
0 1.03480000000e+004
0 1.03490000000e+004
0 1.03500000000e+004
0 1.03510000000e+004
0 1.03520000000e+004
0 1.03530000000e+004
0 1.03540000000e+004
0 1.03550000000e+004
0 1.03560000000e+004
0 1.03570000000e+004
0 1.03580000000e+004
0 1.03590000000e+004
0 1.03600000000e+004
0 1.03610000000e+004
0 1.03620000000e+004
0 1.03630000000e+004
0 1.03640000000e+004
0 1.03650000000e+004
0 1.03660000000e+004
0 1.03670000000e+004
0 1.03680000000e+004
0 1.03690000000e+004
0 1.03700000000e+004
0 1.03710000000e+004
0 1.03720000000e+004
0 1.03730000000e+004
0 1.03740000000e+004
0 1.03750000000e+004
0 1.03760000000e+004
0 1.03770000000e+004
0 1.03780000000e+004
0 1.03790000000e+004
0 1.03800000000e+004
0 1.03810000000e+004
0 1.03820000000e+004
0 1.03830000000e+004
0 1.03840000000e+004
0 1.03850000000e+004
0 1.03860000000e+004
0 1.03870000000e+004
0 1.03880000000e+004
0 1.03890000000e+004
0 1.03900000000e+004
0 1.03910000000e+004
0 1.03920000000e+004
0 1.03930000000e+004
0 1.03940000000e+004
0 1.03950000000e+004
0 1.03960000000e+004
0 1.03970000000e+004
0 1.03980000000e+004
0 1.03990000000e+004
0 1.04000000000e+004
0 1.04010000000e+004
0 1.04020000000e+004
0 1.04030000000e+004
0 1.04040000000e+004
0 1.04050000000e+004
0 1.04060000000e+004
0 1.04070000000e+004
0 1.04080000000e+004
0 1.04090000000e+004
0 1.04100000000e+004
0 1.04110000000e+004
0 1.04120000000e+004
0 1.04130000000e+004
0 1.04140000000e+004
0 1.04150000000e+004
0 1.04160000000e+004
0 1.04170000000e+004
0 1.04180000000e+004
0 1.04190000000e+004
0 1.04200000000e+004
0 1.04210000000e+004
0 1.04220000000e+004
0 1.04230000000e+004
0 1.04240000000e+004
0 1.04250000000e+004
0 1.04260000000e+004
0 1.04270000000e+004
0 1.04280000000e+004
0 1.04290000000e+004
0 1.04300000000e+004
0 1.04310000000e+004
0 1.04320000000e+004
0 1.04330000000e+004
0 1.04340000000e+004
0 1.04350000000e+004
0 1.04360000000e+004
0 1.04370000000e+004
0 1.04380000000e+004
0 1.04390000000e+004
0 1.04400000000e+004
0 1.04410000000e+004
0 1.04420000000e+004
0 1.04430000000e+004
0 1.04440000000e+004
0 1.04450000000e+004
0 1.04460000000e+004
0 1.04470000000e+004
0 1.04480000000e+004
0 1.04490000000e+004
0 1.04500000000e+004
0 1.04510000000e+004
0 1.04520000000e+004
0 1.04530000000e+004
0 1.04540000000e+004
0 1.04550000000e+004
0 1.04560000000e+004
0 1.04570000000e+004
0 1.04580000000e+004
0 1.04590000000e+004
0 1.04600000000e+004
0 1.04610000000e+004
0 1.04620000000e+004
0 1.04630000000e+004
0 1.04640000000e+004
0 1.04650000000e+004
0 1.04660000000e+004
0 1.04670000000e+004
0 1.04680000000e+004
0 1.04690000000e+004
0 1.04700000000e+004
0 1.04710000000e+004
0 1.04720000000e+004
0 1.04730000000e+004
0 1.04740000000e+004
0 1.04750000000e+004
0 1.04760000000e+004
0 1.04770000000e+004
0 1.04780000000e+004
0 1.04790000000e+004
0 1.04800000000e+004
0 1.04810000000e+004
0 1.04820000000e+004
0 1.04830000000e+004
0 1.04840000000e+004
0 1.04850000000e+004
0 1.04860000000e+004
0 1.04870000000e+004
0 1.04880000000e+004
0 1.04890000000e+004
0 1.04900000000e+004
0 1.04910000000e+004
0 1.04920000000e+004
0 1.04930000000e+004
0 1.04940000000e+004
0 1.04950000000e+004
0 1.04960000000e+004
0 1.04970000000e+004
0 1.04980000000e+004
0 1.04990000000e+004
0 1.05000000000e+004
0 1.05010000000e+004
0 1.05020000000e+004
0 1.05030000000e+004
0 1.05040000000e+004
0 1.05050000000e+004
0 1.05060000000e+004
0 1.05070000000e+004
0 1.05080000000e+004
0 1.05090000000e+004
0 1.05100000000e+004
0 1.05110000000e+004
0 1.05120000000e+004
0 1.05130000000e+004
0 1.05140000000e+004
0 1.05150000000e+004
0 1.05160000000e+004
0 1.05170000000e+004
0 1.05180000000e+004
0 1.05190000000e+004
0 1.05200000000e+004
0 1.05210000000e+004
0 1.05220000000e+004
0 1.05230000000e+004
0 1.05240000000e+004
0 1.05250000000e+004
0 1.05260000000e+004
0 1.05270000000e+004
0 1.05280000000e+004
0 1.05290000000e+004
0 1.05300000000e+004
0 1.05310000000e+004
0 1.05320000000e+004
0 1.05330000000e+004
0 1.05340000000e+004
0 1.05350000000e+004
0 1.05360000000e+004
0 1.05370000000e+004
0 1.05380000000e+004
0 1.05390000000e+004
0 1.05400000000e+004
0 1.05410000000e+004
0 1.05420000000e+004
0 1.05430000000e+004
0 1.05440000000e+004
0 1.05450000000e+004
0 1.05460000000e+004
0 1.05470000000e+004
0 1.05480000000e+004
0 1.05490000000e+004
0 1.05500000000e+004
0 1.05510000000e+004
0 1.05520000000e+004
0 1.05530000000e+004
0 1.05540000000e+004
0 1.05550000000e+004
0 1.05560000000e+004
0 1.05570000000e+004
0 1.05580000000e+004
0 1.05590000000e+004
0 1.05600000000e+004
0 1.05610000000e+004
0 1.05620000000e+004
0 1.05630000000e+004
0 1.05640000000e+004
0 1.05650000000e+004
0 1.05660000000e+004
0 1.05670000000e+004
0 1.05680000000e+004
0 1.05690000000e+004
0 1.05700000000e+004
0 1.05710000000e+004
0 1.05720000000e+004
0 1.05730000000e+004
0 1.05740000000e+004
0 1.05750000000e+004
0 1.05760000000e+004
0 1.05770000000e+004
0 1.05780000000e+004
0 1.05790000000e+004
0 1.05800000000e+004
0 1.05810000000e+004
0 1.05820000000e+004
0 1.05830000000e+004
0 1.05840000000e+004
0 1.05850000000e+004
0 1.05860000000e+004
0 1.05870000000e+004
0 1.05880000000e+004
0 1.05890000000e+004
0 1.05900000000e+004
0 1.05910000000e+004
0 1.05920000000e+004
0 1.05930000000e+004
0 1.05940000000e+004
0 1.05950000000e+004
0 1.05960000000e+004
0 1.05970000000e+004
0 1.05980000000e+004
0 1.05990000000e+004
0 1.06000000000e+004

__MACOSX/Assignment 4/Policyholders/._AAI_Policies.dbf

Assignment 4/Policyholders/AAI_Policies.prj

PROJCS["USA_Contiguous_Albers_Equal_Area_Conic",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-96.0],PARAMETER["Standard_Parallel_1",29.5],PARAMETER["Standard_Parallel_2",45.5],PARAMETER["Latitude_Of_Origin",37.5],UNIT["Meter",1.0]]

__MACOSX/Assignment 4/Policyholders/._AAI_Policies.prj

Assignment 4/Policyholders/AAI_Policies.sbn

__MACOSX/Assignment 4/Policyholders/._AAI_Policies.sbn

Assignment 4/Policyholders/AAI_Policies.sbx

__MACOSX/Assignment 4/Policyholders/._AAI_Policies.sbx

Assignment 4/Policyholders/AAI_Policies.shp

__MACOSX/Assignment 4/Policyholders/._AAI_Policies.shp

Assignment 4/Policyholders/AAI_Policies.shp.UL-PRM6-006.7232.11232.sr.lock

__MACOSX/Assignment 4/Policyholders/._AAI_Policies.shp.UL-PRM6-006.7232.11232.sr.lock

Assignment 4/Policyholders/AAI_Policies.shp.xml

20181016 12592700 1.0 TRUE CalculateField AAI_Policies PolicyID [FID]+1 VB # CalculateField AAI_Policies PolicyID [FID]+10000 VB #

__MACOSX/Assignment 4/Policyholders/._AAI_Policies.shp.xml

Assignment 4/Policyholders/AAI_Policies.shx

__MACOSX/Assignment 4/Policyholders/._AAI_Policies.shx

Assignment 4/Policyholders/AAI_Policies_tab.xls

AAI_Policies_tab

PolicyID Type Real Estate Auto Other Property
10000 Commerical $86,592.00
10001 Commerical $117,372.00
10002 Commerical $4,474.00
10003 Commerical $499,844.00 $38,651.00
10004 Commerical $29,362.00
10005 Commerical $497,668.00
10006 Commerical $3,219.00
10007 Commerical $25,592.00
10008 Commerical $17,751.00
10009 Commerical $667.00
10010 Commerical $496,966.00
10011 Commerical $252,126.00 $36,876.00
10012 Commerical $357.00
10013 Commerical $461,281.00
10014 Commerical $4,955.00 $8,684.00
10015 Personal $332,242.00
10016 Commerical $186,324.00
10017 Commerical $372,559.00 $78,111.00 $48,344.00
10018 Personal $58,291.00
10019 Commerical $477,688.00
10020 Commerical $346,375.00 $149,945.00
10021 Commerical $1,341.00
10022 Commerical $18,663.00 $3,285.00
10023 Commerical $11,696.00
10024 Commerical $35,979.00 $61,617.00
10025 Commerical $222,697.00
10026 Commerical $482,463.00 $25,569.00
10027 Commerical $284,376.00 $28,612.00
10028 Commerical $13,332.00
10029 Commerical $45,241.00 $193,653.00
10030 Commerical $448,811.00 $11,911.00
10031 Commerical $3,386.00
10032 Commerical $294,154.00 $1,167.00
10033 Commerical $119,584.00 $97,149.00
10034 Commerical $313,839.00
10035 Commerical $419,335.00 $91,614.00
10036 Commerical $1,318.00 $35,181.00
10037 Commerical $1,334.00
10038 Commerical $337,178.00 $92,287.00
10039 Commerical $94,375.00
10040 Commerical $335,677.00
10041 Commerical $13,123.00 $38,965.00
10042 Commerical $16,984.00
10043 Commerical $15,818.00
10044 Commerical $321,425.00 $158,215.00
10045 Commerical $11,658.00
10046 Commerical $31,716.00
10047 Commerical $317,369.00 $19,744.00
10048 Commerical $14,299.00 $17,892.00
10049 Commerical $1,187.00
10050 Commerical $282,977.00 $64,361.00
10051 Commerical $31,339.00
10052 Commerical $231,594.00
10053 Commerical $22,436.00
10054 Commerical $13,426.00
10055 Commerical $38,245.00
10056 Commerical $1,637.00
10057 Commerical $22,995.00
10058 Commerical $32,235.00
10059 Commerical $13,413.00
10060 Commerical $23,283.00
10061 Commerical $367,467.00
10062 Commerical $1,849.00
10063 Commerical $218.00
10064 Commerical $2,241.00
10065 Commerical $22,826.00
10066 Commerical $11,311.00
10067 Commerical $155,499.00
10068 Commerical $22,885.00
10069 Commerical $39,721.00
10070 Commerical $265,825.00
10071 Commerical $23,189.00
10072 Commerical $12,995.00
10073 Commerical $24,843.00
10074 Commerical $3,123.00
10075 Commerical $23,248.00
10076 Commerical $46,342.00
10077 Commerical $26,649.00
10078 Commerical $3,378.00
10079 Commerical $48,464.00
10080 Commerical $25,114.00
10081 Commerical $31,838.00
10082 Commerical $163,926.00
10083 Commerical $5,869.00
10084 Commerical $12,387.00
10085 Commerical $17,393.00
10086 Commerical $3,768.00
10087 Commerical $3,125.00
10088 Commerical $287,514.00
10089 Commerical $12,541.00
10090 Commerical $21,431.00
10091 Commerical $321,282.00
10092 Commerical $25,217.00
10093 Commerical $367.00
10094 Commerical $393,978.00
10095 Commerical $31,862.00
10096 Commerical $12,223.00
10097 Commerical $475,194.00
10098 Commerical $5,936.00
10099 Commerical $2,672.00
10100 Commerical $174,754.00 $5,815.00
10101 Commerical $2,966.00
10102 Commerical $3,879.00
10103 Commerical $185,658.00 $18,664.00
10104 Commerical $36,813.00
10105 Commerical $266.00
10106 Commerical $457,727.00 $13,584.00
10107 Commerical $3,494.00
10108 Commerical $2,352.00
10109 Commerical $174,835.00 $31,127.00
10110 Commerical $2,537.00
10111 Commerical $13,452.00
10112 Commerical $337,198.00 $3,933.00
10113 Commerical $582.00
10114 Commerical $29,481.00
10115 Commerical $242,477.00 $4,379.00
10116 Commerical $1,576.00
10117 Commerical $23,951.00
10118 Commerical $344,162.00 $24,811.00
10119 Commerical $34,633.00
10120 Commerical $9,975.00
10121 Commerical $119,417.00 $6,732.00
10122 Commerical $32,694.00
10123 Commerical $2,654.00
10124 Commerical $225,968.00 $33,898.00
10125 Commerical $32,897.00
10126 Personal $377,776.00 $15,386.00
10127 Commerical $264,435.00 $34,964.00
10128 Commerical $13,929.00
10129 Personal $12,212.00 $12,168.00
10130 Commerical $262,766.00 $33,113.00
10131 Commerical $14,496.00
10132 Personal $4,452.00
10133 Commerical $279,137.00 $16,627.00 $24,186.00
10134 Personal $413,944.00
10135 Personal $41,615.00
10136 Commerical $195,768.00 $2,158.00 $26,436.00
10137 Personal $337,551.00
10138 Personal $171,843.00
10139 Commerical $15,313.00 $196,865.00 $29,258.00
10140 Personal $25,992.00
10141 Personal $345,766.00
10142 Commerical $4,699.00 $47,291.00 $18,542.00
10143 Personal $13,714.00
10144 Personal $24,129.00
10145 Commerical $41,672.00 $133,331.00 $3,331.00
10146 Personal $475,965.00
10147 Personal $11,553.00
10148 Commerical $12,348.00 $116,886.00 $15,499.00
10149 Personal $323,591.00
10150 Personal $44,151.00
10151 Commerical $17,665.00 $13,325.00 $32,276.00
10152 Personal $156,518.00
10153 Personal $34,511.00 $2,994.00
10154 Commerical $44,715.00 $177,992.00 $22,544.00
10155 Personal $25,466.00
10156 Personal $34,844.00 $46,191.00
10157 Commerical $47,232.00 $74,995.00 $48,533.00
10158 Personal $45,962.00
10159 Personal $5,978.00 $34.00
10160 Commerical $325,286.00 $88,633.00 $41,317.00
10161 Commerical $139,647.00 $49,511.00
10162 Commerical $34,798.00 $124,619.00
10163 Commerical $297,761.00 $9,724.00
10164 Commerical $3,932.00 $176,384.00
10165 Commerical $273,541.00 $16,325.00
10166 Commerical $262,349.00 $57,542.00
10167 Commerical $135,672.00 $156,876.00
10168 Commerical $42,179.00 $15,334.00
10169 Commerical $192,919.00 $163,826.00
10170 Commerical $332,525.00 $15,656.00
10171 Commerical $44,585.00 $98,829.00
10172 Commerical $491,816.00 $65,265.00
10173 Commerical $426,918.00 $172,723.00
10174 Commerical $442,561.00 $112,598.00
10175 Commerical $228,438.00 $52,461.00
10176 Commerical $16,598.00 $1,592.00
10177 Commerical $27,236.00 $15,618.00
10178 Commerical $456,738.00 $26,846.00
10179 Commerical $257,157.00 $65,669.00
10180 Commerical $46,461.00 $126,354.00
10181 Commerical $419,349.00 $6,561.00
10182 Commerical $13,624.00 $191,929.00
10183 Commerical $15,678.00 $17,366.00
10184 Commerical $32,619.00 $192,358.00
10185 Commerical $183,233.00 $135,649.00
10186 Commerical $156,681.00 $168,596.00
10187 Commerical $33,487.00 $12,163.00
10188 Commerical $154,994.00 $4,918.00
10189 Commerical $26,788.00 $157,162.00
10190 Commerical $37,932.00 $5,918.00
10191 Commerical $494,696.00 $122,551.00
10192 Commerical $131,372.00 $45,863.00
10193 Commerical $416,318.00 $5,814.00
10194 Commerical $19,129.00 $38,478.00
10195 Commerical $1,228.00 $14,116.00
10196 Commerical $385,456.00 $36,575.00
10197 Commerical $22,827.00 $145,961.00
10198 Commerical $182,977.00 $8,533.00
10199 Commerical $47,187.00 $147,962.00
10200 Commerical $411,229.00 $187,731.00
10201 Commerical $475,374.00 $3,594.00
10202 Commerical $266,951.00 $112,562.00
10203 Commerical $278,166.00 $16,214.00
10204 Commerical $1,646.00 $52,178.00
10205 Commerical $296,839.00 $16,556.00
10206 Commerical $43,843.00 $18,597.00
10207 Commerical $285,136.00 $182,348.00
10208 Commerical $216,234.00 $8,659.00
10209 Commerical $34,127.00 $145,337.00
10210 Commerical $482,239.00 $17,198.00
10211 Commerical $179,919.00 $1,228.00
10212 Commerical $347,379.00 $15,181.00
10213 Commerical $15,852.00 $1,743.00
10214 Commerical $2,135.00 $11,583.00
10215 Commerical $321,946.00 $19,264.00
10216 Commerical $344,612.00 $199,121.00
10217 Commerical $174,544.00 $87,158.00
10218 Commerical $12,679.00 $116,796.00
10219 Commerical $44,966.00 $56,638.00
10220 Commerical $145,498.00 $137,354.00
10221 Commerical $43,385.00 $188,114.00
10222 Commerical $294,413.00 $8,752.00
10223 Commerical $19,513.00
10224 Commerical $479.00
10225 Commerical $733.00
10226 Commerical $11,216.00
10227 Commerical $157,941.00
10228 Commerical $5,674.00
10229 Commerical $78,149.00
10230 Commerical $198,467.00
10231 Commerical $141,165.00
10232 Commerical $82,538.00
10233 Commerical $91,659.00
10234 Commerical $152,771.00
10235 Commerical $21,324.00
10236 Commerical $88,536.00
10237 Commerical $96,417.00
10238 Commerical $7,237.00
10239 Commerical $121,221.00
10240 Commerical $11,148.00
10241 Commerical $198,914.00
10242 Commerical $58,995.00
10243 Commerical $41,987.00
10244 Commerical $63,563.00
10245 Commerical $112,277.00
10246 Commerical $7,373.00
10247 Commerical $97,166.00
10248 Commerical $23,748.00
10249 Commerical $77,962.00
10250 Commerical $3,715.00
10251 Commerical $158,563.00
10252 Commerical $23,415.00
10253 Commerical $6,975.00
10254 Commerical $73,554.00
10255 Commerical $6,225.00 $33,922.00
10256 Commerical $49,977.00 $13,442.00
10257 Commerical $5,589.00 $2,315.00
10258 Commerical $17,278.00 $3,496.00
10259 Commerical $9,956.00 $233.00
10260 Commerical $23,728.00
10261 Commerical $39,153.00
10262 Commerical $21,517.00
10263 Commerical $1,466.00
10264 Commerical $17,319.00
10265 Commerical $3,677.00
10266 Commerical $29,397.00
10267 Commerical $27,282.00
10268 Commerical $7,253.00
10269 Commerical $317.00
10270 Commerical $15,364.00
10271 Commerical $13,258.00
10272 Commerical $814.00
10273 Commerical $16,632.00
10274 Commerical $3,495.00
10275 Commerical $1,667.00
10276 Commerical $27,764.00
10277 Commerical $153.00
10278 Commerical $1,213.00
10279 Commerical $6,797.00
10280 Commerical $22,462.00
10281 Commerical $2,381.00
10282 Commerical $35,824.00
10283 Commerical $31,441.00
10284 Commerical $7,791.00
10285 Commerical $18.00
10286 Commerical $18,861.00
10287 Commerical $9,972.00
10288 Commerical $1,264.00
10289 Commerical $4,768.00
10290 Commerical $3,862.00
10291 Commerical $15,396.00
10292 Commerical $3,546.00
10293 Commerical $2,945.00
10294 Commerical $15,757.00
10295 Commerical $11,984.00
10296 Commerical $1,218.00
10297 Commerical $27,548.00
10298 Commerical $1,428.00
10299 Commerical $212.00
10300 Commerical $3,538.00
10301 Commerical $2,857.00
10302 Commerical $155.00
10303 Commerical $17,729.00
10304 Commerical $4,648.00
10305 Commerical $39,363.00
10306 Commerical $2,432.00
10307 Commerical $3,595.00
10308 Commerical $3,787.00
10309 Commerical $29,768.00
10310 Commerical $1,159.00
10311 Commerical $19,722.00
10312 Commerical $2,292.00
10313 Commerical $39,284.00
10314 Commerical $11,159.00
10315 Commerical $13,853.00
10316 Commerical $28,638.00
10317 Commerical $991.00
10318 Commerical $16,943.00
10319 Commerical $24,735.00
10320 Commerical $21,398.00
10321 Commerical $14,339.00
10322 Commerical $18,354.00
10323 Commerical $26,476.00
10324 Commerical $1,478.00
10325 Commerical $9,375.00
10326 Commerical $18,351.00
10327 Commerical $23,753.00
10328 Commerical $26,411.00
10329 Commerical $21,972.00
10330 Commerical $789.00
10331 Commerical $3,466.00
10332 Commerical $29,483.00
10333 Commerical $34,423.00
10334 Commerical $29,661.00
10335 Commerical $2,129.00
10336 Commerical $13,674.00
10337 Commerical $1,676.00
10338 Commerical $13,247.00
10339 Commerical $2,146.00
10340 Commerical $311.00
10341 Commerical $9,394.00
10342 Commerical $11,863.00
10343 Commerical $27,171.00
10344 Commerical $31,875.00
10345 Commerical $9,682.00
10346 Commerical $16,565.00
10347 Commerical $29,785.00
10348 Commerical $17,229.00
10349 Commerical $818.00
10350 Commerical $3,637.00
10351 Commerical $23,244.00
10352 Commerical $32,327.00
10353 Commerical $2,337.00
10354 Commerical $18,844.00
10355 Commerical $6,891.00
10356 Commerical $332.00
10357 Commerical $29,449.00
10358 Commerical $11,618.00
10359 Commerical $38,199.00
10360 Commerical $15,283.00
10361 Commerical $1,342.00
10362 Commerical $3,166.00
10363 Commerical $3,592.00
10364 Commerical $2,859.00
10365 Commerical $34,333.00
10366 Commerical $2,419.00
10367 Commerical $1,953.00
10368 Commerical $1,653.00
10369 Commerical $15,122.00
10370 Commerical $3,428.00
10371 Commerical $2,529.00
10372 Commerical $3,436.00
10373 Commerical $221.00
10374 Commerical $21,593.00
10375 Commerical $34,848.00
10376 Commerical $318.00
10377 Commerical $18,152.00
10378 Commerical $3,162.00
10379 Commerical $33,384.00
10380 Commerical $33,495.00
10381 Commerical $6,884.00
10382 Commerical $6,249.00
10383 Commerical $8,876.00
10384 Commerical $1,211.00
10385 Commerical $28,462.00
10386 Commerical $6,371.00
10387 Commerical $3,569.00
10388 Commerical $6,311.00
10389 Commerical $12,535.00
10390 Commerical $7,774.00
10391 Commerical $3,148.00
10392 Commerical $39,183.00
10393 Commerical $197.00
10394 Commerical $4,924.00
10395 Commerical $1,186.00
10396 Commerical $775.00
10397 Commerical $13,481.00
10398 Commerical $1,939.00
10399 Commerical $2,342.00
10400 Commerical $11,734.00
10401 Commerical $16,348.00
10402 Commerical $2,182.00
10403 Commerical $2,966.00
10404 Commerical $36,348.00
10405 Commerical $27,981.00
10406 Commerical $31,295.00
10407 Commerical $22,988.00
10408 Commerical $19.00
10409 Commerical $25,346.00
10410 Commerical $26,231.00
10411 Commerical $1,729.00
10412 Commerical $1,113.00
10413 Commerical $2,897.00
10414 Commerical $4,322.00
10415 Commerical $4,828.00
10416 Commerical $23,427.00
10417 Commerical $1,427.00
10418 Commerical $35,547.00
10419 Commerical $37,198.00
10420 Commerical $4,417.00
10421 Commerical $382.00
10422 Commerical $1,547.00
10423 Commerical $2,986.00
10424 Commerical $21,994.00
10425 Commerical $663.00
10426 Commerical $29,935.00
10427 Commerical $343.00
10428 Commerical $1,516.00
10429 Commerical $28,585.00
10430 Commerical $16,679.00
10431 Commerical $18,154.00
10432 Commerical $25,986.00
10433 Commerical $29,933.00
10434 Commerical $26,911.00
10435 Commerical $23,996.00
10436 Commerical $37,848.00
10437 Commerical $23,687.00
10438 Commerical $2,267.00
10439 Commerical $1,892.00
10440 Commerical $2,924.00
10441 Commerical $2,252.00
10442 Commerical $2,337.00
10443 Commerical $1,616.00
10444 Commerical $3,589.00
10445 Commerical $29,791.00
10446 Commerical $1,614.00
10447 Commerical $22,241.00
10448 Commerical $23,285.00
10449 Commerical $3,645.00
10450 Commerical $8,541.00
10451 Commerical $24,749.00
10452 Commerical $12,251.00
10453 Commerical $3,742.00
10454 Commerical $31,698.00
10455 Commerical $3,246.00
10456 Commerical $36,953.00
10457 Commerical $3,372.00
10458 Commerical $31,525.00
10459 Commerical $5,153.00
10460 Commerical $2,375.00
10461 Commerical $31,179.00
10462 Commerical $3,259.00
10463 Commerical $39,939.00
10464 Commerical $19,565.00
10465 Commerical $1,246.00
10466 Commerical $3,385.00
10467 Commerical $24,231.00
10468 Commerical $26,787.00
10469 Commerical $3,487.00
10470 Commerical $8,122.00
10471 Commerical $33,179.00
10472 Commerical $3,316.00
10473 Commerical $38,399.00
10474 Commerical $18,421.00
10475 Commerical $1,996.00
10476 Commerical $8,293.00
10477 Commerical $25,854.00
10478 Commerical $33,778.00
10479 Commerical $19,473.00
10480 Commerical $12,843.00
10481 Commerical $3,183.00
10482 Commerical $6,949.00
10483 Commerical $5,583.00
10484 Commerical $28,595.00
10485 Commerical $24,248.00
10486 Commerical $36,967.00
10487 Commerical $33,246.00
10488 Commerical $39,264.00
10489 Commerical $31,366.00
10490 Commerical $33,552.00
10491 Personal $3,196.00 $22,381.00
10492 Personal $193,159.00 $38,133.00
10493 Personal $82,294.00 $12,262.00
10494 Personal $357,957.00 $2,784.00
10495 Personal $23,754.00 $12,959.00
10496 Personal $45,874.00 $14,924.00
10497 Personal $347,873.00 $2,544.00
10498 Personal $281,751.00 $9,937.00
10499 Personal $472,546.00 $136.00
10500 Personal $185,263.00 $5,388.00
10501 Personal $214,153.00 $39,852.00
10502 Personal $39,592.00 $33,376.00
10503 Personal $8,323.00 $14,617.00
10504 Personal $183,826.00 $3,374.00
10505 Personal $462,363.00 $19,278.00
10506 Personal $218,229.00 $364.00
10507 Personal $435,945.00 $16,338.00
10508 Personal $253,979.00 $24,694.00
10509 Personal $29,599.00 $28,554.00
10510 Personal $356,999.00 $13,777.00
10511 Personal $147,671.00
10512 Personal $437,627.00
10513 Personal $331,197.00
10514 Personal $34,967.00
10515 Personal $8,971.00
10516 Personal $182,147.00
10517 Personal $454,256.00
10518 Personal $37,584.00
10519 Personal $332,963.00
10520 Personal $237,146.00
10521 Personal $275,328.00
10522 Personal $373,313.00
10523 Personal $12,223.00
10524 Personal $137,699.00
10525 Personal $397,326.00
10526 Personal $183,729.00
10527 Personal $31,867.00
10528 Personal $299.00
10529 Personal $28,698.00
10530 Personal $388,889.00
10531 Personal $211,372.00
10532 Personal $233,376.00
10533 Personal $198,873.00
10534 Personal $341,574.00
10535 Personal $2,866.00
10536 Personal $328,849.00
10537 Personal $344,676.00
10538 Personal $214,482.00
10539 Personal $2,184.00
10540 Personal $171,411.00
10541 Personal $316,691.00
10542 Personal $258,972.00
10543 Personal $235,642.00
10544 Personal $47,523.00
10545 Personal $156,613.00
10546 Personal $24,434.00
10547 Personal $443,132.00
10548 Personal $47,723.00
10549 Personal $393,824.00
10550 Personal $44,613.00
10551 Personal $491,916.00
10552 Personal $312,184.00
10553 Personal $31,994.00
10554 Personal $327,168.00
10555 Personal $38,143.00
10556 Personal $1,639.00
10557 Personal $132,512.00
10558 Personal $4,321.00
10559 Personal $48,917.00
10560 Personal $12,699.00
10561 Personal $21,849.00
10562 Personal $127,853.00
10563 Personal $166,659.00
10564 Personal $489,515.00
10565 Personal $184,291.00 $18,852.00
10566 Personal $395,249.00 $3,719.00
10567 Personal $427,715.00 $1,273.00
10568 Personal $339.00 $62,467.00
10569 Personal $47,123.00 $22,523.00
10570 Personal $258,553.00 $22,585.00
10571 Personal $47,645.00 $79,167.00
10572 Personal $459,767.00 $23,145.00
10573 Personal $16,542.00 $36,142.00
10574 Personal $329,269.00 $3,737.00
10575 Personal $33,353.00 $5,595.00
10576 Personal $24,127.00 $63,684.00
10577 Personal $266,992.00 $1,514.00
10578 Personal $126,153.00 $12,853.00
10579 Personal $426,186.00 $57,612.00
10580 Personal $82,941.00 $67,843.00
10581 Personal $498,673.00 $51,277.00
10582 Personal $384,481.00 $49,739.00
10583 Personal $152,254.00 $68,472.00
10584 Personal $25,896.00 $1,978.00 $1,659.00
10585 Personal $448,582.00 $2,623.00 $28,889.00
10586 Personal $34,811.00 $4,592.00 $18,671.00
10587 Personal $377,339.00 $11,199.00 $39,662.00
10588 Personal $333,793.00 $65,584.00 $158.00
10589 Personal $13,612.00 $122.00
10590 Personal $4,162.00 $257.00
10591 Personal $17,762.00 $2,423.00
10592 Personal $4,948.00 $33,663.00
10593 Personal $46,362.00 $13,536.00
10594 Personal $73,127.00 $2,286.00
10595 Personal $37,932.00 $17,916.00
10596 Personal $79,912.00 $13,744.00
10597 Personal $59,391.00 $243.00
10598 Personal $51,319.00 $2,116.00
10599 Personal $6,993.00
10600 Personal $52,996.00
&P
&F

__MACOSX/Assignment 4/Policyholders/._AAI_Policies_tab.xls

__MACOSX/Assignment 4/._Policyholders

Assignment 4/Tornados/Tornado_Area.cpg

UTF-8

__MACOSX/Assignment 4/Tornados/._Tornado_Area.cpg

Assignment 4/Tornados/Tornado_Area.dbf

om mo time tz st stf mag inj fat loss closs slon slat elon elat len wid kind BUFF_DIST ORIG_FID
275388 2 15:53:00 3 AR 5 1 0 0 1.65000000000e-01 0.00000000000e+00 -9.28653000000e+01 3.47782e+01 -9.27182000000e+01 3.48804e+01 1.10900e+01 80 Tornado 2.00000000000e+00 0
275383 2 16:56:00 3 AR 5 1 0 0 7.50000000000e-02 0.00000000000e+00 -9.20772000000e+01 3.47304e+01 -9.20422000000e+01 3.47477e+01 2.32000e+00 100 Tornado 2.00000000000e+00 1
275386 2 17:03:00 3 AR 5 1 0 0 4.00000000000e-01 0.00000000000e+00 -9.19045000000e+01 3.47708e+01 -9.18812000000e+01 3.47830e+01 1.57000e+00 235 Tornado 2.00000000000e+00 2
289566 4 00:13:00 3 AR 5 1 0 0 2.40000000000e-01 0.00000000000e+00 -9.29800000000e+01 3.46206e+01 -9.28802000000e+01 3.46857e+01 7.31000e+00 250 Tornado 2.00000000000e+00 3
290112 4 00:38:00 3 AR 5 1 0 0 4.00000000000e-02 0.00000000000e+00 -9.26176000000e+01 3.44510e+01 -9.25671000000e+01 3.44605e+01 2.95000e+00 250 Tornado 2.00000000000e+00 4
289568 4 00:47:00 3 AR 5 1 0 0 7.75000000000e-01 0.00000000000e+00 -9.24726000000e+01 3.44806e+01 -9.21956000000e+01 3.45650e+01 1.68500e+01 350 Tornado 2.00000000000e+00 5
289571 4 00:57:00 3 AR 5 1 2 2 3.85000000000e+01 0.00000000000e+00 -9.23773000000e+01 3.47501e+01 -9.23142000000e+01 3.47738e+01 3.94000e+00 475 Tornado 2.00000000000e+00 6
289572 4 01:01:00 3 AR 5 1 0 0 2.00000000000e+00 0.00000000000e+00 -9.22941000000e+01 3.46586e+01 -9.21948000000e+01 3.47074e+01 6.57000e+00 200 Tornado 2.00000000000e+00 7
289573 4 01:09:00 3 AR 5 1 1 0 4.55000000000e-01 0.00000000000e+00 -9.21469000000e+01 3.45988e+01 -9.20334000000e+01 3.46287e+01 6.79000e+00 200 Tornado 2.00000000000e+00 8
289563 4 01:17:00 3 AR 5 2 0 0 2.00000000000e+01 5.00000000000e-02 -9.19650000000e+01 3.46494e+01 -9.18587000000e+01 3.47001e+01 6.98000e+00 200 Tornado 2.00000000000e+00 9
289657 4 15:24:00 3 AR 5 1 0 0 6.00000000000e-01 0.00000000000e+00 -9.31026000000e+01 3.47201e+01 -9.29457000000e+01 3.47567e+01 9.26000e+00 300 Tornado 2.00000000000e+00 10
289592 4 17:07:00 3 AR 5 3 20 1 2.30000000000e+01 0.00000000000e+00 -9.30390000000e+01 3.45903e+01 -9.28000000000e+01 3.47330e+01 1.67800e+01 300 Tornado 2.00000000000e+00 11
290100 4 17:21:00 3 AR 5 1 0 0 7.00000000000e-01 0.00000000000e+00 -9.28326000000e+01 3.49522e+01 -9.27659000000e+01 3.50187e+01 5.95000e+00 300 Tornado 2.00000000000e+00 12
289605 4 17:48:00 3 AR 5 2 16 4 5.34050000000e+01 0.00000000000e+00 -9.26075000000e+01 3.48057e+01 -9.19473000000e+01 3.53098e+01 6.81000e+01 2900 Tornado 2.00000000000e+00 13
289659 4 17:48:00 3 AR 5 1 0 0 2.50000000000e-01 0.00000000000e+00 -9.26957000000e+01 3.48767e+01 -9.26719000000e+01 3.48902e+01 1.64000e+00 400 Tornado 2.00000000000e+00 14
289645 4 18:06:00 3 AR 5 1 0 0 1.00000000000e-01 0.00000000000e+00 -9.24738000000e+01 3.52053e+01 -9.24569000000e+01 3.52132e+01 1.10000e+00 50 Tornado 2.00000000000e+00 15
289604 4 18:46:00 3 AR 5 2 4 0 1.25000000000e+02 0.00000000000e+00 -9.21702000000e+01 3.48720e+01 -9.21220000000e+01 3.49355e+01 5.17000e+00 350 Tornado 2.00000000000e+00 16
289661 4 18:53:00 3 AR 5 1 0 0 3.90000000000e-01 0.00000000000e+00 -9.20547000000e+01 3.45281e+01 -9.17182000000e+01 3.46821e+01 2.19400e+01 800 Tornado 2.00000000000e+00 17
289738 4 16:14:00 3 AR 5 1 0 0 1.75000000000e+00 0.00000000000e+00 -9.19124000000e+01 3.45273e+01 -9.17763000000e+01 3.45707e+01 8.31000e+00 800 Tornado 2.00000000000e+00 18
289742 4 17:32:00 3 AR 5 1 0 0 4.00000000000e-02 0.00000000000e+00 -9.21565000000e+01 3.51784e+01 -9.19610000000e+01 3.52733e+01 1.28800e+01 200 Tornado 2.00000000000e+00 19

__MACOSX/Assignment 4/Tornados/._Tornado_Area.dbf

Assignment 4/Tornados/Tornado_Area.prj

GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]

__MACOSX/Assignment 4/Tornados/._Tornado_Area.prj

Assignment 4/Tornados/Tornado_Area.sbn

__MACOSX/Assignment 4/Tornados/._Tornado_Area.sbn

Assignment 4/Tornados/Tornado_Area.sbx

__MACOSX/Assignment 4/Tornados/._Tornado_Area.sbx

Assignment 4/Tornados/Tornado_Area.shp

__MACOSX/Assignment 4/Tornados/._Tornado_Area.shp

Assignment 4/Tornados/Tornado_Area.shp.UL-PRM6-006.7232.11232.sr.lock

__MACOSX/Assignment 4/Tornados/._Tornado_Area.shp.UL-PRM6-006.7232.11232.sr.lock

Assignment 4/Tornados/Tornado_Area.shp.xml

20181126 11412500 1.0 FALSE DeleteField Tornados_LittleRock yr;date Buffer Tornados_LittleRock E:\UNT\Tornado_Area.shp "2 Miles" FULL ROUND NONE # PLANAR Tornado_Area 002 0.000 file://\\UL-PRM6-006\E\UNT\Tornado_Area.shp Local Area Network Geographic GCS_WGS_1984 Angular Unit: Degree (0.017453) <GeographicCoordinateSystem xsi:type='typens:GeographicCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.7'><WKT>GEOGCS[&quot;GCS_WGS_1984&quot;,DATUM[&quot;D_WGS_1984&quot;,SPHEROID[&quot;WGS_1984&quot;,6378137.0,298.257223563]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433],AUTHORITY[&quot;EPSG&quot;,4326]]</WKT><XOrigin>-400</XOrigin><YOrigin>-400</YOrigin><XYScale>11258999068426.238</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>8.983152841195215e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4326</WKID><LatestWKID>4326</LatestWKID></GeographicCoordinateSystem> 20190927 13134000 20190927 13134000 Version 6.2 (Build 9200) ; Esri ArcGIS 10.7.1.11595 Tornado_Area Shapefile 0.000 dataset EPSG 6.14(3.0.1) 0 Simple FALSE 0 FALSE FALSE Tornado_Area Feature Class 0 FID FID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 0 0 0 Feature geometry. Esri Coordinates defining the features. om om Integer 10 10 0 mo mo Integer 5 5 0 time time String 8 0 0 tz tz Integer 5 5 0 st st String 2 0 0 stf stf Integer 5 5 0 mag mag Integer 5 5 0 inj inj Integer 5 5 0 fat fat Integer 5 5 0 loss loss Double 19 0 0 closs closs Double 19 0 0 slon slon Double 19 0 0 slat slat Single 13 0 0 elon elon Double 19 0 0 elat elat Single 13 0 0 len len Single 13 0 0 wid wid Integer 5 5 0 kind kind String 7 0 0 BUFF_DIST BUFF_DIST Double 19 0 0 ORIG_FID ORIG_FID Integer 10 10 0 20190927

__MACOSX/Assignment 4/Tornados/._Tornado_Area.shp.xml

Assignment 4/Tornados/Tornado_Area.shx

__MACOSX/Assignment 4/Tornados/._Tornado_Area.shx

Assignment 4/Tornados/Tornados_LittleRock.CPG

UTF-8

__MACOSX/Assignment 4/Tornados/._Tornados_LittleRock.CPG

Assignment 4/Tornados/Tornados_LittleRock.dbf

om mo time tz st stf mag inj fat loss closs slon slat elon elat len wid kind
275388 2 15:53:00 3 AR 5 1 0 0 1.65000000000e-01 0.00000000000e+00 -9.28653000000e+01 3.47782e+01 -9.27182000000e+01 3.48804e+01 1.10900e+01 80 Tornado
275383 2 16:56:00 3 AR 5 1 0 0 7.50000000000e-02 0.00000000000e+00 -9.20772000000e+01 3.47304e+01 -9.20422000000e+01 3.47477e+01 2.32000e+00 100 Tornado
275386 2 17:03:00 3 AR 5 1 0 0 4.00000000000e-01 0.00000000000e+00 -9.19045000000e+01 3.47708e+01 -9.18812000000e+01 3.47830e+01 1.57000e+00 235 Tornado
289566 4 00:13:00 3 AR 5 1 0 0 2.40000000000e-01 0.00000000000e+00 -9.29800000000e+01 3.46206e+01 -9.28802000000e+01 3.46857e+01 7.31000e+00 250 Tornado
290112 4 00:38:00 3 AR 5 1 0 0 4.00000000000e-02 0.00000000000e+00 -9.26176000000e+01 3.44510e+01 -9.25671000000e+01 3.44605e+01 2.95000e+00 250 Tornado
289568 4 00:47:00 3 AR 5 1 0 0 7.75000000000e-01 0.00000000000e+00 -9.24726000000e+01 3.44806e+01 -9.21956000000e+01 3.45650e+01 1.68500e+01 350 Tornado
289571 4 00:57:00 3 AR 5 1 2 2 3.85000000000e+01 0.00000000000e+00 -9.23773000000e+01 3.47501e+01 -9.23142000000e+01 3.47738e+01 3.94000e+00 475 Tornado
289572 4 01:01:00 3 AR 5 1 0 0 2.00000000000e+00 0.00000000000e+00 -9.22941000000e+01 3.46586e+01 -9.21948000000e+01 3.47074e+01 6.57000e+00 200 Tornado
289573 4 01:09:00 3 AR 5 1 1 0 4.55000000000e-01 0.00000000000e+00 -9.21469000000e+01 3.45988e+01 -9.20334000000e+01 3.46287e+01 6.79000e+00 200 Tornado
289563 4 01:17:00 3 AR 5 2 0 0 2.00000000000e+01 5.00000000000e-02 -9.19650000000e+01 3.46494e+01 -9.18587000000e+01 3.47001e+01 6.98000e+00 200 Tornado
289657 4 15:24:00 3 AR 5 1 0 0 6.00000000000e-01 0.00000000000e+00 -9.31026000000e+01 3.47201e+01 -9.29457000000e+01 3.47567e+01 9.26000e+00 300 Tornado
289592 4 17:07:00 3 AR 5 3 20 1 2.30000000000e+01 0.00000000000e+00 -9.30390000000e+01 3.45903e+01 -9.28000000000e+01 3.47330e+01 1.67800e+01 300 Tornado
290100 4 17:21:00 3 AR 5 1 0 0 7.00000000000e-01 0.00000000000e+00 -9.28326000000e+01 3.49522e+01 -9.27659000000e+01 3.50187e+01 5.95000e+00 300 Tornado
289605 4 17:48:00 3 AR 5 2 16 4 5.34050000000e+01 0.00000000000e+00 -9.26075000000e+01 3.48057e+01 -9.19473000000e+01 3.53098e+01 6.81000e+01 2900 Tornado
289659 4 17:48:00 3 AR 5 1 0 0 2.50000000000e-01 0.00000000000e+00 -9.26957000000e+01 3.48767e+01 -9.26719000000e+01 3.48902e+01 1.64000e+00 400 Tornado
289645 4 18:06:00 3 AR 5 1 0 0 1.00000000000e-01 0.00000000000e+00 -9.24738000000e+01 3.52053e+01 -9.24569000000e+01 3.52132e+01 1.10000e+00 50 Tornado
289604 4 18:46:00 3 AR 5 2 4 0 1.25000000000e+02 0.00000000000e+00 -9.21702000000e+01 3.48720e+01 -9.21220000000e+01 3.49355e+01 5.17000e+00 350 Tornado
289661 4 18:53:00 3 AR 5 1 0 0 3.90000000000e-01 0.00000000000e+00 -9.20547000000e+01 3.45281e+01 -9.17182000000e+01 3.46821e+01 2.19400e+01 800 Tornado
289738 4 16:14:00 3 AR 5 1 0 0 1.75000000000e+00 0.00000000000e+00 -9.19124000000e+01 3.45273e+01 -9.17763000000e+01 3.45707e+01 8.31000e+00 800 Tornado
289742 4 17:32:00 3 AR 5 1 0 0 4.00000000000e-02 0.00000000000e+00 -9.21565000000e+01 3.51784e+01 -9.19610000000e+01 3.52733e+01 1.28800e+01 200 Tornado

__MACOSX/Assignment 4/Tornados/._Tornados_LittleRock.dbf

Assignment 4/Tornados/Tornados_LittleRock.prj

GEOGCS["WGS84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["degree",0.0174532925199433]]

__MACOSX/Assignment 4/Tornados/._Tornados_LittleRock.prj

Assignment 4/Tornados/Tornados_LittleRock.sbn

__MACOSX/Assignment 4/Tornados/._Tornados_LittleRock.sbn

Assignment 4/Tornados/Tornados_LittleRock.sbx

__MACOSX/Assignment 4/Tornados/._Tornados_LittleRock.sbx

Assignment 4/Tornados/Tornados_LittleRock.shp

__MACOSX/Assignment 4/Tornados/._Tornados_LittleRock.shp

Assignment 4/Tornados/Tornados_LittleRock.shp.UL-PRM6-006.7232.11232.sr.lock

__MACOSX/Assignment 4/Tornados/._Tornados_LittleRock.shp.UL-PRM6-006.7232.11232.sr.lock

Assignment 4/Tornados/Tornados_LittleRock.shp.xml

20181126 11412500 1.0 TRUE DeleteField Tornados_LittleRock yr;date

__MACOSX/Assignment 4/Tornados/._Tornados_LittleRock.shp.xml

Assignment 4/Tornados/Tornados_LittleRock.shx

__MACOSX/Assignment 4/Tornados/._Tornados_LittleRock.shx

__MACOSX/Assignment 4/._Tornados

Assignment 4/Week 4 Assignment.docx

Week 4 – Assignment

Our week 4 assignment leverages attribute and spatial queries in ArcGIS Desktop to summarize insurance risk faced by our company as a result of tornados striking the Little Rock, Arkansas area. In the end, your boss would like for you to produce a table that summarizes the payout risk the company faces by two different customer types. Just an excel table or .csv is an appropriate deliverable here. Additionally, there are two questions of particular interest that we need to answer:

1) What total insurance risk does Atlantic Advantage Insurance face from all product lines and coverage offerings in Little Rock?

2) What subset insurance risk does Atlantic Advantage Insurance face from commercial product lines offering auto coverage in Little Rock?

Attached Files:

LittleRock_Metro.shp – polygonal shapefile of Little Rock (U.S. Census)

AAI_Policies.shp – point shapefile of policy holders in Little Rock (Atlantic Advantage Insurance)

Tornados_LittleRock – line shapefile of tornado paths from the recent storm activity in the city (NOAA)

Tornado_Area – your manager wants you to use 75% damage payouts for all policies within 1 mile based on historical data from the claims department

1. Load features

Let’s load our data into ArcGIS Desktop in a logical spatial order so that all layers are present. Your initial map should mirror what is below:

2. Aspatial Join

Let’s create a quick join between the locations of our policyholders and the policy information provided by the claims department. What is the primary key for this join? Right click on your policyholders layer and select Joins and Relates, and Join…

Input the following parameters:

Now, each point on the map will have specific coverage information appended to it.

2. Spatial Query

The next step is to identify which policyholders fall within the footprint of the recent storms. Under the selection option in the ribbon, choose to select records by location. Match the input parameters below.

The selected features should highlight in a bright blue.

Let’s export this feature to a new layer. Right click AAI_Policies > Selection > Create Layer from Selected Features.

3. Attribute Table Calculations

Based on the 75% rule the claims department gave us, we can leverage ArcGIS, quick statistics functionality to arrive at the total and subset insurance risks faced by the company.

Let’s use this formula:

Where AR denote automobile coverage risk, RER denotes home coverage risk, and OPR denotes all other property risk. A quick sum and multiplying by .75 returns exactly what we need. Thankfully, ArcGIS can sum these columns very quick. Open the attribute table. Right click the real estate column and select Statistics…

ArcGIS returns this nice little summary with a sum of the column (excluding nulls) provided. Adjust the field drop down to fill in our other variables in the above equation to arrive at the total risk faced by the firm.

4. Attribute Query

Answering the second question from the manager requires a more targeted subset of the data that looks at commercial lines. We can perform an attribute query to find this subset and use the statistic calculation method above to sum the auto risk from commercial lines. Once again, click Selection in the ribbon, and click on Select by Attributes…

Isolate this new selection in another separate layer and sum the auto column. You have now answered the two questions provided by your manager.

5. Export Results

Finally, let’s export the results of the spatial query to an Excel file. You may add a text box to that Excel file to input your name, date, and answers to questions 1 and 2. Use the Table to Excel tool under the search tab on the right of the ArcGIS interface.

__MACOSX/Assignment 4/._Week 4 Assignment.docx

__MACOSX/._Assignment 4