View In:   ArcGIS Online Map Viewer

Name: MTA.temp_street_closures

Display Field: CASE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: | A. METHODOLOGY | Exported from the Special Events/Shared Spaces Saleforce database maintained by the SFMTA ISCOTT unit and the Special Traffic Permit (STP) Access database, and converted to geometry of streets and intersections based on closed street extent description. | B. UPDATE FREQUENCY | Database is updated weekly.| C. OTHER CRITICAL INFO | | D. ATTRIBUTES |CASE_NUM: case numberCASE_NAME: case nameTYPE: closure type - Shared Space, Special Event or STP (special traffic permit)STATUS: case statusSTART_DATE: closure start dateSTART_TIME: closure start timeSTART_DT: closure start datetimeEND_DATE: closure end dataEND_TIME: closure end timeEND_DT: closure end datetimeLOC_DESC: closure locationdescriptionDT_DESC: closure date/time descriptionCNN: CNN of street impacted by closure. CNN is San Francisco’s street centerline network unique ID.STREET: street impacted by closureFROM_ST: crossed street 1 of the street impacted by closureTO_ST: crossed street 2 of the street impacted by closureDOW: day of weekDIRECTION: direction of street being closedVEH_IMP: vehicle impact

Copyright Text: | A. CUSTODIAN | Muyi Zhou, muyi.zhou@sfmta.com, SFMTA, Sustainable Streets, Data Analytics | B. CREATED | 20200701, Muyi Zhou created the first version | C. VERSIONS | 20200701, Muyi Zhou, created with program applications

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.513616719
YMin: 37.70798826
XMax: -122.367870671
YMax: 37.808965883000006
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [46, 95, 130, 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 ( type: esriFieldTypeOID, alias: FID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CASE_NUM ( type: esriFieldTypeString, alias: CASE_NUM, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CASE_NUM )
• CASE_NAME ( type: esriFieldTypeString, alias: CASE_NAME, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CASE_NAME )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TYPE )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STATUS )
• START_DATE ( type: esriFieldTypeString, alias: START_DATE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: START_DATE )
• START_TIME ( type: esriFieldTypeString, alias: START_TIME, editable: true, nullable: true, length: 8, defaultValue: null, modelName: START_TIME )
• START_DT ( type: esriFieldTypeString, alias: START_DT, editable: true, nullable: true, length: 19, defaultValue: null, modelName: START_DT )
• END_DATE ( type: esriFieldTypeString, alias: END_DATE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: END_DATE )
• END_TIME ( type: esriFieldTypeString, alias: END_TIME, editable: true, nullable: true, length: 8, defaultValue: null, modelName: END_TIME )
• END_DT ( type: esriFieldTypeString, alias: END_DT, editable: true, nullable: true, length: 19, defaultValue: null, modelName: END_DT )
• LOC_DESC ( type: esriFieldTypeString, alias: LOC_DESC, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LOC_DESC )
• CNN ( type: esriFieldTypeString, alias: CNN, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CNN )
• STREET ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STREET )
• 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 )
• INFO ( type: esriFieldTypeString, alias: INFO, editable: true, nullable: true, length: 254, defaultValue: null, modelName: INFO )
• START_UTC ( type: esriFieldTypeString, alias: START_UTC, editable: true, nullable: true, length: 254, defaultValue: null, modelName: START_UTC )
• END_UTC ( type: esriFieldTypeString, alias: END_UTC, editable: true, nullable: true, length: 254, defaultValue: null, modelName: END_UTC )
• DIRECTION ( type: esriFieldTypeString, alias: DIRECTION, editable: true, nullable: true, length: 254, defaultValue: null, modelName: DIRECTION )
• VEH_IMP ( type: esriFieldTypeString, alias: VEH_IMP, editable: true, nullable: true, length: 254, defaultValue: null, modelName: VEH_IMP )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• 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 )
• ACTIVE ( type: esriFieldTypeSmallInteger, alias: ACTIVE, editable: true, nullable: true, defaultValue: null, modelName: ACTIVE )

Templates:

• Name: MTA.temp_street_closures
  Description:
  Prototype:
  VEH_IMP: null
  ACTIVE: null
  CASE_NUM: null
  CASE_NAME: null
  TYPE: null
  STATUS: null
  START_DATE: null
  START_TIME: null
  START_DT: null
  END_DATE: null
  END_TIME: null
  END_DT: null
  LOC_DESC: null
  CNN: null
  STREET: null
  FROM_ST: null
  TO_ST: null
  INFO: null
  START_UTC: null
  END_UTC: null
  DIRECTION: 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