Name: DPW_SMD.Pump_Stations_Complete

Display Field: MMS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature class contain information about the sewer pump stations within Consolidated Sewer Maintenance District (CSMD). The sewer pump stations are represented as point, indicating the physical location of the stie. Attributes include specification of pump station that are being used by SCADA. Attributes include:OBJECTID – This is a require Unique integer field from databaseMMS – This attribute is internal Maintenance Management System NumberPUMPSTA – This attribute is the name of the pumpstationCREW – This attribute is crew leader numberJOB_NO – This attribute is the job number of this pumpstationADDRESS – This attribute is the address of the pumpstationZIP – This attribute is the zip codeLOC_MISC – This attribute contains various miscellaneous location descriptionCITY_VIC – This attribute is the location where city location ADEMCO –ALARM_ID – This attribute is Alarm ID from SCADABIS_NOS – This attribute is Bispectral Index Monitoring numberPROJ_ID – This attribute is project numberFM_LENGTH – This attribute is FM Antenna lengthFM_PAGES –NO_ -ABOVE_G – This attribute is above ground or notIP_ADDRESS – This attribute is IP addressPMPSTA_12 – This attribute is the name of the pumpstationPUMP_STATI – This attribute is the name of the pumpstationIMEI_NO_ - This attribute is IMEI numberS_N – This attribute is Serial NumberPRODUCT – This attribute is product name of the pumpPHONE_NO – This attribute is Alarm notification phone numberCARRIER – This attribute is cellular carrierSIGNAL_STR – This attribute is signal strengthCELL_BOOST – This attribute contains cell boost require or notPLC_CONTRO – This attribute is the name of Programmable Logic Controller START_DATE –MODEM_CONF –X_COORD – This attribute is longitude coordinate of the pointY_COORD – This attribute is latitude coordinate of the pointDMS_DESC –DMS_CON –STATUS – This attribute contains sewer pumpstation statusMAINTAINED_BY – The attribute shows who’s maintained byACCEPTANCE_DATE – CONSTRUCTION_DATE – This attribute contains sewer pumpstation construction dateMXCREATIONSTATE –ASSETNUM – This attribute is unique identifier of asset numberPUMP_STATION_NAME – This attribute is the name of the pumpstationSHAPE – This attribute is type of Geometry fieldGLOBALID – Field type Universal Unique Identifier which automatically assigned by SDE

Copyright Text: This data is maintained by the Los Angeles County Public Works – Sewer Maintenance Division. Sandra Medina, (626) 300-3363. samedina@dpw.lacounty.gov

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 6300458.83796455
YMin: 1716826.34009354
XMax: 6627038.83886839
YMax: 2069068.56237099
Spatial Reference: 102645 (2229)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[119,140,63,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• MMS (type: esriFieldTypeString, alias: MMS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PUMPSTA (type: esriFieldTypeString, alias: PUMPSTA, SQL Type: sqlTypeOther, length: 23, nullable: true, editable: true)
• CREW (type: esriFieldTypeInteger, alias: CREW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JOB_NO (type: esriFieldTypeString, alias: JOB_NO, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 27, nullable: true, editable: true)
• ZIP (type: esriFieldTypeDouble, alias: ZIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOC_MISC (type: esriFieldTypeString, alias: LOC_MISC, SQL Type: sqlTypeOther, length: 61, nullable: true, editable: true)
• CITY_VIC (type: esriFieldTypeString, alias: CITY_VIC, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true)
• ADEMCO (type: esriFieldTypeString, alias: ADEMCO, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• ALARM_ID (type: esriFieldTypeString, alias: ALARM_ID, SQL Type: sqlTypeOther, length: 19, nullable: true, editable: true)
• BIS_NOS (type: esriFieldTypeDouble, alias: BIS_NOS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJ_ID (type: esriFieldTypeString, alias: PROJ_ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FM_LENGTH (type: esriFieldTypeDouble, alias: FM_LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FM_PAGES (type: esriFieldTypeString, alias: FM_PAGES, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• NO_ (type: esriFieldTypeInteger, alias: NO_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ABOVE_G (type: esriFieldTypeString, alias: ABOVE_G, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IP_ADDRESS (type: esriFieldTypeString, alias: IP_ADDRESS, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PUMPSTA_1 (type: esriFieldTypeString, alias: PUMPSTA_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PUMP_STATI (type: esriFieldTypeString, alias: PUMP_STATI, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• IMEI_NO_ (type: esriFieldTypeString, alias: IMEI_NO_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• S_N (type: esriFieldTypeString, alias: S_N, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PRODUCT (type: esriFieldTypeString, alias: PRODUCT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PHONE_NO_ (type: esriFieldTypeString, alias: PHONE_NO_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CARRIER (type: esriFieldTypeString, alias: CARRIER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SIGNAL_STR (type: esriFieldTypeString, alias: SIGNAL_STR, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CELL_BOOST (type: esriFieldTypeString, alias: CELL_BOOST, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PLC_CONTRO (type: esriFieldTypeString, alias: PLC_CONTRO, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• START_DATE (type: esriFieldTypeDate, alias: START_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MODEM_CONF (type: esriFieldTypeString, alias: MODEM_CONF, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• X_COORD (type: esriFieldTypeDouble, alias: X_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_COORD (type: esriFieldTypeDouble, alias: Y_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DMS_DESC (type: esriFieldTypeString, alias: DMS_DESC, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DMS_CON (type: esriFieldTypeString, alias: DMS_CON, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CREATED_USER (type: esriFieldTypeString, alias: CREATED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• CREATED_DATE (type: esriFieldTypeDate, alias: CREATED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• LAST_EDITED_USER (type: esriFieldTypeString, alias: LAST_EDITED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• LAST_EDITED_DATE (type: esriFieldTypeDate, alias: LAST_EDITED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: DPW_SMD.Pump_Stations_Complete
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/13/2025 6:48:49 PM

Schema Last Edit Date: 1/13/2025 6:48:49 PM

Data Last Edit Date: 1/13/2025 6:48:49 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat