trees
11,761 rows where qSpecies_id = 17 sorted by PermitNotes
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
| 31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
| 99 | 255073 | Private 9 | Tree(s) :: 17 | 173R Glenview Dr | Back Yard : Yard | Tree | Private 2 | ||||||||||||||||
| 111 | 97355 | Permitted Site 7 | Tree(s) :: 17 | 5 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
| 115 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000333 | 2099683 | 37.7453477932295 | -122.441551386161 | (37.7453477932295, -122.441551386161) | 2 | 7 | 5 | 63 | 22 | ||||
| 129 | 107934 | DPW Maintained 1 | Tree(s) :: 17 | 3098X Market St | 3 | Median : Yard | Tree | DPW 1 | 5999920 | 2105144 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | 2 | 4 | 5 | 28862 | 3 | |||||
| 135 | 99586 | Permitted Site 7 | Tree(s) :: 17 | 2299 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002978.6 | 2106459.9 | 37.7641059209125 | -122.432887400675 | (37.7641059209125, -122.432887400675) | 15 | 4 | 5 | 28862 | 3 | |||||
| 139 | 106382 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 9 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
| 140 | 97920 | Undocumented 4 | Tree(s) :: 17 | 399X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6000685 | 2110085 | 37.7739291843989 | -122.441080369401 | (37.7739291843989, -122.441080369401) | 15 | 5 | 11 | 29492 | 16 | |||
| 148 | 108238 | Undocumented 4 | Tree(s) :: 17 | 764x JUNIPERO SERRA BLVD | 1 | Median : Yard | Tree | Private 2 | 5991289.6 | 2092496.8 | 37.7250969308873 | -122.472297921456 | (37.7250969308873, -122.472297921456) | 9 | 8 | 4 | 64 | 40 | |||||
| 158 | 100607 | Permitted Site 7 | Tree(s) :: 17 | 270x 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | |||||
| 162 | 105806 | Undocumented 4 | Tree(s) :: 17 | 1248X ANZA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x3 | 5994834 | 2112130 | 37.7792092085373 | -122.461468091676 | (37.7792092085373, -122.461468091676) | 11 | 6 | 2 | 54 | 11 | |||||
| 164 | 116129 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 167 | 99668 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 169 | 258020 | DPW Maintained 1 | Tree(s) :: 17 | 1001X San Jose Ave | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 180 | 110904 | Significant Tree 6 | Tree(s) :: 17 | 203 CORBETT AVE | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6000094 | 2105620 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | 15 | 5 | 5 | 28862 | 3 | |||
| 193 | 100595 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
| 194 | 112359 | Undocumented 4 | Tree(s) :: 17 | 1129 DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001379 | 2100423 | 37.7474391957634 | -122.437987492815 | (37.7474391957634, -122.437987492815) | 2 | 4 | 5 | 63 | 22 | ||||
| 198 | 102463 | Undocumented 4 | Tree(s) :: 17 | 3119 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6007346.2 | 2103903.1 | 37.7573322957921 | -122.417599878082 | (37.7573322957921, -122.417599878082) | 2 | 4 | 7 | 28859 | 19 | |||
| 203 | 56596 | Permitted Site 7 | Tree(s) :: 17 | 536 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003173.97949504 | 2096124.55404861 | 37.7357385703685 | -122.431473765394 | (37.7357385703685, -122.431473765394) | 2 | 7 | 5 | 63 | 7 | |||||
| 207 | 251656 | DPW Maintained 1 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard | Tree | Private 2 | 3x3 | 5999423 | 2096089 | 37.7354276387403 | -122.44443976141 | (37.7354276387403, -122.44443976141) | 9 | 7 | 4 | 63 | 40 | ||||
| 226 | 56655 | Permitted Site 7 | Tree(s) :: 17 | 491 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993749.22353597 | 2090472.28724098 | 37.7196801529508 | -122.463648462413 | (37.7196801529508, -122.463648462413) | 9 | 8 | 6 | 64 | 24 | |||||
| 227 | 102275 | Property Tree 8 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001225.6 | 2097744.2 | 37.7400751189117 | -122.438326054857 | (37.7400751189117, -122.438326054857) | 2 | 7 | 5 | 63 | 7 | ||||||
| 233 | 100684 | Undocumented 4 | Tree(s) :: 17 | 400 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6012367 | 2116823 | 37.7930886299645 | -122.401143699021 | (37.7930886299645, -122.401143699021) | 4 | 1 | 10 | 28854 | 6 | |||||
| 260 | 56449 | Permitted Site 7 | Tree(s) :: 17 | 1439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5982754.68200032 | 2105326.56088651 | 37.7598262733968 | -122.502750996927 | (37.7598262733968, -122.502750996927) | 1 | 8 | 3 | 56 | 35 | |||||
| 271 | 107116 | DPW Maintained 1 | Tree(s) :: 17 | 300X LIBERTY ST | 18 | Median : Cutout | Tree | DPW 1 | 12 | 6004270.1 | 2103982.4 | 37.7573764628527 | -122.428243896062 | (37.7573764628527, -122.428243896062) | 2 | 4 | 5 | 28862 | 3 | ||||
| 273 | 117070 | Private 9 | Tree(s) :: 17 | 6 JOY ST | 3 | Front Yard : Yard | Tree | Private 2 | 6010444 | 2098901 | 37.7437714571602 | -122.406533939617 | (37.7437714571602, -122.406533939617) | 2 | 7 | 7 | 28859 | 2 | |||||
| 293 | 102283 | Undocumented 4 | Tree(s) :: 17 | 4428 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6000463 | 2102288 | 37.7525079029002 | -122.441288746114 | (37.7525079029002, -122.441288746114) | 2 | 4 | 5 | 28862 | 22 | |||
| 297 | 113036 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
| 305 | 56460 | Permitted Site 7 | Tree(s) :: 17 | 2430 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006920.19744074 | 2104198.59660265 | 37.7581196808576 | -122.419094125211 | (37.7581196808576, -122.419094125211) | 2 | 4 | 7 | 28859 | 19 | |||||
| 307 | 99748 | Undocumented 4 | Tree(s) :: 17 | 4224 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002441 | 2100645 | 37.7481090922721 | -122.434331041256 | (37.7481090922721, -122.434331041256) | 2 | 4 | 5 | 28862 | 22 | ||||
| 323 | 106136 | Undocumented 4 | Tree(s) :: 17 | 200X RIDGEWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996801 | 2094865 | 37.7319168756422 | -122.453416604011 | (37.7319168756422, -122.453416604011) | 9 | 7 | 4 | 59 | 40 | ||||
| 329 | 101063 | Undocumented 4 | Tree(s) :: 17 | 710 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001857 | 2102025 | 37.7518650783703 | -122.436449244442 | (37.7518650783703, -122.436449244442) | 2 | 4 | 5 | 28862 | 22 | ||||
| 359 | 113255 | Undocumented 4 | Tree(s) :: 17 | 178 Edgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5996632.6 | 2106029.8 | 37.7625629978497 | -122.454805165139 | (37.7625629978497, -122.454805165139) | 15 | 5 | 11 | 29492 | 12 | |||||
| 361 | 107141 | Undocumented 4 | Tree(s) :: 17 | 3498 16TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003565.7 | 2106565.7 | 37.764429704069 | -122.430864344516 | (37.764429704069, -122.430864344516) | 15 | 4 | 5 | 28862 | 3 | ||||||
| 364 | 255980 | Property Tree 8 | Tree(s) :: 17 | 541 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000551 | 2110847 | 37.7760138103106 | -122.441598590487 | (37.7760138103106, -122.441598590487) | 15 | 5 | 11 | 29492 | 16 | ||||
| 383 | 94356 | DPW Maintained 1 | Tree(s) :: 17 | 455 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5999581.42646 | 2091332.3229 | 37.7223759483442 | -122.443550437353 | (37.7223759483442, -122.443550437353) | 9 | 7 | 6 | 28861 | 25 | ||||
| 387 | 106394 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 21 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
| 407 | 56529 | Permitted Site 7 | Tree(s) :: 17 | 4721 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998571.81433707 | 2105652.41045975 | 37.7616378261686 | -122.448070980729 | (37.7616378261686, -122.448070980729) | 15 | 5 | 11 | 29492 | 12 | |||||
| 419 | 78519 | Significant Tree 6 | Tree(s) :: 17 | 12 Sumner St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 3x3 | 6009421 | 2110873 | 37.7765865656959 | -122.410916638665 | (37.7765865656959, -122.410916638665) | 8 | 2 | 9 | 28853 | 34 | |||
| 434 | 102445 | Undocumented 4 | Tree(s) :: 17 | 900 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001563.3 | 2088855.6 | 37.7156882523244 | -122.436522388875 | (37.7156882523244, -122.436522388875) | 9 | 7 | 6 | 28861 | 5 | |||
| 461 | 56448 | Permitted Site 7 | Tree(s) :: 17 | 1410 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5982800.36611702 | 2105511.04189371 | 37.7603354906122 | -122.502606655486 | (37.7603354906122, -122.502606655486) | 1 | 8 | 3 | 56 | 35 | |||||
| 465 | 105354 | Undocumented 4 | Tree(s) :: 17 | 3294 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007856.1 | 2100992.4 | 37.7493688530402 | -122.415630356523 | (37.7493688530402, -122.415630356523) | 2 | 4 | 7 | 28859 | 19 | ||||
| 477 | 113497 | DPW Maintained 1 | Tree(s) :: 17 | 200x MANSELL ST | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011136 | 2090597 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | 10 | 3 | 7 | 309 | 28 | ||||
| 486 | 251556 | DPW Maintained 1 | Tree(s) :: 17 | 299 Clinton Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004847 | 2108161 | 37.7688825293039 | -122.426546282794 | (37.7688825293039, -122.426546282794) | 8 | 4 | 5 | 28862 | 19 | ||||
| 521 | 100638 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
| 660 | 261647 | DPW Maintained 1 | Tree(s) :: 17 | 605 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | 3x5 | 5995910 | 2089162 | 37.7162066827324 | -122.456084795666 | (37.7162066827324, -122.456084795666) | 9 | 8 | 6 | 28861 | 24 | ||
| 709 | 102222 | Undocumented 4 | Tree(s) :: 17 | 30 Aloha Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5992101.6 | 2104316.3 | 37.7575972316932 | -122.470351313846 | (37.7575972316932, -122.470351313846) | 1 | 8 | 4 | 56 | 12 | |||
| 833 | 106379 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 6 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
| 1105 | 106501 | Undocumented 4 | Tree(s) :: 17 | 1266 09TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5993358 | 2106830.8 | 37.764573953722 | -122.46618893715 | (37.764573953722, -122.46618893715) | 11 | 8 | 11 | 56 | 12 | |||||
| 1249 | 107933 | DPW Maintained 1 | Tree(s) :: 17 | 3098X Market St | 1 | Median : Yard | Tree | DPW 1 | 5999920 | 2105144 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | 2 | 4 | 5 | 28862 | 3 | |||||
| 1347 | 109892 | Permitted Site 7 | Tree(s) :: 17 | 205 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2015 12:00:00 AM | 3 | 3x6 | 5995308.1 | 2091295.6 | 37.7220304751495 | -122.458319579925 | (37.7220304751495, -122.458319579925) | 9 | 8 | 4 | 28861 | 24 | ||
| 1361 | 105851 | Undocumented 4 | Tree(s) :: 17 | 2590 16TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991465.4 | 2097806.4 | 37.7396859298071 | -122.472077039908 | (37.7396859298071, -122.472077039908) | 1 | 8 | 4 | 29491 | 40 | |||||
| 1730 | 121323 | Undocumented 4 | Tree(s) :: 17 | 3699X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003556 | 2121083 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | 13 | 9 | 1 | 28858 | 17 | ||||
| 1748 | 56640 | Permitted Site 7 | Tree(s) :: 17 | 2016 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004277.89575757 | 2115357.17634953 | 37.7886092629589 | -122.429027916831 | (37.7886092629589, -122.429027916831) | 13 | 9 | 11 | 29490 | 27 | |||||
| 1752 | 865 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
| 1892 | 124739 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
| 1970 | 260506 | DPW Maintained 1 | Tree(s) :: 17 | 289 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6009625.74334 | 2110365.68554 | 37.7752050776892 | -122.41017254363 | (37.7752050776892, -122.41017254363) | 8 | 2 | 9 | 28853 | 34 | ||||
| 2010 | 260603 | DPW Maintained 1 | Tree(s) :: 17 | 1162 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013406.09782 | 2090446.93369 | 37.7207235989971 | -122.395699409803 | (37.7207235989971, -122.395699409803) | 10 | 3 | 8 | 58 | 1 | |||
| 2057 | 111315 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
| 2090 | 260628 | DPW Maintained 1 | Tree(s) :: 17 | 1251 Revere Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6016934.60308 | 2092996.85523 | 37.7279208386687 | -122.383679778477 | (37.7279208386687, -122.383679778477) | 10 | 3 | 8 | 58 | 1 | |||
| 2153 | 100644 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
| 2183 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 5990450 | 2089482 | 37.7167704112637 | -122.474980331165 | (37.7167704112637, -122.474980331165) | 1 | 8 | 4 | 64 | 14 | ||||
| 2294 | 84947 | Permitted Site 7 | Tree(s) :: 17 | 1812 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003475 | 2114918 | 37.7873579154126 | -122.431774444579 | (37.7873579154126, -122.431774444579) | 13 | 9 | 11 | 29490 | 27 | |||||
| 2335 | 262272 | Undocumented 4 | Tree(s) :: 17 | 99X Glendale St | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5999984 | 2103563 | 37.7559814441149 | -122.443036761048 | (37.7559814441149, -122.443036761048) | 2 | 5 | 5 | 28862 | 38 | |||||
| 2436 | 102404 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
| 2478 | 110785 | Permitted Site 7 | Tree(s) :: 17 | 2 Edna St | 2 | Front Yard : Yard | Tree | Private 2 | 05/06/2015 12:00:00 AM | 3 | 5998788.4 | 2092979.9 | 37.7268545527586 | -122.446410203741 | (37.7268545527586, -122.446410203741) | 9 | 7 | 4 | 28861 | 40 | |||
| 2598 | 95032 | - 12 | Tree(s) :: 17 | 211 Maynard St | Front Yard : Cutout | Landscaping | Private 2 | 6004772 | 2093802 | 37.7294517978782 | -122.425783519869 | (37.7294517978782, -122.425783519869) | 9 | 7 | 6 | 28861 | 5 | ||||||
| 2764 | 262058 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 9 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
| 2857 | 99536 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5x9 | 6014774.7 | 2116168.9 | 37.7914266467329 | -122.392767069159 | (37.7914266467329, -122.392767069159) | 12 | 2 | 9 | 28855 | 6 | ||||
| 2991 | 99574 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 3105 | 56728 | Permitted Site 7 | Tree(s) :: 17 | 1543 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015672.6894307 | 2095677.74798122 | 37.7352121997354 | -122.388229306646 | (37.7352121997354, -122.388229306646) | 10 | 3 | 8 | 58 | 1 | |||||
| 3133 | 53387 | Permitted Site 7 | Tree(s) :: 17 | 272 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994766.71798377 | 2090393.02640531 | 37.7195210985022 | -122.460125633496 | (37.7195210985022, -122.460125633496) | 9 | 8 | 6 | 28861 | 24 | |||||
| 3301 | 102850 | Undocumented 4 | Tree(s) :: 17 | 25X Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 6014185 | 2114270 | 37.7861799368485 | -122.394674400267 | (37.7861799368485, -122.394674400267) | 6 | 2 | 9 | 28855 | 6 | |||
| 3313 | 262482 | Significant Tree 6 | Tree(s) :: 17 | 45 Delta St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6010254 | 2089941 | 37.7191585615903 | -122.406559656354 | (37.7191585615903, -122.406559656354) | 10 | 7 | 8 | 309 | 39 | ||||
| 3495 | 181336 | DPW Maintained 1 | Tree(s) :: 17 | 1260 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5986177.8228 | 2106650.4552 | 37.7636618977311 | -122.49100962005 | (37.7636618977311, -122.49100962005) | 1 | 8 | 3 | 56 | 35 | |||
| 3519 | 261713 | DPW Maintained 1 | Tree(s) :: 17 | 2363 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2020 12:00:00 AM | 3 | 5x5 | 5987606 | 2099209 | 37.7433130060865 | -122.485523930836 | (37.7433130060865, -122.485523930836) | 1 | 8 | 3 | 29491 | 35 | ||
| 3533 | 263634 | Section 806 (d) 5 | Tree(s) :: 17 | 211 Sawyer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2020 12:00:00 AM | 3 | 3x3 | 6008194.27066 | 2088426.33179 | 37.71488415001 | -122.413572307092 | (37.71488415001, -122.413572307092) | 9 | 7 | 8 | 309 | 39 | ||
| 3701 | 78185 | Section 806 (d) 5 | Tree(s) :: 17 | 811 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999080 | 2107571 | 37.7669348288429 | -122.446451411547 | (37.7669348288429, -122.446451411547) | 15 | 5 | 11 | 29492 | 9 | |||||
| 3740 | 102276 | DPW Maintained 1 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.438398959733 | (37.7402178594385, -122.438398959733) | 2 | 7 | 5 | 63 | 7 | ||||||
| 3800 | 261425 | Undocumented 4 | Tree(s) :: 17 | 1001 Potrero Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 3885 | 113314 | DPW Maintained 1 | Tree(s) :: 17 | 69-71 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993857 | 2115083.3 | 37.7872618877682 | -122.46506246599 | (37.7872618877682, -122.46506246599) | 11 | 6 | 1 | 54 | 11 | |||||
| 3951 | 183335 | DPW Maintained 1 | Tree(s) :: 17 | 1211 43rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982688 | 2106849 | 37.7640025388616 | -122.503094328734 | (37.7640025388616, -122.503094328734) | 1 | 8 | 3 | 56 | 35 | |||
| 3975 | 56564 | Permitted Site 7 | Tree(s) :: 17 | 250 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992102.77849477 | 2095182.39763056 | 37.7325179438205 | -122.469682298657 | (37.7325179438205, -122.469682298657) | 9 | 8 | 4 | 59 | 40 | |||||
| 4147 | 261430 | Undocumented 4 | Tree(s) :: 17 | 1001 Potrero Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 4356 | 262525 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
| 4399 | 260599 | DPW Maintained 1 | Tree(s) :: 17 | 1114 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014272.04969 | 2090150.96276 | 37.7199590543715 | -122.392685364492 | (37.7199590543715, -122.392685364492) | 10 | 3 | 8 | 58 | 1 | |||
| 4476 | 112909 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 4489 | 97354 | Permitted Site 7 | Tree(s) :: 17 | 4 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
| 4623 | 106966 | Undocumented 4 | Tree(s) :: 17 | 2391 47TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981720.8 | 2098834.4 | 37.7419398125124 | -122.505845312535 | (37.7419398125124, -122.505845312535) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 4754 | 101985 | Undocumented 4 | Tree(s) :: 17 | 205X Rose St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005538.6 | 2109749.6 | 37.7732835163003 | -122.424267082997 | (37.7732835163003, -122.424267082997) | 7 | 9 | 11 | 28852 | 10 | ||||
| 4853 | 107519 | Undocumented 4 | Tree(s) :: 17 | 100x CHURCH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004015.5 | 2108290.9 | 37.7691921614924 | -122.429431648714 | (37.7691921614924, -122.429431648714) | 7 | 9 | 5 | 28862 | 3 | ||||||
| 4964 | 104791 | Undocumented 4 | Tree(s) :: 17 | 98X 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005767 | 2099074 | 37.7439837097913 | -122.422718209223 | (37.7439837097913, -122.422718209223) | 2 | 7 | 5 | 28859 | 22 | ||||
| 5027 | 261648 | DPW Maintained 1 | Tree(s) :: 17 | 605 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 5995910 | 2089162 | 37.7162066827324 | -122.456084795666 | (37.7162066827324, -122.456084795666) | 9 | 8 | 6 | 28861 | 24 | ||||
| 5100 | 101532 | Undocumented 4 | Tree(s) :: 17 | 11323 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
| 5102 | 183834 | DPW Maintained 1 | Tree(s) :: 17 | 2210 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986396.7617 | 2100164.5451 | 37.7458661487434 | -122.489775365895 | (37.7458661487434, -122.489775365895) | 1 | 8 | 3 | 29491 | 35 | |||
| 5249 | 100990 | Undocumented 4 | Tree(s) :: 17 | 1675 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009464 | 2106858 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | 8 | 4 | 7 | 28853 | 19 | ||||
| 5412 | 261620 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1633 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2020 12:00:00 AM | 3 | 3x3 | 6006860 | 2117000 | 37.7932658708928 | -122.420210847334 | (37.7932658708928, -122.420210847334) | 13 | 9 | 10 | 28858 | 32 | ||
| 5426 | 102462 | Undocumented 4 | Tree(s) :: 17 | 3354 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007825.6 | 2104471.5 | 37.7589199559787 | -122.415982170306 | (37.7589199559787, -122.415982170306) | 2 | 4 | 7 | 28859 | 19 | |||
| 5582 | 183333 | DPW Maintained 1 | Tree(s) :: 17 | 1211 43rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982688 | 2106849 | 37.7640025388616 | -122.503094328734 | (37.7640025388616, -122.503094328734) | 1 | 8 | 3 | 56 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );