Name: Street Sign

Display Field: SurveyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: de73effa61484703b7120fe733135131

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: Street Sign
  Description:
  Prototype:
  CitySign: null
  ContinentalID: null
  FacilityID: null
  LegacyID: null
  Address: null
  Location: null
  Condition: null
  ConditionDate: null
  WarrantyDate: null
  PurchaseDate: null
  InstallDate: null
  AssetCost: null
  CoF: null
  PoF: null
  BRE: null
  UsefulLife: null
  LifecycleStatus: null
  Comments: null
  Owner: null
  MaintainedBy: null
  ContractorID: null
  ImagePath: null
  SurveyDate: null
  SurveyName: null
  EditDate: null
  EditorName: null
  Source: null
  DataSourceType: null
  DataSourceReference: null
  SignCode: null
  SignSubCode: null
  Type: null
  SignShape: null
  Text: null
  Size: null
  SignSupport: null
  Backing: null
  Sheeting: null
  Height: null
  Orientation: null
  DirectionofTraffic: null
  Corner: null
  PrimaryRoad: null
  SecondaryRoad: null
  TertiaryRoad: null
  DistanceinFeet: null
  SideOfRoad: null
  MeasuredFrom: null
  TimeLimit: null
  Zone: null
  ActionDescriptionNumber: null
  DateRemoved: null
  TapeNumber: null
  TapeCounter: null
  StructID: null
  Date: null
  IntersectionNumber: null
  Action: null
  UserIDNumber: null
  Verified: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• trSignalStructure (11) -- Related To: Traffic Signal Pole Structure (149)

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

Sync Can Return Changes: false

Is Data Versioned: true

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: false

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