Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
PlantType ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161 | 161 | 142720 | Undocumented 2 | :: 54 | 1170 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6007999.4825 | 2121188.7351 | 37.8048312311886 | -122.416565007078 | (37.8048312311886, -122.416565007078) | ||||
| 443 | 443 | 251293 | Undocumented 2 | :: 54 | 3789 Market St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6000208.0 | 2102740.0 | 37.753734455764 | -122.44220302061701 | (37.753734455764, -122.442203020617) | ||||
| 514 | 514 | 251312 | Undocumented 2 | :: 54 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 518 | 518 | 251314 | Planning Code 138.1 required 4 | :: 54 | 1108 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001901.0 | 2100825.0 | 37.7485726639367 | -122.43621121860001 | (37.7485726639367, -122.4362112186) | ||||
| 533 | 533 | 251313 | Planning Code 138.1 required 4 | :: 54 | 390 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 667 | 667 | 251356 | Undocumented 2 | :: 54 | 519 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989039.0 | 2111772.0 | 37.777890994652296 | -122.481488924787 | (37.7778909946523, -122.481488924787) | ||||
| 870 | 870 | 117001 | DPW Maintained 3 | :: 54 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 1389 | 1389 | 251532 | Permitted Site 1 | :: 54 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 1391 | 1391 | 251531 | Permitted Site 1 | :: 54 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 1410 | 1410 | 139164 | Undocumented 2 | :: 54 | 1975 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002726.0596 | 2114048.1262 | 37.784926980365206 | -122.43430340574699 | (37.7849269803652, -122.434303405747) | ||||
| 1800 | 1800 | 251700 | Permitted Site 1 | :: 54 | 1560 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/05/2017 12:00:00 AM | 3 | 410x11 | Permit Number 780193 | 6003924.0 | 2099150.0 | 37.7440882334859 | -122.429096301435 | (37.7440882334859, -122.429096301435) | |
| 1824 | 1824 | 251724 | Permitted Site 1 | :: 54 | 1630 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | 3x3 | 6006933.88533 | 2116748.92044 | 37.792580631742204 | -122.419937373279 | (37.7925806317422, -122.419937373279) | ||
| 1988 | 1988 | 252845 | DPW Maintained 3 | :: 54 | 544 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2014 12:00:00 AM | 3x3 | 5993963.0 | 2110797.0 | 37.7754989773977 | -122.46438440768401 | (37.7754989773977, -122.464384407684) | |||
| 2270 | 2270 | 253008 | Permitted Site 1 | :: 54 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | ||
| 2526 | 2526 | 141913 | Undocumented 2 | :: 54 | 900 MCALLISTER ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004416.1749 | 2111910.2001 | 37.779152551854104 | -122.42830372330299 | (37.7791525518541, -122.428303723303) | |||
| 2865 | 2865 | 253261 | Permitted Site 1 | :: 54 | 339 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990256.0 | 2113097.0 | 37.78159976365421 | -122.477375802178 | (37.7815997636542, -122.477375802178) | ||||
| 2881 | 2881 | 253260 | Permitted Site 1 | :: 54 | 734 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993234.0 | 2110465.0 | 37.7745453462497 | -122.46688203122801 | (37.7745453462497, -122.466882031228) | ||||
| 2900 | 2900 | 70091 | Permitted Site 1 | :: 54 | 752 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 6 | 3x3 | 5988512.5089 | 2110855.81451 | 37.7753447787774 | -122.483243045223 | (37.7753447787774, -122.483243045223) | |
| 3255 | 3255 | 253377 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
| 3275 | 3275 | 253378 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
| 3276 | 3276 | 149033 | Permitted Site 1 | :: 54 | 3916 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2017 12:00:00 AM | 3 | 5.5x12 | 5996085.364440001 | 2114918.02173 | 37.7869363183091 | -122.45734088598302 | (37.7869363183091, -122.457340885983) | ||
| 3345 | 3345 | 253419 | Planning Code 138.1 required 4 | :: 54 | 3499 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997570.0 | 2115996.0 | 37.78998131889129 | -122.452282225129 | (37.7899813188913, -122.452282225129) | ||||
| 3620 | 3620 | 139511 | Undocumented 2 | :: 54 | 1400 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001017.0 | 2111110.0 | 37.776762480662704 | -122.440005440059 | (37.7767624806627, -122.440005440059) | |||
| 3639 | 3639 | 253517 | Permitted Site 1 | :: 54 | 559 24th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x4.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3643 | 3643 | 253515 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 7x9.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3650 | 3650 | 253518 | Permitted Site 1 | :: 54 | 559 24th Ave | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x1 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3660 | 3660 | 253516 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x2 | 5988392.0 | 2112177.0 | 37.778965370493495 | -122.483756799769 | (37.7789653704935, -122.483756799769) | ||
| 4723 | 4723 | 253676 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x3.75 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 4726 | 4726 | 253675 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x14.2 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 5050 | 5050 | 253762 | Planning Code 138.1 required 4 | :: 54 | 520 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993490.0 | 2111935.0 | 37.778596343165496 | -122.46610332918101 | (37.7785963431655, -122.466103329181) | ||||
| 5211 | 5211 | 253829 | Permitted Site 1 | :: 54 | 869 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006713.1749 | 2113568.2957099997 | 37.7838349840749 | -122.420475171434 | (37.7838349840749, -122.420475171434) | |||
| 5216 | 5216 | 253831 | Permitted Site 1 | :: 54 | 651X Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5222 | 5222 | 253825 | Permitted Site 1 | :: 54 | 725 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007393.727109999 | 2113660.9435900003 | 37.784127700976896 | -122.418127279043 | (37.7841277009769, -122.418127279043) | |||
| 5224 | 5224 | 253827 | Permitted Site 1 | :: 54 | 825 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
| 5226 | 5226 | 253832 | Permitted Site 1 | :: 54 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007254.7956 | 2113297.42725 | 37.783121752773 | -122.41858214693501 | (37.783121752773, -122.418582146935) | |||
| 5228 | 5228 | 253828 | Permitted Site 1 | :: 54 | 825 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
| 5229 | 5229 | 253834 | Permitted Site 1 | :: 54 | 747 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006860.78535 | 2113242.76542 | 37.7829494746502 | -122.419941385136 | (37.7829494746502, -122.419941385136) | |||
| 5230 | 5230 | 253826 | Permitted Site 1 | :: 54 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5236 | 5236 | 253833 | Permitted Site 1 | :: 54 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5239 | 5239 | 253830 | Permitted Site 1 | :: 54 | 651X Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 6373 | 6373 | 138089 | Undocumented 2 | :: 54 | 1600 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004809.7961 | 2114741.3813 | 37.7869485378128 | -122.427143741054 | (37.7869485378128, -122.427143741054) | ||||
| 7654 | 7654 | 139157 | Undocumented 2 | :: 54 | 1699 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6003069.5459 | 2114034.3612 | 37.7849086753549 | -122.433114070807 | (37.7849086753549, -122.433114070807) | ||||
| 9914 | 9914 | 173708 | DPW Maintained 3 | :: 54 | 126 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001214.0 | 2098705.0 | 37.7427125900371 | -122.438434982469 | (37.7427125900371, -122.438434982469) | ||||
| 10092 | 10092 | 173852 | Permitted Site 1 | :: 54 | 450 Toland St | 7 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 8.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10093 | 10093 | 173849 | Permitted Site 1 | :: 54 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 17.6x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10096 | 10096 | 173850 | Permitted Site 1 | :: 54 | 450 Toland St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 13.9x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10097 | 10097 | 173851 | Permitted Site 1 | :: 54 | 450 Toland St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 27.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10098 | 10098 | 173848 | Permitted Site 1 | :: 54 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 19.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10101 | 10101 | 173846 | Permitted Site 1 | :: 54 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 15x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10104 | 10104 | 173847 | Permitted Site 1 | :: 54 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 11.85x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10106 | 10106 | 173853 | Permitted Site 1 | :: 54 | 450 Toland St | 8 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 26.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10128 | 10128 | 173868 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
| 10139 | 10139 | 173867 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
| 18412 | 18412 | 247322 | Undocumented 2 | :: 54 | 218 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002795.6845 | 2109344.9924 | 37.7720173021936 | -122.433726268045 | (37.7720173021936, -122.433726268045) | ||||
| 18795 | 18795 | 31192 | Permitted Site 1 | :: 54 | 744 Shields St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 19176 | 19176 | 36500 | Permitted Site 1 | :: 54 | 78 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39380 | 6007942.28499887 | 2098248.55652594 | 37.741839715130894 | -122.41513812883001 | (37.7418397151309, -122.41513812883) | ||
| 19242 | 19242 | 36516 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
| 20483 | 20483 | 109769 | Permitted Site 1 | :: 54 | 2502X Bush St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x12.75 | 6001313.62368 | 2114572.17699 | 37.786285618589204 | -122.43922754338101 | (37.7862856185892, -122.439227543381) | ||||
| 20493 | 20493 | 31189 | Permitted Site 1 | :: 54 | 744 Shields St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 22368 | 22368 | 183808 | Undocumented 2 | :: 54 | 1823 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987517.377 | 2100286.1656 | 37.7462654526109 | -122.48590940972 | (37.7462654526109, -122.48590940972) | |||
| 22811 | 22811 | 185829 | Undocumented 2 | :: 54 | 2061 34th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985695.3610000005 | 2101217.9835 | 37.7487176270346 | -122.49227823369301 | (37.7487176270346, -122.492278233693) | |||
| 22852 | 22852 | 138173 | Undocumented 2 | :: 54 | 1953 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 6000211.2401 | 2111613.6154 | 37.7780993776744 | -122.44282896766 | (37.7780993776744, -122.44282896766) | |||
| 23417 | 23417 | 183167 | Undocumented 2 | :: 54 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.741329561902596 | -122.50344114283101 | (37.7413295619026, -122.503441142831) | |||
| 23724 | 23724 | 181665 | Undocumented 2 | :: 54 | 1275 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985511.3315 | 2106531.7973 | 37.7632971348656 | -122.49330603001499 | (37.7632971348656, -122.493306030015) | |||
| 23777 | 23777 | 183752 | Undocumented 2 | :: 54 | 2287 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987917.4443 | 2099749.9687 | 37.7448165037016 | -122.484486720736 | (37.7448165037016, -122.484486720736) | |||
| 23835 | 23835 | 182329 | Undocumented 2 | :: 54 | 1501 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985565.7361 | 2104954.3084 | 37.75896897093661 | -122.493001657059 | (37.7589689709366, -122.493001657059) | |||
| 23845 | 23845 | 142111 | Undocumented 2 | :: 54 | 36 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998636.7696 | 2110968.1942 | 37.7762373313333 | -122.448229118378 | (37.7762373313333, -122.448229118378) | |||
| 23926 | 23926 | 181820 | Undocumented 2 | :: 54 | 2299 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985846.0311 | 2099546.7997 | 37.7441378151504 | -122.491634223287 | (37.7441378151504, -122.491634223287) | |||
| 24053 | 24053 | 181971 | Undocumented 2 | :: 54 | 2467 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985787.1457 | 2098434.4072 | 37.7410800425161 | -122.49175595946801 | (37.7410800425161, -122.491755959468) | |||
| 24081 | 24081 | 183742 | Undocumented 2 | :: 54 | 2278 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988578.8889999995 | 2099828.4885 | 37.745070593746796 | -122.482205348546 | (37.7450705937468, -122.482205348546) | |||
| 24104 | 24104 | 248307 | Undocumented 2 | :: 54 | 1323 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999369.7066 | 2108379.5015 | 37.7691713129844 | -122.44550750940901 | (37.7691713129844, -122.445507509409) | |||
| 24148 | 24148 | 182529 | Undocumented 2 | :: 54 | 1583 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986203.973999999 | 2104470.5925 | 37.7576781250927 | -122.490758769583 | (37.7576781250927, -122.490758769583) | |||
| 24206 | 24206 | 181982 | Undocumented 2 | :: 54 | 2479 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986720.0054 | 2098392.2737 | 37.7410188327151 | -122.488527415956 | (37.7410188327151, -122.488527415956) | |||
| 24275 | 24275 | 184454 | Undocumented 2 | :: 54 | 2153 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981374.6331 | 2100381.1786 | 37.7461664541179 | -122.507156946857 | (37.7461664541179, -122.507156946857) | |||
| 24313 | 24313 | 184893 | Undocumented 2 | :: 54 | 1786 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981952.8719 | 2102926.7078 | 37.753189803786896 | -122.505346142178 | (37.7531898037869, -122.505346142178) | |||
| 24402 | 24402 | 182453 | Undocumented 2 | :: 54 | 1500 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986555.3586 | 2104541.3333 | 37.7578928802813 | -122.489548755928 | (37.7578928802813, -122.489548755928) | |||
| 24496 | 24496 | 184100 | Undocumented 2 | :: 54 | 1614 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985016.0366 | 2104172.5195 | 37.756790232687 | -122.494845106619 | (37.756790232687, -122.494845106619) | |||
| 24523 | 24523 | 141857 | Undocumented 2 | :: 54 | 1100 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004651.3626 | 2112630.8889 | 37.781144690344895 | -122.42754147050199 | (37.7811446903449, -122.427541470502) | |||
| 24606 | 24606 | 181614 | Undocumented 2 | :: 54 | 1246 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984927.2833 | 2106710.1633 | 37.7637526989564 | -122.49533918573601 | (37.7637526989564, -122.495339185736) | |||
| 24662 | 24662 | 124715 | Undocumented 2 | :: 54 | 599X 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002687.0 | 2100013.0 | 37.7463877287793 | -122.433435226166 | (37.7463877287793, -122.433435226166) | ||||
| 24683 | 24683 | 183508 | Undocumented 2 | :: 54 | 2547 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988598.1694 | 2097978.5588 | 37.7399922937625 | -122.482003188533 | (37.7399922937625, -122.482003188533) | |||
| 24723 | 24723 | 181788 | Undocumented 2 | :: 54 | 3131 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986265.505 | 2098198.358 | 37.740459860841 | -122.49008463083 | (37.740459860841, -122.49008463083) | |||
| 24732 | 24732 | 141579 | Undocumented 2 | :: 54 | 500 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000650.2876 | 2110740.0178 | 37.7757257205697 | -122.44124745176501 | (37.7757257205697, -122.441247451765) | |||
| 24890 | 24890 | 183769 | Undocumented 2 | :: 54 | 2295 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987606.9921 | 2099681.9039 | 37.7446115325485 | -122.48555519813499 | (37.7446115325485, -122.485555198135) | |||
| 25062 | 25062 | 247418 | Undocumented 2 | :: 54 | 1001 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002608.194 | 2110213.5869 | 37.7743916070028 | -122.43443692499599 | (37.7743916070028, -122.434436924996) | |||
| 25160 | 25160 | 244247 | Undocumented 2 | :: 54 | 200 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005673.0642 | 2110022.6890000002 | 37.7740409443959 | -122.423821374378 | (37.7740409443959, -122.423821374378) | |||
| 25293 | 25293 | 182679 | Undocumented 2 | :: 54 | 2631 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986083.8267 | 2103639.2241 | 37.7553883964845 | -122.49111310108299 | (37.7553883964845, -122.491113101083) | |||
| 25460 | 25460 | 181596 | Undocumented 2 | :: 54 | 1683 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984674.4393 | 2103735.9717 | 37.7555715918184 | -122.495994253801 | (37.7555715918184, -122.495994253801) | |||
| 25506 | 25506 | 137920 | Undocumented 2 | :: 54 | 2028 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002940.7431 | 2115305.2702 | 37.788390961736795 | -122.433650548643 | (37.7883909617368, -122.433650548643) | |||
| 25583 | 25583 | 139608 | Undocumented 2 | :: 54 | 1724 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001827.9162 | 2112238.3787 | 37.7799068540457 | -122.437281058847 | (37.7799068540457, -122.437281058847) | |||
| 25649 | 25649 | 182532 | Undocumented 2 | :: 54 | 1581 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985581.6988 | 2104465.1884 | 37.7576269162189 | -122.492910423341 | (37.7576269162189, -122.492910423341) | |||
| 25748 | 25748 | 182187 | Undocumented 2 | :: 54 | 1622 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989666.9072 | 2104289.3052 | 37.757382042273996 | -122.47876940221 | (37.757382042274, -122.47876940221) | |||
| 25969 | 25969 | 183335 | Undocumented 2 | :: 54 | 1211 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982706.9565 | 2106839.0545 | 37.7639763455704 | -122.503028028557 | (37.7639763455704, -122.503028028557) | |||
| 25978 | 25978 | 182524 | Undocumented 2 | :: 54 | 1579 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985892.4217 | 2104503.3998 | 37.757750000215005 | -122.491838645138 | (37.757750000215, -122.491838645138) | |||
| 26076 | 26076 | 181698 | Undocumented 2 | :: 54 | 1809 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5990006.9617 | 2107176.8497 | 37.7653302032624 | -122.47780444851401 | (37.7653302032624, -122.477804448514) | |||
| 26178 | 26178 | 186047 | Undocumented 2 | :: 54 | 1900 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984778.2299 | 2102058.2647 | 37.7509711496958 | -122.495511585412 | (37.7509711496958, -122.495511585412) | |||
| 26182 | 26182 | 142482 | Undocumented 2 | :: 54 | 1501 GRANT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010536.0572 | 2119686.9897 | 37.800850136387204 | -122.407680928456 | (37.8008501363872, -122.407680928456) | |||
| 26491 | 26491 | 184713 | Undocumented 2 | :: 54 | 1626 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984397.6244 | 2104083.8858 | 37.756510650266705 | -122.496977229466 | (37.7565106502667, -122.496977229466) | |||
| 26507 | 26507 | 184509 | Undocumented 2 | :: 54 | 1886 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981125.5546 | 2102268.3878 | 37.751333525850896 | -122.50815826243401 | (37.7513335258509, -122.508158262434) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");