View In:   ArcGIS Online Map Viewer

Name: Signs

Display Field: UNIT_NUM

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: INTERNAL NOTES:Data Manager: John Williams (Supervisor, Signs & Markings)The GIS Office manages the UNIT_NUMBER field in this data layer. The UNIT_NUMBER is a concatenation of three pieces of data: Street Code + Sign Grid ID + Sign Number. The Street Code is found in the "STC" field of the ROAD_VIEW feature class (not in a dataset). The sign grid id is located in the "GRIDID" field of the SignGrid feature class (located in the PW_Signs dataset on SDE). Sign numbers are sequentially assigned with no overlapping numbers permitted. To date, the GIS Office has used an ArcMap document - Select by Location tool - to pinpoint all the signs in a particular gridid that has unassigned UNIT_NUMBERs. A future script that would auto-populate these UNIT_NUMBERs would be beneficial.* DO NOT EDIT UNIT_NUM = II

Copyright Text: City of Bakersfield

Default Visibility: false

MaxRecordCount: 1000

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: 6188016.022192612
YMin: 2282518.1988285184
XMax: 6315244.146343097
YMax: 2349232.077674657
Spatial Reference: 102645  (2229)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [49, 158, 107, 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• UNIT_NUM ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: UNIT_NUM )
• ADR_RANGE ( type: esriFieldTypeString, alias: Address Range, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ADR_RANGE )
• STREET ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 16, defaultValue: null, modelName: LOCATION , Coded Values: [CENTER: CENTER] , [CURB SIDE: CURB SIDE] , [END OF PAVEMENT: END OF PAVEMENT] , ...2 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Signs
  Description:
  Prototype:
  LOCATION: null
  UNIT_NUM: null
  ADR_RANGE: null
  STREET: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata