Name: gisprod.GIS.trSign

Display Field: SurveyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: f8ac453316a447faac95a8db96d99507

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID or Asset ID, length: 40 )
• LegacyID ( type: esriFieldTypeString, alias: Legacy ID, length: 40 )
• Address ( type: esriFieldTypeString, alias: Address, length: 130 )
• Location ( type: esriFieldTypeString, alias: Location, length: 250 )
• Condition ( type: esriFieldTypeDouble, alias: Condition )
• ConditionDate ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• PurchaseDate ( type: esriFieldTypeDate, alias: Purchase Date, length: 8 )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• AssetCost ( type: esriFieldTypeDouble, alias: Asset Cost )
• CoF ( type: esriFieldTypeDouble, alias: Consequence of Failure )
• PoF ( type: esriFieldTypeDouble, alias: Probability of Failure )
• BRE ( type: esriFieldTypeDouble, alias: Business Risk Exposure )
• UsefulLife ( type: esriFieldTypeDouble, alias: Useful Life )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, length: 10 , Coded Values: [AB: Abandoned] , [DISP: Disposed] , [IS: In Service] , ...4 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 250 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 7 , Coded Values: [-1: Private] , [-2: Other] , [1: City of Santa Ana] , ...14 more... )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, length: 25 , Coded Values: [-1: Private] , [-2: Other] , [1: City of Santa Ana] , ...14 more... )
• ContractorID ( type: esriFieldTypeString, alias: Contractor Number/Name, length: 25 )
• ImagePath ( type: esriFieldTypeString, alias: ImagePath, length: 100 )
• SurveyDate ( type: esriFieldTypeDate, alias: Survey Date, length: 8 )
• SurveyName ( type: esriFieldTypeString, alias: Surveyor Name, length: 25 )
• EditDate ( type: esriFieldTypeDate, alias: Date and Time Edit Was Made, length: 8 )
• EditorName ( type: esriFieldTypeString, alias: Name of Editor, length: 25 )
• Source ( type: esriFieldTypeString, alias: Source, length: 25 , Coded Values: [-1: Consultant] , [-2: Other] , [1: City of Santa Ana PWA] , ...2 more... )
• DataSourceType ( type: esriFieldTypeString, alias: Data Source Type, length: 50 , Coded Values: [ASBUILT: As-built Record Plan] , [AUTOCADDRAWING: AutoCAD Drawing] , [ESTIMATED: Estimated Feature Location] , ...16 more... )
• DataSourceReference ( type: esriFieldTypeString, alias: Data Source Reference, length: 250 )
• SignCode ( type: esriFieldTypeString, alias: MUTCD Code, length: 12 , Coded Values: [D1-1: D1-1: DESTINATION (1 LINE)] , [D1-1a: D1-1a: DESTINATION A D DISTANCE (1 LINE)] , [D1-1c: D1-1c] , ...1263 more... )
• SignSubCode ( type: esriFieldTypeString, alias: MUTCD Sub-Code, length: 10 , Coded Values: )
• Type ( type: esriFieldTypeString, alias: Sign Type, length: 25 , Coded Values: [GUIDE: Guide (D, E, M, G, SG)] , [SPECIAL GUIDE: Special Guide (SG)] , [RECCULTUR: Recreation] , ...11 more... )
• SignShape ( type: esriFieldTypeString, alias: Sign Shape, length: 15 , Coded Values: [CIRCLE: CIRCLE] , [CROSSBUCK: CROSSBUCK] , [DIAMOND: DIAMOND] , ...8 more... )
• Text ( type: esriFieldTypeString, alias: Sign Text, length: 50 )
• Size ( type: esriFieldTypeString, alias: Sign Size, length: 10 , Coded Values: [102" x 60": 102" x 60"] , [114" x 24": 114" x 24"] , [12" x 18": 12" x 18"] , ...81 more... )
• SignSupport ( type: esriFieldTypeString, alias: Sign Support, length: 25 , Coded Values: [Ex. Post: Existing Post] , [New Steel Post: New Steel Post] , [Ex. Signal Pole: Existing Signal Pole] , ...3 more... )
• Backing ( type: esriFieldTypeString, alias: Backing Material, length: 25 , Coded Values: [000ex: 000ex - Existing sign] , [3930W: 3930W - High Int White] , [3930RW: 3930RW - High Int white/Red Silk screen] , ...8 more... )
• Sheeting ( type: esriFieldTypeString, alias: Sheeting Material, length: 25 , Coded Values: [000ex: 000ex - Existing sign] , [3930W: 3930W - High Int White] , [3930RW: 3930RW - High Int white/Red Silk screen] , ...8 more... )
• Height ( type: esriFieldTypeDouble, alias: Height )
• Orientation ( type: esriFieldTypeString, alias: Direction Sign Faces, length: 10 , Coded Values: [N: North] , [S: South] , [E: East] , ...7 more... )
• DirectionofTraffic ( type: esriFieldTypeString, alias: Direction of Traffic, length: 25 , Coded Values: )
• Corner ( type: esriFieldTypeString, alias: Corner, length: 4 , Coded Values: [N: North] , [S: South] , [E: East] , ...7 more... )
• PrimaryRoad ( type: esriFieldTypeString, alias: Main Street, length: 75 )
• SecondaryRoad ( type: esriFieldTypeString, alias: Cross Street, length: 75 )
• TertiaryRoad ( type: esriFieldTypeString, alias: Tertiary Street, length: 75 )
• DistanceinFeet ( type: esriFieldTypeDouble, alias: Distance in Feet )
• SideOfRoad ( type: esriFieldTypeString, alias: Side of the Road, length: 10 , Coded Values: [N: North] , [S: South] , [E: East] , ...9 more... )
• MeasuredFrom ( type: esriFieldTypeString, alias: Measured From, length: 50 )
• TimeLimit ( type: esriFieldTypeString, alias: Time Limit, length: 10 )
• Zone ( type: esriFieldTypeString, alias: Zone, length: 50 )
• ActionDescriptionNumber ( type: esriFieldTypeDouble, alias: Action Description Number )
• DateRemoved ( type: esriFieldTypeDate, alias: Removal Date, length: 8 )
• TapeNumber ( type: esriFieldTypeString, alias: Tape Number, length: 255 )
• TapeCounter ( type: esriFieldTypeDouble, alias: Tape Counter )
• StructID ( type: esriFieldTypeString, alias: Struct ID, length: 40 )
• Date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• IntersectionNumber ( type: esriFieldTypeDouble, alias: Intersection Number )
• Action ( type: esriFieldTypeString, alias: Action, length: 255 )
• UserIDNumber ( type: esriFieldTypeInteger, alias: UserIDNumber )
• Verified ( type: esriFieldTypeInteger, alias: Verified )
• CitySign ( type: esriFieldTypeString, alias: City Sign, length: 10 , Coded Values: [Y: Yes] , [N: No] , [N/A: Not Applicable] )
• ContinentalID ( type: esriFieldTypeString, alias: ContinentalID, length: 40 )

Relationships:

• trSignalStructure (8) -- Related To: Traffic Signal Pole (356)
• trSignStructure (10) -- Related To: Street Sign Pole (353)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata