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 Street Closure Saleforce database which is maintained by the SFMTA ISCOTT unit, and converted to geometry of streets and intersections based on closed street extent description. | B. UPDATE FREQUENCY | Database is updated constantly. This report is issued daily/weekly/thrice weekly. | C. OTHER CRITICAL INFO | | D. ATTRIBUTES |CNN: CNN of street impacted by closure. CNN is San Francisco’s street centerline network unique ID.Case_number: case numberCase_name: case nameType: closure typeStatus: case statusDT_opened: date/time of case openedPolicyDist: policy districtPubhear: public hearing dateContact_Na: contact nameContact_Em: contact emailLocation: closure locationStreet: street impacted by closureX_Street1: crossed street 1 for the entire closureX_Street2: crossed street 2 for the entire closure Street_name: street impacted by closureFrom_st: crossed street 1 for the street segment impacted by closureTo_st: crossed street 1 for the street segment impacted by closureStart_date: start date of closure in date/time format (local time)End_date: end date of closure in date/time format (local time)Start_UTC: start date of closure in date/time format (UTC time)End_UTC: end date of closure in date/time format (UTC time)Event_Date: event details of start/end date, day of week, frequency, ect.Descriptio: comments by applicant

Copyright Text: | A. CUSTODIAN | Nick Chapman, nick.chapman@sfmta.com, SFMTA, Sustainable Streets, Transportation Engineering | 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: [0, 176, 85, 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: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CNN ( type: esriFieldTypeString, alias: CNN, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CNN )
• 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 )
• 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 )
• START_DATE ( type: esriFieldTypeString, alias: START_DATE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: START_DATE )
• END_DATE ( type: esriFieldTypeString, alias: END_DATE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: END_DATE )
• 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 )
• CASE_NUM ( type: esriFieldTypeString, alias: CASE_NUM, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CASE_NUM )
• 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_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 )
• 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 )
• 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 )
• ACTIVE ( type: esriFieldTypeSmallInteger, alias: ACTIVE, editable: true, nullable: true, defaultValue: null, modelName: ACTIVE )

Templates:

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