View In:   ArcGIS Online Map Viewer

Name: Signs

Display Field: I_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

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: 2450223.6310767233
YMin: 312462.5492388159
XMax: 2488739.9615242183
YMax: 398516.56151364744
Spatial Reference: 103191  (6609)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [52, 155, 97, 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

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 )
• BCODE_IDNU ( type: esriFieldTypeString, alias: BCODE_IDNU, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BCODE_IDNU )
• YR_INSTALL ( type: esriFieldTypeString, alias: YR_INSTALL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YR_INSTALL , Coded Values: [1950: 1950] , [1951: 1951] , [1952: 1952] , ...87 more... )
• SIGN_CLASS ( type: esriFieldTypeString, alias: SIGN_CLASS, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SIGN_CLASS , Coded Values: [Regulatory: Regulatory] , [Warning: Warning] , [Marker: Marker] , ...9 more... )
• REGULATORY ( type: esriFieldTypeString, alias: REGULATORY, editable: true, nullable: true, length: 75, defaultValue: null, modelName: REGULATORY , Coded Values: [R1-1: Stop] , [R1-2: Yield] , [R7-108: (Hour/Minute) Parking (time limit)] , ...248 more... )
• WARNING_TY ( type: esriFieldTypeString, alias: WARNING_TY, editable: true, nullable: true, length: 75, defaultValue: null, modelName: WARNING_TY , Coded Values: [W7-3b_O: % Grade (distance) Miles (Orange)] , [W7-3b_Y: % Grade (distance) Miles (Yellow)] , [W7-3_O: % Grade (Orange)] , ...415 more... )
• MARKER_TYP ( type: esriFieldTypeString, alias: MARKER_TYP, editable: true, nullable: true, length: 75, defaultValue: null, modelName: MARKER_TYP , Coded Values: [M1-1_2: Interstate Route (2 digit)] , [M1-1_3: Interstate Route (3 digit)] , [M1-1a: Interstate Route (2 digit - with state name)] , ...127 more... )
• GUIDE_AND_ ( type: esriFieldTypeString, alias: GUIDE_AND_, editable: true, nullable: true, length: 75, defaultValue: null, modelName: GUIDE_AND_ , Coded Values: [D1-1: Destination (single)] , [I-5: Airport] , [D9-13b: Ambulance Station (plaque)] , ...132 more... )
• REC_CUL_IN ( type: esriFieldTypeString, alias: REC_CUL_IN, editable: true, nullable: true, length: 75, defaultValue: null, modelName: REC_CUL_IN , Coded Values: [RA-010: Airport] , [RL-170: All-Terrain Vehicle Trail] , [RL-010: Amphitheater] , ...90 more... )
• BICYCLE ( type: esriFieldTypeString, alias: BICYCLE, editable: true, nullable: true, length: 75, defaultValue: null, modelName: BICYCLE , Coded Values: [D4-3: Bicycle Parking] , [D11-1: Bike Route] , [M1-8: Bicycle Route (Numbered)] , ...41 more... )
• TEM_TRAFF_ ( type: esriFieldTypeString, alias: TEM_TRAFF_, editable: true, nullable: true, length: 75, defaultValue: null, modelName: TEM_TRAFF_ , Coded Values: [G20-1: Road Work Next (distance)] , [G20-2: End Road Work] , [G20-4: Pilot Car Follow Me] , ...34 more... )
• RAILROAD ( type: esriFieldTypeString, alias: RAILROAD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RAILROAD , Coded Values: [I-7: Train Station] , [I-12: Light Rail Station] , [I-13L: Emergency Notification (large)] , ...37 more... )
• SCHOOL ( type: esriFieldTypeString, alias: SCHOOL, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SCHOOL , Coded Values: [S-CApollo: Businesses On Apollo Dr.] , [S-CCautionEntering: Caution Vehicles Entering Highway] , [S-CCrossTraffic: Cross Traffic Does Not Stop] , ...25 more... )
• EMER_INCID ( type: esriFieldTypeString, alias: EMER_INCID, editable: true, nullable: true, length: 75, defaultValue: null, modelName: EMER_INCID , Coded Values: [EM-1: Evacuation Route marker] , [EM-2: Area Closed] , [EM-3: Traffic Control Point] , ...33 more... )
• CHANGE_MES ( type: esriFieldTypeString, alias: CHANGE_MES, editable: true, nullable: true, length: 80, defaultValue: null, modelName: CHANGE_MES )
• OTHER_TYPE ( type: esriFieldTypeString, alias: OTHER_TYPE, editable: true, nullable: true, length: 80, defaultValue: null, modelName: OTHER_TYPE )
• SIGN_COLOR ( type: esriFieldTypeString, alias: SIGN_COLOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGN_COLOR , Coded Values: [Black on Fluorescent Pink: Black on Fluorescent Pink] , [Black on Fluorescent Yellow-Green: Black on Fluorescent Yellow-Green] , [Black on Orange: Black on Orange] , ...14 more... )
• SIGN_SIZE ( type: esriFieldTypeString, alias: SIGN_SIZE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGN_SIZE )
• SIGN_SHAPE ( type: esriFieldTypeString, alias: SIGN_SHAPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGN_SHAPE , Coded Values: [Octagon: Octagon] , [Equilateral Triangle: Equilateral Triangle] , [Circle: Circle] , ...8 more... )
• SHT_TYPE ( type: esriFieldTypeString, alias: SHT_TYPE, editable: true, nullable: true, length: 70, defaultValue: null, modelName: SHT_TYPE , Coded Values: [Beaded: Beaded] , [Prismatic: Prismatic] , [Beaded (Type I - Eng. Grade): Beaded (Type I - Eng. Grade)] , ...14 more... )
• RETRO_CLR_ ( type: esriFieldTypeString, alias: RETRO_CLR_, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETRO_CLR_ )
• RETRO_LVL_ ( type: esriFieldTypeString, alias: RETRO_LVL_, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETRO_LVL_ )
• RETRO_CON_ ( type: esriFieldTypeString, alias: RETRO_CON_, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETRO_CON_ , Coded Values: [Good: Good] , [Fair: Fair] , [Replace: Replace] )
• RETRO_CLR1 ( type: esriFieldTypeString, alias: RETRO_CLR1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETRO_CLR1 )
• RETRO_LVL1 ( type: esriFieldTypeString, alias: RETRO_LVL1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETRO_LVL1 )
• RETRO_CON1 ( type: esriFieldTypeString, alias: RETRO_CON1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETRO_CON1 , Coded Values: [Good: Good] , [Fair: Fair] , [Replace: Replace] )
• RETRO_CL_1 ( type: esriFieldTypeString, alias: RETRO_CL_1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETRO_CL_1 )
• RETRO_LV_1 ( type: esriFieldTypeString, alias: RETRO_LV_1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETRO_LV_1 )
• RETRO_CO_1 ( type: esriFieldTypeString, alias: RETRO_CO_1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RETRO_CO_1 , Coded Values: [Good: Good] , [Fair: Fair] , [Replace: Replace] )
• SPACER ( type: esriFieldTypeString, alias: SPACER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SPACER , Coded Values: [---------------------: ---------------------] )
• REP_SIGN ( type: esriFieldTypeString, alias: REP_SIGN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REP_SIGN , Coded Values: [Yes: Yes] , [No: No] )
• REP_YR ( type: esriFieldTypeString, alias: REP_YR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REP_YR , Coded Values: [2010: 2010] , [2011: 2011] , [2012: 2012] , ...38 more... )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ADDRESS )
• NEAR_INT ( type: esriFieldTypeString, alias: NEAR_INT, editable: true, nullable: true, length: 150, defaultValue: null, modelName: NEAR_INT )
• I_DATE ( type: esriFieldTypeDate, alias: I_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: I_DATE )
• I_TIME ( type: esriFieldTypeString, alias: I_TIME, editable: true, nullable: true, length: 10, defaultValue: null, modelName: I_TIME )
• I_NAME ( type: esriFieldTypeString, alias: I_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: I_NAME )
• S_D_Z_A ( type: esriFieldTypeString, alias: S_D_Z_A, editable: true, nullable: true, length: 50, defaultValue: null, modelName: S_D_Z_A )
• STICKER ( type: esriFieldTypeString, alias: STICKER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STICKER , Coded Values: [Yes: Yes] , [No: No] )
• FACE_D ( type: esriFieldTypeString, alias: FACE_D, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FACE_D , Coded Values: [NW: NW] , [N: N] , [NE: NE] , ...5 more... )
• F_S_S_S ( type: esriFieldTypeString, alias: F_S_S_S, editable: true, nullable: true, length: 15, defaultValue: null, modelName: F_S_S_S )
• S_L_S_S ( type: esriFieldTypeString, alias: S_L_S_S, editable: true, nullable: true, length: 10, defaultValue: null, modelName: S_L_S_S , Coded Values: [Yes: Yes] , [No: No] )
• SIGN_MAN ( type: esriFieldTypeString, alias: SIGN_MAN, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SIGN_MAN )
• SIGN_PLA_H ( type: esriFieldTypeString, alias: SIGN_PLA_H, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SIGN_PLA_H )
• SIGN_CON_T ( type: esriFieldTypeString, alias: SIGN_CON_T, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SIGN_CON_T )
• NEAR_MILE_ ( type: esriFieldTypeString, alias: NEAR_MILE_, editable: true, nullable: true, length: 60, defaultValue: null, modelName: NEAR_MILE_ )
• L_L_1 ( type: esriFieldTypeString, alias: L_L_1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: L_L_1 )
• L_L_2 ( type: esriFieldTypeString, alias: L_L_2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: L_L_2 )
• SIGN_OBS ( type: esriFieldTypeString, alias: SIGN_OBS, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SIGN_OBS , Coded Values: [Yes: Yes] , [No: No] )
• SIGN_OBS_D ( type: esriFieldTypeString, alias: SIGN_OBS_D, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SIGN_OBS_D )
• SIGN_OBS_1 ( type: esriFieldTypeDate, alias: SIGN_OBS_1, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SIGN_OBS_1 )
• OBS_COR_DA ( type: esriFieldTypeDate, alias: OBS_COR_DA, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OBS_COR_DA )
• OBS_COR_NO ( type: esriFieldTypeString, alias: OBS_COR_NO, editable: true, nullable: true, length: 150, defaultValue: null, modelName: OBS_COR_NO )
• CURR_COST ( type: esriFieldTypeDouble, alias: CURR_COST, editable: true, nullable: true, defaultValue: null, modelName: CURR_COST )
• FU_COST ( type: esriFieldTypeDouble, alias: FU_COST, editable: true, nullable: true, defaultValue: null, modelName: FU_COST )
• SIGN_COMM ( type: esriFieldTypeString, alias: SIGN_COMM, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SIGN_COMM )
• SIGN_NOTE ( type: esriFieldTypeString, alias: SIGN_NOTE, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SIGN_NOTE )
• Needs_Attn ( type: esriFieldTypeString, alias: Needs Attention, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Needs_Attn , Coded Values: [Yes: Yes] , [No: No] )
• OLDID ( type: esriFieldTypeDouble, alias: OLDID, editable: true, nullable: true, defaultValue: null, modelName: OLDID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• POLE_TYPE ( type: esriFieldTypeString, alias: POLE_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POLE_TYPE )
• TAPCO ( type: esriFieldTypeString, alias: TAPCO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TAPCO )
• LAT ( type: esriFieldTypeDouble, alias: LAT, editable: true, nullable: true, defaultValue: null, modelName: LAT )
• LONG ( type: esriFieldTypeDouble, alias: LONG, editable: true, nullable: true, defaultValue: null, modelName: LONG )
• FACILITY_ID ( type: esriFieldTypeString, alias: FACILITY_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FACILITY_ID )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STREETNAME )

Templates:

• Name: SIGNS.DBO.Signs
  Description:
  Prototype:
  STREETNAME: null
  BCODE_IDNU: null
  YR_INSTALL: null
  SIGN_CLASS: null
  REGULATORY: null
  WARNING_TY: null
  MARKER_TYP: null
  GUIDE_AND_: null
  REC_CUL_IN: null
  BICYCLE: null
  TEM_TRAFF_: null
  RAILROAD: null
  SCHOOL: null
  EMER_INCID: null
  CHANGE_MES: null
  OTHER_TYPE: null
  SIGN_COLOR: null
  SIGN_SIZE: null
  SIGN_SHAPE: null
  SHT_TYPE: null
  RETRO_CLR_: null
  RETRO_LVL_: null
  RETRO_CON_: null
  RETRO_CLR1: null
  RETRO_LVL1: null
  RETRO_CON1: null
  RETRO_CL_1: null
  RETRO_LV_1: null
  RETRO_CO_1: null
  SPACER: null
  REP_SIGN: null
  REP_YR: null
  ADDRESS: null
  NEAR_INT: null
  I_DATE: null
  I_TIME: null
  I_NAME: null
  S_D_Z_A: null
  STICKER: null
  FACE_D: null
  F_S_S_S: null
  S_L_S_S: null
  SIGN_MAN: null
  SIGN_PLA_H: null
  SIGN_CON_T: null
  NEAR_MILE_: null
  L_L_1: null
  L_L_2: null
  SIGN_OBS: null
  SIGN_OBS_D: null
  SIGN_OBS_1: null
  OBS_COR_DA: null
  OBS_COR_NO: null
  CURR_COST: null
  FU_COST: null
  SIGN_COMM: null
  SIGN_NOTE: null
  Needs_Attn: null
  OLDID: null
  FACILITY_ID: null
  LONG: null
  LAT: null
  TAPCO: null
  POLE_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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