trees
50 rows where Supervisor Districts = 7 and qSpecies_id = 3
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 121463 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
27 | 121462 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
2600 | 258371 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
3660 | 166080 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 658 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6007879.9571 | 2104073.95506 | 37.7578314446872 | -122.415766028184 | (37.7578314446872, -122.415766028184) | 2 | 4 | 7 | 28859 | 19 | |||
3667 | 97254 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 601 Tompkins Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768271 | 6008616.2 | 2096553.7 | 37.7372238594213 | -122.412688154144 | (37.7372238594213, -122.412688154144) | 10 | 7 | 7 | 28859 | 2 | |||
4048 | 255910 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 85 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 6007891 | 2093604 | 37.7290838947974 | -122.414986794268 | (37.7290838947974, -122.414986794268) | 9 | 3 | 7 | 309 | 28 | ||
5926 | 258370 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
6088 | 258369 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
9698 | 258382 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 91 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007891.9701 | 2093531.56209 | 37.7288850504069 | -122.414978315537 | (37.7288850504069, -122.414978315537) | 9 | 3 | 7 | 309 | 28 | |||
11074 | 108918 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 566 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772703 | 6007660.3 | 2096715.1 | 37.7376133311576 | -122.416004574089 | (37.7376133311576, -122.416004574089) | 2 | 7 | 7 | 28859 | 2 |
15554 | 81207 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 939-941 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50562 | 6009973.59973707 | 2103738.09495501 | 37.7570267223359 | -122.408501615607 | (37.7570267223359, -122.408501615607) | 2 | 4 | 7 | 28859 | 19 | ||
19710 | 82646 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.421213943138 | (37.7672998944856, -122.421213943138) | 8 | 4 | 7 | 28853 | 19 | |
24190 | 79708 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006457.91011592 | 2104927.14791455 | 37.760094069279 | -122.420744637251 | (37.760094069279, -122.420744637251) | 2 | 4 | 7 | 28859 | 19 |
29116 | 82728 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1665 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50228 | 6009327.85316952 | 2099771.61869186 | 37.7460994782416 | -122.410454789266 | (37.7460994782416, -122.410454789266) | 2 | 7 | 7 | 28859 | 2 | ||
41261 | 84460 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 698X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52659 | 6009314.54246303 | 2104977.65271839 | 37.7603933359548 | -122.410868438641 | (37.7603933359548, -122.410868438641) | 2 | 4 | 7 | 28859 | 19 | ||
50039 | 82645 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.421213943138 | (37.7672998944856, -122.421213943138) | 8 | 4 | 7 | 28853 | 19 | |
52140 | 254351 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1510 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778658 | 6010079.1962 | 2100542.61311 | 37.7482585517324 | -122.407911089362 | (37.7482585517324, -122.407911089362) | 2 | 4 | 7 | 28859 | 2 |
53142 | 97253 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 364 Banks St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768268 | 6008584.5 | 2096981.4 | 37.7383964511341 | -122.412827985209 | (37.7383964511341, -122.412827985209) | 10 | 7 | 7 | 28859 | 2 | |||
58009 | 37694 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 587 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52664 | 6007904.99529024 | 2104523.82497992 | 37.7590680918379 | -122.415711288385 | (37.7590680918379, -122.415711288385) | 2 | 4 | 7 | 28859 | 19 | ||
61129 | 82614 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 80X Julian Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.421213943138 | (37.7672998944856, -122.421213943138) | 8 | 4 | 7 | 28853 | 19 | |
68841 | 82764 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 326 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50236 | 6009628.04821978 | 2099623.52632894 | 37.7457096736308 | -122.40940629959 | (37.7457096736308, -122.40940629959) | 2 | 7 | 7 | 28859 | 2 | ||
74598 | 96063 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767689 | 6007319.1 | 2099659.7 | 37.745679358438 | -122.417392885985 | (37.745679358438, -122.417392885985) | 2 | 7 | 7 | 28859 | 2 | |
78960 | 36710 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.421222946795 | (37.7673939082567, -122.421222946795) | 8 | 4 | 7 | 28853 | 19 | |
81584 | 96162 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 130 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767794 | 6007212 | 2096763 | 37.7377196388784 | -122.417557958394 | (37.7377196388784, -122.417557958394) | 2 | 7 | 7 | 28859 | 2 | |
87698 | 82731 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 328 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50237 | 6009619.57749446 | 2099623.04642916 | 37.7457078813161 | -122.409435556374 | (37.7457078813161, -122.409435556374) | 2 | 7 | 7 | 28859 | 2 | ||
89635 | 84456 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2800 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52651 | 6009557.23570783 | 2105031.47254004 | 37.760554718378 | -122.410032871336 | (37.760554718378, -122.410032871336) | 2 | 4 | 7 | 28859 | 19 | ||
91803 | 72659 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.421222946795 | (37.7673939082567, -122.421222946795) | 8 | 4 | 7 | 28853 | 19 | |
94917 | 82266 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 366 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50238 | 6009458.6336342 | 2099613.92832895 | 37.7456738259394 | -122.409991435275 | (37.7456738259394, -122.409991435275) | 2 | 7 | 7 | 28859 | 2 | ||
98016 | 92227 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 587 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52664 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.415274584034 | (37.7590797904057, -122.415274584034) | 2 | 4 | 7 | 28859 | 19 | ||
101133 | 114693 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 436 Hamilton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774634 | 6009470.9 | 2092282.5 | 37.7255439885799 | -122.409431705435 | (37.7255439885799, -122.409431705435) | 9 | 3 | 7 | 309 | 28 | ||||
103548 | 96168 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 617 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767800 | 6008684.2 | 2096511.3 | 37.7371112545774 | -122.412450049968 | (37.7371112545774, -122.412450049968) | 10 | 7 | 7 | 28859 | 2 | |
107040 | 82648 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.421213943138 | (37.7672998944856, -122.421213943138) | 8 | 4 | 7 | 28853 | 19 | |
113879 | 108438 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200-212X Lexington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 4 | 7 | 28859 | 19 |
116944 | 82201 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 3236 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49903 | 6006735.54842487 | 2103815.93628153 | 37.7570585841288 | -122.419705571484 | (37.7570585841288, -122.419705571484) | 2 | 4 | 7 | 28859 | 19 | |
123694 | 36711 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.421222946795 | (37.7673939082567, -122.421222946795) | 8 | 4 | 7 | 28853 | 19 | |
125763 | 254347 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 331 Nevada St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781315 | 6008972.61593 | 2096759.8302 | 37.7378098459669 | -122.411470414989 | (37.7378098459669, -122.411470414989) | 10 | 7 | 7 | 28859 | 2 | |
131831 | 87906 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 29 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50926 | 6005790 | 2097546 | 37.7397894643754 | -122.422530125788 | (37.7397894643754, -122.422530125788) | 2 | 7 | 7 | 28859 | 2 | ||
134501 | 94128 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 420 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53495 | 6010221.9 | 2098587.9 | 37.7428993246027 | -122.407279845082 | (37.7428993246027, -122.407279845082) | 10 | 7 | 7 | 28859 | 2 | ||
153730 | 47116 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 111X Kingston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776317 | 6005877.48531462 | 2098254.931079 | 37.7417409646574 | -122.422277993643 | (37.7417409646574, -122.422277993643) | 2 | 7 | 7 | 28859 | 2 |
160705 | 82436 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 26 Samoset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3X3 | Permit Number 50250 | 6010014.10477715 | 2099190.9547508 | 37.7445435496536 | -122.408040866179 | (37.7445435496536, -122.408040866179) | 2 | 7 | 7 | 28859 | 2 | ||
161899 | 74044 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.421222946795 | (37.7673939082567, -122.421222946795) | 8 | 4 | 7 | 28853 | 19 | |
164488 | 72661 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.421222946795 | (37.7673939082567, -122.421222946795) | 8 | 4 | 7 | 28853 | 19 | |
165528 | 108435 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 3467 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006465.10924 | 2104925.09074 | 37.7600888265129 | -122.420719592832 | (37.7600888265129, -122.420719592832) | 2 | 4 | 7 | 28859 | 19 |
166290 | 95793 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1115 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767536 | 6010282 | 2102727 | 37.7542677476114 | -122.407363767722 | (37.7542677476114, -122.407363767722) | 10 | 4 | 7 | 28859 | 19 | |
174484 | 82647 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773693 | 6006376.13216739 | 2107553.16833294 | 37.7672998944856 | -122.421213943138 | (37.7672998944856, -122.421213943138) | 8 | 4 | 7 | 28853 | 19 |
178008 | 106812 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 196X WOOL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6007325 | 2097296 | 37.7391894968596 | -122.417205020194 | (37.7391894968596, -122.417205020194) | 2 | 7 | 7 | 28859 | 2 | |||
178716 | 36712 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Julian Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52215 | 6006374.23290867 | 2107587.4469069 | 37.7673939082567 | -122.421222946795 | (37.7673939082567, -122.421222946795) | 8 | 4 | 7 | 28853 | 19 | |
183243 | 69522 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 601 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768271 | 6008573.55056705 | 2096511.22734842 | 37.7371048449327 | -122.41283261137 | (37.7371048449327, -122.41283261137) | 10 | 7 | 7 | 28859 | 2 | ||
185446 | 95799 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767541 | 6010051.6 | 2104518.5 | 37.7591739071678 | -122.408286901595 | (37.7591739071678, -122.408286901595) | 2 | 4 | 7 | 28859 | 19 | |
186303 | 32210 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 85 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2018 12:00:00 AM | 3 | 3x6 | Permit Number 781715 | 6009682.7318 | 2099892.23554 | 37.7464505538497 | -122.409236169516 | (37.7464505538497, -122.409236169516) | 2 | 7 | 7 | 28859 | 2 |
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) );