20220215
08200900
1.0
FALSE
vectorLGIM.DBO.SitePlanTracking
002
Server=SCGISDB01; Service=sde:sqlserver:SCGISDB01; Database=vectorLGIM; User=gisadmin; Version=dbo.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Virginia_North_FIPS_4501_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_Virginia_North_FIPS_4501_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",11482916.66666666],PARAMETER["False_Northing",6561666.666666666],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",38.03333333333333],PARAMETER["Standard_Parallel_2",39.2],PARAMETER["Latitude_Of_Origin",37.66666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2283]]</WKT><XOrigin>-110512499.9998</XOrigin><YOrigin>-88857999.999414995</YOrigin><XYScale>3262.2992133654102</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0024522582009720499</XYTolerance><ZTolerance>2</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>102746</WKID><LatestWKID>2283</LatestWKID></ProjectedCoordinateSystem>
FeatureClassToFeatureClass "T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp" C:\Users\ethompson\Documents\ArcGIS\Projects\SitePlanTracking\SitePlanTracking.gdb SitePlan # "MAP_Pin "MAP_Pin" true true false 25 Text 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,MAP_Pin,0,25;ZONING "Zoning" true true false 50 Text 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,ZONING,0,254;PARCEL "Parcel" true true false 254 Text 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,Parcel,0,254;PROJECTNUM "Project Number" true true false 20 Text 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,ProjectNum,0,254;PROJECTNAM "Project Name" true true false 254 Text 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,ProjectNam,0,254;SPTYPE "Site Plan Type" true true false 50 Text 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,SP_Type,0,254;SPUSE "Site Plan Use" true true false 255 Text 0 0,First,#;ZONINGUSE "Zoning Use" true true false 255 Text 0 0,First,#;DISTURBEDACS "Disturbed Acres" true true false 19 Double 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,DisturbedA,-1,-1;SITEACS "Site Acres" true true false 19 Double 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,SiteAcres,-1,-1;SFDPERMIT "Single Family Detatched Permitted" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,SFDPermitt,-1,-1;SFAPERMIT "Single Family Attached Permitted" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,SFAPermitt,-1,-1;MFUPERMIT "Multi Family Units Permitted" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,MFunitsPer,-1,-1;SFDBUILT "Single Family Detached Built" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,SFDBuilt,-1,-1;SFABUILT "Single Family Attached Built" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,SFABuilt,-1,-1;MFUBUILT "Multi Family Units Built" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,MFBuilt,-1,-1;COMMSQFT "Commercial Square Feet" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,CommSqFt,-1,-1;OFFSQFT "Office Square Feet" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,OffSqFt,-1,-1;INDSQFT "Industrial Square Feet" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,IndSqFt,-1,-1;COMMSQFTBLT "Commercial Square Feet Built" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,CSqFtBlt,-1,-1;OFFSQFTBLT "Office Square Feet Built" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,OSqFtBlt,-1,-1;INDSQFTBLT "Industrial Square Feet Built" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,ISqFtBlt,-1,-1;FINALTAZ "Final Taz" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,FinalTaz,-1,-1;TAZ "Taz" true true false 10 Long 0 10,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,Taz,-1,-1;STATUS "Status" true true false 254 Text 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,Status,0,254;DATEAPPROVED "Date Approved" true true false 8 Date 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,DateApprov,-1,-1;DEVSTATUS "Development Status" true true false 254 Text 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,Dev_Status,0,254;Shape_Leng "Shape_Leng" true true false 19 Double 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,Shape_Leng,-1,-1;Shape_Area "Shape_Area" true true false 19 Double 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,Shape_Area,-1,-1;COMMENTS "Comments" true true false 254 Text 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,PCW_Notes,0,254;APPROVPLAN "Approved Plan" true true false 250 Text 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,PDF_Links,0,250;APPROVLETT "ApprLtr" true true false 250 Text 0 0,First,#,T:\Planshar\Long Range Planning\Site Plan History Mapping\Emergency_Backup_12012021.shp,ApprLtr,0,250" #
FeatureClassToFeatureClass SitePlan Y:\SDEConnections\vectorLGIM_scgisdb01test_gisadmin_Default.sde\vectorLGIM.DBO.PlanningZoning SitePlanTracking # "MAP_Pin "MAP_Pin" true true false 25 Text 0 0,First,#,SitePlan,MAP_Pin,0,25;ZONING "Zoning" true true false 50 Text 0 0,First,#,SitePlan,ZONING,0,50;PARCEL "Parcel" true true false 254 Text 0 0,First,#,SitePlan,PARCEL,0,254;PROJECTNUM "Project Number" true true false 20 Text 0 0,First,#,SitePlan,PROJECTNUM,0,20;PROJECTNAM "Project Name" true true false 254 Text 0 0,First,#,SitePlan,PROJECTNAM,0,254;SPTYPE "Site Plan Type" true true false 50 Text 0 0,First,#,SitePlan,SPTYPE,0,50;SPUSE "Site Plan Use" true true false 255 Text 0 0,First,#,SitePlan,SPUSE,0,255;ZONINGUSE "Zoning Use" true true false 255 Text 0 0,First,#,SitePlan,ZONINGUSE,0,255;DISTURBEDACS "Disturbed Acres" true true false 8 Double 0 0,First,#,SitePlan,DISTURBEDACS,-1,-1;SITEACS "Site Acres" true true false 8 Double 0 0,First,#,SitePlan,SITEACS,-1,-1;SFDPERMIT "Single Family Detatched Permitted" true true false 4 Long 0 0,First,#,SitePlan,SFDPERMIT,-1,-1;SFAPERMIT "Single Family Attached Permitted" true true false 4 Long 0 0,First,#,SitePlan,SFAPERMIT,-1,-1;MFUPERMIT "Multi Family Units Permitted" true true false 4 Long 0 0,First,#,SitePlan,MFUPERMIT,-1,-1;SFDBUILT "Single Family Detached Built" true true false 4 Long 0 0,First,#,SitePlan,SFDBUILT,-1,-1;SFABUILT "Single Family Attached Built" true true false 4 Long 0 0,First,#,SitePlan,SFABUILT,-1,-1;MFUBUILT "Multi Family Units Built" true true false 4 Long 0 0,First,#,SitePlan,MFUBUILT,-1,-1;COMMSQFT "Commercial Square Feet" true true false 4 Long 0 0,First,#,SitePlan,COMMSQFT,-1,-1;OFFSQFT "Office Square Feet" true true false 4 Long 0 0,First,#,SitePlan,OFFSQFT,-1,-1;INDSQFT "Industrial Square Feet" true true false 4 Long 0 0,First,#,SitePlan,INDSQFT,-1,-1;COMMSQFTBLT "Commercial Square Feet Built" true true false 4 Long 0 0,First,#,SitePlan,COMMSQFTBLT,-1,-1;OFFSQFTBLT "Office Square Feet Built" true true false 4 Long 0 0,First,#,SitePlan,OFFSQFTBLT,-1,-1;INDSQFTBLT "Industrial Square Feet Built" true true false 4 Long 0 0,First,#,SitePlan,INDSQFTBLT,-1,-1;FINALTAZ "Final Taz" true true false 4 Long 0 0,First,#,SitePlan,FINALTAZ,-1,-1;TAZ "Taz" true true false 4 Long 0 0,First,#,SitePlan,TAZ,-1,-1;STATUS "Status" true true false 254 Text 0 0,First,#,SitePlan,STATUS,0,254;DATEAPPROVED "Date Approved" true true false 8 Date 0 0,First,#,SitePlan,DATEAPPROVED,-1,-1;DEVSTATUS "Development Status" true true false 254 Text 0 0,First,#,SitePlan,DEVSTATUS,0,254;Shape_Leng "Shape_Leng" true true false 8 Double 0 0,First,#,SitePlan,Shape_Leng,-1,-1;COMMENTS "Comments" true true false 254 Text 0 0,First,#,SitePlan,COMMENTS,0,254;APPROVPLAN "Approved Plan" true true false 250 Text 0 0,First,#,SitePlan,APPROVPLAN,0,250;APPROVLETT "ApprLtr" true true false 250 Text 0 0,First,#,SitePlan,APPROVLETT,0,250;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,SitePlan,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,SitePlan,Shape_Area,-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>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e684c4356694e5479536c6f57414c52432b426d4169744b4e4d6a43487046676762592f4b676d474a447479383d2a00;SERVER=scgisdb01test;INSTANCE=sde:sqlserver:scgisdb01test;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=scgisdb01test;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>ZONING</field_name><domain_name>ZoningDistrict</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>SPTYPE</field_name><domain_name>SitePlanType</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>STATUS</field_name><domain_name>Status</domain_name></AssignDomainToField></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>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6835767478785a326e566f736673654556685364797a784c4d31474879387761684c764665614462323475383d2a00;SERVER=SCGISDB01TEST;INSTANCE=sde:sqlserver:SCGISDB01TEST;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SCGISDB01TEST;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DeleteField><field_name>MAP_Pin</field_name></DeleteField></workflow><workflow><AddField><field_name>VOTDISTRICT</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_alias>Voting District</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>VotDistricts</field_domain></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>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6835767478785a326e566f736673654556685364797a784c4d31474879387761684c764665614462323475383d2a00;SERVER=SCGISDB01TEST;INSTANCE=sde:sqlserver:SCGISDB01TEST;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SCGISDB01TEST;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>MAP_Pin</field_name></DeleteField></workflow><workflow><AddField><field_name>VOTDISTRICT</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_alias>VOTDISTRICT</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>VotDistricts</field_domain></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>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686c4c626a38634d4c582b7544657639754b752b6e57636d494d39494b53677a50795359506c4d742b4659633d2a00;SERVER=scgisdb01test;INSTANCE=sde:sqlserver:scgisdb01test;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=scgisdb01test;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>MAP_Pin</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>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686c4c626a38634d4c582b7544657639754b752b6e57636d494d39494b53677a50795359506c4d742b4659633d2a00;SERVER=scgisdb01test;INSTANCE=sde:sqlserver:scgisdb01test;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=scgisdb01test;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>VOTDISTRICT</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>100</field_length><field_alias>Voting District</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>VotDistricts</field_domain></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>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686c4c626a38634d4c582b7544657639754b752b6e57636d494d39494b53677a50795359506c4d742b4659633d2a00;SERVER=scgisdb01test;INSTANCE=sde:sqlserver:scgisdb01test;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=scgisdb01test;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>SPUSE</field_name><domain_name>SitePlanUse</domain_name></AssignDomainToField></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>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686c4c626a38634d4c582b7544657639754b752b6e57636d494d39494b53677a50795359506c4d742b4659633d2a00;SERVER=scgisdb01test;INSTANCE=sde:sqlserver:scgisdb01test;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=scgisdb01test;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterField><field_name>SFDPERMIT</field_name><field_alias>Single Family Detached Approved</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>SFAPERMIT</field_name><field_alias>Single Family Attached Approved</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>MFUPERMIT</field_name><field_alias>Multi Family Units Approved</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>"
FeatureClassToFeatureClass vectorLGIM.DBO.SitePlanTracking Z:\SDEConnections\SCGISDB01_vectorLGIM_Default_gisadmin.sde\vectorLGIM.DBO.PlanningZoning SitePlanTracking # "PARCEL "Parcel" true true false 254 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,PARCEL,-1,-1;PROJECTNUM "Project Number" true true false 20 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,PROJECTNUM,-1,-1;PROJECTNAM "Project Name" true true false 254 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,PROJECTNAM,-1,-1;SPTYPE "Site Plan Type" true true false 50 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,SPTYPE,-1,-1;SPUSE "Site Plan Use" true true false 255 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,SPUSE,-1,-1;ZONING "Zoning" true true false 50 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,ZONING,-1,-1;ZONINGUSE "Zoning Use" true true false 255 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,ZONINGUSE,-1,-1;DISTURBEDACS "Disturbed Acres" true true false 8 Double 8 38 ,First,#,vectorLGIM.DBO.SitePlanTracking,DISTURBEDACS,-1,-1;SITEACS "Site Acres" true true false 8 Double 8 38 ,First,#,vectorLGIM.DBO.SitePlanTracking,SITEACS,-1,-1;SFDPERMIT "Single Family Detached Approved" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,SFDPERMIT,-1,-1;SFAPERMIT "Single Family Attached Approved" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,SFAPERMIT,-1,-1;MFUPERMIT "Multi Family Units Approved" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,MFUPERMIT,-1,-1;SFDBUILT "Single Family Detached Built" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,SFDBUILT,-1,-1;SFABUILT "Single Family Attached Built" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,SFABUILT,-1,-1;MFUBUILT "Multi Family Units Built" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,MFUBUILT,-1,-1;COMMSQFT "Commercial Square Feet" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,COMMSQFT,-1,-1;OFFSQFT "Office Square Feet" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,OFFSQFT,-1,-1;INDSQFT "Industrial Square Feet" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,INDSQFT,-1,-1;COMMSQFTBLT "Commercial Square Feet Built" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,COMMSQFTBLT,-1,-1;OFFSQFTBLT "Office Square Feet Built" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,OFFSQFTBLT,-1,-1;INDSQFTBLT "Industrial Square Feet Built" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,INDSQFTBLT,-1,-1;FINALTAZ "Final Taz" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,FINALTAZ,-1,-1;TAZ "Taz" true true false 4 Long 0 10 ,First,#,vectorLGIM.DBO.SitePlanTracking,TAZ,-1,-1;VOTDISTRICT "Voting District" true true false 100 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,VOTDISTRICT,-1,-1;STATUS "Status" true true false 254 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,STATUS,-1,-1;DATEAPPROVED "Date Approved" true true false 8 Date 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,DATEAPPROVED,-1,-1;DEVSTATUS "Development Status" true true false 254 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,DEVSTATUS,-1,-1;COMMENTS "Comments" true true false 254 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,COMMENTS,-1,-1;APPROVPLAN "Approved Plan" true true false 250 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,APPROVPLAN,-1,-1;APPROVLETT "ApprLtr" true true false 250 Text 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,APPROVLETT,-1,-1;Shape_Leng "Shape_Leng" true true false 8 Double 8 38 ,First,#,vectorLGIM.DBO.SitePlanTracking,Shape_Leng,-1,-1;Shape_STArea() "Shape.STArea()" false true true 0 Double 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,Shape.STArea(),-1,-1;Shape_STLength() "Shape.STLength()" false true true 0 Double 0 0 ,First,#,vectorLGIM.DBO.SitePlanTracking,Shape.STLength(),-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>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686439366d6869364e6131536c634b70622f372f4d576d75555045562f794538777053466f437170517938593d2a00;SERVER=SCGISDB01;INSTANCE=sde:sqlserver:SCGISDB01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SCGISDB01;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>SFDPERMIT</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>SFAPERMIT</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>MFUPERMIT</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>SFDBUILT</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>SFABUILT</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>MFUBUILT</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>COMMSQFT</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>OFFSQFT</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>INDSQFT</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>COMMSQFTBLT</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>OFFSQFTBLT</field_name><default_value>0</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>INDSQFTBLT</field_name><default_value>0</default_value></AssignDefaultToField></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>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686439366d6869364e6131536c634b70622f372f4d576d75555045562f794538777053466f437170517938593d2a00;SERVER=SCGISDB01;INSTANCE=sde:sqlserver:SCGISDB01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SCGISDB01;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>YEAR</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>Application Year</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField SitePlan_Editing COMMENTS !COMMENTS2! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SitePlan_Editing DEVSTATUS !DEVSTATUS2! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SitePlan_Editing APPLICANT !APPLICANT! "Python 3" # Text NO_ENFORCE_DOMAINS
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.4.0'><FeatureDataset>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686439366d6869364e6131536c634b70622f372f4d576d75555045562f794538777053466f437170517938593d2a00;SERVER=SCGISDB01;INSTANCE=sde:sqlserver:SCGISDB01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SCGISDB01;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>DEVSTATUS2</field_name><field_name>COMMENTS2</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.4.0'><FeatureDataset>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686439366d6869364e6131536c634b70622f372f4d576d75555045562f794538777053466f437170517938593d2a00;SERVER=SCGISDB01;INSTANCE=sde:sqlserver:SCGISDB01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SCGISDB01;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>SPTYPE</field_name></RemoveDomainFromField></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/3.0.0'><FeatureDataset>vectorLGIM.DBO.PlanningZoning</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686439366d6869364e6131536c634b70622f372f4d576d75555045562f794538777053466f437170517938593d2a00;SERVER=SCGISDB01;INSTANCE=sde:sqlserver:SCGISDB01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SCGISDB01;DATABASE=vectorLGIM;USER=gisadmin;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>vectorLGIM.DBO.SitePlanTracking</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>SPTYPE</field_name><domain_name>SitePlanType</domain_name></AssignDomainToField></workflow></operationSequence>
20220314
10321000
20220314
10321000
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
SitePlan_Public
Site Plans
Site Plans
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
vectorLGIM.DBO.SitePlanTracking
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
ZONING
Zoning
String
50
0
0
PARCEL
Parcel
String
254
0
0
PROJECTNUM
Project Number
String
20
0
0
PROJECTNAM
Project Name
String
254
0
0
SPTYPE
Site Plan Type
String
50
0
0
SPUSE
Site Plan Use
String
255
0
0
ZONINGUSE
Zoning Use
String
255
0
0
DISTURBEDACS
Disturbed Acres
Double
8
38
8
SITEACS
Site Acres
Double
8
38
8
SFDPERMIT
Single Family Detached Approved
Integer
4
10
0
SFAPERMIT
Single Family Attached Approved
Integer
4
10
0
MFUPERMIT
Multi Family Units Approved
Integer
4
10
0
SFDBUILT
Single Family Detached Built
Integer
4
10
0
SFABUILT
Single Family Attached Built
Integer
4
10
0
MFUBUILT
Multi Family Units Built
Integer
4
10
0
COMMSQFT
Commercial Square Feet
Integer
4
10
0
OFFSQFT
Office Square Feet
Integer
4
10
0
INDSQFT
Industrial Square Feet
Integer
4
10
0
COMMSQFTBLT
Commercial Square Feet Built
Integer
4
10
0
OFFSQFTBLT
Office Square Feet Built
Integer
4
10
0
INDSQFTBLT
Industrial Square Feet Built
Integer
4
10
0
FINALTAZ
Final Taz
Integer
4
10
0
VOTDISTRICT
Voting District
String
100
0
0
TAZ
Taz
Integer
4
10
0
STATUS
Status
String
254
0
0
DATEAPPROVED
Date Approved
Date
8
0
0
DEVSTATUS
Development Status
String
254
0
0
Shape_Leng
Shape_Leng
Double
8
38
8
COMMENTS
Comments
String
254
0
0
APPROVPLAN
Approved Plan
String
250
0
0
APPROVLETT
ApprLtr
String
250
0
0
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20220314
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK5Txdc+I9PijvtG8iWCAFp7doyWYYPOc8gc
HAwcjuOKmUuVXJlLlVzq6KydAvrnUtDtbu7g8maVdxX1GeD7ZGD+Na1NO6uNO6uFZ1vqKzXF/HKq
xLayhNzN95Situ9upH4Vo1h+I4S+n5SN2IYFmTsB6+tEtFcunHnmotm0rK6hlYMD3Bp1c5oMNuAD
Heu7AZaEHCg+uO9dHRF3VyqsFCTin+hXuonntpIo2VWZcZddw/EZFFLczx2tvJPK6pHGpZmYhQAP
c9KKtJvZGLaW7J6KKKkoKKKKACiiigAooooAKKKKACiiigAooqOSWOJQ0jqgJCgsccnoKAJKK5nx
HP4lt1STQ4rSWEY8xZVYyA5ySOcFccEdeuPbCudf8U3E0It7aOBEO2cJHuZiCSSAT93aB78/ljOs
obpiTu7HoLMEUsxwAMmsjVLi9ufDk1xobpJcyRboGYcEH0B74zjPfGazUj1C+EEt9b7hJ9+IEhV9
R9PfvU2py/ZNatpEfyIUjVZCvTaCfl2j2/n7VdCo6knpa3fqVXhyRWu/boa+lW01ppdrb3EzTTRx
KskjHJZscnNXqhguIbmISwyLIh7qc1NVvfUlWS0CsLXdVtYbaW03b5pFK7VP3frWxKAYmB3Y2n7v
X8PevOTG8bsJQRID8wPUGplKMYu52YOg6s79i7o1xDDq0TTbgucBgejHjn2rtrsXDWkgtHVZ9vyF
hkZry063p2m6raxX4doywMuxc7R7+oz2HbNekvq9lHJbRmdWa5XfEF5ymM7j6L7n1FbSo+zjGyMc
TXjVqvXVaeh5Eup6nqV1daJqC3TahczBYz5hXypd3cD+AAt646+mCvXG0fT31eLV/JQ3aRlFkA7H
v9cZGfQmiul41x/hq3c8xYJS/iSbNKiiiuI7gooooAKKKKACiiigAooooAKKKKAKl9eQafYTXdxJ
5cMSFmfrgD+deT2Gpf29qUbveXEqQSNcuJ3YhScFQo6AA/yPrXrV5ZW+oWj2t3CksMgwyMMg15V4
l+Hd3pcctzo5kuLU8vDnMijr/wACA/Os3RnVqRUZcq11MqlSVP3lHmXVHqGl6hDqemW97AwaOZAw
Pv3H505o7eziacQ8xpj5FyxHp71yfwxNz/wjDLMCIluGEWR24z+ua6y/N4scZs1Rm8wbw393vW9W
nyzcE9iqM/aQUmtzA1bWb2Zlj0wtGo5MmwMx69jnjHtWFPHJefZxDDJm33POVBZpmP8AEx6gDnr3
JrqrGxTTnWe9eJXd1SPDE/OePzNbKQxRM7xxqrSHLkDG4+9RQqyUffSuZypOe7OD8Nz6iPE5tYpk
NrFDuuVcckknbj3GPyzW54R8QN4jtr26KBI0uSkK45CbRjPv1rzzWdffTviHe3oWRTFKU+XAJAQL
jnqDjP45rr/hjZS2vhqSaUYW4mLxj/ZAAz+YNd1aklT53u7W/U56FW9T2cXte/4WO5rMv9HttQdH
fKODyygZYehrTorgaT3PRjOUHzRdmYOseF9O1e0SNolimhH7iZR80Z7fUZ7GuTTTp7K+utR1af7T
eqCgKghY4x0Cg9OP89SfSqydX09rhVmiGXQYYd2FRiJVXRcIPQ5qtJSfN1OV8Ma3q32Qz3oTypW3
RQ/3U7c0V0mlabEUS5k3M3ZGXABB6+9Fc1KlW5V71vxCEJ8u5uUUUV2m4UUUUAFFFFABRRRQAUUU
UAUb7VbLTBC17cpCs0nloX6FsE49uner1ZWqaHYavJbvewmQ2z74zvIwcg9B16d61alXu7iV7hRR
RVDI0iSNcIiqMk4UY5PWpKKKAMG40KW5uo7iW68x4wyruU8BipPGfVF/Kt6iipjBR2EopbHM+IPB
mm+Ip47i48yKdMAyIfvKOxB/nW/b28Vpbx28CCOKNQqKo4AFT0Vo5yaUW9EJQim5JasKKKKkoKKK
KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooqMSxmQoHG4YyKAJKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAx9ZvjCot42IdhlmHGBWCTubc2SfUnmtj7E+oahctNvjVDtUgdfT9B+tLLoH
3fJm+u8f4V51WnVqyclsc8oyk7oi0WaR77Y0jspjPBYkdq6Ks7T9NWx3OX3yMME4wAK0a66EZRha
W5tBNLUKKKK2KCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigD/2Q==