Name: MTA.temp_street_closures_intrsctn

Display Field: CASE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

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 || D. ATTRIBUTES |CNN: CNN of intersection impacted by closure. CNN is unique ID of San Francisco’s street centerlines/intersections .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: intersected streetTo_st: kept blankStart_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: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -122.511938326
YMin: 37.70798826
XMax: -122.367870671
YMax: 37.808965883000006
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [173, 0, 49, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 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: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CNN ( type: esriFieldTypeString, alias: CNN, length: 254 )
• CASE_NAME ( type: esriFieldTypeString, alias: CASE_NAME, length: 254 )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 254 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 254 )
• STREET ( type: esriFieldTypeString, alias: STREET, length: 254 )
• START_DATE ( type: esriFieldTypeString, alias: START_DATE, length: 254 )
• END_DATE ( type: esriFieldTypeString, alias: END_DATE, length: 254 )
• IS_OPEN ( type: esriFieldTypeString, alias: IS_OPEN, length: 254 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• CASE_NUM ( type: esriFieldTypeString, alias: CASE_NUM, length: 254 )
• START_TIME ( type: esriFieldTypeString, alias: START_TIME, length: 8 )
• START_DT ( type: esriFieldTypeString, alias: START_DT, length: 19 )
• END_TIME ( type: esriFieldTypeString, alias: END_TIME, length: 8 )
• END_DT ( type: esriFieldTypeString, alias: END_DT, length: 19 )
• LOC_DESC ( type: esriFieldTypeString, alias: LOC_DESC, length: 254 )
• X_STREET ( type: esriFieldTypeString, alias: X_STREET, length: 254 )
• DIRECTION ( type: esriFieldTypeString, alias: DIRECTION, length: 50 )
• VEH_IMP ( type: esriFieldTypeString, alias: VEH_IMP, length: 254 )
• INFO ( type: esriFieldTypeString, alias: INFO, length: 254 )
• START_UTC ( type: esriFieldTypeString, alias: START_UTC, length: 254 )
• END_UTC ( type: esriFieldTypeString, alias: END_UTC, length: 254 )
• ACTIVE ( type: esriFieldTypeSmallInteger, alias: ACTIVE )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata