20210313
11360800
1.0
FALSE
sde_Lucity.ARCADMIN.SW_LID_Bio_Planter
002
Server=srv-azgissql02; Service=sde:sqlserver:srv-azgissql02; Database=sde_published; User=arcadmin; Version=dbo.DEFAULT
ArcSDE Connection
1291734.340660
1309468.888852
245417.762899
264483.747404
1
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Washington_North_FIPS_4601_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.6'><WKT>PROJCS["NAD_1983_StatePlane_Washington_North_FIPS_4601_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",1640416.666666667],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-120.8333333333333],PARAMETER["Standard_Parallel_1",47.5],PARAMETER["Standard_Parallel_2",48.73333333333333],PARAMETER["Latitude_Of_Origin",47.0],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2285]]</WKT><XOrigin>-117104300</XOrigin><YOrigin>-99539600</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>102748</WKID><LatestWKID>2285</LatestWKID></ProjectedCoordinateSystem>
CalculateField SW_LID_Bio_Planter ASSETID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 1 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n"
CalculateField SW_LID_Bio_Planter GISID [ASSETID] VB #
CalculateField SW_LID_Bio_Planter ASSETID ""BioPlanter-"& [GISID]" VB #
CalculateField sde_vector.ARCADMIN.SW_LID_Bio_Planter GISID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart=1\n if (rec==0):\n rec=pStart\n else:\n rec=rec+1\n return rec"
CalculateField sde_vector.ARCADMIN.SW_LID_Bio_Planter ASSETID ""BioPlanter-"& [GISID]" VB #
CalculateField sde_vector.ARCADMIN.SW_LID_Bio_Planter GISID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart =1\n pInterval = 1\n if (rec==0):\n rec=pStart\n else:\n rec = rec+pInterval\n return rec"
CalculateField sde_vector.ARCADMIN.SW_LID_Bio_Planter ASSETID ""BioPlanter-"& [GISID]" VB #
CalculateField sde_vector.ARCADMIN.SW_LID_Bio_Planter GISID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 1\n pInterval = 1\n if (rec==0):\n rec=pStart\n else:\n rec=rec+pInterval\n return rec"
CalculateField sde_vector.ARCADMIN.SW_LID_Bio_Planter ASSETID ""BioPlatner-"& [GISID]" VB #
CalculateField sde_vector.ARCADMIN.SW_LID_Bio_Planter ASSETID ""BioPlanter-"& [GISID]" VB #
CalculateField Bioretention_Planter GISID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 1 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n"
CalculateField Bioretention_Planter ASSETID ""BioPlanter-"& [GISID]" VB #
EnableEditorTracking M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\arcadmin@srv-gisdb01@sde_Lucity.sde\sde_Lucity.ARCADMIN.SW_LID_Bio_Planter CREATE_NAME CREATE_DATE Edit_Name Edit_Date NO_ADD_FIELDS UTC
EnableEditorTracking M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\arcadmin@srv-gisdb01@sde_Lucity.sde\sde_Lucity.ARCADMIN.SW_LID_Bio_Planter CREATE_NAME CREATE_DATE Edit_Name Edit_Date NO_ADD_FIELDS UTC
EnableEditorTracking M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\arcadmin@srv-gisdb01@sde_Lucity.sde\sde_Lucity.ARCADMIN.SW_LID_Bio_Planter CREATE_NAME CREATE_DATE Edit_Name Edit_Date NO_ADD_FIELDS UTC
EnableEditorTracking M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\arcadmin@srv-gisdb01@sde_Lucity.sde\sde_Lucity.ARCADMIN.SW_LID_Bio_Planter CREATE_NAME CREATE_DATE Edit_Name Edit_Date NO_ADD_FIELDS UTC
EnableEditorTracking M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\arcadmin@srv-gisdb01@sde_Lucity.sde\sde_Lucity.ARCADMIN.SW_LID_Bio_Planter CREATE_NAME CREATE_DATE Edit_Name Edit_Date NO_ADD_FIELDS UTC
DisableEditorTracking M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\arcadmin@srv-gisdb01@sde_Lucity.sde\sde_Lucity.ARCADMIN.SW_LID_Bio_Planter DISABLE_CREATOR DISABLE_CREATION_DATE DISABLE_LAST_EDITOR DISABLE_LAST_EDIT_DATE
DeleteRows M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\arcadmin@srv-gisdb01@sde_Lucity.sde\sde_Lucity.ARCADMIN.SW_LID_Bio_Planter
Append M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\arcadmin@srv-gisdb01@sde_Lucity.sde\\sde_Lucity.ARCADMIN.SW_LID_Bio_Planter NO_TEST "Edit_Date "Edit_Date" true true false 36 Date 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,Edit_Date,-1,-1;Edit_Name "Edit_Name" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,Edit_Name,-1,-1;Edit_Source "Edit_Source" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,Edit_Source,-1,-1;Flow_Control "Flow_Control" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,Flow_Control,-1,-1;Water_Quality "Water_Quality" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,Water_Quality,-1,-1;Underdrain "Underdrain" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,Underdrain,-1,-1;GISID "GISID" true true false 2 Short 0 5 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,GISID,-1,-1;Maintenance "Maintenance" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,Maintenance,-1,-1;SW_Manual "SW_Manual" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,SW_Manual,-1,-1;Year_Installed "Year_Installed" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,Year_Installed,-1,-1;LID_SystemID "LID_SystemID" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,LID_SystemID,-1,-1;ASSETID "ASSETID" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,ASSETID,-1,-1;PDI_SystemID "PDI_SystemID" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,PDI_SystemID,-1,-1;PIN "PIN" true true false 50 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,PIN,-1,-1;ADDRESS "ADDRESS" true true false 80 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,ADDRESS,-1,-1;CREATE_NAME "CREATE_NME" true true false 150 Text 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,CREATE_NAME,-1,-1;CREATE_DATE "CREATE_DATE" true true false 36 Date 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,CREATE_DATE,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#;SHAPE.STArea() "SHAPE.STArea()" false false true 0 Double 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,SHAPE.STArea(),-1,-1;SHAPE.STLength() "SHAPE.STLength()" false false true 0 Double 0 0 ,First,#,M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\gisuser@srv-gisdb.sde\sde_vector.ARCADMIN.SW_LID_Bio_Planter,SHAPE.STLength(),-1,-1" #
EnableEditorTracking M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\arcadmin@srv-gisdb01@sde_Lucity.sde\sde_Lucity.ARCADMIN.SW_LID_Bio_Planter CREATE_NAME CREATE_DATE Edit_Name Edit_Date NO_ADD_FIELDS UTC
EnableEditorTracking M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\arcadmin@srv-gisdb01@sde_Lucity.sde\sde_Lucity.ARCADMIN.SW_LID_Bio_Planter CREATE_NAME CREATE_DATE EDIT_NAME EDIT_DATE NO_ADD_FIELDS UTC
EnableEditorTracking M:\IT\ApplicationAdmin\Lucity\Tool\Script\Lucity_Database_Day\Database_Connections\arcadmin@srv-gisdb01@sde_Lucity.sde\sde_Lucity.ARCADMIN.SW_LID_Bio_Planter CREATE_NAME CREATE_DATE EDIT_NAME EDIT_DATE NO_ADD_FIELDS UTC
AddField SW_LID_Bio_Planter LastModBy TEXT # # 40 "Last Modified By" NULLABLE NON_REQUIRED #
AddField SW_LID_Bio_Planter LastSynDate DATE # # 40 "Last Synchronized Date" NULLABLE NON_REQUIRED #
AddField SW_LID_Bio_Planter LUC_PRNTKEY LONG 10 # 40 # NULLABLE NON_REQUIRED #
AddField SW_LID_Bio_Planter PARENT_SYSID TEXT 10 # 20 # NULLABLE NON_REQUIRED #
CalculateField SW_LID_Bio_Planter PARENT_SYSID [PDI_SystemID] VB #
CalculateField SW_LID_Bio_Planter PARENT_SYSID [LID_SystemID] VB #
20210115
16442700
20210115
16442700
150000000
5000
ItemDescription
Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9270
SW_LID_Bio_Planter
1
-122.249874
-122.176489
47.717146
47.664014
Point locations of City of Kirkland surface water bio planters.
<DIV STYLE="text-align:Left;"><P><SPAN>Point locations of City of Kirkland surface water bio planters.</SPAN></P></DIV>
utilities / surface water system
City of Kirkland
Bio Planters
Flow Control
Water Quality
Underdrain
Low Impact Development
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
53
Simple
FALSE
53
TRUE
FALSE
sde_Lucity.ARCADMIN.SW_LID_Bio_Planter
Feature Class
53
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Edit_Date
Edit_Date
Date
8
0
0
Edit_Name
Edit_Name
String
50
0
0
Edit_Source
Edit_Source
String
50
0
0
Flow_Control
Flow_Control
String
50
0
0
Water_Quality
Water_Quality
String
50
0
0
Underdrain
Underdrain
String
50
0
0
GISID
GISID
SmallInteger
2
5
0
Maintenance
Maintenance
String
50
0
0
SW_Manual
SW_Manual
String
50
0
0
Year_Installed
Year_Installed
String
50
0
0
LID_SystemID
LID_SystemID
String
50
0
0
ASSETID
ASSETID
String
50
0
0
PDI_SystemID
PDI_SystemID
String
50
0
0
PIN
PIN
String
50
0
0
ADDRESS
ADDRESS
String
80
0
0
CREATE_NAME
CREATE_NME
String
150
0
0
CREATE_DATE
CREATE_DATE
Date
8
0
0
SHAPE
SHAPE
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
GlobalID
GlobalID
GlobalID
38
0
0
LID_INSP_FLG
LID_INSP_FLG
String
15
0
0
LUCITYKEY
LUCITYKEY
Integer
4
10
0
InLucity
InLucity?
SmallInteger
2
5
0
LastModBy
Last Modified By
String
40
0
0
LastModDate
Last Modified Date
Date
8
0
0
LastSynDate
Last Synchronized Date
Date
8
0
0
LUC_PRNTKEY
LUC_PRNTKEY
Integer
4
10
0
PARENT_SYSID
PARENT_SYSID
String
20
0
0
SHAPE.STArea()
SHAPE.STArea()
Double
0
0
0
SHAPE.STLength()
SHAPE.STLength()
Double
0
0
0
20210115
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKAEDAswGcjrkEf/rpaKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo
oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooPHbNFABRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRR
RQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFF
ABRRRQAUUUUAFFFFABRRRQAUUUUAFFJgbi3OSMdaWgAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigAoqOKUyjPlsowCCcYOR2qSgAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAP//Z