20210624
13092600
1.0
FALSE
MDB.DBO.PoliceBeat
002
6118737.565223
6613437.000363
1763373.650403
2129759.999322
1
Server=CW-GIS; Service=sde:sqlserver:CW-GIS\MSSQLSERVER_GIS; Database=MDB; User=sa; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_California_VI_FIPS_0406_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/10.8'><WKT>PROJCS["NAD_1983_StatePlane_California_VI_FIPS_0406_Feet",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["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-116.25],PARAMETER["Standard_Parallel_1",32.78333333333333],PARAMETER["Standard_Parallel_2",33.88333333333333],PARAMETER["Latitude_Of_Origin",32.16666666666666],UNIT["Foot_US",0.3048006096012192]],VERTCS["NAVD88_height_(ftUS)",VDATUM["North_American_Vertical_Datum_1988"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Foot_US",0.3048006096012192]]</WKT><XOrigin>-118608900</XOrigin><YOrigin>-91259500</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102646</WKID><LatestWKID>2230</LatestWKID><VCSWKID>105703</VCSWKID><LatestVCSWKID>6360</LatestVCSWKID></ProjectedCoordinateSystem>
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.7.0'><FeatureDataset>MDB.DBO.Administrative</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68436f796532675663684e4f64516b68784e5a303364502b37545248434d556153543878766a3874644c41453d2a00;SERVER=CW-GIS;INSTANCE=sde:sqlserver:CW-GIS\MSSQLSERVER_GIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=CW-GIS\MSSQLSERVER_GIS;DATABASE=MDB;USER=sa;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS\\vspeavey-p\MapServiceDocuments\People\PublicSafety\HPD_CAD_POI\LayerFiles7545248434d556153543878766a3874644c41453d2a00;SERVER=CW-GIS;INSTANCE=sde:sqlserver:CW-GIS\MSSQLSERVER_GIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=CW-GIS\MSSQLSERVER_GIS;DATABASE=MDB;USER=sa;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MDB.DBO.PoliceBeat</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>BEAT</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_alias>Beat</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.7.0'><FeatureDataset>MDB.DBO.Administrative</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68436f796532675663684e4f64516b68784e5a303364502b37545248434d556153543878766a3874644c41453d2a00;SERVER=CW-GIS;INSTANCE=sde:sqlserver:CW-GIS\MSSQLSERVER_GIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=CW-GIS\MSSQLSERVER_GIS;DATABASE=MDB;USER=sa;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS\\vspeavey-p\MapServiceDocuments\People\PublicSafety\HPD_CAD_POI\LayerFiles7545248434d556153543878766a3874644c41453d2a00;SERVER=CW-GIS;INSTANCE=sde:sqlserver:CW-GIS\MSSQLSERVER_GIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=CW-GIS\MSSQLSERVER_GIS;DATABASE=MDB;USER=sa;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MDB.DBO.PoliceBeat</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>BEAT</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_alias>Beat</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField "Police Beats" BEAT !BEATNUMBER! "Python 3" # Text
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.7.0'><FeatureDataset>MDB.DBO.Administrative</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68436f796532675663684e4f64516b68784e5a303364502b37545248434d556153543878766a3874644c41453d2a00;SERVER=CW-GIS;INSTANCE=sde:sqlserver:CW-GIS\MSSQLSERVER_GIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=CW-GIS\MSSQLSERVER_GIS;DATABASE=MDB;USER=sa;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS\\vspeavey-p\MapServiceDocuments\People\PublicSafety\HPD_CAD_POI\LayerFiles7545248434d556153543878766a3874644c41453d2a00;SERVER=CW-GIS;INSTANCE=sde:sqlserver:CW-GIS\MSSQLSERVER_GIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=CW-GIS\MSSQLSERVER_GIS;DATABASE=MDB;USER=sa;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MDB.DBO.PoliceBeat</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>BEAT</field_name></DeleteField></workflow><workflow><AddField><field_name>beat</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_alias>beat</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField HPD_Police_Beats beat !BEATNUMBER! "Python 3" # Text
AddGlobalIDs C:\Workspace\Projects\DatabaseConnections\sa_cw-gis_mdb.sde\MDB.DBO.Administrative\MDB.DBO.PoliceBeat
MultipartToSinglepart Police_Beats \\vshamer-a\MapServiceDocuments\HPD_CAD\HPD_CAD.gdb\PoliceBeat_Single
FeatureClassToFeatureClass PoliceBeat_Single \\vshamer-a\MapServiceDocuments\HPD_CAD\DatabaseConnections\sa_cw-gis_mdb.sde\MDB.DBO.Administrative PoliceBeat_Single # "LANDMANAGEMENTZONEIDPK "LANDMANAGEMENTZONEIDPK" true true false 20 Text 0 0,First,#,PoliceBeat_Single,LANDMANAGEMENTZONEIDPK,0,20;SDSFEATUREDESCRIPTION "SDSFEATUREDESCRIPTION" true true false 255 Text 0 0,First,#,PoliceBeat_Single,SDSFEATUREDESCRIPTION,0,255;SDSMETADATAID "SDSMETADATAID" true true false 80 Text 0 0,First,#,PoliceBeat_Single,SDSMETADATAID,0,80;MANAGEMENTZONE "MANAGEMENTZONE" true true false 30 Text 0 0,First,#,PoliceBeat_Single,MANAGEMENTZONE,0,30;BEATNUMBER "BEATNUMBER" true true false 10 Text 0 0,First,#,PoliceBeat_Single,BEATNUMBER,0,10;beat "beat" true true false 50 Text 0 0,First,#,PoliceBeat_Single,beat,0,50;ORIG_FID "ORIG_FID" true true false 4 Long 0 0,First,#,PoliceBeat_Single,ORIG_FID,-1,-1;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0,First,#,PoliceBeat_Single,SHAPE_Length,-1,-1;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0,First,#,PoliceBeat_Single,SHAPE_Area,-1,-1" #
Rename \\vshamer-a\MapServiceDocuments\HPD_CAD\DatabaseConnections\sa_cw-gis_mdb.sde\MDB.DBO.Administrative\MDB.DBO.PoliceBeat_Single \\vshamer-a\MapServiceDocuments\HPD_CAD\DatabaseConnections\sa_cw-gis_mdb.sde\MDB.DBO.Administrative\MDB.DBO.PoliceBeat FeatureClass
AddGlobalIDs \\vshamer-a\MapServiceDocuments\HPD_CAD\DatabaseConnections\sa_cw-gis_mdb.sde\MDB.DBO.Administrative\MDB.DBO.PoliceBeat
Rename \\vshamer-a\MapServiceDocuments\HPD_CAD\DatabaseConnections\sa_cw-gis_mdb.sde\MDB.DBO.Administrative\MDB.DBO.PoliceBeat \\vshamer-a\MapServiceDocuments\HPD_CAD\DatabaseConnections\sa_cw-gis_mdb.sde\MDB.DBO.Administrative\MDB.DBO.PoliceBeat_old FeatureClass
CopyMultiple "\\vshamer-a\MapServiceDocuments\HPD_CAD\DatabaseConnections\sa_cw-gis_mdb.sde\MDB.DBO.Administrative\MDB.DBO.PoliceBeat_old FeatureClass" \\vshamer-a\MapServiceDocuments\HPD_CAD\DatabaseConnections\sa_cw-gis_mdb.sde\MDB.DBO.Administrative PoliceBeat_old_1 "MDB.DBO.PoliceBeat_old FeatureClass MDB.DBO.PoliceBeat_old_1 #"
Rename \\vshamer-a\MapServiceDocuments\HPD_CAD\DatabaseConnections\sa_cw-gis_mdb.sde\MDB.DBO.Administrative\MDB.DBO.PoliceBeat_old_1 \\vshamer-a\MapServiceDocuments\HPD_CAD\DatabaseConnections\sa_cw-gis_mdb.sde\MDB.DBO.Administrative\MDB.DBO.PoliceBeat FeatureClass
20210721
16272300
20220407
13551000
150000000
5000
ItemDescription
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
Police_Beats
1
-117.703036
-116.080156
33.511553
32.496206
Operational layer used in SOMA CAD
My Credits
SOMA
Public
Safety
CAD
911
My Use Limitations
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
34
Simple
FALSE
34
TRUE
FALSE
MDB.DBO.PoliceBeat
Feature Class
34
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
LANDMANAGEMENTZONEIDPK
LANDMANAGEMENTZONEIDPK
String
20
0
0
SDSFEATUREDESCRIPTION
SDSFEATUREDESCRIPTION
String
255
0
0
SDSMETADATAID
SDSMETADATAID
String
80
0
0
MANAGEMENTZONE
MANAGEMENTZONE
String
30
0
0
BEATNUMBER
BEATNUMBER
String
10
0
0
SHAPE
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
beat
beat
String
50
0
0
GlobalID
GlobalID
GlobalID
38
0
0
ORIG_FID
ORIG_FID
Integer
4
10
0
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20220407