trees
169 rows where qSpecies_id = 3 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
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 | ||
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 | |
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 |
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 | |
129114 | 95631 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 47 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767397 | 6003332.1 | 2102812.2 | 37.7541102528563 | -122.431404335591 | (37.7541102528563, -122.431404335591) | 2 | 4 | 5 | 28862 | 22 | |
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 | |
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 | ||
134227 | 252890 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 301x Howth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2019 08:38:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
134331 | 111021 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 90x DOWNEY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
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 | ||
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 | ||
145406 | 88575 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 562 18th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51515 | 5990373.3 | 2111545.8 | 37.7773474033188 | -122.47685663061 | (37.7773474033188, -122.47685663061) | 11 | 6 | 2 | 55 | 26 | |||
146888 | 91575 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 576 Sanchez St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52611 | 6003627 | 2104921 | 37.7599172257375 | -122.430534960736 | (37.7599172257375, -122.430534960736) | 2 | 4 | 5 | 28862 | 3 | ||
147589 | 88245 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 4343 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51232 | 6000519 | 2105766 | 37.7620608314048 | -122.44134462504 | (37.7620608314048, -122.44134462504) | 15 | 5 | 5 | 28862 | 3 | |||
151880 | 65682 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1301 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50609 | 6005842.98381939 | 2101391.5473786 | 37.7503514528508 | -122.422620128615 | (37.7503514528508, -122.422620128615) | 2 | 4 | 5 | 28859 | 19 | ||
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 |
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 | |
162147 | 174953 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 42 McLea Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010005 | 2109213 | 37.7720613219198 | -122.408779264004 | (37.7720613219198, -122.408779264004) | 14 | 2 | 9 | 28853 | 34 | ||||
163261 | 99199 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 330X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 50790 | 6002852.8 | 2106288.8 | 37.7636289858331 | -122.433310278834 | (37.7636289858331, -122.433310278834) | 15 | 4 | 5 | 28862 | 3 | ||
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 |
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 | ||
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 | |
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 | |
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 | |
190887 | 82886 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 761 Clementina St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52437 | 6009240.34446046 | 2110165.45314704 | 37.7746336766823 | -122.411491580973 | (37.7746336766823, -122.411491580973) | 8 | 2 | 9 | 28853 | 34 | ||
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 | ||
193143 | 44206 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 576 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52611 | 6003624.01893692 | 2104922.29831142 | 37.7599206217144 | -122.430545363422 | (37.7599206217144, -122.430545363422) | 2 | 4 | 5 | 28862 | 3 | |
194434 | 37829 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 450X Moscow St | 17 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:54:00 AM | 3 | 3x3 | Permit Number 40134 | 6003878.28183 | 2090416.42534 | 37.7201052157501 | -122.428631950629 | (37.7201052157501, -122.428631950629) | 9 | 7 | 6 | 28861 | 5 |
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 | |
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 | |
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 | |
154111 | 6541 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1201 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1997 12:00:00 AM | 3 | 4X4 | 6017765.6846273 | 2096901.7583545 | 37.7386888362962 | -122.381078057558 | (37.7386888362962, -122.381078057558) | 10 | 3 | 8 | 58 | 1 | ||
75164 | 256027 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1330 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 6016370 | 2093149 | 37.7283073735733 | -122.385642243241 | (37.7283073735733, -122.385642243241) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |
13708 | 243312 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 43 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6006015.19315 | 2105235.08241 | 37.7609146228339 | -122.42229766482 | (37.7609146228339, -122.42229766482) | 2 | 4 | 5 | 28859 | 19 | |||
94395 | 84815 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 716 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2007 12:00:00 AM | 5 | 4x4 | Permit No. 49227 | 6001220 | 2102216 | 37.7523533016427 | -122.438665759041 | (37.7523533016427, -122.438665759041) | 2 | 4 | 5 | 28862 | 22 | |
180108 | 64097 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1275 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | 4x4 | Permit Number 53106 | 5992357.42606092 | 2106782.26411484 | 37.7643829076917 | -122.469646088045 | (37.7643829076917, -122.469646088045) | 11 | 8 | 11 | 56 | 12 | ||
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 | |||
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 | |||
6840 | 146944 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 657 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 5982245.6447 | 2111287.33209 | 37.7761629024372 | -122.504953198457 | (37.7761629024372, -122.504953198457) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
13639 | 147784 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 237 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 5991492.63835 | 2113823.73496 | 37.7836668536977 | -122.473150680654 | (37.7836668536977, -122.473150680654) | 11 | 6 | 2 | 54 | 26 | |||
38508 | 93522 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 36 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 4x5 | Permit Number 53241 | 6001363.6 | 2107898.4 | 37.7679639544684 | -122.438576280736 | (37.7679639544684, -122.438576280736) | 15 | 5 | 5 | 29492 | 3 | ||
12619 | 261103 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 67 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013064 | 2090741 | 37.7215120099241 | -122.396902551001 | (37.7215120099241, -122.396902551001) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
18202 | 167215 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 241 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6002729.33729 | 2104497.2521 | 37.7587028229819 | -122.433609252083 | (37.7587028229819, -122.433609252083) | 2 | 4 | 5 | 28862 | 3 | |||
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 |
19206 | 71692 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 364 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 26 | 6x7 | 6006147.03421 | 2111101.36218 | 37.7770294657815 | -122.422258481339 | (37.7770294657815, -122.422258481339) | 7 | 9 | 11 | 28852 | 10 | ||
117952 | 161318 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 530 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:04:00 AM | 3 | Width 0ft | 6002775.65928 | 2090671.86234 | 37.7207441256113 | -122.432461575944 | (37.7207441256113, -122.432461575944) | 9 | 7 | 6 | 28861 | 5 | |
194441 | 180986 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 363 Munich St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/11/2017 09:24:00 AM | 3 | Width 10ft | 6004214.2336 | 2090323.21202 | 37.7198682794893 | -122.427464041535 | (37.7198682794893, -122.427464041535) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |
6837 | 167024 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 464 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002938.64707 | 2105560.74079 | 37.7616347810493 | -122.4329613427 | (37.7616347810493, -122.4329613427) | 15 | 4 | 5 | 28862 | 3 | |||
8970 | 171237 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 33 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003785.69947 | 2093212.07448 | 37.7277762088874 | -122.429151209279 | (37.7277762088874, -122.429151209279) | 9 | 7 | 6 | 28861 | 5 | ||
18153 | 167505 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 3516 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003321.88174 | 2106561.08485 | 37.7644032144593 | -122.431707314554 | (37.7644032144593, -122.431707314554) | 15 | 4 | 5 | 28862 | 3 | |||
92899 | 190438 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1350 Evans Ave | 4 | : | Tree | DPW 1 | 03/18/2017 11:59:00 AM | 3 | Width 3ft | 6016891.21359 | 2097667.15217 | 37.7407421449384 | -122.38415488076 | (37.7407421449384, -122.38415488076) | 10 | 3 | 8 | 58 | 1 | ||
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 |
117072 | 190439 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1350 Evans Ave | 6 | : | Tree | DPW 1 | 03/18/2017 11:54:00 AM | 3 | Width 3ft | 6016857.78658 | 2097692.82931 | 37.7408108009722 | -122.384272247659 | (37.7408108009722, -122.384272247659) | 10 | 3 | 8 | 58 | 1 | ||
120431 | 188691 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 45 | : | Tree | DPW 1 | 03/18/2017 02:26:00 PM | 3 | Width 3ft | 6017107.93008 | 2097506.97635 | 37.7403143140663 | -122.38339440234 | (37.7403143140663, -122.38339440234) | 10 | 3 | 8 | 58 | 1 | ||
149263 | 188692 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 46 | : | Tree | DPW 1 | 03/18/2017 02:33:00 PM | 3 | Width 3ft | 6017090.76081 | 2097520.28707 | 37.7403499137184 | -122.383454693803 | (37.7403499137184, -122.383454693803) | 10 | 3 | 8 | 58 | 1 | ||
177500 | 188690 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1300 Evans Ave | 44 | : | Tree | DPW 1 | 03/18/2017 02:23:00 PM | 3 | Width 3ft | 6017127.64655 | 2097493.15124 | 37.7402774427419 | -122.383325267851 | (37.7402774427419, -122.383325267851) | 10 | 3 | 8 | 58 | 1 |
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) );