trees
47 rows where Zip Codes = 29490 and qSpecies_id = 148
This data as json, CSV (advanced)
These facets timed out: Zip Codes
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23054 | 104167 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
| 26556 | 26652 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2324 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003670.20137 | 2115963.1333 | 37.7902386497824 | -122.43117371613 | (37.7902386497824, -122.43117371613) | 13 | 9 | 1 | 29490 | 27 | |||
| 29927 | 5259 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1221 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X3 | 6001282.65173 | 2112621.17829 | 37.7809269126295 | -122.439194811296 | (37.7809269126295, -122.439194811296) | 15 | 5 | 11 | 29490 | 41 | |||
| 31354 | 5288 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1450 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 01/01/2010 12:00:00 AM | 3 | 3X3 | 6001279.3901091 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) | 15 | 5 | 11 | 29490 | 41 | ||
| 37333 | 8452 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1850X Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6002863.14639 | 2113881.31105 | 37.7844767282199 | -122.433817202745 | (37.7844767282199, -122.433817202745) | 13 | 9 | 11 | 29490 | 13 | ||
| 37348 | 116701 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1450 Divisadero St | 6 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 3X3 | 6001279.3901091 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) | 15 | 5 | 11 | 29490 | 41 | ||||
| 44726 | 8521 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.437805961288 | (37.7836169980675, -122.437805961288) | 15 | 5 | 11 | 29490 | 41 | ||
| 49683 | 116229 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1699 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | 13 | 9 | 11 | 29490 | 13 | |||||
| 51845 | 116302 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
| 56014 | 8417 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1625X Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/1997 12:00:00 AM | 6 | 3X3 | 6003997.4163 | 2113895.15466 | 37.7845790386871 | -122.429894005852 | (37.7845790386871, -122.429894005852) | 13 | 9 | 11 | 29490 | 41 | ||
| 57943 | 95166 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1300X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001355.20441 | 2112906.07306 | 37.7817132894018 | -122.438964239497 | (37.7817132894018, -122.438964239497) | 15 | 5 | 11 | 29490 | 41 | |||
| 59971 | 116303 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
| 60464 | 116304 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
| 67495 | 3009 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2402 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2012 12:00:00 AM | 3 | 3x3 | 6002808.01196 | 2115517.13179 | 37.7889651474795 | -122.434124927834 | (37.7889651474795, -122.434124927834) | 13 | 9 | 1 | 29490 | 27 | ||
| 67522 | 5221 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1009X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2005 12:00:00 AM | 5 | 3X3 | 6001407.0548 | 2111843.67263 | 37.7787991574032 | -122.438708711528 | (37.7787991574032, -122.438708711528) | 15 | 5 | 11 | 29490 | 41 | ||
| 68592 | 116702 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1450 Divisadero St | 7 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 3X3 | 6001279.3901091 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) | 15 | 5 | 11 | 29490 | 41 | ||||
| 72171 | 5231 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1053 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | 6 | 3X3 | 6001315.02339 | 2112044.91566 | 37.7793464837663 | -122.439041510199 | (37.7793464837663, -122.439041510199) | 15 | 5 | 11 | 29490 | 41 | ||
| 77190 | 95181 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1301X Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001253.46052 | 2112914.04483 | 37.781729388453 | -122.439316796194 | (37.781729388453, -122.439316796194) | 15 | 5 | 11 | 29490 | 41 | |||
| 79663 | 28725 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1970 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2013 12:00:00 AM | 3 | 3x3 | 6003187.8589 | 2114511.853 | 37.7862264577302 | -122.432738867912 | (37.7862264577302, -122.432738867912) | 13 | 9 | 11 | 29490 | 27 | ||
| 83783 | 95165 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100 Divisadero St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2014 12:00:00 AM | 3 | 3x3 | 6001410.7267 | 2112361.1413 | 37.7802202041401 | -122.438733098992 | (37.7802202041401, -122.438733098992) | 15 | 5 | 11 | 29490 | 41 | ||
| 96187 | 116306 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
| 101337 | 95167 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1300 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3 | 3x3 | 6001355 | 2112906 | 37.7817130771674 | -122.43896494142 | (37.7817130771674, -122.43896494142) | 15 | 5 | 11 | 29490 | 41 | ||
| 105019 | 95178 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1215 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3 | 3x3 | 6001286.14287 | 2112595.80793 | 37.7808574507306 | -122.439180914838 | (37.7808574507306, -122.439180914838) | 15 | 5 | 11 | 29490 | 41 | ||
| 105368 | 116227 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1699 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | 13 | 9 | 11 | 29490 | 13 | |||||
| 111380 | 26653 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2324 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003670.20137 | 2115963.1333 | 37.7902386497824 | -122.43117371613 | (37.7902386497824, -122.43117371613) | 13 | 9 | 1 | 29490 | 27 | |||
| 119087 | 101070 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3018 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768630 | 5999883.5 | 2115123.7 | 37.7877184733225 | -122.444215032048 | (37.7877184733225, -122.444215032048) | 13 | 6 | 1 | 29490 | 27 | |
| 120954 | 23883 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1500X Webster St | 6 | Median : Cutout | Tree | DPW 1 | 30 | 6X6 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.431115216253 | (37.7845850728987, -122.431115216253) | 13 | 9 | 11 | 29490 | 41 | |||
| 124996 | 95180 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1301X Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001253.46052 | 2112914.04483 | 37.781729388453 | -122.439316796194 | (37.781729388453, -122.439316796194) | 15 | 5 | 11 | 29490 | 41 | |||
| 125923 | 94527 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1545 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2010 12:00:00 AM | Permit Number 53714 | 6001163 | 2113666 | 37.7837889169409 | -122.439683671841 | (37.7837889169409, -122.439683671841) | 15 | 6 | 11 | 29490 | 13 | |||
| 126440 | 95163 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 998 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001491.8688 | 2111772.0851 | 37.7786074207661 | -122.438410176931 | (37.7786074207661, -122.438410176931) | 15 | 5 | 11 | 29490 | 41 | |
| 126874 | 5235 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5x5 | 6001436.83253 | 2112303.93811 | 37.7800646238097 | -122.438638687165 | (37.7800646238097, -122.438638687165) | 15 | 5 | 11 | 29490 | 41 | |||
| 130284 | 116305 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
| 131372 | 101526 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2300X Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6003597.8 | 2116101.6 | 37.7906147410217 | -122.431434108251 | (37.7906147410217, -122.431434108251) | 13 | 9 | 1 | 29490 | 27 | |||
| 131647 | 5275 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1325 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001243.83619 | 2112984.00007 | 37.7819209200143 | -122.439355107677 | (37.7819209200143, -122.439355107677) | 15 | 5 | 11 | 29490 | 41 | |||
| 136072 | 8432 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1655X Geary Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/22/2015 12:00:00 AM | 3 | 3X3 | 6003848.7878415 | 2113876.6611275 | 37.7845198420807 | -122.430406890022 | (37.7845198420807, -122.430406890022) | 13 | 9 | 11 | 29490 | 41 | ||
| 138293 | 116228 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1699 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | 13 | 9 | 11 | 29490 | 13 | |||||
| 146391 | 104166 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
| 147700 | 95179 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1301X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2008 12:00:00 AM | 3 | 3x3 | 6001253.46052 | 2112914.04483 | 37.781729388453 | -122.439316796194 | (37.781729388453, -122.439316796194) | 15 | 5 | 11 | 29490 | 41 | ||
| 153132 | 3074 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2889 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2005 12:00:00 AM | 3 | 3X3 | 6000557.1809667 | 2115144.6462063 | 37.7878143969754 | -122.441885735464 | (37.7878143969754, -122.441885735464) | 13 | 6 | 1 | 29490 | 27 | ||
| 159490 | 104165 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
| 162479 | 104530 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1363 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 10:11:00 AM | 3 | 3x3 | 6001216 | 2113103 | 37.782246079324 | -122.439459940797 | (37.782246079324, -122.439459940797) | 15 | 5 | 11 | 29490 | 41 | ||
| 165559 | 18884 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2324 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1991 12:00:00 AM | 6 | 3X3 | 6003670.20137 | 2115963.1333 | 37.7902386497824 | -122.43117371613 | (37.7902386497824, -122.43117371613) | 13 | 9 | 1 | 29490 | 27 | ||
| 168290 | 5284 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1351 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2016 12:00:00 AM | 3 | 3X4 | 6001249.4687 | 2113069.2889 | 37.7821554219249 | -122.439341737157 | (37.7821554219249, -122.439341737157) | 15 | 5 | 11 | 29490 | 41 | ||
| 172138 | 2992 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2271 California St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/1997 12:00:00 AM | 3 | 3X3 | 6003533.29552 | 2115470.79333 | 37.7888790501987 | -122.431612235281 | (37.7888790501987, -122.431612235281) | 13 | 9 | 1 | 29490 | 27 | ||
| 184180 | 26654 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2324 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003670.20137 | 2115963.1333 | 37.7902386497824 | -122.43117371613 | (37.7902386497824, -122.43117371613) | 13 | 9 | 1 | 29490 | 27 | |||
| 191319 | 30169 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3110 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2007 12:00:00 AM | 3 | 3x3 | 5999423.70663 | 2115059.74822 | 37.7875166362976 | -122.445801222119 | (37.7875166362976, -122.445801222119) | 13 | 6 | 1 | 29490 | 31 | ||
| 192322 | 104164 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 |
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) );