Name: SignInventory
Display Field: SVG_NUM
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: This dataset was created by Pinal County and Electronic Mappins Solutions (EMS) for use in the Lucity asset management system. The data were originally created by Pinal County via worksheets filled out by the field worker. The attributes and location data were manually entered into GIS. The data were then modified to fit the Lucity asset management software and will be updated by Pinal County Public Works (both in the filed - mobile utilizing Marshall GeoKNX working with Lucity, and as needed utilizing the Marshall tools, Lucity, and ArcGIS) ***NOT AVAILABLE FOR DISTRIBUTION***For more information please contact Pinal County Public Works GIS Analyst - 520-866-6985Extracted from the Pinal County Spatial Database on 18 Feb for the use of RAS expressly as part of an asset survey being conducted on behalf of Pinal County Development services - Public Works 2025 NO UPDATES TO COME
Service Item Id: 11f1089812cd441eb019b8d54b309042
Copyright Text: Pinal County, Electronic Mapping Solutions (EMS)
Extracted from the Pinal County Spatial Database on 18 Feb for the use of RAS expressly as part of an asset survey being conducted on behalf of Pinal County Development services - Public Works 2025 NO UPDATES TO COME
Default Visibility: true
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: false
Can Modify Layer: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 615855.4693130746
YMin: 475112.46631188627
XMax: 1136524.275196936
YMax: 897263.1522840168
Spatial Reference: 2868
(2868)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSMSCircle
Color: [130, 54, 77, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
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: false
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: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
-
SVG_ID
(
type: esriFieldTypeInteger, alias: Sign Number
)
-
SVG_NUM
(
type: esriFieldTypeString, alias: Alt Sign ID, length: 20
)
-
SVG_PL_ID
(
type: esriFieldTypeInteger, alias: Pole Rec #
)
-
SVG_PL_NUM
(
type: esriFieldTypeString, alias: Alt Pole ID, length: 20
)
-
SVG_INST_DT
(
type: esriFieldTypeDate, alias: Installation Date, length: 8
)
-
SVG_STAT_CD
(
type: esriFieldTypeInteger, alias: Sign Status
, Coded Values:
[999: Removed]
, [998: Replaced]
, [951: Out of Service]
, ...5 more...
)
-
SVG_CLAS_CD
(
type: esriFieldTypeInteger, alias: Sign Class
, Coded Values:
[1: Regulatory]
, [2: Warning]
, [3: Marker]
, ...6 more...
)
-
SVG_MUTCD
(
type: esriFieldTypeString, alias: MUTCD Number, length: 20
)
-
SVG_LABEL
(
type: esriFieldTypeString, alias: Sign Label, length: 25
)
-
SVG_SIZE_H
(
type: esriFieldTypeDouble, alias: Sign Height
)
-
SVG_SIZE_W
(
type: esriFieldTypeDouble, alias: Sign Width
)
-
SVG_SHTY_CD
(
type: esriFieldTypeInteger, alias: Sign Sheeting
, Coded Values:
[0: Unknown]
, [1: Commercial Grade]
, [2: Engineering Grade]
, ...2 more...
)
-
SVG_SUP_CD
(
type: esriFieldTypeInteger, alias: Support
, Coded Values:
[0: Unknown]
, [1: 4 Channel]
, [2: Barricade]
, ...8 more...
)
-
SVG_COND_CD
(
type: esriFieldTypeInteger, alias: Overall Condition
, Coded Values:
[3: Needs Replaced]
, [2: Needs Repair]
, [1: Good]
, ...1 more...
)
-
SVG_RFTY_CD
(
type: esriFieldTypeInteger, alias: Reflectivity
, Coded Values:
[4: Poor]
, [3: Fair]
, [2: Good]
, ...2 more...
)
-
SVG_TD_CD
(
type: esriFieldTypeInteger, alias: Facing Direction
, Coded Values:
[9: S-E]
, [8: S]
, [7: N-W]
, ...11 more...
)
-
SVG_REPL_DT
(
type: esriFieldTypeDate, alias: Replacement Date, length: 8
)
-
SVG_WO_COMM
(
type: esriFieldTypeString, alias: Comments, length: 255
)
-
SVG_ADR_STR
(
type: esriFieldTypeString, alias: On Street, length: 50
)
-
SVG_ADRSTR2
(
type: esriFieldTypeString, alias: Cross Street, length: 50
)
-
SVG_USER4
(
type: esriFieldTypeString, alias: Photo File, length: 50
)
-
SVG_USER5
(
type: esriFieldTypeGUID, alias: GlobalID, length: 38
)
-
SVG_X
(
type: esriFieldTypeDouble, alias: Logitude
)
-
SVG_Y
(
type: esriFieldTypeDouble, alias: Latitude
)
-
SVG_DB
(
type: esriFieldTypeSmallInteger, alias: In Lucity Database?
, Coded Values:
[0: No]
, [1: Yes]
)
-
LastModBy
(
type: esriFieldTypeString, alias: Last Modified By, length: 40
)
-
LastModDate
(
type: esriFieldTypeDate, alias: Last Modified date, length: 8
)
-
LastSynDate
(
type: esriFieldTypeDate, alias: Last Synchronized Date, length: 8
)
-
SVGMUTC_TEMP
(
type: esriFieldTypeInteger, alias: SVGMUTC_TEMP
)
-
Tech
(
type: esriFieldTypeString, alias: Tech, length: 10
)
-
LastReflectDt
(
type: esriFieldTypeDate, alias: Last Retroreflectivity Date, length: 8
)
-
SVG_BGRNDRR02
(
type: esriFieldTypeDouble, alias: Background 0.2 Deg RR
)
-
SVG_LEGENDRR02
(
type: esriFieldTypeDouble, alias: Legend 0.2 Deg RR
)
-
SVG_BGRND05RR
(
type: esriFieldTypeDouble, alias: Background 0.5 Deg RR
)
-
SVG_LEGENDRR05
(
type: esriFieldTypeDouble, alias: Legend 0.5 Deg RR
)
-
SVG_BGRNDRR1
(
type: esriFieldTypeDouble, alias: Background 1.0 Deg RR
)
-
SVG_LEGENDRR1
(
type: esriFieldTypeDouble, alias: Legend 1.0 Deg RR
)
-
SVG_CONTRAST
(
type: esriFieldTypeDouble, alias: Sign Contrast
)
-
SVG_COLR_CD
(
type: esriFieldTypeSmallInteger, alias: Sign Legend Color Code
, Coded Values:
[1: Black]
, [2: White]
, [3: Red]
, ...5 more...
)
-
SVG_BKCL_CD
(
type: esriFieldTypeSmallInteger, alias: Sign Background Color Code
, Coded Values:
[1: Black]
, [2: White]
, [3: Red]
, ...5 more...
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
-
SignMaintArea
(
type: esriFieldTypeString, alias: Sign Maintenance Area, length: 15
, Coded Values:
[Apache Junction: Apache Junction]
, [Arizona City: Arizona City]
, [Casa Grande: Casa Grande]
, ...4 more...
)
-
IGA_Date
(
type: esriFieldTypeDate, alias: Intergovernmental Agreement Date, length: 8
)
-
IGA_FeeNo
(
type: esriFieldTypeString, alias: Intergovernmental Agreement Fee Number, length: 12
)
-
RASID
(
type: esriFieldTypeInteger, alias: RASID
)
-
AssetID
(
type: esriFieldTypeString, alias: AssetID, length: 255
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata