Layer: MTA.projects_points (ID:0)

View In: Map Viewer

Name: MTA.projects_points

Display Field: PROJECTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: | A. METHODOLOGY | Data is collected from project managers and SFMTA.com project page editors through the Interactive Project Map Collector Tool.| B. UPDATE FREQUENCY | The data is updated on an as needed basis. Project geographies should be updated by project managers and project pge editors whenever project extents change.| C. OTHER CRITICAL INFO | Please note there is a 250ft buffer for projects to more accurately represent the supervisor districts and neighborhoods that could potentially be affected by a project.| D. ATTRIBUTES |OBJECTID: Auto-populated field generated when a new attribute is added to the feature class;PROJECTNODE: The project node ID is the unique page identifier behind each public-facing url for pages on SFMTA.com;PROJECTNAME: Auto-populated field that grabs the appropriate project name based on the PROJECTNODE entered with the map attribute; CIP ID (if applicable): The CIP ID assigned to projects. If the field says NEW the project has not yet been assigned a CIP ID, please reach out to Capital Finance staff; CIP Title: The CIP Title assigned to projects. If the field says NEW the project has not yet been assigned a CIP Title, please reach out to Capital Finance staff; PROJECTPAGE: Auto-populated field that grabs the appropriate page url based on the PROJECTNODE entered with the map attribute;Project Teaser: Auto-populated field that grabs Project Teaser info from SFMTA.com project page;Project Phase: Auto-populated field that grabs Project Phase info from SFMTA.com project page; Project Type: Auto-populated field that grabs Project Type/Mode info from SFMTA.com project page; WEBPAGEPUBLISHED: Auto-populated field that denotes whether the map attribute has a published webpage; Supervisor Name: Auto-populated field with the name of the district supervisor(s) based on project extent; Supervisor District: Auto-populated field with the number of the supervisorial district(s) based on project extent;Neighborhood: Auto-populated field with the name of the neighborhood based on project extent;Project Page Map Option: Auto-populated field showing which map tab option on SFMTA.com is selected by project page editors; GEOEVENT_LASTUPDATE: ; CREATED_DATE: Auto-populated field with creation time stamp;CREATED_USER: Auto-populated field with the GIS login assigned to various workgroups;LAST_EDITED_DATE: Auto-populated field with edit time stamp;LAST_EDITED_USER: Auto-populated field with the GIS login assigned to various workgroups;SHAPE: Auto-populated field based on how the project feature is drawn; Partner Agencies: Auto-populated field that grabs Partner Agency info from SFMTA.com project page;SHAPE.LEN: ;

Copyright Text: | A. CUSTODIAN | Tori Winters, SFMTA Planning, tori.winters@sfmta.com | B. CREATED | 20171110, Steph A. Nelson | C. VERSIONS | 20180613, Tori Winters, Metadata added, edited CIP data to transition data collected from development to maintenance

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,91,149,255],"width":0.61538461538461542}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
PROJECTNODE (type: esriFieldTypeString, alias: PROJECTNODE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
PROJECTNAME (type: esriFieldTypeString, alias: PROJECTNAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
CIP_ID (type: esriFieldTypeString, alias: CIP ID (if applicable), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
CIP_TITLE (type: esriFieldTypeString, alias: CIP Title, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
PROJECTPAGE (type: esriFieldTypeString, alias: PROJECTPAGE, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
TEASER (type: esriFieldTypeString, alias: Project Teaser, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
PROJECTPHASE (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
PROJECTTYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
PARTNERAGENCIES (type: esriFieldTypeString, alias: Partner Agencies, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
WEBPAGEPUBLISHED (type: esriFieldTypeString, alias: WEBPAGEPUBLISHED, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
SUPERVISORNAME (type: esriFieldTypeString, alias: Supervisor Name, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
SUPERVISORDISTRICT (type: esriFieldTypeString, alias: Supervisor District, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
NEIGHBORHOOD (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
MAP_OPTION (type: esriFieldTypeString, alias: Project Page Map Option, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
GEOEVENT_LASTUPDATE (type: esriFieldTypeDate, alias: GEOEVENT_LASTUPDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CREATED_DATE (type: esriFieldTypeDate, alias: CREATED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CREATED_USER (type: esriFieldTypeString, alias: CREATED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LAST_EDITED_DATE (type: esriFieldTypeDate, alias: LAST_EDITED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LAST_EDITED_USER (type: esriFieldTypeString, alias: LAST_EDITED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
NHOOD_NODE (type: esriFieldTypeString, alias: NHOOD_NODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
FTID (type: esriFieldTypeString, alias: FTID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
LEADAGENCY (type: esriFieldTypeString, alias: LEADAGENCY, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
CHILD_STATUS (type: esriFieldTypeString, alias: CHILD_STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/9/2025 9:39:46 PM

Schema Last Edit Date: 4/9/2025 9:39:46 PM

Data Last Edit Date: 4/9/2025 9:39:46 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat