View In:   ArcGIS Online Map Viewer

Name: MTA.PL_landuse

Display Field: TO_ST

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: | A. METHODOLOGY | Land use categories for every parcel in San Francisco. The land use categories are derived from a range of City and commercial databases. Where building square footages were missing from these databases they were derived from a LIDAR survey flown in 2007. Some fields (CIE, MED, MIPS, RETAIL, PDER & VISITOR) were derived using the NAICS codes supplied in the Dun & Bradstreet dataset and the TOTAL_USES column.| B. UPDATE FREQUENCY | Updated infrequently (less than annual).| C. OTHER CRITICAL INFO | The determining factor for a parcel's LANDUSE is if the square footage of any non-residential use is 80% or more of its total uses. Otherwise it becomes MIXED. In the case where RESIDENT use has some square footage of non-residential use, this is mainly accessory uses such as home businesses, freelancers, etc.| D. ATTRIBUTES |LANDUSE: Specified land use category for each parcel [CIE = Cultural, Institutional, Educational,MED = Medical,MIPS = Office (Management, Information, Professional Services),MIXED = Mixed Uses (Without Residential),MIXRES = Mixed Uses (With Residential),PDR = Industrial (Production, Distribution, Repair),RETAIL/ENT = Retail, Entertainment,RESIDENT = Residential,VISITOR = Hotels, Visitor Services,VACANT = Vacant,ROW = Right-of-Way,OPENSPACE = Open Space];RESUNITS: Number of residential units;BLDGSQFT: Square footage of building;YRBUILT: Year the structure was built;TOTAL_USES: Sum of square footage from Dun & Bradstreet business data (joined points to parcels);CIE: Square feet of Civic and Educational Institutional land use area;MED: Square feet of Medical land use area;MIPS: Square feet of office land use area;RETAIL: Square feet of Retail land use area;PDR: Square feet of Production, Distribution, and Repair land use area;VISITOR: Square feet of Hotels, Visitor Services land use area

Copyright Text: | A. CUSTODIAN | SF Planning staff Mike Wynne, mike.wynne@sfgov.org, Steph A. Nelson, SFMTA Information Technology, steph.nelson@sfmta.com | B. CREATED | unknown | C. VERSIONS | 201603, last updated 2017, imported into Spatial Data Store from DataSF

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.514712292
YMin: 37.707919217000004
XMax: -122.33493419199999
YMax: 37.833297396999995
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [200, 238, 250, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
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: true
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_1 ( type: esriFieldTypeOID, alias: OBJECTID_1, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• TO_ST ( type: esriFieldTypeString, alias: TO_ST, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TO_ST )
• PDR ( type: esriFieldTypeDouble, alias: PDR, editable: true, nullable: true, defaultValue: null, modelName: PDR )
• FROM_ST ( type: esriFieldTypeString, alias: FROM_ST, editable: true, nullable: true, length: 254, defaultValue: null, modelName: FROM_ST )
• LANDUSE ( type: esriFieldTypeString, alias: LANDUSE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LANDUSE )
• OBJECTID ( type: esriFieldTypeDouble, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID )
• RESUNITS ( type: esriFieldTypeDouble, alias: RESUNITS, editable: true, nullable: true, defaultValue: null, modelName: RESUNITS )
• MAPBLKLOT ( type: esriFieldTypeString, alias: MAPBLKLOT, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MAPBLKLOT )
• TOTAL_USES ( type: esriFieldTypeDouble, alias: TOTAL_USES, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_USES )
• VISITOR ( type: esriFieldTypeDouble, alias: VISITOR, editable: true, nullable: true, defaultValue: null, modelName: VISITOR )
• MIPS ( type: esriFieldTypeDouble, alias: MIPS, editable: true, nullable: true, defaultValue: null, modelName: MIPS )
• BLDGSQFT ( type: esriFieldTypeDouble, alias: BLDGSQFT, editable: true, nullable: true, defaultValue: null, modelName: BLDGSQFT )
• LOT_NUM ( type: esriFieldTypeString, alias: LOT_NUM, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LOT_NUM )
• CIE ( type: esriFieldTypeDouble, alias: CIE, editable: true, nullable: true, defaultValue: null, modelName: CIE )
• YRBUILT ( type: esriFieldTypeDouble, alias: YRBUILT, editable: true, nullable: true, defaultValue: null, modelName: YRBUILT )
• STREET ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STREET )
• MED ( type: esriFieldTypeDouble, alias: MED, editable: true, nullable: true, defaultValue: null, modelName: MED )
• BLOCK_NUM ( type: esriFieldTypeString, alias: BLOCK_NUM, editable: true, nullable: true, length: 254, defaultValue: null, modelName: BLOCK_NUM )
• ST_TYPE ( type: esriFieldTypeString, alias: ST_TYPE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ST_TYPE )
• SHAPE_LENG ( type: esriFieldTypeDouble, alias: SHAPE_LENG, editable: true, nullable: true, defaultValue: null, modelName: SHAPE_LENG )
• RETAIL ( type: esriFieldTypeDouble, alias: RETAIL, editable: true, nullable: true, defaultValue: null, modelName: RETAIL )
• BLKLOT ( type: esriFieldTypeString, alias: BLKLOT, editable: true, nullable: true, length: 254, defaultValue: null, modelName: BLKLOT )
• 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__Area ( type: esriFieldTypeDouble, alias: SHAPE.AREA, editable: false, nullable: true, defaultValue: null, modelName: SHAPE.AREA, required: true )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.LEN, editable: false, nullable: true, defaultValue: null, modelName: SHAPE.LEN, required: true )

Templates:

• Name: MTA.PL_landuse
  Description:
  Prototype:
  RETAIL: null
  BLKLOT: null
  TO_ST: null
  PDR: null
  FROM_ST: null
  LANDUSE: null
  OBJECTID: null
  RESUNITS: null
  MAPBLKLOT: null
  TOTAL_USES: null
  VISITOR: null
  MIPS: null
  BLDGSQFT: null
  LOT_NUM: null
  CIE: null
  YRBUILT: null
  STREET: null
  MED: null
  BLOCK_NUM: null
  ST_TYPE: null
  SHAPE_LENG: null
  
  Drawing Tool: esriFeatureEditToolPolygon

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