View In:   ArcGIS Online Map Viewer

Name: MTA.trafficcalming

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This dataset tracks the status of midblock traffic calming devices from data collection to project completion. Use the definition query CURRENT_STATUS = Complete to find completed devices. Another usual query is PROGRAM = App-Based to find all application-based traffic calming locations.Attributes:- CNN: Corresponding centerline network node- STREETNAME: Primary street- FROM_ST: Beginning project bound- TO_ST: Ending project bound- PROJECT_LOCATION: Concatenated location- NEIGHBORHOOD: Neighborhood in which TC device is located- DISTRICT: Supervisorial district in which TC device is located- TC_MEASURE: Type of traffic calming device installed at location- UNITS: Number of devices installed at location- INSTALL_MO: Month of installation- INSTALL_YR: Year of installation- SOURCE: Data source for locations, device types, and current status- FISCAL_YR: Fiscal year included if a location is part of a fiscal year program cycle (ie. App-Based program)- PROGRAM: Specifies if a TC location is part of a specific program (ie. NTIP, CRT, or neighborhood proactive)- CURRENT_ST: Current status (Options include: Complete, Collect traffic data for each block, pending construction, etc.)- CURRENT_TI: Timeline for current step, if available- NEXT_ST: Next step in traffic calming process- NEXT_ST_TI: Timeline for next step, if available

Copyright Text: A. CUSTODIAN | Mike Jacobson; michael.jacobson@sfmta.com; SFMTA Livable Streets | B. CREATED | 20191220; Jenn Chan; jennifer.chan@sfmta.com; SFMTA Livable Streets | C. VERSIONS | 20191220, Jenn Chan, clean up for MTA spatial datastore 20220407, Mike Jacobson, updated with completed traffic calming devices installed through Q1 2022 20220614, Mike Jacobson, updated with completed traffic calming devices installed through May 2022 20221010, Mike Jacobson, updated to include pending devices locations in addition to completed traffic calmind devices. Data current through Q3 2022

Default Visibility: false

MaxRecordCount: 10000

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: -122.510925947
YMin: 37.708354337
XMax: -122.36771095
YMax: 37.828354987
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [68, 140, 42, 255]
Width: 1
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
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 Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID )
• CNN ( type: esriFieldTypeDouble, alias: CNN, editable: true, nullable: true, defaultValue: null, modelName: CNN )
• NHOOD ( type: esriFieldTypeString, alias: NHOOD, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NHOOD )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STREETNAME )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, editable: true, nullable: true, length: 254, defaultValue: null, modelName: DISTRICT )
• FROM_ST ( type: esriFieldTypeString, alias: FROM_ST, editable: true, nullable: true, length: 254, defaultValue: null, modelName: FROM_ST )
• TO_ST ( type: esriFieldTypeString, alias: TO_ST, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TO_ST )
• PROJECT_LO ( type: esriFieldTypeString, alias: PROJECT_LO, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PROJECT_LO )
• TC_MEASURE ( type: esriFieldTypeString, alias: TC_MEASURE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TC_MEASURE )
• UNITS ( type: esriFieldTypeString, alias: UNITS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: UNITS )
• INSTALL_MO ( type: esriFieldTypeString, alias: INSTALL_MO, editable: true, nullable: true, length: 254, defaultValue: null, modelName: INSTALL_MO )
• INSTALL_YR ( type: esriFieldTypeString, alias: INSTALL_YR, editable: true, nullable: true, length: 254, defaultValue: null, modelName: INSTALL_YR )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SOURCE )
• FISCAL_YR ( type: esriFieldTypeString, alias: FISCAL_YR, editable: true, nullable: true, length: 254, defaultValue: null, modelName: FISCAL_YR )
• PROGRAM ( type: esriFieldTypeString, alias: PROGRAM, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PROGRAM )
• CURRENT_ST ( type: esriFieldTypeString, alias: CURRENT_ST, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CURRENT_ST )
• CURRENT_TI ( type: esriFieldTypeString, alias: CURRENT_TI, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CURRENT_TI )
• NEXT_STEP ( type: esriFieldTypeString, alias: NEXT_STEP, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NEXT_STEP )
• NEXT_STEP_ ( type: esriFieldTypeString, alias: NEXT_STEP_, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NEXT_STEP_ )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.LEN, editable: false, nullable: true, defaultValue: null, modelName: SHAPE.LEN, required: true )

Templates:

• Name: MTA.trafficcalming
  Description:
  Prototype:
  NEXT_STEP: null
  NEXT_STEP_: null
  OBJECTID: null
  CNN: null
  NHOOD: null
  STREETNAME: null
  DISTRICT: null
  FROM_ST: null
  TO_ST: null
  PROJECT_LO: null
  TC_MEASURE: null
  UNITS: null
  INSTALL_MO: null
  INSTALL_YR: null
  SOURCE: null
  FISCAL_YR: null
  PROGRAM: null
  CURRENT_ST: null
  CURRENT_TI: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

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

Child Resources:

Supported Operations:   Query   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata