Foundations Of Geographic Information Systems Assignment Package
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["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],AUTHORITY["ESRI",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 |
__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["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433],AUTHORITY["EPSG",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:
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.