{ "culture": "en-US", "name": "", "guid": "", "catalogPath": "", "snippet": "SFMTA Sign shop assets, updated daily.", "description": "

| A. METHODOLOGY | Sign shop assets are manually added and updated via the Sign Shop Web Map Editor: https://sfgov.maps.arcgis.com/apps/webappviewer/index.html?id=a28072f040a84754a56163003e2b1fc2 <\/SPAN><\/P>

| B. UPDATE FREQUENCY | Multiple times per day, Monday through Friday 7am to 5pm<\/SPAN><\/P>

<\/P>

| C. OTHER CRITICAL INFO | Delineators and bike racks use the \"NUM_OF_ASSETS\" field to indicate how many assets are represented by a single point. Use values of 5 and 10 where possible. New are located along the curb. Old assets will be gradually moved to the curb. The 'zero point' of the blockface (where measurements begin) needs further SFMTA internal discussion and alignment. Currently, the MTA.curb layer sourced from SFGIS in 2017/18 uses the intersection of property lines to splice the curb into blockfaces and curb returns. Traffic Engineering uses a different methodology reliant on the location of the crosswalk.<\/SPAN><\/P>

<\/P>

| D. ATTRIBUTES |<\/SPAN><\/P>

<\/P>

OBJECTID_1: System (ArcGIS) generated unique identifier;<\/SPAN><\/P>

ASSET_ID: Unique ID generated by HxGN EAMS and synced back to ArcGIS via Logic Apps. Does not populate for 'cancelled' features;<\/SPAN><\/P>

SIGN_CODE: Alphanumeric value associated with unique combination of LEGEND and SIGN_SIZE. Uses domain EAMS_Signshop_SignCode. Domain created from table MTA.signshop_domain_signcode;<\/SPAN><\/P>

LEGEND: Text that appears on the sign, or if not a sign, a brief description of asset type. Populated via Logic App which uses the MTA.signshop_contingent_reference table to look up the value based on the sign code;<\/SPAN><\/P>

SIGN_SIZE: Dimensions of the sign. Populated via Logic App which uses the MTA.signshop_contingent_reference table to look up the value based on the sign;<\/SPAN><\/P>

STREET_ADDRESS_RANGE: Lowest to highest address number and name of street asset is located on. Null for intersection assets;<\/SPAN><\/P>

SIGN_SUPPORT: Type of structure sign is affixed to. Uses domain EAMS_Signshop_SignSupport. Domain created from table MTA.signshop_domain_signsupport;<\/SPAN><\/P>

FROM_ST: For assets on blockfaces/street segments, street name of first intersecting street. Based on CNN street segments, is not directional. For 3+ way intersections, street name(s) of intersecting street(s);<\/SPAN><\/P>

TO_ST: For assets on blockfaces/street segments, street name of second intersecting street. Based on CNN street segments, is not directional. Null for intersection assets;<\/SPAN><\/P>

INTERSECTION: Street names of two intersecting streets. Null for assets on street segment / blockface;<\/SPAN><\/P>

CORNER_SIDE_FACING: Description of where asset is located in an intersection. Somewhat legacy field from previous tabular database architecture. Uses domain EAMS_Signshop_SideFacing. Domain created from table MTA.signshop_domain_sidefacing;<\/SPAN><\/P>

ARROW_DIR: Direction of arrow for signs with arrows, such as ONE WAY. Uses domain EAMS_Signshop_ArrowDirection. Domain created from table MTA.signshop_domain_arrowdir;<\/SPAN><\/P>

BAPA: Whether asset requires Breakaway Pole Assembly;<\/SPAN><\/P>

BOOM_TRUCK: Whether the asset requires a boom truck to install;<\/SPAN><\/P>

CLEARANCE_PERMIT: Whether the asset requires a clearance permit;<\/SPAN><\/P>

NUM_OF_ASSETS: Number of assets, such as in the case of delineators and bike racks. Should use value of 5 or 10;<\/SPAN><\/P>

CONDITION: Condition of the asset. Uses domain EAMS_Signshop_Condition. Domain created from table MTA.signshop_domain_condition;<\/SPAN><\/P>

ORIG_INSTALL_DATE: Date of original installation;<\/SPAN><\/P>

REPLACEMENT_DATE: Replacement date;<\/SPAN><\/P>

SIGN_SUPERVISOR: Which sign supervisor district the asset is in;<\/SPAN><\/P>

SF_SUP_DISTRICT: Which SF Supervisor district the asset is in;<\/SPAN><\/P>

SHEETING: Type of sheeting. Uses domain EAMS_Signshop_Sheeting. Domain created from table MTA.signshop_domain_sheeting;<\/SPAN><\/P>

STATUS_CODE: Status of asset, such as Pending Installation, In Service, Retired, or Withdrawn. Uses domain EAMS_Signshop_SignStatus. Domain created from table MTA.signshop_domain_status;<\/SPAN><\/P>

NEW_SIGN_CODE: Alphanumeric value for new sign codes. Manually entered by Sign Shop supervisors;<\/SPAN><\/P>

NEW_SIGN_LEGEND: Text for new legends. Manually entered by Sign Shop Supervisors;<\/SPAN><\/P>

NEW_SIGN_SIZE: Dimensions of sign for new sign codes. Uses domain EAMS_Signshop_NewSignSize. Domain created from table MTA.signshop_domain_signsize;<\/SPAN><\/P>

SIGN_CATEGORY: Name of category. Uses domain EAMS_Signshop_SignCategory. Domain created from table MTA.signshop_domain_category;<\/SPAN><\/P>

SIGN_CLASS: Name of sign class. Uses domain EAMS_Signshop_SignClass. Domain created from table MTA.signshop_domain_class;<\/SPAN><\/P>

PURPOSE: For what purpose sign is for, according to planners. Uses domain EAMS_Signshop_Purpose. Domain created from table MTA.signshop_domain_purpose;<\/SPAN><\/P>

GISOBJID: Unique ID generated by Logic App, set equal to OBJECTID_1, populated in HxGN EAMS then synced back to GIS. Does not populate for 'cancelled' features. Required field for HxGN EAMS;<\/SPAN><\/P>

CANCEL: If asset created in error, user will populate this field with \"cancel' to flag it for removal;<\/SPAN><\/P>

<\/P>

<\/P>

<\/P>

<\/P>

<\/P><\/DIV><\/DIV><\/DIV>", "summary": "SFMTA Sign shop assets, updated daily.", "title": "MTA.signs", "tags": [ "signs", "signshop", "assets", "eams", "shops" ], "type": "", "typeKeywords": [], "thumbnail": "", "url": "", "minScale": 150000000, "maxScale": 5000, "spatialReference": "", "accessInformation": "| A. CUSTODIAN | Contact steph.nelson@sfmta.com, Spatial Data Store DBA\n| B. CREATED | 20230703, Mallik Budhavarapu and Steph Nelson imported from Spears/SHOPS database\n| C. VERSIONS | 20230703", "licenseInfo": "", "portalUrl": "" }