Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78123 | 78123 | 104843 | Permitted Site 1 | :: 54 | 1320 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989622.0 | 2106334.7 | 37.7629955389606 | -122.47907431964701 | (37.7629955389606, -122.479074319647) | ||||||
| 81298 | 81298 | 104856 | Permitted Site 1 | :: 54 | 739 27th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.746186600460604 | -122.43676722664301 | (37.7461866004606, -122.436767226643) | ||||
| 87925 | 87925 | 104864 | Permitted Site 1 | :: 54 | 45 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6000629.3 | 2102650.0 | 37.7535113392088 | -122.440739618385 | (37.7535113392088, -122.440739618385) | ||||||
| 89307 | 89307 | 105925 | Permitted Site 1 | :: 54 | 4166 20th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6002608.6 | 2104160.0 | 37.7577699584222 | -122.434002709079 | (37.7577699584222, -122.434002709079) | |||||
| 92954 | 92954 | 97034 | Property Tree 7 | :: 54 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 94853 | 94853 | 104637 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 98644 | 98644 | 106968 | Property Tree 7 | :: 54 | 351 26th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.48618540122601 | (37.7828456076198, -122.486185401226) | ||||||
| 99206 | 99206 | 115258 | Permitted Site 1 | :: 54 | 2150 Jackson St | : Cutout 24 | Landscaping 2 | Private 1 | 01/21/2016 12:00:00 AM | 6x12 | 6003858.0 | 2116995.5 | 37.7930839063862 | -122.430597643601 | (37.7930839063862, -122.430597643601) | ||||
| 105108 | 105108 | 104859 | Permitted Site 1 | :: 54 | 650 Fillmore St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6003597.7 | 2110555.4 | 37.775386259915 | -122.43103844044701 | (37.775386259915, -122.431038440447) | ||||||
| 105296 | 105296 | 107631 | Undocumented 2 | :: 54 | 4059 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003507.0 | 2100669.0 | 37.7482354401484 | -122.43064656488701 | (37.7482354401484, -122.430646564887) | ||||||
| 110212 | 110212 | 110320 | Property Tree 7 | :: 54 | 9 Imperial Aly | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | ||||||
| 111744 | 111744 | 104636 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 112494 | 112494 | 119244 | Undocumented 2 | :: 54 | 311 30th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2016 12:00:00 AM | 3 | 3x3 | 6004402.0 | 2098353.0 | 37.7419269008751 | -122.42738671849101 | (37.7419269008751, -122.427386718491) | |||
| 112497 | 112497 | 104858 | Permitted Site 1 | :: 54 | 4205 24th St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 6001816.0 | 2101720.7 | 37.7510272133613 | -122.43656924920201 | (37.7510272133613, -122.436569249202) | ||||||
| 114617 | 114617 | 105046 | Permitted Site 1 | :: 54 | 268 Capitol Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995102.1 | 2087921.7 | 37.7127547049329 | -122.458787524461 | (37.7127547049329, -122.458787524461) | ||||||
| 114741 | 114741 | 104860 | Permitted Site 1 | :: 54 | 283 Randall St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6003774.7 | 2097827.3 | 37.7404479510811 | -122.429518236565 | (37.7404479510811, -122.429518236565) | ||||||
| 114892 | 114892 | 115259 | Permitted Site 1 | :: 54 | 2130 Jackson St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/21/2016 12:00:00 AM | 6x12 | 6003918.8 | 2117004.0 | 37.7931106894063 | -122.43038787884501 | (37.7931106894063, -122.430387878845) | ||||
| 117306 | 117306 | 104857 | Permitted Site 1 | :: 54 | 2555 46th Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | ||||||
| 118218 | 118218 | 104635 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | |||||
| 119022 | 119022 | 104960 | Permitted Site 1 | :: 54 | 2895 San Bruno Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6011715.1 | 2091289.8 | 37.7229437265236 | -122.401603910944 | (37.7229437265236, -122.401603910944) | ||||||
| 122339 | 122339 | 104861 | Permitted Site 1 | :: 54 | 3458A 18th St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 6006508.0 | 2105569.9 | 37.7618617394874 | -122.42061702780899 | (37.7618617394874, -122.420617027809) | ||||||
| 125788 | 125788 | 104827 | Permitted Site 1 | :: 54 | 4366 26th St | : Cutout 24 | Tree 1 | Private 1 | 3X3 | 6001535.3 | 2100615.2 | 37.7479758185871 | -122.437460780102 | (37.7479758185871, -122.437460780102) | |||||
| 127904 | 127904 | 105121 | Undocumented 2 | :: 54 | 721 BEACH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6006739.7 | 2121813.5 | 37.8064757462399 | -122.42096901139601 | (37.8064757462399, -122.420969011396) | |||||
| 141674 | 141674 | 104634 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | |||||
| 141787 | 141787 | 103673 | Property Tree 7 | :: 54 | 64 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003097.0 | 2107420.0 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | ||||||
| 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 | ||||||||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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 | ||||||||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 26576 | 26576 | 184709 | Undocumented 2 | :: 54 | 1618 40th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983775.4227 | 2104111.6852 | 37.7565504997112 | -122.499131044219 | (37.7565504997112, -122.499131044219) | |||
| 26632 | 26632 | 182608 | Undocumented 2 | :: 54 | 1839 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985333.4224 | 2102688.337 | 37.7527336497539 | -122.493638125681 | (37.7527336497539, -122.493638125681) | |||
| 26723 | 26723 | 183174 | Undocumented 2 | :: 54 | 2400 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984903.1916 | 2098438.8046 | 37.7410404135541 | -122.494812631239 | (37.7410404135541, -122.494812631239) | |||
| 26774 | 26774 | 183705 | Undocumented 2 | :: 54 | 3628 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983226.2116 | 2105643.5823 | 37.760724424253205 | -122.50114368176399 | (37.7607244242532, -122.501143681764) | |||
| 26822 | 26822 | 183837 | Undocumented 2 | :: 54 | 2206 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985462.2045 | 2100160.7045 | 37.745800992601 | -122.4930066047 | (37.745800992601, -122.4930066047) | |||
| 26862 | 26862 | 245988 | Undocumented 2 | :: 54 | 1250 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999884.6674 | 2108495.9392 | 37.76952040656629 | -122.44373466044901 | (37.7695204065663, -122.443734660449) | |||
| 26866 | 26866 | 182267 | Undocumented 2 | :: 54 | 1474 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986846.9486 | 2105227.058 | 37.7597927113016 | -122.48859072822201 | (37.7597927113016, -122.488590728222) | |||
| 26920 | 26920 | 182657 | Undocumented 2 | :: 54 | 2630 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985816.7659 | 2102326.4814 | 37.75176835729211 | -122.491940021962 | (37.7517683572921, -122.491940021962) | |||
| 27047 | 27047 | 181865 | Undocumented 2 | :: 54 | 2331 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986993.7887 | 2099395.3559 | 37.743789001507004 | -122.487654458992 | (37.743789001507, -122.487654458992) | |||
| 27065 | 27065 | 183718 | Undocumented 2 | :: 54 | 2254 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987333.4527 | 2099922.5844 | 37.745256435851495 | -122.486518698932 | (37.7452564358515, -122.486518698932) | |||
| 27133 | 27133 | 183989 | Undocumented 2 | :: 54 | 1678 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985337.681 | 2103783.3365 | 37.755740466247296 | -122.493704080582 | (37.7557404662473, -122.493704080582) | |||
| 27251 | 27251 | 184688 | Undocumented 2 | :: 54 | 1611 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984657.9281 | 2104207.7196 | 37.7568659135367 | -122.496086155975 | (37.7568659135367, -122.496086155975) |
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");