trees
169 rows where qSpecies_id = 3 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
93785 | 95632 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 84 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767399 | 6005074 | 2104592 | 37.7590957347764 | -122.425507072647 | (37.7590957347764, -122.425507072647) | 2 | 4 | 5 | 28859 | 19 | |
81770 | 95643 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1430 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2011 12:00:00 AM | 3x3` | Permit Number 767411 | 6009341 | 2118148 | 37.7965574803307 | -122.411707541294 | (37.7965574803307, -122.411707541294) | 3 | 1 | 10 | 308 | 4 | |
937 | 95737 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 445 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767484 | 6003120.3 | 2091142.7 | 37.7220564786865 | -122.431303852024 | (37.7220564786865, -122.431303852024) | 9 | 7 | 6 | 28861 | 5 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |||
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 | |||
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 | ||
7770 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2324 Sacramento St | Front Yard : Yard | Tree | Private 2 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.431173718492 | (37.7902385582714, -122.431173718492) | 13 | 9 | 1 | 29490 | 27 | |||
73765 | 43361 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1100X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 5x6 | Permit Number 769743 | 6003157.69483217 | 2101814.87307727 | 37.751361942995 | -122.431936260805 | (37.751361942995, -122.431936260805) | 2 | 4 | 5 | 28862 | 22 |
124726 | 73311 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 3993 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6003233.13125919 | 2101819.03684703 | 37.7513776519742 | -122.431675690307 | (37.7513776519742, -122.431675690307) | 2 | 4 | 5 | 28862 | 22 |
68354 | 41383 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 3995 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2004 12:00:00 AM | 3x3 | Permit Number 771193 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||
112282 | 60630 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 470 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 772107 | 6003622.94051992 | 2096160.25019953 | 37.7358620195082 | -122.429924078324 | (37.7358620195082, -122.429924078324) | 2 | 7 | 5 | 63 | 7 | |
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 |
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 |
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 |
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 |
8540 | 108986 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 58 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773047 | 6003766 | 2108010.7 | 37.7684086713102 | -122.430274662073 | (37.7684086713102, -122.430274662073) | 7 | 9 | 5 | 28862 | 3 |
44398 | 110615 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/31/2015 12:00:00 AM | 3 | 13.2x7.8 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | |
59912 | 108412 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
82815 | 108411 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
85170 | 110614 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/31/2015 12:00:00 AM | 3 | 21.4x7.8 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | |
99901 | 88026 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175 | 2112425 | 37.7807780405047 | -122.415336822355 | (37.7807780405047, -122.415336822355) | 7 | 10 | 9 | 28852 | 36 | ||
115122 | 108413 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
135346 | 108414 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
141581 | 110613 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/27/2015 12:00:00 AM | 3 | 12.8x7.8 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | |
141779 | 88025 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175 | 2112425 | 37.7807780405047 | -122.415336822355 | (37.7807780405047, -122.415336822355) | 7 | 10 | 9 | 28852 | 36 | ||
193111 | 88024 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008175 | 2112425 | 37.7807780405047 | -122.415336822355 | (37.7807780405047, -122.415336822355) | 7 | 10 | 9 | 28852 | 36 | ||
105180 | 114988 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1020 Ulloa St | 2 | Side Yard : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | Permit Number 773462 | 5992930.8 | 2098449.5 | 37.7415364116566 | -122.467057099516 | (37.7415364116566, -122.467057099516) | 1 | 8 | 4 | 59 | 40 | |||
107555 | 106975 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1020 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2015 12:00:00 AM | Permit Number 773462 | 5992930.77277 | 2098449.45466 | 37.7415362855926 | -122.467057190372 | (37.7415362855926, -122.467057190372) | 1 | 8 | 4 | 59 | 40 | |||
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 |
11383 | 54618 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1241 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2015 12:00:00 AM | 3 | Permit Number 773836 | 5995447.87893812 | 2107104.396215 | 37.7654455330173 | -122.458980467929 | (37.7654455330173, -122.458980467929) | 15 | 5 | 11 | 56 | 12 | ||
175832 | 115290 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2642 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 774426 | 5991478.6 | 2097428.2 | 37.7386482527839 | -122.472003841981 | (37.7386482527839, -122.472003841981) | 1 | 8 | 4 | 29491 | 40 | |||
63366 | 110454 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 7630 Geary Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774506 | 5983294.7 | 2112541.2 | 37.7796673212814 | -122.501417065582 | (37.7796673212814, -122.501417065582) | 11 | 6 | 2 | 55 | 26 | |
100740 | 110453 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 7630 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774506 | 5983294.7 | 2112541.2 | 37.7796673212814 | -122.501417065582 | (37.7796673212814, -122.501417065582) | 11 | 6 | 2 | 55 | 26 | |
187369 | 24737 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 7630 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774506 | 5983294.71592 | 2112541.16992 | 37.7796672396255 | -122.501417008283 | (37.7796672396255, -122.501417008283) | 11 | 6 | 2 | 55 | 26 | |
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 | ||||
77580 | 109775 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1530 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775056 | 5992490 | 2105022.4 | 37.7595584460972 | -122.469059468108 | (37.7595584460972, -122.469059468108) | 1 | 8 | 4 | 56 | 12 |
170572 | 65507 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 169 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | Permit Number 775100 | 6005433.48243483 | 2100181.63700927 | 37.747006205468 | -122.423950186936 | (37.747006205468, -122.423950186936) | 2 | 7 | 5 | 28859 | 22 | ||
72099 | 79383 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 339 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2015 12:00:00 AM | Permit Number 775296 | 6004813.3574213 | 2101815.69281838 | 37.7514579152774 | -122.426210842735 | (37.7514579152774, -122.426210842735) | 2 | 4 | 5 | 28862 | 22 | ||
147711 | 46901 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1490 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/2015 12:00:00 AM | Permit Number 775424 | 5991189.27223217 | 2105275.5936987 | 37.7601784073134 | -122.473576456034 | (37.7601784073134, -122.473576456034) | 1 | 8 | 4 | 56 | 12 | ||
52951 | 115234 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 614 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775529 | 5982925.7 | 2111574.8 | 37.776992191518 | -122.502622024839 | (37.776992191518, -122.502622024839) | 11 | 6 | 2 | 55 | 26 | |||
109127 | 55735 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2257 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 775540 | 6002523.01452093 | 2107055.09703548 | 37.765714336292 | -122.434505696133 | (37.765714336292, -122.434505696133) | 15 | 5 | 5 | 28862 | 3 | |||
56656 | 114974 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 23 Holloway Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 775981 | 5996745.4 | 2091181.1 | 37.7217985747524 | -122.45334295572 | (37.7217985747524, -122.45334295572) | 9 | 8 | 6 | 28861 | 24 | |||
92208 | 87201 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 198 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992637 | 2097914 | 37.7400491012762 | -122.468034007919 | (37.7400491012762, -122.468034007919) | 1 | 8 | 4 | 59 | 40 | ||
166075 | 67634 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 198 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 776030 | 5992640.98676311 | 2097929.31580717 | 37.7400913848475 | -122.468021337222 | (37.7400913848475, -122.468021337222) | 1 | 8 | 4 | 59 | 40 | ||
108192 | 114981 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 115 Moncada Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | Permit Number 776112 | 5992157.9 | 2093028.6 | 37.7266073370069 | -122.469335018242 | (37.7266073370069, -122.469335018242) | 9 | 8 | 4 | 59 | 40 | |||
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 |
161070 | 113256 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 45 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 776597 | 6004879 | 2096228.3 | 37.7361199217499 | -122.425586223473 | (37.7361199217499, -122.425586223473) | 2 | 7 | 5 | 28859 | 2 | |||
151024 | 113258 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 56 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 776598 | 6004861.1 | 2096154.7 | 37.7359168212577 | -122.42564287438 | (37.7359168212577, -122.42564287438) | 2 | 7 | 5 | 28859 | 2 | |||
174021 | 117327 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1762 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778536 | 5992852.9 | 2103474.1 | 37.7553281792803 | -122.467691786389 | (37.7553281792803, -122.467691786389) | 1 | 8 | 4 | 56 | 12 | ||
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 |
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 | |
27998 | 58743 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2142 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2018 12:00:00 AM | 3 | Permit Number 779599 | 6007661.70452 | 2119773.97834 | 37.800927664051 | -122.417633590924 | (37.800927664051, -122.417633590924) | 5 | 1 | 1 | 308 | 32 | ||
4743 | 167761 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 451 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780770 | 6000439.87639 | 2107208.3352 | 37.7660166188918 | -122.441721798828 | (37.7660166188918, -122.441721798828) | 15 | 5 | 5 | 29492 | 3 | |
26587 | 254188 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 990 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781213 | 6011879.09445 | 2103781.87392 | 37.7572534589089 | -122.401914730273 | (37.7572534589089, -122.401914730273) | 10 | 3 | 8 | 28856 | 29 |
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 | |
41488 | 215160 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 125 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/26/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 781603 | 5992679.1263 | 2088076.57107 | 37.7130403764755 | -122.467173279126 | (37.7130403764755, -122.467173279126) | 9 | 8 | 6 | 64 | 24 | |
43522 | 254861 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 950 Harrison St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781647 | 6011722.62416 | 2111414.26222 | 37.7782015384395 | -122.402992686912 | (37.7782015384395, -122.402992686912) | 14 | 2 | 9 | 28856 | 34 | |
591 | 264763 | Section 806 (d) 5 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 274 Victoria St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/05/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781692 | 5993256.27541 | 2089011.86791 | 37.7156417766237 | -122.465246370223 | (37.7156417766237, -122.465246370223) | 9 | 8 | 6 | 64 | 24 | |
18566 | 256863 | Section 806 (d) 5 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 274 Victoria St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/19/2018 12:00:00 AM | 3 | 3x8 | Permit Number 781692 | 5993256.27541 | 2089011.86791 | 37.7156417766237 | -122.465246370223 | (37.7156417766237, -122.465246370223) | 9 | 8 | 6 | 64 | 24 | |
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 | |
115121 | 172492 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1650 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782055 | 6008369.46089 | 2118168.63641 | 37.7965595947944 | -122.415070752424 | (37.7965595947944, -122.415070752424) | 5 | 1 | 10 | 308 | 21 | |
103511 | 126549 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2113 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782608 | 6008108.43544 | 2119716.18601 | 37.8007941084157 | -122.416083612992 | (37.8007941084157, -122.416083612992) | 5 | 1 | 1 | 308 | 32 |
131119 | 256693 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2512 Polk St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782622 | 6006252.42192 | 2119405.80976 | 37.7998373648088 | -122.422484137829 | (37.7998373648088, -122.422484137829) | 13 | 9 | 1 | 28858 | 32 |
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) );