ArcGIS REST Services Directory
Home
>
services
>
PavementDatabase (FeatureServer)
>
All Layers and Tables
|
API Reference
JSON
All Layers and Tables (PavementDatabase)
Layers:
Layer:
2023PavementDB
(0)
Name:
2023PavementDB
Display Field:
Subdivisio
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
2023PavementDB
Copyright Text:
Min. Scale:
0
Max. Scale:
0
Default Visibility:
true
Max Record Count:
1000
Supported query Formats:
JSON, geoJSON, PBF
Use Standardized Queries:
True
Extent:
XMin: 1011000.13398725
YMin: 1820255.41004226
XMax: 1051049.24877076
YMax: 1877192.98219051
Spatial Reference: PROJCS["NAD_1983_HARN_StatePlane_Illinois_East_FIPS_1201",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",984250.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-88.33333333333333],PARAMETER["Scale_Factor",0.999975],PARAMETER["Latitude_Of_Origin",36.66666666666666],UNIT["Foot_US",0.3048006096012192]]
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":4},"label":"","description":""},"transparency":0,"labelingInfo":null}
HasZ:
false
HasM:
true
Has Attachments:
false
Has Geometry Properties:
true
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Object ID Field:
OBJECTID
Unique ID Field:
Name : OBJECTID
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
Subdivisio
(type: esriFieldTypeString, alias: Subdivisio, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
Branch
(type: esriFieldTypeString, alias: Branch, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
Distance_F
(type: esriFieldTypeInteger, alias: Distance_F, SQL Type: sqlTypeOther, nullable: true, editable: true)
Direction_
(type: esriFieldTypeString, alias: Direction_, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
FromStreet
(type: esriFieldTypeString, alias: FromStreet, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
Distance_T
(type: esriFieldTypeInteger, alias: Distance_T, SQL Type: sqlTypeOther, nullable: true, editable: true)
Direction1
(type: esriFieldTypeString, alias: Direction1, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
ToStreet
(type: esriFieldTypeString, alias: ToStreet, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
Length
(type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
Width
(type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
Bulb_Area
(type: esriFieldTypeDouble, alias: Bulb_Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
SurfType
(type: esriFieldTypeString, alias: SurfType, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
BaseType
(type: esriFieldTypeString, alias: BaseType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
Fabric_Y_O
(type: esriFieldTypeString, alias: Fabric_Y_O, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Pavement_S
(type: esriFieldTypeString, alias: Pavement_S, SQL Type: sqlTypeOther, length: 240, nullable: true, editable: true)
Structural
(type: esriFieldTypeDouble, alias: Structural, SQL Type: sqlTypeOther, nullable: true, editable: true)
PCI
(type: esriFieldTypeDouble, alias: PCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
PCIDate
(type: esriFieldTypeInteger, alias: PCIDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
LastSurf
(type: esriFieldTypeInteger, alias: LastSurf, SQL Type: sqlTypeOther, nullable: true, editable: true)
Mea_Est
(type: esriFieldTypeString, alias: Mea_Est, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
Patching_A
(type: esriFieldTypeDouble, alias: Patching_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
pct_of_Tot
(type: esriFieldTypeSingle, alias: pct_of_Tot, SQL Type: sqlTypeOther, nullable: true, editable: true)
Area
(type: esriFieldTypeDouble, alias: Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
Born_On_Da
(type: esriFieldTypeInteger, alias: Born_On_Da, SQL Type: sqlTypeOther, nullable: true, editable: true)
Next_Surfa
(type: esriFieldTypeInteger, alias: Next_Surfa, SQL Type: sqlTypeOther, nullable: true, editable: true)
fHSO
(type: esriFieldTypeInteger, alias: fHSO, SQL Type: sqlTypeOther, nullable: true, editable: true)
pHSO
(type: esriFieldTypeInteger, alias: pHSO, SQL Type: sqlTypeOther, nullable: true, editable: true)
fCrkF
(type: esriFieldTypeInteger, alias: fCrkF, SQL Type: sqlTypeOther, nullable: true, editable: true)
pCRKF
(type: esriFieldTypeInteger, alias: pCRKF, SQL Type: sqlTypeOther, nullable: true, editable: true)
fCrkR
(type: esriFieldTypeInteger, alias: fCrkR, SQL Type: sqlTypeOther, nullable: true, editable: true)
pCrkR
(type: esriFieldTypeInteger, alias: pCrkR, SQL Type: sqlTypeOther, nullable: true, editable: true)
fCkCbF
(type: esriFieldTypeInteger, alias: fCkCbF, SQL Type: sqlTypeOther, nullable: true, editable: true)
pCkCbF
(type: esriFieldTypeInteger, alias: pCkCbF, SQL Type: sqlTypeOther, nullable: true, editable: true)
fCkCbR
(type: esriFieldTypeInteger, alias: fCkCbR, SQL Type: sqlTypeOther, nullable: true, editable: true)
pCkCbR
(type: esriFieldTypeInteger, alias: pCkCbR, SQL Type: sqlTypeOther, nullable: true, editable: true)
fPRA
(type: esriFieldTypeInteger, alias: fPRA, SQL Type: sqlTypeOther, nullable: true, editable: true)
pPRA
(type: esriFieldTypeInteger, alias: pPRA, SQL Type: sqlTypeOther, nullable: true, editable: true)
fRRA
(type: esriFieldTypeInteger, alias: fRRA, SQL Type: sqlTypeOther, nullable: true, editable: true)
pRRA
(type: esriFieldTypeInteger, alias: pRRA, SQL Type: sqlTypeOther, nullable: true, editable: true)
MICRO
(type: esriFieldTypeInteger, alias: MICRO, SQL Type: sqlTypeOther, nullable: true, editable: true)
MICRO2
(type: esriFieldTypeInteger, alias: MICRO2, SQL Type: sqlTypeOther, nullable: true, editable: true)
MICRO3
(type: esriFieldTypeInteger, alias: MICRO3, SQL Type: sqlTypeOther, nullable: true, editable: true)
Slurry
(type: esriFieldTypeInteger, alias: Slurry, SQL Type: sqlTypeOther, nullable: true, editable: true)
Slurry2
(type: esriFieldTypeInteger, alias: Slurry2, SQL Type: sqlTypeOther, nullable: true, editable: true)
Conc
(type: esriFieldTypeInteger, alias: Conc, SQL Type: sqlTypeOther, nullable: true, editable: true)
Conc2
(type: esriFieldTypeInteger, alias: Conc2, SQL Type: sqlTypeOther, nullable: true, editable: true)
In_Mill
(type: esriFieldTypeInteger, alias: In_Mill, SQL Type: sqlTypeOther, nullable: true, editable: true)
In_Mill2
(type: esriFieldTypeInteger, alias: In_Mill2, SQL Type: sqlTypeOther, nullable: true, editable: true)
Mill
(type: esriFieldTypeInteger, alias: Mill, SQL Type: sqlTypeOther, nullable: true, editable: true)
Mill2
(type: esriFieldTypeInteger, alias: Mill2, SQL Type: sqlTypeOther, nullable: true, editable: true)
Seal
(type: esriFieldTypeInteger, alias: Seal, SQL Type: sqlTypeOther, nullable: true, editable: true)
Seal2
(type: esriFieldTypeInteger, alias: Seal2, SQL Type: sqlTypeOther, nullable: true, editable: true)
InHouse
(type: esriFieldTypeInteger, alias: InHouse, SQL Type: sqlTypeOther, nullable: true, editable: true)
InHouse2
(type: esriFieldTypeInteger, alias: InHouse2, SQL Type: sqlTypeOther, nullable: true, editable: true)
Recon
(type: esriFieldTypeInteger, alias: Recon, SQL Type: sqlTypeOther, nullable: true, editable: true)
Recon2
(type: esriFieldTypeInteger, alias: Recon2, SQL Type: sqlTypeOther, nullable: true, editable: true)
ConcOvrlay
(type: esriFieldTypeInteger, alias: ConcOvrlay, SQL Type: sqlTypeOther, nullable: true, editable: true)
ConcOvrl_1
(type: esriFieldTypeInteger, alias: ConcOvrl_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
CIP
(type: esriFieldTypeString, alias: CIP, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
Roadway_De
(type: esriFieldTypeDouble, alias: Roadway_De, SQL Type: sqlTypeOther, nullable: true, editable: true)
Remarks_Ye
(type: esriFieldTypeString, alias: Remarks_Ye, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
Remarks
(type: esriFieldTypeString, alias: Remarks, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
RouteID
(type: esriFieldTypeInteger, alias: RouteID, SQL Type: sqlTypeOther, nullable: true, editable: true)
FromMeas
(type: esriFieldTypeDouble, alias: FromMeas, SQL Type: sqlTypeOther, nullable: true, editable: true)
ToMeas
(type: esriFieldTypeDouble, alias: ToMeas, SQL Type: sqlTypeOther, nullable: true, editable: true)
Roadway_Ow
(type: esriFieldTypeString, alias: Roadway_Ow, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
Funding
(type: esriFieldTypeString, alias: Funding, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ID
(type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
OBJECTID
(type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Shape__Length
(type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: 2023PavementDB
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
3/22/2023 2:12:00 PM
Schema Last Edit Date:
3/22/2023 2:12:00 PM
Data Last Edit Date:
3/22/2023 2:12:00 PM
Tables:
City.traffic.Pavement
(1)
Name:
City.traffic.Pavement
Display Field:
Subdivision
Type:
Table
Description:
Copyright Text:
Max Record Count:
1000
Supported query Formats:
JSON, geoJSON, PBF
Use Standardized Queries:
True
HasZ:
false
HasM:
false
Has Attachments:
false
Has Geometry Properties:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Object ID Field:
ID
Unique ID Field:
Name : ID
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
ID
(type: esriFieldTypeOID, alias: ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Subdivision
(type: esriFieldTypeString, alias: Subdivision, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Branch
(type: esriFieldTypeString, alias: Branch, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Distance_From
(type: esriFieldTypeInteger, alias: Distance_From, SQL Type: sqlTypeOther, nullable: true, editable: true)
Direction_From
(type: esriFieldTypeString, alias: Direction_From, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
FromStreet
(type: esriFieldTypeString, alias: FromStreet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Distance_To
(type: esriFieldTypeInteger, alias: Distance_To, SQL Type: sqlTypeOther, nullable: true, editable: true)
Direction_To
(type: esriFieldTypeString, alias: Direction_To, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
ToStreet
(type: esriFieldTypeString, alias: ToStreet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Length
(type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
Width
(type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
Bulb_Area
(type: esriFieldTypeDouble, alias: Bulb_Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
SurfType
(type: esriFieldTypeString, alias: SurfType, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
BaseType
(type: esriFieldTypeString, alias: BaseType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
Fabric_Y_Or_N
(type: esriFieldTypeString, alias: Fabric_Y_Or_N, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Pavement_Section
(type: esriFieldTypeString, alias: Pavement_Section, SQL Type: sqlTypeOther, length: 240, nullable: true, editable: true)
Structural_Number
(type: esriFieldTypeDouble, alias: Structural_Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
PCI
(type: esriFieldTypeDouble, alias: PCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
PCIDate
(type: esriFieldTypeInteger, alias: PCIDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
LastSurf
(type: esriFieldTypeInteger, alias: LastSurf, SQL Type: sqlTypeOther, nullable: true, editable: true)
Mea_Est
(type: esriFieldTypeString, alias: Mea_Est, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
Patching_Area
(type: esriFieldTypeDouble, alias: Patching_Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
pct_of_Total_Patching
(type: esriFieldTypeSingle, alias: pct_of_Total_Patching, SQL Type: sqlTypeOther, nullable: true, editable: true)
Born_On_Date
(type: esriFieldTypeInteger, alias: Born_On_Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
Next_Surface_Date
(type: esriFieldTypeInteger, alias: Next_Surface_Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
fHSO
(type: esriFieldTypeInteger, alias: fHSO, SQL Type: sqlTypeOther, nullable: true, editable: true)
pHSO
(type: esriFieldTypeInteger, alias: pHSO, SQL Type: sqlTypeOther, nullable: true, editable: true)
fCrkF
(type: esriFieldTypeInteger, alias: fCrkF, SQL Type: sqlTypeOther, nullable: true, editable: true)
pCRKF
(type: esriFieldTypeInteger, alias: pCRKF, SQL Type: sqlTypeOther, nullable: true, editable: true)
fCrkR
(type: esriFieldTypeInteger, alias: fCrkR, SQL Type: sqlTypeOther, nullable: true, editable: true)
pCrkR
(type: esriFieldTypeInteger, alias: pCrkR, SQL Type: sqlTypeOther, nullable: true, editable: true)
fCkCbF
(type: esriFieldTypeInteger, alias: fCkCbF, SQL Type: sqlTypeOther, nullable: true, editable: true)
pCkCbF
(type: esriFieldTypeInteger, alias: pCkCbF, SQL Type: sqlTypeOther, nullable: true, editable: true)
fCkCbR
(type: esriFieldTypeInteger, alias: fCkCbR, SQL Type: sqlTypeOther, nullable: true, editable: true)
pCkCbR
(type: esriFieldTypeInteger, alias: pCkCbR, SQL Type: sqlTypeOther, nullable: true, editable: true)
fPRA
(type: esriFieldTypeInteger, alias: fPRA, SQL Type: sqlTypeOther, nullable: true, editable: true)
pPRA
(type: esriFieldTypeInteger, alias: pPRA, SQL Type: sqlTypeOther, nullable: true, editable: true)
fRRA
(type: esriFieldTypeInteger, alias: fRRA, SQL Type: sqlTypeOther, nullable: true, editable: true)
pRRA
(type: esriFieldTypeInteger, alias: pRRA, SQL Type: sqlTypeOther, nullable: true, editable: true)
MICRO
(type: esriFieldTypeInteger, alias: MICRO, SQL Type: sqlTypeOther, nullable: true, editable: true)
MICRO2
(type: esriFieldTypeInteger, alias: MICRO2, SQL Type: sqlTypeOther, nullable: true, editable: true)
MICRO3
(type: esriFieldTypeInteger, alias: MICRO3, SQL Type: sqlTypeOther, nullable: true, editable: true)
Slurry
(type: esriFieldTypeInteger, alias: Slurry, SQL Type: sqlTypeOther, nullable: true, editable: true)
Slurry2
(type: esriFieldTypeInteger, alias: Slurry2, SQL Type: sqlTypeOther, nullable: true, editable: true)
Conc
(type: esriFieldTypeInteger, alias: Conc, SQL Type: sqlTypeOther, nullable: true, editable: true)
Conc2
(type: esriFieldTypeInteger, alias: Conc2, SQL Type: sqlTypeOther, nullable: true, editable: true)
In_Mill
(type: esriFieldTypeInteger, alias: In_Mill, SQL Type: sqlTypeOther, nullable: true, editable: true)
In_Mill2
(type: esriFieldTypeInteger, alias: In_Mill2, SQL Type: sqlTypeOther, nullable: true, editable: true)
Mill
(type: esriFieldTypeInteger, alias: Mill, SQL Type: sqlTypeOther, nullable: true, editable: true)
Mill2
(type: esriFieldTypeInteger, alias: Mill2, SQL Type: sqlTypeOther, nullable: true, editable: true)
Seal
(type: esriFieldTypeInteger, alias: Seal, SQL Type: sqlTypeOther, nullable: true, editable: true)
Seal2
(type: esriFieldTypeInteger, alias: Seal2, SQL Type: sqlTypeOther, nullable: true, editable: true)
InHouse
(type: esriFieldTypeInteger, alias: InHouse, SQL Type: sqlTypeOther, nullable: true, editable: true)
InHouse2
(type: esriFieldTypeInteger, alias: InHouse2, SQL Type: sqlTypeOther, nullable: true, editable: true)
Recon
(type: esriFieldTypeInteger, alias: Recon, SQL Type: sqlTypeOther, nullable: true, editable: true)
Recon2
(type: esriFieldTypeInteger, alias: Recon2, SQL Type: sqlTypeOther, nullable: true, editable: true)
ConcOvrlay
(type: esriFieldTypeInteger, alias: ConcOvrlay, SQL Type: sqlTypeOther, nullable: true, editable: true)
ConcOvrlay2
(type: esriFieldTypeInteger, alias: ConcOvrlay2, SQL Type: sqlTypeOther, nullable: true, editable: true)
CIP
(type: esriFieldTypeString, alias: CIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Roadway_Designation_Index
(type: esriFieldTypeDouble, alias: Roadway_Designation_Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
Remarks_Yes_Only
(type: esriFieldTypeString, alias: Remarks_Yes_Only, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Remarks
(type: esriFieldTypeString, alias: Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
RouteID
(type: esriFieldTypeInteger, alias: RouteID, SQL Type: sqlTypeOther, nullable: true, editable: true)
FromMeas
(type: esriFieldTypeDouble, alias: FromMeas, SQL Type: sqlTypeOther, nullable: true, editable: true)
ToMeas
(type: esriFieldTypeDouble, alias: ToMeas, SQL Type: sqlTypeOther, nullable: true, editable: true)
Roadway_Owner
(type: esriFieldTypeString, alias: Roadway_Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Funding
(type: esriFieldTypeString, alias: Funding, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Area
(type: esriFieldTypeDouble, alias: Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: City.traffic.Pavement
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
3/22/2023 2:12:01 PM
Schema Last Edit Date:
3/22/2023 2:12:01 PM
Data Last Edit Date:
3/22/2023 2:12:01 PM
City.PBWORKS.SIGN
(2)
Name:
City.PBWORKS.SIGN
Display Field:
IDLOC
Type:
Table
Description:
Copyright Text:
Max Record Count:
1000
Supported query Formats:
JSON, geoJSON, PBF
Use Standardized Queries:
True
HasZ:
false
HasM:
false
Has Attachments:
false
Has Geometry Properties:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Object ID Field:
OBJECTID
Unique ID Field:
Name : OBJECTID
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
OBJECTID
(type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
IDLOC
(type: esriFieldTypeString, alias: SIMS LocationID, SQL Type: sqlTypeOther, length: 13, nullable: false, editable: true)
SIGNDESCRP
(type: esriFieldTypeString, alias: Sign Description, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
SIGNCATGRY
(type: esriFieldTypeString, alias: Sign Category, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [COM: Common], [CUS: Custom], [ST: Street Name], ... 1 more ...)
SIGNNUMBER
(type: esriFieldTypeInteger, alias: Sign Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
MATERIALUID
(type: esriFieldTypeString, alias: MATERIALUID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PWSNR10139-24x30HI: PWSNR10139-24x30HI], [PWSNDI10140-30x18VIP: PWSNDI10140-30x18VIP], [PWSNR759-24X36VIP: PWSNR759-24X36VIP], ... 4329 more ...)
SIGNWIDTH
(type: esriFieldTypeSmallInteger, alias: Sign Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
SIGNHEIGHT
(type: esriFieldTypeSmallInteger, alias: Sign Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
SIGNTYPE
(type: esriFieldTypeString, alias: Sign Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [AR: Acknowledgement/Recognition], [C: Construction], [DI: Directional/Informational], ... 5 more ...)
SIGNCOLOR
(type: esriFieldTypeString, alias: Sign Color, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [White/Blue, White/Green: White/Blue, White/Green], [Black/Orange: Black/Orange], [White/Green, White/Brown: White/Green, White/Brown], ... 5 more ...)
SIGNMATRL
(type: esriFieldTypeString, alias: Sign Material, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [DG: Diamond Grade], [EG: Engineer Grade], [HI: High Intensity], ... 4 more ...)
MUTCDCODE
(type: esriFieldTypeString, alias: MUTCD Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
FACING_N
(type: esriFieldTypeSmallInteger, alias: Sign Faces North, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
FACING_S
(type: esriFieldTypeSmallInteger, alias: Sign Faces South, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
FACING_E
(type: esriFieldTypeSmallInteger, alias: Sign Faces East, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
FACING_W
(type: esriFieldTypeSmallInteger, alias: Sign Faces West, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
MNTHEIGHTFT
(type: esriFieldTypeSmallInteger, alias: Mount Height FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
MNTHEIGHTIN
(type: esriFieldTypeSmallInteger, alias: Mount Height IN, SQL Type: sqlTypeOther, nullable: true, editable: true)
CONDITION
(type: esriFieldTypeString, alias: Sign Condition, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: New], [G: Good], [F: Fair], ... 1 more ...)
DateAdded
(type: esriFieldTypeDate, alias: SIMS Date Added, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
AssetID
(type: esriFieldTypeString, alias: Cityworks AssetID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
Location
(type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
WarrantyDate
(type: esriFieldTypeDate, alias: WarrantyDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
InstallDate
(type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ConditionDate
(type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Status
(type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [PRP: Proposed], [ACT: Active], [RMVD: Removed], ... 2 more ...)
Comments
(type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
LegacyLocID
(type: esriFieldTypeString, alias: LegacyLocID, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
Templates:
Name: City.PBWORKS.SIGN
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
IDLOC
:
SIGNMATRL
: VIP
FACING_N
: 0
FACING_S
: 0
FACING_E
: 0
FACING_W
: 0
CONDITION
: N
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
3/22/2023 2:12:05 PM
Schema Last Edit Date:
3/22/2023 2:12:05 PM
Data Last Edit Date:
3/22/2023 2:12:05 PM