20190905 16102300 1.0 FALSE CrimePoints 002 file://\\PLA-2UA6322PBV\C$\Users\vencia\Documents\ArcGIS\Projects\TAD\TAD.gdb Local Area Network Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Georgia_West_FIPS_1002_Feet <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/2.4.0'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Georgia_West_FIPS_1002_Feet&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;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,2296583.333333333],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-84.16666666666667],PARAMETER[&quot;Scale_Factor&quot;,0.9999],PARAMETER[&quot;Latitude_Of_Origin&quot;,30.0],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2240]]</WKT><XOrigin>-16150100</XOrigin><YOrigin>-43703500</YOrigin><XYScale>3048.0037936712029</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.00328083336353302</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102667</WKID><LatestWKID>2240</LatestWKID></ProjectedCoordinateSystem> FeatureClassToFeatureClass XY_Crimes C:\Users\vencia\Documents\ArcGIS\Projects\TAD\TAD.gdb XYCrime # "Status "Status" true true false 1 Text 0 0,First,#,XY_Crimes,Status,0,1;Score "Score" true true false 19 Double 2 18,First,#,XY_Crimes,Score,-1,-1;Match_type "Match_type" true true false 2 Text 0 0,First,#,XY_Crimes,Match_type,0,2;Match_addr "Match_addr" true true false 120 Text 0 0,First,#,XY_Crimes,Match_addr,0,120;X "X" true true false 19 Double 6 18,First,#,XY_Crimes,X,-1,-1;Y "Y" true true false 19 Double 6 18,First,#,XY_Crimes,Y,-1,-1;Xmin "Xmin" true true false 19 Double 6 18,First,#,XY_Crimes,Xmin,-1,-1;Xmax "Xmax" true true false 19 Double 6 18,First,#,XY_Crimes,Xmax,-1,-1;Ymin "Ymin" true true false 19 Double 6 18,First,#,XY_Crimes,Ymin,-1,-1;Ymax "Ymax" true true false 19 Double 6 18,First,#,XY_Crimes,Ymax,-1,-1;Addr_type "Addr_type" true true false 20 Text 0 0,First,#,XY_Crimes,Addr_type,0,20;ARC_Single "ARC_Single" true true false 100 Text 0 0,First,#,XY_Crimes,ARC_Single,0,100;CaseNumber "CaseNumber" true true false 254 Text 0 0,First,#,XY_Crimes,CaseNumber,0,254;ReportDate "ReportDate" true true false 8 Date 0 0,First,#,XY_Crimes,ReportDate,-1,-1;CaseType "CaseType" true true false 254 Text 0 0,First,#,XY_Crimes,CaseType,0,254;Dispositio "Dispositio" true true false 254 Text 0 0,First,#,XY_Crimes,Dispositio,0,254;Address "Address" true true false 254 Text 0 0,First,#,XY_Crimes,Address,0,254;Apartment "Apartment" true true false 254 Text 0 0,First,#,XY_Crimes,Apartment,0,254;City "City" true true false 254 Text 0 0,First,#,XY_Crimes,City,0,254;X_1 "X_1" true true false 17 Double 6 16,First,#,XY_Crimes,X_1,-1,-1;Y_1 "Y_1" true true false 17 Double 6 16,First,#,XY_Crimes,Y_1,-1,-1;CommonName "CommonName" true true false 254 Text 0 0,First,#,XY_Crimes,CommonName,0,254" # Merge XYCrime;Geocoding_Result_4 C:\Users\vencia\Documents\ArcGIS\Projects\TAD\TAD.gdb\Crime_Merge "Status "Status" true true false 1 Text 0 0,First,#,XYCrime,Status,0,1,Geocoding_Result_4,Status,0,1;Score "Score" true true false 8 Double 0 0,First,#,XYCrime,Score,-1,-1,Geocoding_Result_4,Score,-1,-1;Match_type "Match_type" true true false 2 Text 0 0,First,#,XYCrime,Match_type,0,2,Geocoding_Result_4,Match_type,0,2;Match_addr "Match_addr" true true false 120 Text 0 0,First,#,XYCrime,Match_addr,0,120,Geocoding_Result_4,Match_addr,0,120;X "X" true true false 8 Double 0 0,First,#,XYCrime,X,-1,-1,Geocoding_Result_4,X,-1,-1;Y "Y" true true false 8 Double 0 0,First,#,XYCrime,Y,-1,-1,Geocoding_Result_4,Y,-1,-1;Xmin "Xmin" true true false 8 Double 0 0,First,#,XYCrime,Xmin,-1,-1,Geocoding_Result_4,Xmin,-1,-1;Xmax "Xmax" true true false 8 Double 0 0,First,#,XYCrime,Xmax,-1,-1,Geocoding_Result_4,Xmax,-1,-1;Ymin "Ymin" true true false 8 Double 0 0,First,#,XYCrime,Ymin,-1,-1,Geocoding_Result_4,Ymin,-1,-1;Ymax "Ymax" true true false 8 Double 0 0,First,#,XYCrime,Ymax,-1,-1,Geocoding_Result_4,Ymax,-1,-1;Addr_type "Addr_type" true true false 20 Text 0 0,First,#,XYCrime,Addr_type,0,20,Geocoding_Result_4,Addr_type,0,20;ARC_Single "ARC_Single" true true false 100 Text 0 0,First,#,XYCrime,ARC_Single,0,100,Geocoding_Result_4,ARC_Single,0,100;CaseNumber "CaseNumber" true true false 254 Text 0 0,First,#,XYCrime,CaseNumber,0,254,Geocoding_Result_4,CaseNumber,0,254;ReportDate "ReportDate" true true false 8 Date 0 0,First,#,XYCrime,ReportDate,-1,-1,Geocoding_Result_4,ReportDate,-1,-1;CaseType "CaseType" true true false 254 Text 0 0,First,#,XYCrime,CaseType,0,254,Geocoding_Result_4,CaseType,0,254;Dispositio "Dispositio" true true false 254 Text 0 0,First,#,XYCrime,Dispositio,0,254,Geocoding_Result_4,Dispositio,0,254;Address "Address" true true false 254 Text 0 0,First,#,XYCrime,Address,0,254,Geocoding_Result_4,Address,0,254;Apartment "Apartment" true true false 254 Text 0 0,First,#,XYCrime,Apartment,0,254,Geocoding_Result_4,Apartment,0,254;City "City" true true false 254 Text 0 0,First,#,XYCrime,City,0,254,Geocoding_Result_4,City,0,254;X_1 "X_1" true true false 8 Double 0 0,First,#,XYCrime,X_1,-1,-1,Geocoding_Result_4,X_1,-1,-1;Y_1 "Y_1" true true false 8 Double 0 0,First,#,XYCrime,Y_1,-1,-1,Geocoding_Result_4,Y_1,-1,-1;CommonName "CommonName" true true false 254 Text 0 0,First,#,XYCrime,CommonName,0,254,Geocoding_Result_4,CommonName,0,254" NO_SOURCE_INFO UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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/2.4.0'><WorkspaceConnectionString>DATABASE=C:\Users\vencia\Documents\ArcGIS\Projects\TAD\TAD.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Crime_Merge</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Year</field_name><field_type>LONG</field_type><field_alias>Year</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Crime_Merge Year 2015 "Python 3" # CalculateField Crime_Merge Year 2016 "Python 3" # CalculateField Crime_Merge Year 2017 "Python 3" # CalculateField Crime_Merge Year 2018 "Python 3" # CalculateField Crime_Merge Year 2019 "Python 3" # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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/2.4.0'><WorkspaceConnectionString>DATABASE=C:\Users\vencia\Documents\ArcGIS\Projects\TAD\TAD.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Crime_Merge</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Date</field_name><field_type>DATE</field_type><field_alias>Date</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Crime_Merge Date !Year! "Python 3" # DeleteField Crime_Merge Date FeatureClassToFeatureClass Crime_Merge C:\Users\vencia\Documents\ArcGIS\Projects\TAD\TAD.gdb CrimePoints # "Year "Year" true true false 4 Long 0 0,First,#,Crime_Merge,Year,-1,-1" # 20190909 13154300 20190909 13154300 Microsoft Windows 10 Version 10.0 (Build 17134) ; Esri ArcGIS 12.4.0.19948 CrimePoints Crime TAD Crime data with attribution stripped 2015-2019 File Geodatabase Feature Class dataset EPSG 5.3(9.0.0) 0 Simple FALSE 0 TRUE FALSE CrimePoints Feature Class 0 OBJECTID OBJECTID 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. Year Year Integer 4 0 0 20190909