20130730
09012800
1.0
FALSE
CreateFeatureclass "Database Connections\Ellis_SDE.sde\Ellis.SDE.Data" Parcels POLYGON 'Database Connections\Titus.sde\Titus.SDE.Data\Titus.SDE.Parcels' DISABLED DISABLED "{B286C06B-0879-11D2-AACA-00C04FA33C20};-450359962737.05 -450359962737.05 10000;#;#;0.001;#;#;IsHighPrecision" # 0 0 0
DeleteFeatures "Database Connections\Ellis_SDE.sde\Ellis.SDE.Data\Ellis.SDE.Parcels"
DeleteFeatures "Database Connections\Ellis_SDE.sde\Ellis.SDE.Data\Ellis.SDE.Parcels"
CopyFeatures C:\Scripts\_Temp\Ellis.sde\Ellis.SDE.Parcels D:\GIS_Data\Ellis\SDE_Export\Parcels.shp # 0 0 0
CalculateField Ennis.SDE.Parcels Source "ECAD" VB #
CalculateField Ennis.SDE.Parcels Source_Date "8/18/2014" VB #
CalculateField Ennis.SDE.Parcels Source_Date "8/27/2012" VB #
CalculateField Ennis.SDE.Parcels Source_Date "8/18/2014" VB #
CalculateField Ennis.SDE.Parcels Source_Date "8/18/2014" VB #
CalculateField Parcels CAD_Link ""http://esearch.elliscad.com/Property/View/" & [PROP_ID]" VB #
CalculateField Parcels_2014_QAQC Prop_ID_Text [PROP_ID] VB #
CalculateField Ennis.SDE.Parcels Source_Date "Now ( )" VB #
CalculateField Ennis.SDE.Parcels Source_Date "Date ( )" VB #
CalculateField Ennis.SDE.Parcels Prop_ID_Text [PROP_ID] VB #
CalculateField Ennis.SDE.Parcels CAD_Link ""http://esearch.elliscad.com/Property/View/"& [Prop_ID_Text]" VB #
AddSpatialIndex Parcels -6 0 0
RemoveSpatialIndex Ennis.SDE.Parcels
AddSpatialIndex Ennis.SDE.Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Ennis.SDE.Parcels
AddSpatialIndex Ennis.SDE.Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels -6 0 0
AddSpatialIndex Parcels -6 0 0
AddSpatialIndex Parcels -6 0 0
RemoveSpatialIndex Parcels
RemoveSpatialIndex Parcels
RemoveSpatialIndex Parcels
RemoveSpatialIndex Parcels
RemoveSpatialIndex Ennis.SDE.Parcels
RemoveSpatialIndex Ennis.SDE.Parcels
RemoveSpatialIndex Ennis.SDE.Parcels
RemoveSpatialIndex W:\Citrix\30000s\30393\GIS\Ennis_srvsql14_LOADER.sde\Ennis.SDE.Reference_Data\Ennis.SDE.Parcels
RemoveSpatialIndex Parcels
RemoveSpatialIndex Parcels
RemoveSpatialIndex Ennis.SDE.Parcels
RemoveSpatialIndex Ennis.SDE.Parcels
RemoveSpatialIndex Parcels
RemoveSpatialIndex Parcels
RemoveSpatialIndex Parcels
RemoveSpatialIndex Ennis.SDE.Parcels
AddSpatialIndex Ennis.SDE.Parcels 0 0 0
RemoveSpatialIndex Ennis.SDE.Parcels
RemoveSpatialIndex Ennis.SDE.Parcels
AddSpatialIndex Ennis.SDE.Parcels 0 0 0
RemoveSpatialIndex Parcels
AddSpatialIndex Parcels 0 0 0
RemoveSpatialIndex Parcels
CalculateField Ennis.SDE.Parcels Owner_Address "1612 ARBORCREEK TRL MANSFIELD TX USA 76063" VB #
FeatureClassToFeatureClass Ennis.SDE.Parcels "W:\Citrix\SDE_Connections\SQL19\SQL19_PROD\Ennis to rchdb03-ahv.sde\Ennis.SDE.Reference_Data" Parcels # "PROP_ID "PROP_ID" true true false 8 Double 8 38,First,#,Ennis.SDE.Parcels,PROP_ID,-1,-1;Source "Source" true true false 50 Text 0 0,First,#,Ennis.SDE.Parcels,Source,0,50;Source_Date "Source Date" true true false 8 Date 0 0,First,#,Ennis.SDE.Parcels,Source_Date,-1,-1;CAD_Link "CAD Link" true true false 254 Text 0 0,First,#,Ennis.SDE.Parcels,CAD_Link,0,254;Address "Address" true true false 50 Text 0 0,First,#,Ennis.SDE.Parcels,Address,0,50;Prop_ID_Text "Property ID" true true false 25 Text 0 0,First,#,Ennis.SDE.Parcels,Prop_ID_Text,0,25;Owner_Nm "Owner Name" true true false 100 Text 0 0,First,#,Ennis.SDE.Parcels,Owner_Nm,0,100;Owner_Address "Owner Address" true true false 100 Text 0 0,First,#,Ennis.SDE.Parcels,Owner_Address,0,100;created_user "created_user" false true false 255 Text 0 0,First,#,Ennis.SDE.Parcels,created_user,0,255;created_date "created_date" false true false 8 Date 0 0,First,#,Ennis.SDE.Parcels,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0,First,#,Ennis.SDE.Parcels,last_edited_user,0,255;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,Ennis.SDE.Parcels,last_edited_date,-1,-1;geo_id "Geographic ID" true true false 50 Text 0 0,First,#,Ennis.SDE.Parcels,geo_id,0,50;GlobalID "GlobalID" false false false 38 GlobalID 0 0,First,#,Ennis.SDE.Parcels,GlobalID,-1,-1;legal_acre "Acres (Ellis Co Calulated)" true true false 8 Double 8 38,First,#,Ennis.SDE.Parcels,legal_acre,-1,-1;legal_desc "Legal Description" true true false 255 Text 0 0,First,#,Ennis.SDE.Parcels,legal_desc,0,255;Square_Feet "Square Feet (GIS Calculation)" true true false 8 Double 8 38,First,#,Ennis.SDE.Parcels,Square_Feet,-1,-1;Acres_GIS "Acres GIS Calculation" true true false 8 Double 8 38,First,#,Ennis.SDE.Parcels,Acres_GIS,-1,-1" #
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.9.0'><FeatureDataset>Ennis.SDE.Reference_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68325575626f414c2f4d4b4248773138656b50494c39773d3d2a00;SERVER=rchdb03-ahv;INSTANCE=sde:sqlserver:rchdb03-ahv\sde;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=rchdb03-ahv\sde;DATABASE=Ennis;USER=sde;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>Ennis.SDE.Parcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Lat</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Latitude </field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Long</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Longitude </field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>URL</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Google Street View URL</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.9.0'><FeatureDataset>Ennis.SDE.Reference_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68325575626f414c2f4d4b4248773138656b50494c39773d3d2a00;SERVER=rchdb03-ahv;INSTANCE=sde:sqlserver:rchdb03-ahv\sde;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=rchdb03-ahv\sde;DATABASE=Ennis;USER=sde;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>Ennis.SDE.Parcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Lat</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Lat</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Long</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Long</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>URL</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>URL</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.9.0'><FeatureDataset>Ennis.SDE.Reference_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68325575626f414c2f4d4b4248773138656b50494c39773d3d2a00;SERVER=rchdb03-ahv;INSTANCE=sde:sqlserver:rchdb03-ahv\sde;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=rchdb03-ahv\sde;DATABASE=Ennis;USER=sde;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>Ennis.SDE.Parcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Lat</field_name><field_name>Long</field_name><field_name>URL</field_name></DeleteField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.9.0'><FeatureDataset>Ennis.SDE.Reference_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68325575626f414c2f4d4b4248773138656b50494c39773d3d2a00;SERVER=rchdb03-ahv;INSTANCE=sde:sqlserver:rchdb03-ahv\sde;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=rchdb03-ahv\sde;DATABASE=Ennis;USER=sde;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>Ennis.SDE.Parcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Lat</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Latitude </field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Long</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Longitude </field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>URL</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Google Street View URL</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.9.0'><FeatureDataset>Ennis.SDE.Reference_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68325575626f414c2f4d4b4248773138656b50494c39773d3d2a00;SERVER=rchdb03-ahv;INSTANCE=sde:sqlserver:rchdb03-ahv\sde;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=rchdb03-ahv\sde;DATABASE=Ennis;USER=sde;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>Ennis.SDE.Parcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><EnableAttachments /></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.9.0'><FeatureDataset>Ennis.SDE.Reference_Data</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68325575626f414c2f4d4b4248773138656b50494c39773d3d2a00;SERVER=rchdb03-ahv;INSTANCE=sde:sqlserver:rchdb03-ahv\sde;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=rchdb03-ahv\sde;DATABASE=Ennis;USER=sde;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>Ennis.SDE.Parcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>X</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>X</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Y</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Y</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
FeatureClassToFeatureClass Ennis.SDE.Parcels W:\Citrix\30000s\30393\GIS\Data\Planning_Zoning\Streetview_Processing\Parcel_Data20220410.gdb Parcels_Working # "PROP_ID "PROP_ID" true true false 8 Double 8 38,First,#,Ennis.SDE.Parcels,PROP_ID,-1,-1;Source "Source" true true false 50 Text 0 0,First,#,Ennis.SDE.Parcels,Source,0,50;Source_Date "Source Date" true true false 8 Date 0 0,First,#,Ennis.SDE.Parcels,Source_Date,-1,-1;CAD_Link "CAD Link" true true false 254 Text 0 0,First,#,Ennis.SDE.Parcels,CAD_Link,0,254;Address "Address" true true false 50 Text 0 0,First,#,Ennis.SDE.Parcels,Address,0,50;Prop_ID_Text "Property ID" true true false 25 Text 0 0,First,#,Ennis.SDE.Parcels,Prop_ID_Text,0,25;Owner_Nm "Owner Name" true true false 100 Text 0 0,First,#,Ennis.SDE.Parcels,Owner_Nm,0,100;Owner_Address "Owner Address" true true false 100 Text 0 0,First,#,Ennis.SDE.Parcels,Owner_Address,0,100;created_user "created_user" false true false 255 Text 0 0,First,#,Ennis.SDE.Parcels,created_user,0,255;created_date "created_date" false true false 8 Date 0 0,First,#,Ennis.SDE.Parcels,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0,First,#,Ennis.SDE.Parcels,last_edited_user,0,255;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,Ennis.SDE.Parcels,last_edited_date,-1,-1;geo_id "Geographic ID" true true false 50 Text 0 0,First,#,Ennis.SDE.Parcels,geo_id,0,50;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,Ennis.SDE.Parcels,GlobalID,-1,-1;legal_acre "Acres (Ellis Co Calulated)" true true false 8 Double 8 38,First,#,Ennis.SDE.Parcels,legal_acre,-1,-1;legal_desc "Legal Description" true true false 255 Text 0 0,First,#,Ennis.SDE.Parcels,legal_desc,0,255;Square_Feet "Square Feet (GIS Calculation)" true true false 8 Double 8 38,First,#,Ennis.SDE.Parcels,Square_Feet,-1,-1;Acres_GIS "Acres GIS Calculation" true true false 8 Double 8 38,First,#,Ennis.SDE.Parcels,Acres_GIS,-1,-1;Lat "Latitude " true true false 255 Text 0 0,First,#,Ennis.SDE.Parcels,Lat,0,255;Long "Longitude " true true false 255 Text 0 0,First,#,Ennis.SDE.Parcels,Long,0,255;URL "Google Street View URL" true true false 255 Text 0 0,First,#,Ennis.SDE.Parcels,URL,0,255;X "X" true true false 8 Double 1 7,First,#,Ennis.SDE.Parcels,X,-1,-1;Y "Y" true true false 8 Double 1 7,First,#,Ennis.SDE.Parcels,Y,-1,-1" #
CalculateGeometryAttributes Parcels_Working "Lat CENTROID_Y" # # # "Same as input"
CalculateGeometryAttributes Parcels_Working "Long CENTROID_X" # # # "Same as input"
CalculateGeometryAttributes Parcels_Working "Long CENTROID_X" # # # "Same as input"
CalculateGeometryAttributes Parcels_Working "Lat INSIDE_Y" # # # "Same as input"
CalculateGeometryAttributes Parcels_Working "Long INSIDE_X" # # # "Same as input"
FeatureToPoint Parcels_Working W:\Citrix\30000s\30393\GIS\Data\Planning_Zoning\Streetview_Processing\Parcels_Test.shp INSIDE
CalculateField Parcels_Test URL "var PointGeometry = Geometry($feature);
var ArcadeX = PointGeometry.x;
var ArcadeY = PointGeometry.y;
var ArcadeSr = PointGeometry.spatialReference.wkid;
var Latitude, Longitude;
function AuxSphereToLatLon(x, y) { Console("Converting...");
// Conversion based on http://dotnetfollower.com/wordpress/2011/07/javascript-how-to-convert-mercator-sphere-coordinates-to-latitude-and-longitude/ var rMajor = 6378137;
var shift = PI * rMajor;
Longitude = x / shift * 180.0;
Latitude = y / shift * 180.0;
Latitude = 180 / PI * (2 * Atan(Exp(Latitude * PI / 180.0)) - PI / 2.0);
}
if (ArcadeSr == 4326) { Console("4326 Spatial Reference - No Conversion Necessary"); Latitude = ArcadeY; Longitude = ArcadeX;} else if (ArcadeSr == 102100) { Console("102100 Spatial Reference - Conversion Necessary"); AuxSphereToLatLon(ArcadeX, ArcadeY);} else { Console(ArcadeSr + " Spatial Reference is not supported - currently works with Web Maps where the basemap is in WGS84 (4326) or Web Mercator Auxiliary Sphere 102100");}
var url = "http://www.google.com/maps/@?api=1&map_action=pano&viewpoint=" + text(Latitude) + "," + text(Longitude);
return url;" Arcade # Text NO_ENFORCE_DOMAINS
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.9.0'><WorkspaceConnectionString>DATABASE=W:\Citrix\30000s\30393\GIS\Data\Planning_Zoning\Streetview_Processing</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>Parcels_Test</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>PROP_ID</field_name><field_name>Owner_Nm</field_name><field_name>Owner_Addr</field_name><field_name>geo_id</field_name><field_name>legal_acre</field_name><field_name>legal_desc</field_name><field_name>Square_Fee</field_name><field_name>X</field_name><field_name>Y</field_name><field_name>ORIG_FID</field_name></DeleteField></workflow></operationSequence>
FeatureClassToFeatureClass Parcels_Test "W:\Citrix\SDE_Connections\SQL19\SQL19_PROD\Ennis to rchdb03-ahv.sde\Ennis.SDE.Reference_Data" Streetview_LocationPoints # "Source "Source" true true false 50 Text 0 0,First,#,Parcels_Test,Source,0,50;Source_Dat "Source_Dat" true true false 8 Date 0 0,First,#,Parcels_Test,Source_Dat,-1,-1;CAD_Link "CAD_Link" true true false 254 Text 0 0,First,#,Parcels_Test,CAD_Link,0,254;Address "Address" true true false 50 Text 0 0,First,#,Parcels_Test,Address,0,50;Prop_ID_Te "Prop_ID_Te" true true false 25 Text 0 0,First,#,Parcels_Test,Prop_ID_Te,0,25;created_us "created_us" true true false 254 Text 0 0,First,#,Parcels_Test,created_us,0,254;created_da "created_da" true true false 8 Date 0 0,First,#,Parcels_Test,created_da,-1,-1;last_edite "last_edite" true true false 254 Text 0 0,First,#,Parcels_Test,last_edite,0,254;last_edi_1 "last_edi_1" true true false 8 Date 0 0,First,#,Parcels_Test,last_edi_1,-1,-1;GlobalID "GlobalID" true true false 38 Text 0 0,First,#,Parcels_Test,GlobalID,0,38;Acres_GIS "Acres_GIS" true true false 19 Double 0 0,First,#,Parcels_Test,Acres_GIS,-1,-1;Lat "Lat" true true false 254 Text 0 0,First,#,Parcels_Test,Lat,0,254;Long "Long" true true false 254 Text 0 0,First,#,Parcels_Test,Long,0,254;URL "URL" true true false 254 Text 0 0,First,#,Parcels_Test,URL,0,254;Shape_Leng "Shape_Leng" true true false 19 Double 0 0,First,#,Parcels_Test,Shape_Leng,-1,-1;Shape_Area "Shape_Area" true true false 19 Double 0 0,First,#,Parcels_Test,Shape_Area,-1,-1" #
CalculateField "Google Streetview Location Points" URL "'http://maps.google.com/maps?q=&layer=c&cbll=' + $feature.Lat + ',' + $feature.Long" Arcade # Text NO_ENFORCE_DOMAINS
CalculateGeometryAttributes "Google Streetview Location Points" "Lat POINT_Y" # # GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] "Same as input"
CalculateGeometryAttributes "Google Streetview Location Points" "Long POINT_X" # # GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] "Same as input"
CalculateField "Google Streetview Location Points" URL "'http://maps.google.com/maps?q=&layer=c&cbll=' + $feature.Lat + ',' + $feature.Long" Arcade # Text NO_ENFORCE_DOMAINS
Ennis.SDE.Streetview_LocationPoints
002
0.000
Server=rchdb03-ahv; Service=sde:sqlserver:rchdb03-ahv\sde; Database=Ennis; User=sde; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_Web_Mercator_Auxiliary_Sphere
<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.9.0'><WKT>PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem>
{"type":"CIMLayerDocument","version":"2.7.0","build":26828,"layers":["CIMPATH=layers/ennis_sde_parcels2.xml"],"layerDefinitions":[{"type":"CIMFeatureLayer","name":"Ennis.SDE.Parcels","uRI":"CIMPATH=layers/ennis_sde_parcels2.xml","sourceModifiedTime":{"type":"TimeInstant"},"useSourceMetadata":true,"description":"Ennis.SDE.Parcels","layerElevation":{"type":"CIMLayerElevationSurface","mapElevationID":"ef68eb84d4f242ab9beeddff1f23a0e6"},"expanded":true,"layerType":"Operational","showLegends":true,"visibility":true,"displayCacheType":"Permanent","maxDisplayCacheAge":5,"showPopups":true,"serviceLayerID":-1,"refreshRate":-1,"refreshRateUnit":"esriTimeUnitsSeconds","blendingMode":"Alpha","autoGenerateFeatureTemplates":true,"featureElevationExpression":"0","featureTable":{"type":"CIMFeatureTable","displayField":"PROP_ID","editable":true,"dataConnection":{"type":"CIMFeatureDatasetDataConnection","featureDataset":"Ennis.SDE.Reference_Data","workspaceConnectionString":"ENCRYPTED_PASSWORD=00022e6871765848634e5552476b4459665a336c68516e6949673d3d2a00;SERVER=rchdb03-ahv;INSTANCE=sde:sqlserver:rchdb03-ahv\\sde;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=rchdb03-ahv\\sde;DATABASE=Ennis;USER=sde;AUTHENTICATION_MODE=DBMS","workspaceFactory":"SDE","dataset":"Ennis.SDE.Parcels","datasetType":"esriDTFeatureClass"},"studyAreaSpatialRel":"esriSpatialRelUndefined","searchOrder":"esriSearchOrderSpatial"},"htmlPopupEnabled":true,"selectable":true,"featureCacheType":"Session","displayFiltersType":"ByScale","featureBlendingMode":"Alpha","labelClasses":[{"type":"CIMLabelClass","expressionTitle":"Custom","expression":"$feature.PROP_ID","expressionEngine":"Arcade","featuresToLabel":"AllVisibleFeatures","maplexLabelPlacementProperties":{"type":"CIMMaplexLabelPlacementProperties","featureType":"Line","avoidPolygonHoles":true,"canOverrunFeature":true,"canPlaceLabelOutsidePolygon":true,"canRemoveOverlappingLabel":true,"canStackLabel":true,"connectionType":"Unambiguous","constrainOffset":"NoConstraint","contourAlignmentType":"Page","contourLadderType":"Straight","contourMaximumAngle":90,"enableConnection":true,"featureWeight":100,"fontHeightReductionLimit":4,"fontHeightReductionStep":0.5,"fontWidthReductionLimit":90,"fontWidthReductionStep":5,"graticuleAlignmentType":"Straight","labelBuffer":15,"labelLargestPolygon":true,"labelPriority":-1,"labelStackingProperties":{"type":"CIMMaplexLabelStackingProperties","stackAlignment":"ChooseBest","maximumNumberOfLines":3,"minimumNumberOfCharsPerLine":3,"maximumNumberOfCharsPerLine":24},"lineFeatureType":"General","linePlacementMethod":"OffsetCurvedFromLine","maximumLabelOverrun":36,"maximumLabelOverrunUnit":"Point","minimumFeatureSizeUnit":"Map","multiPartOption":"OneLabelPerPart","offsetAlongLineProperties":{"type":"CIMMaplexOffsetAlongLineProperties","placementMethod":"BestPositionAlongLine","labelAnchorPoint":"CenterOfLabel","distanceUnit":"Percentage","useLineDirection":true},"pointExternalZonePriorities":{"type":"CIMMaplexExternalZonePriorities","aboveLeft":4,"aboveCenter":2,"aboveRight":1,"centerRight":3,"belowRight":5,"belowCenter":7,"belowLeft":8,"centerLeft":6},"pointPlacementMethod":"AroundPoint","polygonAnchorPointType":"GeometricCenter","polygonBoundaryWeight":200,"polygonExternalZones":{"type":"CIMMaplexExternalZonePriorities","aboveLeft":4,"aboveCenter":2,"aboveRight":1,"centerRight":3,"belowRight":5,"belowCenter":7,"belowLeft":8,"centerLeft":6},"polygonFeatureType":"General","polygonInternalZones":{"type":"CIMMaplexInternalZonePriorities","center":1},"polygonPlacementMethod":"CurvedInPolygon","primaryOffset":1,"primaryOffsetUnit":"Point","removeExtraWhiteSpace":true,"repetitionIntervalUnit":"Map","rotationProperties":{"type":"CIMMaplexRotationProperties","rotationType":"Arithmetic","alignmentType":"Straight"},"secondaryOffset":100,"strategyPriorities":{"type":"CIMMaplexStrategyPriorities","stacking":1,"overrun":2,"fontCompression":3,"fontReduction":4,"abbreviation":5},"thinningDistanceUnit":"Map","truncationMarkerCharacter":".","truncationMinimumLength":1,"truncationPreferredCharacters":"aeiou","polygonAnchorPointPerimeterInsetUnit":"Point"},"name":"Class 1","priority":-1,"standardLabelPlacementProperties":{"type":"CIMStandardLabelPlacementProperties","featureType":"Polygon","featureWeight":"None","labelWeight":"High","numLabelsOption":"OneLabelPerName","lineLabelPosition":{"type":"CIMStandardLineLabelPosition","above":true,"inLine":true,"parallel":true},"lineLabelPriorities":{"type":"CIMStandardLineLabelPriorities","aboveStart":3,"aboveAlong":3,"aboveEnd":3,"centerStart":3,"centerAlong":3,"centerEnd":3,"belowStart":3,"belowAlong":3,"belowEnd":3},"pointPlacementMethod":"AroundPoint","pointPlacementPriorities":{"type":"CIMStandardPointPlacementPriorities","aboveLeft":2,"aboveCenter":2,"aboveRight":1,"centerLeft":2,"centerRight":3,"belowLeft":3,"belowCenter":3,"belowRight":2},"rotationType":"Arithmetic","polygonPlacementMethod":"AlwaysHorizontal"},"textSymbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMTextSymbol","blockProgression":"TTB","depth3D":1,"extrapolateBaselines":true,"fontEffects":"Normal","fontEncoding":"Unicode","fontFamilyName":"Tahoma","fontStyleName":"Regular","fontType":"Unspecified","haloSize":1,"height":10,"hinting":"Default","horizontalAlignment":"Left","kerning":true,"letterWidth":100,"ligatures":true,"lineGapType":"ExtraLeading","symbol":{"type":"CIMPolygonSymbol","symbolLayers":[{"type":"CIMSolidFill","enable":true,"color":{"type":"CIMRGBColor","values":[0,0,0,100]}}]},"textCase":"Normal","textDirection":"LTR","verticalAlignment":"Bottom","verticalGlyphOrientation":"Right","wordSpacing":100,"billboardMode3D":"FaceNearPlane"}},"useCodedValue":true,"visibility":true,"iD":-1}],"renderer":{"type":"CIMSimpleRenderer","patch":"Default","symbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMPolygonSymbol","symbolLayers":[{"type":"CIMSolidStroke","enable":true,"capStyle":"Round","joinStyle":"Round","lineStyle3D":"Strip","miterLimit":10,"width":0.69999999999999996,"color":{"type":"CIMRGBColor","values":[110,110,110,100]}},{"type":"CIMSolidFill","enable":true,"color":{"type":"CIMRGBColor","values":[206.97,252.449999999999989,194.389999999999986,100]}}]}}},"scaleSymbols":true,"snappable":true}]}
20220410
21033700
20220410
21033700
Microsoft Windows 10 Version 10.0 (Build 19044) ; Esri ArcGIS 12.9.0.32739
Google Streetview Location Points
Address Points
Google Streetview Location Points
Enterprise Geodatabase Feature Class
0.000
dataset
EPSG
6.18.3(9.3.1.2)
0
Simple
FALSE
0
TRUE
FALSE
Ennis.SDE.Streetview_LocationPoints
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
8
0
0
Feature geometry.
ESRI
Coordinates defining the features.
Source
Source
String
50
0
0
Source_Dat
Source_Dat
Date
8
0
0
Address
Address
String
50
0
0
Prop_ID_Te
Prop_ID_Te
String
25
0
0
created_us
created_us
String
254
0
0
created_da
created_da
Date
8
0
0
last_edite
last_edite
String
254
0
0
last_edi_1
last_edi_1
Date
8
0
0
GlobalID
GlobalID
String
38
0
0
Acres_GIS
Acres_GIS
Double
8
38
8
CAD_Link
CAD_Link
String
254
0
0
Lat
Lat
String
254
0
0
Long
Long
String
254
0
0
URL
URL
String
254
0
0
Shape_Leng
Shape_Leng
Double
8
38
8
20220410
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigD//2Q==