20180921
12572800
1.0
FALSE
Server=gis-ag; Service=sde:sqlserver:gis-ag; Database=GISSupport; User=gisstaff; Version=sde.DEFAULT
ArcSDE Connection
GISSTAFF.pfmProjects
002
5404745.655288
6221875.284805
2009438.050297
2518990.980665
1
Projected
GCS_North_American_1983_HARN
Linear Unit: Foot_US (0.304801)
NAD_1983_HARN_StatePlane_California_V_FIPS_0405_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["NAD_1983_HARN_StatePlane_California_V_FIPS_0405_Feet",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",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",-118.0],PARAMETER["Standard_Parallel_1",34.03333333333333],PARAMETER["Standard_Parallel_2",35.46666666666667],PARAMETER["Latitude_Of_Origin",33.5],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2874]]</WKT><XOrigin>-117608900</XOrigin><YOrigin>-91881400</YOrigin><XYScale>3048.0060960121918</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>2874</WKID><LatestWKID>2874</LatestWKID></ProjectedCoordinateSystem>
FeatureClassToFeatureClass G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp G:\Users\KHIX\FileManagmentForArgGIS\PlanFileMgmt.gdb pfmProjects # "Shape_Leng "Shape_Leng" true true false 19 Double 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,Shape_Leng,-1,-1;Shape_Area "Shape_Area" true true false 19 Double 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,Shape_Area,-1,-1;GISID "GISID" true true false 10 Long 0 10 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,GISID,-1,-1;fileNo "fileNo" true true false 254 Text 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,fileNo,-1,-1;typeof "typeof" true true false 254 Text 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,typeof,-1,-1;desrcip "desrcip" true true false 254 Text 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,desrcip,-1,-1;specNo "specNo" true true false 254 Text 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,specNo,-1,-1;filenumber "filenumber" true true false 254 Text 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,filenumber,-1,-1;location "location" true true false 254 Text 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,location,-1,-1;name "name" true true false 254 Text 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,name,-1,-1;tractName "tractName" true true false 254 Text 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,tractName,-1,-1;pdf "pdf" true true false 254 Text 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,pdf,-1,-1;type "type" true true false 254 Text 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,type,-1,-1;status "status" true true false 254 Text 0 0 ,First,#,G:\Users\KHIX\FileManagmentForArgGIS\PFMProjects.shp,status,-1,-1" #
AlterField pfmProjects P_CW CityWide CityWide TEXT 10 NULLABLE false
AlterField pfmProjects GISID fileID fileID LONG 4 NULLABLE false
AlterField pfmProjects filenumber year year TEXT 254 NULLABLE false
CalculateField pfmProjects temp LCase( [fileNo] ) VB #
CalculateField pfmProjects fileNo LCase( [fileNo] ) VB #
AlterField pfmProjects fileNo PolyJoin PolyJoin TEXT 254 NULLABLE false
JoinField GISSTAFF.pfmProjects PolyJoin pfmJoin.csv polyJoin LFSID;fileID;polyJoin;typeof;description;specnum;year;size;name;tractname;type;status;CityWide;aerial;annex;bridge;commcon;corpyard;creekimp;curb;exhibit;gas;grading;landscape;minsub;parking;parks;privutil;recsurvey;sewer;stormdrain;street;tract;trafficsig;trctmap;water;wtrrec;wtrtreat;autocad;microfilm;recdrawing;scan;vault
JoinField GISSTAFF.pfmProjects PolyJoin pfmJoin.dbf polyJoin #
AlterField GISSTAFF.pfmProjects LFSID hyperlink hyperlink TEXT 254 NULLABLE false
CalculateField GISSTAFF.pfmProjects CityWide "CityWide" VB #
CalculateField GISSTAFF.pfmProjects hyperlink "https://publicplans.slocity.org/WebLink/0/edoc/" VB #
CalculateField GISSTAFF.pfmProjects hyperlink "" VB #
CalculateField pfmProjects temp 1 PYTHON3 # Text
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.7.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6878787756323638564a717543737144595443733933373746594232523434736b474657314845646c596f513d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>temp</field_name></DeleteField></workflow></operationSequence>
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.7.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6878787756323638564a717543737144595443733933373746594232523434736b474657314845646c596f513d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>temp</field_name></DeleteField></workflow></operationSequence>
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.7.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6878787756323638564a717543737144595443733933373746594232523434736b474657314845646c596f513d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>temp</field_name></DeleteField></workflow></operationSequence>
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.7.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6878787756323638564a717543737144595443733933373746594232523434736b474657314845646c596f513d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>temp</field_name></DeleteField></workflow></operationSequence>
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.7.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6878787756323638564a717543737144595443733933373746594232523434736b474657314845646c596f513d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>temp</field_name></DeleteField></workflow></operationSequence>
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.7.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6878787756323638564a717543737144595443733933373746594232523434736b474657314845646c596f513d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>temp</field_name></DeleteField></workflow></operationSequence>
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.7.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6878787756323638564a717543737144595443733933373746594232523434736b474657314845646c596f513d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>temp</field_name></DeleteField></workflow></operationSequence>
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.7.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6878787756323638564a717543737144595443733933373746594232523434736b474657314845646c596f513d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>temp</field_name></DeleteField></workflow></operationSequence>
CalculateField GISSTAFF.pfmProjects polyJoin_1 "'PFM00' + !PolyJoin!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField GISSTAFF.pfmProjects fileID !polyJoin_1! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField GISSTAFF.pfmProjects polyJoin_1 !fileID! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField GISSTAFF.pfmProjects polyJoin_1 "'_' + !fileID!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField GISSTAFF.pfmProjects polyJoin_1 !fileID! "Python 3" # 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/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b77472f545148683033714e4762312b7a71535a6a5a68423665382f6d625171376e4c2f613052376971773d2a00;ENCRYPTED_PASSWORD=00022e68524c364b5a68546e703839555a704b6b5631474f4863592f426c626c646c507a4f6f527333622b336d68383d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>EntryID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>30</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b77472f545148683033714e4762312b7a71535a6a5a68423665382f6d625171376e4c2f613052376971773d2a00;ENCRYPTED_PASSWORD=00022e68524c364b5a68546e703839555a704b6b5631474f4863592f426c626c646c507a4f6f527333622b336d68383d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>EntryID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>30</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b77472f545148683033714e4762312b7a71535a6a5a68423665382f6d625171376e4c2f613052376971773d2a00;ENCRYPTED_PASSWORD=00022e68524c364b5a68546e703839555a704b6b5631474f4863592f426c626c646c507a4f6f527333622b336d68383d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>EntryID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>30</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b77472f545148683033714e4762312b7a71535a6a5a68423665382f6d625171376e4c2f613052376971773d2a00;ENCRYPTED_PASSWORD=00022e68524c364b5a68546e703839555a704b6b5631474f4863592f426c626c646c507a4f6f527333622b336d68383d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>EntryID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b77472f545148683033714e4762312b7a71535a6a5a68423665382f6d625171376e4c2f613052376971773d2a00;ENCRYPTED_PASSWORD=00022e68524c364b5a68546e703839555a704b6b5631474f4863592f426c626c646c507a4f6f527333622b336d68383d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>EntryID_</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b77472f545148683033714e4762312b7a71535a6a5a68423665382f6d625171376e4c2f613052376971773d2a00;ENCRYPTED_PASSWORD=00022e68524c364b5a68546e703839555a704b6b5631474f4863592f426c626c646c507a4f6f527333622b336d68383d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>EntryID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b77472f545148683033714e4762312b7a71535a6a5a68423665382f6d625171376e4c2f613052376971773d2a00;ENCRYPTED_PASSWORD=00022e68524c364b5a68546e703839555a704b6b5631474f4863592f426c626c646c507a4f6f527333622b336d68383d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>EntryID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b77472f545148683033714e4762312b7a71535a6a5a68423665382f6d625171376e4c2f613052376971773d2a00;ENCRYPTED_PASSWORD=00022e68524c364b5a68546e703839555a704b6b5631474f4863592f426c626c646c507a4f6f527333622b336d68383d2a00;SERVER=gis-ag;INSTANCE=sde:sqlserver:gis-ag;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis-ag;DATABASE=GISSupport;USER=gisstaff;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GISSTAFF.pfmProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>EntryID</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
20191127
11555400
20191127
11555400
150000000
5000
Microsoft Windows 10 Version 10.0 (Build 17134) ; Esri ArcGIS 12.4.2.19948
pfmProjects
1
-121.904295
-119.127927
35.908614
34.453294
Approximate outer boundary line for projects with a link to associated plans within the City of San Luis Obispo
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Approximate outer boundary line for projects within the City of San Luis Obispo</SPAN></P></DIV></DIV></DIV>
City of San Luis Obispo
project file management
PMF
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>While every effort has been made to ensure that this data is accurate and reliable, the City of San Luis Obispo does not assume liability for any damages caused by any errors or omissions in the data, nor as a result of the failure of the data to function on a particular system. The City of San Luis Obispo makes no warranty, express or implied, that this data is accurate and reliable, nor does the fact of distribution constitute such a warranty. Users must assume responsibility to determine the appropriate use of these data. The City of San Luis Obispo provides this data to you for your exclusive use. This data may not be given away, sold or otherwise distributed to any third party without express written permission from the City of San Luis Obispo.</SPAN></P></DIV></DIV></DIV>
Enterprise Geodatabase Feature Class
dataset
EPSG
8.9.3(9.0.0)
2023
Simple
FALSE
2023
TRUE
FALSE
GISSTAFF.pfmProjects
Feature Class
2023
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
PolyJoin
PolyJoin
String
254
0
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
hyperlink
hyperlink
String
254
0
0
fileID
fileID
String
254
0
0
polyJoin_1
polyJoin_1
String
254
0
0
typeof
typeof
String
254
0
0
descriptio
descriptio
String
254
0
0
specnum
specnum
String
254
0
0
year
year
Integer
4
10
0
size
size
String
254
0
0
name
name
String
254
0
0
tractName
tractname
String
254
0
0
type
type
String
254
0
0
status
status
String
254
0
0
CityWide
CityWide
String
254
0
0
aerial
aerial
String
254
0
0
annex
annex
String
254
0
0
bridge
bridge
String
254
0
0
commcon
commcon
String
254
0
0
corpyard
corpyard
String
254
0
0
creekimp
creekimp
String
254
0
0
curb
curb
String
254
0
0
exhibit
exhibit
String
254
0
0
gas
gas
String
254
0
0
grading
grading
String
254
0
0
landscape
landscape
String
254
0
0
minsub
minsub
String
254
0
0
parking
parking
String
254
0
0
parks
parks
String
254
0
0
privutil
privutil
String
254
0
0
recsurvey
recsurvey
String
254
0
0
sewer
sewer
String
254
0
0
stormdrain
stormdrain
String
254
0
0
street
street
String
254
0
0
tract
tract
String
254
0
0
trafficsig
trafficsig
String
254
0
0
trctmap
trctmap
String
254
0
0
water
water
String
254
0
0
wtrrec
wtrrec
String
254
0
0
wtrtreat
wtrtreat
String
254
0
0
autocad
autocad
String
254
0
0
microfilm
microfilm
String
254
0
0
recdrawing
recdrawing
String
254
0
0
scan
scan
String
254
0
0
vault
vault
String
254
0
0
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20191127
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAABaRJREFUeJzt3V1v2+YdxuE/JUqyYsdxnSxB0w3YULTnPdr3P94H2MGAoQfZ
S/qaxIlfJFkcKG9BuzVNBMuT7ui6jgSLoB+I0g8kJfJpu67rCiBAu+0BAHwowQJiCBYQQ7CAGIIF
xBAsIIZgATEEC4ghWEAMwQJiCBYQQ7CAGIIFxBAsIIZgATEEC4ghWEAMwQJiCBYQQ7CAGIIFxBAs
IIZgATEEC4ghWEAMwQJiCBYQQ7CAGIIFxBAsIIZgATEEC4ghWEAMwQJiCBYQQ7CAGIIFxBAsIIZg
ATEEC4ghWLc0ny/qn89+qMFguJktwk5qBst68vS0hkPbeZsE65Yuzq/qL396U/enDzezRdhJl/Vt
ffLoqKbT6baHstcE65a66mrYHdSoOdzMFmEnXV2/qK7rtj2MvSdYQAzBAmIIFhBDsIAYggXEECwg
hmABMQQLiCFYQAzBAmIIFhBDsIAYggXEEKwgy25ZV/Pz1T0iPli/aPNrz3dVza8tsOby73m+HU5q
NBx/+P+DnxCsAC/ePK/Z4qJm84t6df5dtWt94N9brPc8v8n1dTUYtHV/elr3Jg/cQ4y1CVaIxw9+
Xx+L5fK6vnn5tWCxNsECYggWEEOwgBiCBcQQLCCGYAExBAuIIVhADMECYggWEEOwgBiCBcQQLCCG
YAExBAuIIVhADMECYggWEEOw9sjl/E0tu+uN3tK9qabG7bSGA28l7p532Z7oumX9ePb3mk6ON7re
xWJW583Lenj8242uF36JYO2NZjVTzYPDxxtdaz+bz8XV2UbXCe8iWEAMweJ/Dh1ni6satwfVrDPB
KvwfCBY/s1jOa9xOxIqdJFisXM5f17Pv/lx/ePJVNc3Aq8JOEixWFot5jUfT+vH1P+rk8MlqSvne
YBWvdX/7AHdDsFg5mn5Sy25RL8+/qdn8orrqajKa1snRpzVshg4R2QmCxVtHB6e17JZ1OTur86uX
dTA+qsX1rNrRoVeJnSBYrFwvF6tvCPvzV9+/+ltdzc/r/vTRzdEg7AjB2nP9HlR/yc7V7PUqVv2e
VR+rT08/r1E7qfHoYNtDhLcEa4/156m+P3tWg6ZdncMaNm1dzM7qy8/+WPcOTlZ7XP3e1snh4xq1
wsX2CdYe6y9cHg5Gq3S9Ov+25ovLOr73mzo8OFntbS2rVo/7vTDBYhcI1p57dPy7t4/7E+7PX/y1
5tezenj/s1our1eHhe1gXF3X+aaQrRMs3ho0TZ0ePa1BM7x5cwz7vS/YHYLFTzQ1Gd3zirCzBAuI
IVhADMECYggWEEOwgBiCBcQQrL3RrS672bT+R6Y398yCuydYe6K/1Kb/9Xr9933abzkvYXVdDQY3
PzSFuyZYe8T1gKQTLCCGYAExBAuIIVhADMECYggWEEOwgBiCBcQQLCCGYAExBAuIIVhADMEKcXbx
Q30s+hmlx6PptodBIMEKcDx9VN1qHuaPR/PvuQ9hHYIV4OZ+Uz7gIFhADMECYggWEEOwgBiCBcQQ
LCCGYAExBAuIIVhADMECYggWEEOwgBiCBcQQLCCGYAExBAuIIVhADMECYggWEEOwgBiCdUuHhwf1
9KvnVfX1z/7e9TPD/MLy7/r7tqw7nl0b/23H3D/3H+/aXr2TUVuTyeQORsc6BOuW2ratL778/Lar
AT6AYAExBAuIIVhADMECYggWEEOwgBiCBcQQLCCGYAExBAuIIVhADMECYggWEEOwgBiCBcQQLCCG
YAExBAuIIVhADMECYggWEEOwgBiCBcQQLCCGYAExBAuIIVhADMECYggWEEOwgBiCBcQQLCCGYAEx
BAuIIVhADMECYggWEEOwgBiCBcQQLCCGYAExBAuIIVhADMECYggWEEOwgBiCBcQQLCCGYAExBAuI
IVhADMECYggWEEOwgBiCBcQQLCCGYAExBAuIIVhApfgXER/sxDyty5EAAAAASUVORK5CYII=