View In:   ArcGIS Online Map Viewer

Name: OperationsMaintenance.DBO.streetlights

Display Field: Map_Number

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 5871013.499648809
YMin: 2087236.392439887
XMax: 6159771.629480466
YMax: 2283603.164075643
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 197, 255, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Map_Number ( type: esriFieldTypeInteger, alias: Map Number, editable: true, nullable: true, defaultValue: null, modelName: Map_Number , Coded Values: [10071824: 10071824] , [10091803: 10091803] , [10091827: 10091827] , ...148 more... )
• Installed_Service_Number ( type: esriFieldTypeInteger, alias: Installed Service Number, editable: true, nullable: true, defaultValue: null, modelName: Installed_Service_Number )
• Rate_Code ( type: esriFieldTypeString, alias: Rate Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Rate_Code )
• Structure_Number ( type: esriFieldTypeString, alias: Structure Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_Number )
• Lamp_Size ( type: esriFieldTypeString, alias: Lamp Size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Lamp_Size , Coded Values: [110W: 110W] , [115W: 115W] , [130W: 130W] , ...20 more... )
• Lamp_Type ( type: esriFieldTypeString, alias: Lamp Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Lamp_Type , Coded Values: [HPSV: HPSV] , [LED: LED] , [MV: MV] )
• MULT_SER ( type: esriFieldTypeString, alias: MULT/SER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MULT_SER )
• AN_MN ( type: esriFieldTypeString, alias: AN/MN, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AN_MN )
• Energize_Date ( type: esriFieldTypeDate, alias: Energize Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Energize_Date )
• Location_Description ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location_Description )
• Pole_Longitude ( type: esriFieldTypeString, alias: Pole Longitude, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pole_Longitude )
• Pole_Latitude ( type: esriFieldTypeString, alias: Pole Latitude, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pole_Latitude )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Streetlight_Working ( type: esriFieldTypeString, alias: Streetlight Working, editable: true, nullable: true, length: 50, defaultValue: Yes, modelName: Streetlight_Working , Coded Values: [Yes: Yes] , [No: No] )
• Inspection_Status ( type: esriFieldTypeString, alias: Inspection Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspection_Status , Coded Values: [Complete: Complete] , [Incomplete: Incomplete] )
• Inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector , Coded Values: [Alec Gamez: Alec Gamez] , [Eddie Perez: Eddie Perez] , [Joshua Goldsmith: Joshua Goldsmith] , ...14 more... )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
• Utility_Company ( type: esriFieldTypeString, alias: Utility Company, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Utility_Company , Coded Values: [SCE: SCE] , [SDGE: SDGE] )
• Service_Account_Number ( type: esriFieldTypeDouble, alias: Service Account Number, editable: true, nullable: true, defaultValue: null, modelName: Service_Account_Number )
• Pole_Type_Code ( type: esriFieldTypeString, alias: Pole Type Code, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Pole_Type_Code , Coded Values: [O: Ornamental] , [W: Wood] )
• Light_City_Code ( type: esriFieldTypeString, alias: Light City Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Light_City_Code )
• Inspection_Notes ( type: esriFieldTypeString, alias: Inspection Notes, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: Inspection_Notes , Coded Values: [Out Completely: Out Completely] , [On/Off: On/Off] , [Flickering: Flickering] , ...4 more... )
• Service_Acct_Number ( type: esriFieldTypeString, alias: Service_Acct_Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Service_Acct_Number )
• County_Maintained_Road ( type: esriFieldTypeString, alias: County_Maintained_Road, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: County_Maintained_Road , Coded Values: [Yes: Yes] , [No: No] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ChargeNum ( type: esriFieldTypeString, alias: ChargeNum, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ChargeNum )
• Keynum ( type: esriFieldTypeString, alias: Keynum, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Keynum )
• OMInspectArea ( type: esriFieldTypeSmallInteger, alias: OMInspectArea, editable: true, nullable: true, defaultValue: null, modelName: OMInspectArea )

Templates:

• Name: OperationsMaintenance.DBO.streetlights
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• OperationsMaintenance.DBO.StreetlightInspection (0) -- Related To: OperationsMaintenance.DBO.StreetlightInspection (1)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata