View In:   ArcGIS Online Map Viewer

Name: MTA.trafficcalming_pointfeatures

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

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: Intersecting street- PROJECT_LO: Intersection location- NEIGHBORHOOD: Neighborhood TC device is located in- DISTRICT: Supervisorial district TC device is located in- TC_MEASURE: Type of traffic calming device- UNITS: Number of devices installed at the location- INSTALL_MO: Month the device was installed- INSTALL_YR: Year the device was installed- SOURCE: Data source for update- FISCAL YEAR: If applicable, the fiscal year program in which the TC location was part (ie. FY for App-Based program- PROGRAM: If applicable, particular program- CURRENT_ST: Current status of location (ie. Complete, pending, etc.)- CURRENT_TI: Anticipated timeline for current step- NEXT_STEP: Next step in traffic calming process- NEXT_STEP_TI: Anticipated timeline for next step

Copyright Text: | A. CUSTODIAN | Mike Jacobson; michael.jacobson@sfmta.com; SFMTA Livable Streets | B. CREATED | 20190614; Jenn Chan; jennifer.chan@sfmta.com; SFMTA Livable Streets | C. VERSIONS | 20190614, Jenn Chan, clean up for MTA spatial datastore 20220407, Mike Jacobson, updated with completed traffic calming devices installed through Q1 2022 20221010, Mike Jacobson, updated with new fields and traffic calming devices installed and planned 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.509622174
YMin: 37.708867204
XMax: -122.373157914
YMax: 37.806498899000005
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [67, 90, 158, 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
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 )
• FID_1 ( type: esriFieldTypeInteger, alias: FID_1, editable: true, nullable: true, defaultValue: null, modelName: FID_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 )
• STREET_NAM ( type: esriFieldTypeString, alias: STREET_NAM, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STREET_NAM )
• FROM_ST ( type: esriFieldTypeString, alias: FROM_ST, editable: true, nullable: true, length: 254, defaultValue: null, modelName: FROM_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: esriFieldTypeDouble, alias: UNITS, editable: true, nullable: true, defaultValue: null, modelName: UNITS )
• INSTALL_MO ( type: esriFieldTypeDouble, alias: INSTALL_MO, editable: true, nullable: true, defaultValue: null, modelName: INSTALL_MO )
• INSTALL_YR ( type: esriFieldTypeDouble, alias: INSTALL_YR, editable: true, nullable: true, 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_ )
• DISTRICT ( type: esriFieldTypeInteger, alias: DISTRICT, editable: true, nullable: true, defaultValue: null, modelName: DISTRICT )
• NAME ( type: esriFieldTypeString, alias: NAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: NAME )
• 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 )

Templates:

• Name: MTA.trafficcalming_pointfeatures
  Description:
  Prototype:
  NAME: null
  DISTRICT: null
  FID_1: null
  OBJECTID: null
  CNN: null
  STREET_NAM: null
  FROM_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
  NEXT_STEP: null
  NEXT_STEP_: null
  
  Drawing Tool: esriFeatureEditToolPoint

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