FALSE
1.0
20230412
16211800
file://\\PUD88205\C$\Users\DBoiano\OneDrive - City of San Diego\Documents\David Projects\Splitting Services\Data\Splitting_Services.gdb
Local Area Network
PUDEDIT.PUD.wMeter
002
6224417.058588
12582611.076755
1777104.772219
3802341.246672
1
-
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],AUTHORITY["EPSG",2230]]</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></ProjectedCoordinateSystem>
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" FACILITYID FACILITYID NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" INSTALLDATE INSTALLDATE NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" ACTIVEFLAG ACTIVEFLAG NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" ENABLED ENABLED NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" OWNEDBY OWNEDBY NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" MAINTBY MAINTBY NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" LASTUPDATE LASTUPDATE NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" LASTEDITOR LASTEDITOR NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" LOCDESC LOCDESC NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" ROTATION ROTATION NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" SERIAL_NUMBER SERIAL_NUMBER NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" CIS_METER_IND CIS_METER_IND NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" MAKE_CD MAKE_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STYLE_CD STYLE_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" SIZE_NUM SIZE_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" WHERE_INSTALLED_CD WHERE_INSTALLED_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" MAP_400_VISIBLE_IND MAP_400_VISIBLE_IND NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" CIS_CYC_NUM CIS_CYC_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" CIS_FOLIO_NUM CIS_FOLIO_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" CIS_MTR_SEQ_NUM CIS_MTR_SEQ_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" BILLING_PD_CD BILLING_PD_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" OUT_SRVC_IND OUT_SRVC_IND NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STATION_NM_CD STATION_NM_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" AREA_NM_CD AREA_NM_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" AREA_TYP_CD AREA_TYP_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" INFRAS_SUBTYP_LVL1_CD INFRAS_SUBTYP_LVL1_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" INFRAS_SUBTYP_LVL2_CD INFRAS_SUBTYP_LVL2_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" INVENTORY_ID_NUM INVENTORY_ID_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" AREA_NUM_CD AREA_NUM_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" MAP_ID MAP_ID NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" FAC_NAME FAC_NAME NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STRT_ADDR_TYP_CD STRT_ADDR_TYP_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STRT_FRACTN_NUM STRT_FRACTN_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STRT_PREDIR_CD STRT_PREDIR_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STRT_NM STRT_NM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STRT_SFX_CD STRT_SFX_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STRT_UNIT_NUM STRT_UNIT_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" JURIS_CD JURIS_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STRT_HNDRD_BLK_IND STRT_HNDRD_BLK_IND NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STRT_HNDRD_BLK_NUM STRT_HNDRD_BLK_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STA_PRIM_NUM STA_PRIM_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STA_SCNDRY_NUM STA_SCNDRY_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" INTERCEPTOR_IND INTERCEPTOR_IND NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" MAPNG_STAT_CD MAPNG_STAT_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" FAC_TYP_CD FAC_TYP_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" ACTL_INST_DT_IND ACTL_INST_DT_IND NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" ASSET_NUM ASSET_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" INVENTORY_NUM INVENTORY_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" FLD_BK_PAGE_NUM FLD_BK_PAGE_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" FLD_BK_GRID_NUM FLD_BK_GRID_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" DRAWING DRAWING NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" NAD83E_NUM NAD83E_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" NAD83N_NUM NAD83N_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" NAD27E_NUM NAD27E_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" NAD27N_NUM NAD27N_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" SENSITIVE_LAND_IND SENSITIVE_LAND_IND NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" COUNCILDISTRICT COUNCILDISTRICT NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" THOMAS_BROTHERS_CD THOMAS_BROTHERS_CD NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" LAST_ATTR_UPDT_DT LAST_ATTR_UPDT_DT NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" LAST_ATTR_UPDT_ID LAST_ATTR_UPDT_ID NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" LAST_BATCH_UPDT_DT LAST_BATCH_UPDT_DT NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" LAST_BATCH_UPDT_ID LAST_BATCH_UPDT_ID NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" GPS_X_COORD_NUM GPS_X_COORD_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" GPS_Y_COORD_NUM GPS_Y_COORD_NUM NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" GPS_SURVEYOR_IND GPS_SURVEYOR_IND NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" OLD_SPLASH1_DWO_ID OLD_SPLASH1_DWO_ID NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" OLD_SPLASH1_WORK_ORDR_ID OLD_SPLASH1_WORK_ORDR_ID NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" FACILITY_COMMENT_TEXT FACILITY_COMMENT_TEXT NON_UNIQUE NON_ASCENDING
AddIndex "Database Connections/ad@atlas-edit.sde/PUDEDIT.PUD.WATER/PUDEDIT.PUD.wMeter" STRT_NUM STRT_NUM NON_UNIQUE NON_ASCENDING
AddField E:\Data\IAMSD\PUDEDIT_FeatureClasses.gdb\wMeter IAMEQUI TEXT # # 20 # NULLABLE NON_REQUIRED #
AddField E:\Data\IAMSD\PUDEDIT_FeatureClasses.gdb\wMeter SAPOBJNR TEXT # # 22 # NULLABLE NON_REQUIRED #
AddField E:\Data\IAMSD\PUDEDIT_FeatureClasses.gdb\wMeter SAPOBJNR TEXT # # 22 # NULLABLE NON_REQUIRED #
CalculateField PUDEDIT.PUD.wMeter ISU_IND "No" VB #
CalculateField PUDEDIT.PUD.wMeter IAMFLOC null VB #
CalculateField PUDEDIT.PUD.wMeter SAPOBJNR null VB #
CalculateField "Water\Water, Active\W Meter" FACILITY_COMMENT_TEXT 'ASSOCIATED WITH DWG 15843. DGREMS 6/12/2018.' PYTHON_9.3 #
AddField D:\batch_files\GIS_TO_SAP_SYNC\connections\PUD@ATLAS-EDIT@PUDEDIT.PUD_Staging.sde\PUDEDIT.PUD.WATER\PUDEDIT.PUD.wMeter last_edited_mdg_date DATE # # # # NULLABLE NON_REQUIRED #
AddField D:\batch_files\GIS_TO_SAP_SYNC\connections\PUD@ATLAS-EDIT@PUDEDIT.PUD_Staging.sde\PUDEDIT.PUD.WATER\PUDEDIT.PUD.wMeter last_edited_mdg_user TEXT # # 50 # NULLABLE NON_REQUIRED #
AddField "w:\Development\39619 - PressureZone Updates\Connections\pud@atlas-edit@pudedit.sde\WATER\wMeter" PRESSR_ZN_NM TEXT # # 20 "Pressure Zone Name" NULLABLE NON_REQUIRED piHGLZone
AddField "w:\Development\39619 - PressureZone Updates\Connections\pud@atlas-edit@pudedit.sde\WATER\wMeter" PRESSR_ZN_QTY LONG # # # "Pressure Zone Quantity" NULLABLE NON_REQUIRED #
AddField pud@atlas-edit@pudedit.JMcMillan_39501.sde\pudedit.PUD.WATER\pudedit.PUD.wMeter SIZE_NUM_str TEXT # # 25 # NULLABLE NON_REQUIRED #
DeleteField pud@atlas-edit@pudedit.JMcMillan_39501.sde\pudedit.PUD.WATER\pudedit.PUD.wMeter SIZE_NUM
AddField pud@atlas-edit@pudedit.JMcMillan_39501.sde\pudedit.PUD.WATER\pudedit.PUD.wMeter SIZE_NUM TEXT # # 25 # NULLABLE NON_REQUIRED #
DeleteField pud@atlas-edit@pudedit.JMcMillan_39501.sde\pudedit.PUD.WATER\pudedit.PUD.wMeter SIZE_NUM_str
AssignDomainToField pud@atlas-edit@pudedit.JMcMillan_39501.sde\pudedit.PUD.WATER\pudedit.PUD.wMeter MAKE_CD wMeterMakeCd #
AssignDomainToField pud@atlas-edit@pudedit.JMcMillan_39501.sde\pudedit.PUD.WATER\pudedit.PUD.wMeter SIZE_NUM wMeterSize #
CalculateField PUDEDIT.PUD.wMeter SIZE_NUM '0.76' PYTHON_9.3 #
CalculateField PUDEDIT.PUD.wMeter SIZE_NUM '0.77' PYTHON_9.3 #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "1" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "5" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "5" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "1" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "5" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "1" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "5" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "5" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "5" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "1" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "1" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "5" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "5" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "5" VB #
CalculateField "Water\Water, Active\W Meter" STYLE_CD "1" VB #
CalculateField "Water\Water, Active\W Meter" MAKE_CD " "0"" VB #
CalculateField "Water\Water, Active\W Meter" MAKE_CD " "2"" VB #
CalculateField "Water\Water, Active\W Meter" MAKE_CD " "1"" VB #
CalculateField "Water\Water, Active\W Meter" PRESSR_ZN_NM "HIDDEN TRAILS" VB #
AddField W:\Workspace\ChenC\Development\43604_Add_SAP_Address_Field_To_Meter\Scripts\wMeterSAP\data\connectionFiles\PROD\PUD@PUDEDIT@ATLAS-EDIT.sde\PUDEDIT.PUD.WATER\PUDEDIT.PUD.wMeter SAP_HOUSE_NUM TEXT # # 10 "SAP House Number" NULLABLE NON_REQUIRED #
AddField W:\Workspace\ChenC\Development\43604_Add_SAP_Address_Field_To_Meter\Scripts\wMeterSAP\data\connectionFiles\PROD\PUD@PUDEDIT@ATLAS-EDIT.sde\PUDEDIT.PUD.WATER\PUDEDIT.PUD.wMeter SAP_STREET TEXT # # 60 "SAP Street" NULLABLE NON_REQUIRED #
AddField W:\Workspace\ChenC\Development\43604_Add_SAP_Address_Field_To_Meter\Scripts\wMeterSAP\data\connectionFiles\PROD\PUD@PUDEDIT@ATLAS-EDIT.sde\PUDEDIT.PUD.WATER\PUDEDIT.PUD.wMeter SAP_CITY TEXT # # 40 "SAP City" NULLABLE NON_REQUIRED #
AddField W:\Workspace\ChenC\Development\43604_Add_SAP_Address_Field_To_Meter\Scripts\wMeterSAP\data\connectionFiles\PROD\PUD@PUDEDIT@ATLAS-EDIT.sde\PUDEDIT.PUD.WATER\PUDEDIT.PUD.wMeter SAP_REGION TEXT # # 3 "SAP State" NULLABLE NON_REQUIRED #
AddField W:\Workspace\ChenC\Development\43604_Add_SAP_Address_Field_To_Meter\Scripts\wMeterSAP\data\connectionFiles\PROD\PUD@PUDEDIT@ATLAS-EDIT.sde\PUDEDIT.PUD.WATER\PUDEDIT.PUD.wMeter SAP_ZIP TEXT # # 10 "SAP Zip Code" NULLABLE NON_REQUIRED #
CalculateField "Water\Water, Active\W Meter" MAPNG_STAT_CD "NM" VB #
CalculateField "Water\Water, Active\W Meter" MAPNG_STAT_CD "NM" VB #
20210719
15213400
20210719
15213400
A point of service at the end of a lateral where water service is connected. It may be one meter or multiple meters with the same LocationID.
X-Ray
WaterDistribution
NaN
NaN
NaN
NaN
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.
ACTIVEFLAG
Active Flag
SmallInteger
2
5
0
Indicates if the feature is in use/active
ACTL_INST_DT_IND
Actual Install Date
String
3
0
0
Indicates if a feature s installed date is actual
AREA_NM_CD
Area Name
String
50
0
0
Area Name
AREA_NUM_CD
Area Number
String
11
0
0
Area Number
AREA_TYP_CD
Area Type
String
10
0
0
Area Type
ASSET_NUM
Asset Number
String
13
0
0
SAP Asset Number
BILLING_PD_CD
Billing Period
String
10
0
0
Billing Period
CIS_CYC_NUM
CIS Cycle
Integer
4
10
0
CIS Cycle
CIS_FOLIO_NUM
CIS Folio Number
Integer
4
10
0
CIS Folio Number
CIS_METER_IND
Metered Service
String
5
0
0
An indicator used to signify whether the service connection is metered
CIS_MTR_SEQ_NUM
CIS Meter Sequence
Integer
4
10
0
CIS Meter Sequence
COUNCILDISTRICT
Council District
String
3
0
0
Used to denote council district
DRAWING
Drawing
String
25
0
0
Concatenation of DRAWG_NUM - DRAWGSHTNO - DRAWG_TYP . Used for labeling.
ENABLED
Trace Enabled
SmallInteger
2
5
0
Geometric Network Enabled
FAC_NAME
Facility Name
String
50
0
0
Facility Name
FAC_TYP_CD
Facility Type
String
4
0
0
Facility Type
FACILITY_COMMENT_TEXT
Facility Comment Text
String
255
0
0
Facility Comment Text
FACILITYID
Facility Id
Integer
4
10
0
Locally assigned Facility Identifier
FLD_BK_GRID_NUM
Field Book Grid Number
Integer
4
10
0
City of San Diego Grid Number
FLD_BK_PAGE_NUM
Field Book Page Number
String
7
0
0
City of San Diego Fieldbook Page Number
GPS_SURVEYOR_IND
GPS Surveyor Flag
String
3
0
0
GPS Surveyor Flag
GPS_X_COORD_NUM
GPS X Coordinate
Double
8
38
8
GPS X Coordinate Number
GPS_Y_COORD_NUM
GPS Y Coordinate
Double
8
38
8
GPS Y Coordinate Number
INFRAS_SUBTYP_LVL1_CD
Infrastructure Subtype M1
String
10
0
0
Infrastructure Subtype M1
INFRAS_SUBTYP_LVL2_CD
Infrastructure Subtype M2
String
10
0
0
Infrastructure Subtype M2
INSTALLDATE
Install Date
Date
8
0
0
The date the asset was installed
INTERCEPTOR_IND
Interceptor Flag
String
3
0
0
Interceptor Flag
INVENTORY_ID_NUM
Inventory Id
String
11
0
0
Inventory Id
INVENTORY_NUM
Inventory Number
String
26
0
0
SAP Inventory Number
JURIS_CD
Jurisdiction
String
2
0
0
Jurisdiction
LAST_ATTR_UPDT_DT
Last Attribute Update Date
Date
8
0
0
Indicates the date the feature was last updated
LAST_ATTR_UPDT_ID
Last Attribute Update Id
String
50
0
0
Indicates the user that updated the feature last
LAST_BATCH_UPDT_DT
Last Batch Update Date
Date
8
0
0
Indicates the date the feature was last updated by a batch process
LAST_BATCH_UPDT_ID
Last Batch Update Id
String
50
0
0
Indicates the id of the batch process that last updated the feature
LASTEDITOR
Last Map Update Id
String
50
0
0
The user who performed the last update
LASTUPDATE
Last Map Update Date
Date
8
0
0
The date the feature was last updated in the maintenance database
LOCDESC
Location Description
String
200
0
0
Text Description of the geographic location
MAINTBY
Managed By
String
2
0
0
Indicates which organization maintains the asset
MAKE_CD
Make
String
20
0
0
Make
MAP_400_VISIBLE_IND
Map 400 Visible Flag
String
3
0
0
Map 400 Visible Flag
MAP_ID
Map Id
Integer
4
10
0
Map ID (unique to Field Book Page)
MAPNG_STAT_CD
Mapping Status
String
2
0
0
Mapping Status
NAD27E_NUM
NAD27 East Number
Double
8
38
8
NAD27 East Number
NAD27N_NUM
NAD27 North Number
Double
8
38
8
NAD27 North Number
NAD83E_NUM
NAD83 East Number
Double
8
38
8
NAD83 East Number
NAD83N_NUM
NAD83 North Number
Double
8
38
8
NAD83 North Number
OLD_SPLASH1_DWO_ID
Old Splash1 DWO Id
String
11
0
0
Old Splash1 DWO Id
OLD_SPLASH1_WORK_ORDR_ID
Old Splash1 Work Order Id
String
11
0
0
Old Splash1 Work Order Id
OUT_SRVC_IND
Out Service Flag
String
3
0
0
Out Service Flag
OWNEDBY
Owned By
String
2
0
0
Indicates which organization owns the asset
ROTATION
Rotation
Double
8
38
8
Map Symbol Rotation value
SENSITIVE_LAND_IND
Sensitive Land Flag
String
3
0
0
Indicates if a feature is contained within a Sensitive Land
SERIAL_NUMBER
Account Number
String
30
0
0
Water billing account identifier
SIZE_NUM
Size
Double
8
38
8
Meter Size
STA_PRIM_NUM
Station Primary Number
Integer
4
10
0
Station Primary Number
STA_SCNDRY_NUM
Station Secondary Number
Double
8
38
8
Station Secondary Number
STATION_NM_CD
Station Name
String
40
0
0
Station Name
STRT_ADDR_TYP_CD
Street Address Type
String
2
0
0
Address calculation method
STRT_FRACTN_NUM
Street Fraction
String
4
0
0
Street Address Fraction
STRT_HNDRD_BLK_IND
Street Hundred Block Flag
String
3
0
0
Street Hundred Block Flag
STRT_HNDRD_BLK_NUM
Street Hundred Block Number
Integer
4
10
0
Street Hundred Block Number
STRT_NM
Street Name
String
200
0
0
Street Name
STRT_NUM
Street Number
String
6
0
0
Street Address Number
STRT_PREDIR_CD
Street Direction
String
3
0
0
Street Pre-name Direction
STRT_SFX_CD
Street Suffix
String
3
0
0
Street Suffix
STRT_UNIT_NUM
Street Unit Number
String
9
0
0
Street Address Unit Number
STYLE_CD
Style
String
20
0
0
Style
THOMAS_BROTHERS_CD
Thomas Brothers Page
String
12
0
0
Thomas Brothers Page
WHERE_INSTALLED_CD
Where Installed
String
20
0
0
Where Installed
PUDEDIT.PUD.wMeter
Feature Class
281782
ISU_IND
ISU_IND
String
3
0
0
IAMFLOC
IAMFLOC
String
30
0
0
IAMEQUI
IAMEQUI
String
20
0
0
SAPOBJNR
SAPOBJNR
String
22
0
0
GlobalID
GlobalID
GlobalID
38
0
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
last_edited_mdg_date
last_edited_mdg_date
Date
8
0
0
last_edited_mdg_user
last_edited_mdg_user
String
50
0
0
Microsoft Windows 7 Version 6.1 (Build 7601) Service Pack 1; Esri ArcGIS 10.8.1.14362
Floating Meters
1
-117.417839
-95.671052
38.100865
31.005688
qaqc
qaqc
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
281782
Simple
FALSE
281782
TRUE
FALSE
20210719
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3Simx
uJI1dTkMMinVIBRRRSAKKKKACiiigAooooAKKKKACiiigAooooAKRjtUk9hmlqlq8zQaZO6ff24W
qjHmkkJuyuQ6MwmhmuV+7NIXU+1adVrC2WzsIbdPuouBVmqqNOba2FBWirhRRRWZQVzWtvJrGoJo
1uwEA+a7cf3f7v45rR17Vk0qwLDmeU+XCg6ljwKzYLQ6RpBUsW1C9bljySx5x9B0relHr939eRMn
ZF3TI4572S5Rf3US+VEfUDuK2ags7dbW0jgQYVBjFT1FSXNLTYIKy1CiiisygooooAKKKKACiiig
AooooAKKKKAMzRHZbRrVz81uxjGe4HQ1p1kh/sniDY33LpPl9ivJ/nWtWtZe9zd9SKe1uwUUUVkW
FFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFZmrNvls7ccmSUZHtg81p1kpGbnxG0+flt4vLx7kg5rW
lu5PoRU2t3NYDAxRRRWRYU2SRYo2kc4VRkmnVzWvTzanex6JZybd2HuJF/hXPT8cY/GrhHmdhNhp
sb65qz6rOn+ixZS2Ru/q348Vfg23+svcD5orcbFPYn1/CpLxotL0oQwjbwIogPU8CrGn2y2llHGB
g43N9Tya1crRcvkiGrysWqKKK5zQKKKKACiiigAooooAKKKKACiiigAooooAzdZTFsk4HzQyBt3o
M81oRuJIkdeQwBFNnhW4t5IX+66lT+NUNEd/sbQSn54XKf8AAc8fpWvxU/T9SNp+pp0UUVkWFFFF
ABRRRQAUUUUAFFFFABRRRQAUUUUAFZeiuLhbi7HSWQ4/Dj+lWNUlaHTZ2Q4fYQv1p2nW621hDGox
8uT9Tya1WlNvuQ9ZryLVFFIzBFLMcADJJrIsz9a1RNJ095ipeQ/LHGvVm9BUGgaX9htnuJhm7uT5
kzHrn0rPsEl17W21GYYsrZituv8AfPdvzzW9qF0lpZSSMccYX6ngVs01aC3ZN+rKeVv9c6borUfg
WP8AUYrWqlpdsbaxQOuJX+eT/ePWrtTVavZbIUFpd9QooorMsKKKKACiiigAooooAKKKKACiiigA
ooooAKyBI1n4hMW391dJu3ejDAA/Gtes3WiIrVLrH/Hu4kOPQVrR+Ll76EVNr9jSopsbh41cdGGa
dWZYUUUUgCiiigAooooAKKKKACiiigAooooAy9Ykz9mtl5eWVTj/AGQea01G1QB2GKyjELnxGsp/
5dYyB/wL/wDVWtWtSyjGP9akR1bYVzmvXTX9ymh2r/PNzOy/wJ3H4jNauraimmWDzsMt0RR1ZjwK
peHdNe2ge9u1/wBOujvlPoOy/hmiHurnfyKfY1bS1isrWO3hXCIoArPnK32sxwD5o7cb39M9MVfv
LlLO0knkOFQZqtpFv5Nn5rriac+ZIfU04aRc36ES1aiaFFFFYmgUUUUAFFFFABRRRQAUUUUAFFFF
ABRRRQAUUUUAFMmiSaF43AKsMEGqumXTXVmDINsyHZIvow61dqmnGVuwk1JXM3RXb7GYHOXgYoT+
v9a0qyED2Wvuv/LC6XcP+un/AOoVr1dVe9zd9Sae1uwUUUVkWFFFFABRRRQAUUUUAFFFFABQTgZN
FVr+TyrGZu+0gfU00ruwm7K5T0d/tMt3dY+9KYx/wEkVqEhQSeAOTVTS4fI02BMfMUBb3J61leIb
x7maPRbRmE9wMyMv/LNO5/lWs1z1GlsTDSKuQWu7xFrbXbMDp1ocQgdJH7n6c11FV7Gyh0+zjtoE
CxoMACn3M6WttJPIcJGpY/hUyfM7IrZXZnXpF7qkFl96NP3kg7fQ/nWsBgYFZujw/uHunH7y4bcS
fTt+laVOq7PlXQmH8z6hRRRWRYUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAZMjHT9XDkf6Pc
8E/3W/8Ar5rWqpqVqbuydF/1g+ZP94dKbpd39ssldgRIvyOD6jg1tL3oKXbR/oZx0lykOtEw28V2
AT5DhsD34/rWkjK6BlIKkZBFMnjE0EkbDIZSKpaLldPEBJJgYxZPtS3p+g9p+po0UUVkWFFFFABR
RRQAUUUUAFFFFABWVrkv7mC1U/vJ5AF/Agn9K1aypVWfX4y3S2j3j6nINa0dJcz6akVNrdyfU7+L
SdOe4cZCDCqOrHsBVHw7YTxxSX99g3l0dxx/CvYfliqar/wkmu+dvJ0+yYhVHR5B/gRXUAYGB0ol
7seXq9ylqFZWpMLq8t9PHIY75AOwHY/WtKWRYonkY4VQSaztHQTiTUCMtOflP+x2p0/dTn2/Mmev
ummqhVCqMADAFLRRWJYUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABWTl9P1jbt/0a6/
i/uv2H481rVT1K1e6snSJtsw+aNvRq0ptJ2ezImtLroXKyIkez8QSAn9xcplF9GGSx/lVzTbv7ZZ
JIw2uOHU9jVbW98UMN1GMtDIM/7pIz+lXTTU3TfXQUmnFSRqUU2N1kjV1OVYAinViaBRRRSAKKKK
ACiiigAooooACcDNcTe6nNc39xZWilri5lMIYfwxjnd/Our1O8jsdPmnlYKFXj3NYnhHRpLK1N7d
nddTjv8AwL2FdFJxjCUn8jOSbkjc0+xi06yitoVAVBgn1PrVqikZgilicADJrBttmhl6tJ5zwWCH
5pmy2Oyjn9cVpxxrFGqIoVVGAB2rL0pUu7ibU8Z8z5I2P9wf/XzWtWtT3bQ7fmRDX3u4UUUViWFF
FFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAZEfmafrTIcfZrr5lPo/p9MCtOeITW8
kTDIdSp/EVX1O1NzaHYdsqfMjehFP0+6N5ZpKy7XIw6+h7itpPmiprdGcVZuJX0aXfYbD1iYx49A
DgfyrRrJij+xeIJAv+ru0347KV4/XNa1KqlzXXXUdPaz6BRRRWRYUUUUAFFFFABRRWH4hv5kSPTr
Lm8ujtBH8C92/DNVGPM7AyixXxProUFjYWL5OOkj+nuOf0rqgABgdKqabYR6bYx20YHyjk+p7mrd
Ocr6LZCQVmaxLujjskbElwdvHUD1rTJwMmsjT1S+1CXUfvKuYoj7d/1FVSVrzfT8+hM9fdXU04IU
t4EijUKijAAqSiis276lhRRRSAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKy
IfNsNakiZh9lufmjHo/f+la9UNWtGurTdGSJYj5iEdyOcfjitaTV+V7Mia0uuhFrWYIor5f+Xdwz
47p3FaUbiSNXHRhmqsTrqOm/MB867XHv3FR6POJbERk/vIiUceh//VinJe5Z7piT971NCiiisTQK
KKKACiijpQBWv72LT7KS5mYKiDv3PYVj+HbKaeSXWL3JuLj/AFYP8EfYfliobjHiTWfsu0tp9m+Z
G7PIO34cGumACqABgDgAVq/cjbqxbsWiiishmdq8+y1FurYlnOxQOvPerdpbpa2scKDAUfr3rOtl
j1DV3vPvJb5jjPbP8X8q162qe7FQ+8zjq3IKKKKxNAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigDOstRLy/ZbtRFdKOR2b3FaNVb6wivY8N8si/ccdVNU7a/ltZ0stQ/1hHySgfKwH
qexrZxU1eG/b/IzUnHSRrUUUViaGTbg6fqz2+7MFx88Y/unuPxJp0EaWeuTKvC3K+Yf97p/IVJq9
q89p5sP/AB8QnzIz7jtVK/kaays9UiyWgbcyj+IfdI/WuuPv699H69DB+78tTdopFYOoZTkHoaWu
Q3CiiigArE8RalNbwx2Vlg3t0dkf+z6k/lWpeXkNhaS3Vw4SKNSzGsTQbN7u5l1q7yZZuIVb/lmn
+Rn8a0gkveYn2NTSdOTS9PjtlO5gMu3dj61eooqG23djCqOq3P2eyYA/vJPkUDrzxV6shVXUNbMh
+aO04X039D+laUkr3eyIm9LLqXrC1Wzso4QOQPmPqe5qzRRWbbbuykrKyCiiikMKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKhubaK7hMUq5U/mKmopptO6Bq5jxTz6TIlvdEyWx4
SYnlfZv8a11ZXUMpBB6EUkkaSoUdQynqDWQRNorAqGlsSenUx/8A1q20q7fF+ZnrD0NmsSOA2l1c
2TPuhuAXhB/hP939Ca2IpY54xJEwZD0Iqlq9qZrdZ48ieA70I/X9M0qTtLlfUJq6uhNFuPO09Yyf
3kBMUn+8OtaNYemTodTaSP5Y7qMSAf7XJP8AStyitG035jpu8QoorH1/UXtLVbe2IN3cHy4x3Gep
/DOazjFydkWzPu5JPEGuCwjUHT7Vg07Ho7dl9x1zXTqqooVQAoGABVDR9MXSrBYA2+Q/NI56sx6n
860Kqck9FshIKKKKzGVdRuRa2UkmfmxhR3Jpul2gs7GOM8uRl27sfWqsqpqGsxpndHa/MQOm/tn8
DWtW0vdgo99X+hC1lcKKKKxLCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKQgMCCMg0tFAGPNbTaW7XNkC8Gcvbj+YrQtrqG9g3xsCDwy9x7GrFZd1YPBK15YYSXGXj
xxJ/9etlJVNJb9/8/wDMzs46rYx7yKXTdRHlHISTzIs9gxww/ACurRg6K46MMiuf1Jk1fTWaImK8
gUsVP3l9at+HNR/tLR45CNrITGR/u8f0ratFypqb3WjM6bSm4rqaF1cx2dtJcSthEGSawNAgbU7y
TXrmNgZRtt0cconr9Tmk1JpNd1hdMhbFpbnddN6nsv6g10qqEUKoAA4AFYfBG3Vm+7FooorIYVXv
bkWlpJMT90cD1PpVism8AvtWhtM5jhxJIB6/w5/WtKcU5a7ImbstCfSbX7NZAtzLId7sepz0/Sr9
HSiplJybbHFWVgoooqRhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUU
UAFFFFABRRRQBn3+m+c32i3by7lRwR0b2NcnFPdaAt5BFEyT3jgW6N3kOcke2aKK7KFRuLg9jGcF
zKSOq0TS00qwWPJeV/mldurMa0qKK5G23dmwUUUUgI7iUQW8kpP3VJqjo8Gy1Nw/Ms53knrg9BRR
Wq0pvzZG8zSooorIsKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigD
/9k=