View In:   ArcGIS Online Map Viewer

Name: School_Flashing_Signal

Display Field: audit_city_issue_comment_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 116573a429374c8a877519b402458f8c

Copyright Text:

Default Visibility: true

Max Result Window: N/A

Max Record Count: 200000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 805782.7302274704
YMin: 2682830.6273793876
XMax: 816988.6274350584
YMax: 2726072.462155387
Spatial Reference: 103072  (6492)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [153, 59, 142, 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:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: true

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• control_box_id ( modelName: CONTROL_BOX_ID, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: CONTROL BOX ID, type: esriFieldTypeString )
• signal_sequence_id ( modelName: SIGNAL_SEQUENCE_ID, nullable: true, editable: true, defaultValue: N/A, alias: SIGNAL SEQUENCE ID, type: esriFieldTypeDouble )
• school_signal_type ( modelName: SCHOOL_SIGNAL_TYPE, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SCHOOL SIGNAL TYPE, type: esriFieldTypeString , Coded Values: [YELLOW: YELLOW] , [SPEED MONITOR: SPEED MONITOR] , [YELLOW WITH SPEED MONITOR: YELLOW WITH SPEED MONITOR] , ...2 more... )
• school_signal_sections ( modelName: SCHOOL_SIGNAL_SECTIONS, nullable: true, editable: true, defaultValue: N/A, alias: SCHOOL SIGNAL SECTIONS, type: esriFieldTypeDouble , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...3 more... )
• school_signal_bulb_size ( modelName: SCHOOL_SIGNAL_BULB_SIZE, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SCHOOL SIGNAL BULB SIZE, type: esriFieldTypeString , Coded Values: [8 INCH: 8 INCH] , [8 INCH LED: 8 INCH LED] , [12 INCH: 12 INCH] , ...5 more... )
• mph_speed ( modelName: MPH_SPEED, nullable: true, editable: true, defaultValue: N/A, alias: MPH SPEED, type: esriFieldTypeDouble )
• mph_speed_bulb_size ( modelName: MPH_SPEED_BULB_SIZE, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: MPH SPEED BULB SIZE, type: esriFieldTypeString , Coded Values: [8 INCH: 8 INCH] , [8 INCH LED: 8 INCH LED] , [12 INCH: 12 INCH] , ...5 more... )
• retrofit_team ( modelName: RETROFIT_TEAM, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: RETROFIT TEAM, type: esriFieldTypeString , Coded Values: [SIEMENS TEAM 1: SIEMENS TEAM 1] , [SIEMENS TEAM 2: SIEMENS TEAM 2] , [SIEMENS TEAM 3: SIEMENS TEAM 3] , ...17 more... )
• retrofit_date_inspected ( modelName: RETROFIT_DATE_INSPECTED, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 8, alias: RETROFIT DATE INSPECTED, type: esriFieldTypeDate )
• retrofit_comments ( modelName: RETROFIT_COMMENTS, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: RETROFIT COMMENTS, type: esriFieldTypeString )
• auditor_status ( modelName: AUDITOR_STATUS, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: AUDITOR STATUS, type: esriFieldTypeString , Coded Values: [COLLECTED: COLLECTED] , [REVIEWED: REVIEWED] )
• retrofit_status ( modelName: RETROFIT_STATUS, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: RETROFIT STATUS, type: esriFieldTypeString , Coded Values: [CONVERTED: CONVERTED] , [CONVERTED WITH ISSUE: CONVERTED WITH ISSUE] , [UNCONVERTED WITH ISSUE CONTRACTOR: UNCONVERTED WITH ISSUE CONTRACTOR] , ...8 more... )
• issue_tracking ( modelName: ISSUE_TRACKING, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: ISSUE TRACKING, type: esriFieldTypeString , Coded Values: [N: NO] , [Y: YES] , [RESOLVED: RESOLVED] )
• auditor_issue_comment ( modelName: AUDITOR_ISSUE_COMMENT, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: AUDITOR_ISSUE_COMMENT, type: esriFieldTypeString )
• auditor_issue_comment_date ( modelName: AUDITOR_ISSUE_COMMENT_DATE, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 8, alias: AUDITOR_ISSUE_COMMENT_DATE, type: esriFieldTypeDate )
• auditor_siemens_issue_comment ( modelName: AUDITOR_SIEMENS_ISSUE_COMMENT, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: AUDITOR_SIEMENS_ISSUE_COMMENT, type: esriFieldTypeString )
• auditor_siemens_issue_comment_d ( modelName: AUDITOR_SIEMENS_ISSUE_COMMENT_D, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 8, alias: AUDITOR_SIEMENS_ISSUE_COMMENT_DATE, type: esriFieldTypeDate )
• auditor_siemens_issue_comment_n ( modelName: AUDITOR_SIEMENS_ISSUE_COMMENT_N, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: AUDITOR_SIEMENS_ISSUE_COMMENT_NAME, type: esriFieldTypeString )
• audit_city_issue_comment ( modelName: AUDIT_CITY_ISSUE_COMMENT, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: AUDIT_CITY_ISSUE_COMMENT, type: esriFieldTypeString )
• audit_city_issue_comment_date ( modelName: AUDIT_CITY_ISSUE_COMMENT_DATE, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 8, alias: AUDIT_CITY_ISSUE_COMMENT_DATE, type: esriFieldTypeDate )
• audit_city_issue_comment_name ( modelName: AUDIT_CITY_ISSUE_COMMENT_NAME, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: AUDIT_CITY_ISSUE_COMMENT_NAME, type: esriFieldTypeString )
• audit_resolution_issue_comment ( modelName: AUDIT_RESOLUTION_ISSUE_COMMENT, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: AUDIT_RESOLUTION_ISSUE_COMMENT, type: esriFieldTypeString )
• audit_resolution_issue_comment_ ( modelName: AUDIT_RESOLUTION_ISSUE_COMMENT_, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 8, alias: AUDIT_RESOLUTION_ISSUE_COMMENT_DATE, type: esriFieldTypeDate )
• audit_resolution_issue_comment1 ( modelName: AUDIT_RESOLUTION_ISSUE_COMMENT1, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: AUDIT_RESOLUTION_ISSUE_COMMENT_NAME, type: esriFieldTypeString )
• retrofit_issue_comment ( modelName: RETROFIT_ISSUE_COMMENT, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: RETROFIT_ISSUE_COMMENT, type: esriFieldTypeString )
• retrofit_siemens_issue_comment ( modelName: RETROFIT_SIEMENS_ISSUE_COMMENT, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: RETROFIT_SIEMENS_ISSUE_COMMENT, type: esriFieldTypeString )
• retrofit_siemens_issue_comment_ ( modelName: RETROFIT_SIEMENS_ISSUE_COMMENT_, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 8, alias: RETROFIT_SIEMENS_ISSUE_COMMENT_DATE, type: esriFieldTypeDate )
• retrofit_siemens_issue_comment1 ( modelName: RETROFIT_SIEMENS_ISSUE_COMMENT1, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: RETROFIT_SIEMENS_ISSUE_COMMENT_NAME, type: esriFieldTypeString )
• retrofit_city_issue_comment ( modelName: RETROFIT_CITY_ISSUE_COMMENT, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: RETROFIT_CITY_ISSUE_COMMENT, type: esriFieldTypeString )
• retrofit_city_issue_comment_dat ( modelName: RETROFIT_CITY_ISSUE_COMMENT_DAT, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 8, alias: RETROFIT_CITY_ISSUE_COMMENT_DATE, type: esriFieldTypeDate )
• retrofit_city_issue_comment_nam ( modelName: RETROFIT_CITY_ISSUE_COMMENT_NAM, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: RETROFIT_CITY_ISSUE_COMMENT_NAME, type: esriFieldTypeString )
• retrofit_resolution_issue_comme ( modelName: RETROFIT_RESOLUTION_ISSUE_COMME, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: RETROFIT_RESOLUTION_ISSUE_COMMENT, type: esriFieldTypeString )
• retrofit_resolution_issue_com_1 ( modelName: RETROFIT_RESOLUTION_ISSUE_COM_1, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 8, alias: RETROFIT_RESOLUTION_ISSUE_COMMENT_DATE, type: esriFieldTypeDate )
• retrofit_resolution_issue_com_2 ( modelName: RETROFIT_RESOLUTION_ISSUE_COM_2, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: RETROFIT_RESOLUTION_ISSUE_COMMENT_NAME, type: esriFieldTypeString )
• count_ ( modelName: COUNT_, nullable: true, editable: true, defaultValue: N/A, alias: COUNT, type: esriFieldTypeDouble )
• x ( modelName: X, nullable: true, editable: true, defaultValue: N/A, alias: X, type: esriFieldTypeDouble )
• y ( modelName: Y, nullable: true, editable: true, defaultValue: N/A, alias: Y, type: esriFieldTypeDouble )
• gis_id ( modelName: GIS_ID, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: GIS_ID, type: esriFieldTypeString )
• globalid ( modelName: GlobalID, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• creationdate ( modelName: CreationDate, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 8, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: Creator, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: EditDate, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 8, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: Editor, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Editor, type: esriFieldTypeString )
• auditor_team ( modelName: AUDITOR_TEAM, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: AUDITOR TEAM, type: esriFieldTypeString , Coded Values: [SIEMENS TEAM 1: SIEMENS TEAM 1] , [SIEMENS TEAM 2: SIEMENS TEAM 2] , [SIEMENS TEAM 3: SIEMENS TEAM 3] , ...17 more... )
• audit_date ( modelName: AUDIT_DATE, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 8, alias: AUDIT DATE, type: esriFieldTypeDate )
• traffic_subtype ( modelName: TRAFFIC_SUBTYPE, nullable: true, editable: true, defaultValue: N/A, alias: TRAFFIC_SUBTYPE, type: esriFieldTypeSmallInteger )
• signal_contains_led ( modelName: SIGNAL_CONTAINS_LED, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SIGNAL_CONTAINS_LED, type: esriFieldTypeString )
• hyperlink ( modelName: Hyperlink, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Hyperlink, type: esriFieldTypeString )
• school_signal_style ( modelName: SCHOOL_SIGNAL_STYLE, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SCHOOL_SIGNAL_STYLE, type: esriFieldTypeString )
• lucitylink ( modelName: LucityLink, nullable: true, editable: true, defaultValue: N/A, alias: LucityLink, type: esriFieldTypeInteger )
• inlucity ( modelName: InLucity, nullable: true, editable: true, defaultValue: N/A, alias: InLucity, type: esriFieldTypeSmallInteger )
• facility_id ( modelName: facility_id, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Facility_ID, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: created_user, type: esriFieldTypeString, required: true )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: created_date, type: esriFieldTypeDate, required: true )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: last_edited_user, type: esriFieldTypeString, required: true )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: last_edited_date, type: esriFieldTypeDate, required: true )

Templates:

• Name: School_Flashing_Signal
  Description:
  Prototype:
  creationdate: null
  audit_city_issue_comment: null
  retrofit_resolution_issue_comme: null
  mph_speed_bulb_size: null
  retrofit_siemens_issue_comment_: null
  gis_id: null
  retrofit_comments: null
  retrofit_status: null
  retrofit_team: null
  auditor_team: null
  auditor_issue_comment_date: null
  facility_id: null
  school_signal_sections: null
  audit_city_issue_comment_name: null
  hyperlink: null
  retrofit_date_inspected: null
  signal_sequence_id: null
  auditor_siemens_issue_comment_d: null
  traffic_subtype: null
  audit_resolution_issue_comment_: null
  auditor_siemens_issue_comment_n: null
  audit_resolution_issue_comment: null
  school_signal_type: null
  editdate: null
  audit_city_issue_comment_date: null
  signal_contains_led: null
  auditor_status: null
  retrofit_issue_comment: null
  audit_date: null
  auditor_siemens_issue_comment: null
  school_signal_bulb_size: null
  control_box_id: null
  retrofit_city_issue_comment_nam: null
  retrofit_siemens_issue_comment1: null
  audit_resolution_issue_comment1: null
  retrofit_city_issue_comment_dat: null
  auditor_issue_comment: null
  editor: null
  issue_tracking: null
  creator: null
  retrofit_siemens_issue_comment: null
  inlucity: null
  retrofit_resolution_issue_com_1: null
  retrofit_resolution_issue_com_2: null
  retrofit_city_issue_comment: null
  count_: null
  school_signal_style: null
  x: null
  mph_speed: null
  y: null
  lucitylink: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports OidReservation: true

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

Supports Coordinates Quantization: true

Child Resources:

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