View In:   ArcGIS Online Map Viewer

Name: CarShare_Off_ST

Display Field: Join_Count

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Original source description: This feature class shows the location and number of vehicles stored in off street lots and garages as of September 2014. Three car share organizations are included: City Carshare, Zipcar, and Getaround. </SPAN></P><P><SPAN>| A. PURPOSE | To support the On Street Car Share Pilot Program (operated roughly from 2013 - 2016), an inventory of off street car share locations was made to understand the geographic distribution of locations and quantity across the city. Car share locations are important when planning for other sustainable modes (i.e. location of bike share or bike parking facilities). </SPAN></P><P><SPAN>| B. METHODOLOGY | In an Excel spreadhseet, each car share organization (CSO)--Getaround, City Carshare, Zipcar--provided the number of vehicles by location (address) in off street facilities across the city. These three spreadsheets were combined with a CSO identifier. This spreadhseet was added to ArcMap. The addresses were geocoded, although approximately 20 out of 700+ were not recognized (unmatched) by the geocode. By looking at the CSO websites and Google streetview, these approx. 20 locations were added to the data set using editor, and create features. Once all locations were accounted for and placed on the map as point features, the data set was exported as a dbf to Excel, where a pivot table was made to total the number of vehicles at each address, by CSO. This table was then added back to ArcMap, then spatially joined to the original address shapefile. In completing this join, duplicate fields occurred (if a single address had vehicles from all three CSOs, three fields existed for the address). The Delete Identical tool was used. </SPAN></P><P><SPAN>| C. UPDATE FREQUENCY | Updated as necessary. Can be updated monthly, weekly, or daily depending on deployment of new spaces. </SPAN></P><P><SPAN>| D. OTHER CRITICAL INFO | Accurate as of Fall 2014. </SPAN></P><P><SPAN>| E. ATTRIBUTES |</SPAN><SPAN /></P><P><SPAN STYLE="font-weight:bold;">City: </SPAN><SPAN>City in which the off street car is located;</SPAN></P><P><SPAN STYLE="font-weight:bold;">Zip:</SPAN><SPAN>Zipcode in which the off streer car is located; </SPAN><SPAN /></P><P><SPAN STYLE="font-weight:bold;">Address: </SPAN><SPAN>Address of the off street car;</SPAN></P><P><SPAN STYLE="font-weight:bold;">CityCarSha: </SPAN><SPAN>the number of City Carshare vehicles located at this address;</SPAN><SPAN /></P><P><SPAN STYLE="font-weight:bold;">Getaround:</SPAN><SPAN>Number of Getaround vehicles located at this address;</SPAN></P><P><SPAN STYLE="font-weight:bold;">Zipcar: </SPAN><SPAN>Number of Zipcar vehicles located at this address;</SPAN></P><P><SPAN STYLE="font-weight:bold;">Total:</SPAN><SPAN>Sum of all car share vehicles at this address</SPAN></P></DIV></DIV></DIV>

Service Item Id: 15db9dc352624912a5ceb222f2cc4876

Copyright Text: Contact SF Planning: maggie.wenger@sfgov.org Contact Silvestrum Climate Associates: abby.mohan@silvestrum.com A. CUSTODIAN | Mark Dreger, mark.dreger@sfmta.com, Parking Group, Sustainable Streets Division, SFMTA | B. CREATED | 20150820, Jimmy Shoemaker, Parking Group (fomer) | C. VERSIONS | 20150820

Default Visibility: true

MaxRecordCount: 2000

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: 5981217.0442249775
YMin: 2086944.921571225
XMax: 6020607.549761385
YMax: 2122031.5439831465
Spatial Reference: 102643  (2227)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [39, 163, 132, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 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: 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: true
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 )
• Join_Count ( type: esriFieldTypeInteger, alias: Join_Count, editable: true, nullable: true, defaultValue: null, modelName: Join_Count )
• TARGET_FID ( type: esriFieldTypeInteger, alias: TARGET_FID, editable: true, nullable: true, defaultValue: null, modelName: TARGET_FID )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CITY )
• ZIP ( type: esriFieldTypeDouble, alias: ZIP, editable: true, nullable: true, defaultValue: null, modelName: ZIP )
• ADDRESS_1 ( type: esriFieldTypeString, alias: ADDRESS_1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ADDRESS_1 )
• CITYCARSHA ( type: esriFieldTypeDouble, alias: CITYCARSHA, editable: true, nullable: true, defaultValue: null, modelName: CITYCARSHA )
• GETAROUND ( type: esriFieldTypeDouble, alias: GETAROUND, editable: true, nullable: true, defaultValue: null, modelName: GETAROUND )
• ZIPCAR ( type: esriFieldTypeDouble, alias: ZIPCAR, editable: true, nullable: true, defaultValue: null, modelName: ZIPCAR )
• TOTAL ( type: esriFieldTypeDouble, alias: TOTAL, editable: true, nullable: true, defaultValue: null, modelName: TOTAL )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• SENS_TEMP ( type: esriFieldTypeSmallInteger, alias: SENS_TEMP, editable: true, nullable: true, defaultValue: null, modelName: SENS_TEMP )
• ADAP_TEMP ( type: esriFieldTypeSmallInteger, alias: ADAP_TEMP, editable: true, nullable: true, defaultValue: null, modelName: ADAP_TEMP )
• VULN_TEMP ( type: esriFieldTypeSmallInteger, alias: VULN_TEMP, editable: true, nullable: true, defaultValue: null, modelName: VULN_TEMP )
• SENS_PERM ( type: esriFieldTypeSmallInteger, alias: SENS_PERM, editable: true, nullable: true, defaultValue: null, modelName: SENS_PERM )
• ADAP_PERM ( type: esriFieldTypeSmallInteger, alias: ADAP_PERM, editable: true, nullable: true, defaultValue: null, modelName: ADAP_PERM )
• VULN_PERM ( type: esriFieldTypeSmallInteger, alias: VULN_PERM, editable: true, nullable: true, defaultValue: null, modelName: VULN_PERM )
• SLR_1_12 ( type: esriFieldTypeSmallInteger, alias: SLR_1_12, editable: true, nullable: true, defaultValue: null, modelName: SLR_1_12 )
• SLR_2_24 ( type: esriFieldTypeSmallInteger, alias: SLR_2_24, editable: true, nullable: true, defaultValue: null, modelName: SLR_2_24 )
• SLR_3_36 ( type: esriFieldTypeSmallInteger, alias: SLR_3_36, editable: true, nullable: true, defaultValue: null, modelName: SLR_3_36 )
• SLR_4_48 ( type: esriFieldTypeSmallInteger, alias: SLR_4_48, editable: true, nullable: true, defaultValue: null, modelName: SLR_4_48 )
• SLR_5_52 ( type: esriFieldTypeSmallInteger, alias: SLR_5_52, editable: true, nullable: true, defaultValue: null, modelName: SLR_5_52 )
• SLR_6_66 ( type: esriFieldTypeSmallInteger, alias: SLR_6_66, editable: true, nullable: true, defaultValue: null, modelName: SLR_6_66 )
• SLR_7_77 ( type: esriFieldTypeSmallInteger, alias: SLR_7_77, editable: true, nullable: true, defaultValue: null, modelName: SLR_7_77 )
• SLR_8_84 ( type: esriFieldTypeSmallInteger, alias: SLR_8_84, editable: true, nullable: true, defaultValue: null, modelName: SLR_8_84 )
• SLR_9_96 ( type: esriFieldTypeSmallInteger, alias: SLR_9_96, editable: true, nullable: true, defaultValue: null, modelName: SLR_9_96 )
• SLR_10_108 ( type: esriFieldTypeSmallInteger, alias: SLR_10_108, editable: true, nullable: true, defaultValue: null, modelName: SLR_10_108 )
• NEIGHBORHOOD ( type: esriFieldTypeString, alias: NEIGHBORHOOD, editable: true, nullable: true, length: 25, defaultValue: null, modelName: NEIGHBORHOOD )

Templates:

• Name: CarShare_Off_ST
  Description:
  Prototype:
  SLR_10_108: null
  Join_Count: null
  TARGET_FID: null
  CITY: null
  ZIP: null
  ADDRESS_1: null
  CITYCARSHA: null
  GETAROUND: null
  ZIPCAR: null
  TOTAL: null
  CREATED_USER: null
  CREATED_DATE: null
  LAST_EDITED_USER: null
  LAST_EDITED_DATE: null
  SENS_TEMP: null
  ADAP_TEMP: null
  VULN_TEMP: null
  SENS_PERM: null
  ADAP_PERM: null
  VULN_PERM: null
  SLR_1_12: null
  SLR_2_24: null
  SLR_3_36: null
  SLR_4_48: null
  SLR_5_52: null
  SLR_6_66: null
  SLR_7_77: null
  SLR_8_84: null
  SLR_9_96: null
  NEIGHBORHOOD: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata