169 rows where qSpecies_id = 3 sorted by DBH

View and edit SQL

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)
85 259368 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 1646 Revere Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
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
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
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
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
8235 95395 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 132 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2010 12:00:00 AM   3x3 Permit Number 767268 6004263.4 2101646.1 37.750961152597 -122.428100577401 (37.750961152597, -122.428100577401) 2 4 5 28862 22
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
13212 87784 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 48 Santa Ysabel Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50524 6000929.5 2093152.6 37.7274508049284 -122.439020861215 (37.7274508049284, -122.439020861215) 9 7 6 28861 25
14422 264660 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 1026 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/10/2020 12:00:00 AM   3x3   6014740.42217 2089801.7979 37.7190263183384 -122.391041957232 (37.7190263183384, -122.391041957232) 10 3 8 58 1
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
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
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
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
42802 95537 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 4215 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767325 6002474 2101197 37.7496266270423 -122.434256385957 (37.7496266270423, -122.434256385957) 2 4 5 28862 22
51160 96776 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 226 27TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2011 12:00:00 AM     Permit Number 767240 6004896 2100216 37.7470701993865 -122.425811201312 (37.7470701993865, -122.425811201312) 2 7 5 63 22
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
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
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
57121 95584 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 202 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767374 6004110 2102157 37.7523552842072 -122.428667464963 (37.7523552842072, -122.428667464963) 2 4 5 28862 22
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
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
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
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
70537 95397 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 1211 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767271 6003877 2101229 37.7497940241726 -122.429407044967 (37.7497940241726, -122.429407044967) 2 4 5 28862 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
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
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
76668 88258 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 327 Carl St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51243 5996646 2106962 37.7651233493989 -122.454826175676 (37.7651233493989, -122.454826175676) 15 5 11 29492 12
79970 94823 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 1247 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53903 5990745.7 2106901.7 37.7646175620315 -122.475229262837 (37.7646175620315, -122.475229262837) 11 8 3 56 12
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
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
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
87504 87033 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 30 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/2010 12:00:00 AM   3x3 Permit Number 53735 6001416 2107932 37.7680591923974 -122.43839744289 (37.7680591923974, -122.43839744289) 15 5 5 29492 3
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
87955 35400 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 527 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2008 12:00:00 AM   3x3 Permit Number 50782 6003213.78352736 2098311.09733417 37.7417445720019 -122.431492193982 (37.7417445720019, -122.431492193982) 2 7 5 63 7
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
90639 88246 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
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
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
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
97053 84461 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 714-716 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2009 12:00:00 AM   3x3 Permit Number 52661 6010104.93425212 2104957.66520048 37.7603827422102 -122.408133417925 (37.7603827422102, -122.408133417925) 2 4 8 28859 19
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
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
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
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
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
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
110670 43224 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 1682 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52405 5990924.01024208 2103958.73208826 37.7565472889648 -122.474397763174 (37.7565472889648, -122.474397763174) 1 8 4 56 12
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
112577 91576 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
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
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
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
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
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
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
151570 96775 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 226 27TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2011 12:00:00 AM     Permit Number 767240 6004896 2100216 37.7470701993865 -122.425811201312 (37.7470701993865, -122.425811201312) 2 7 5 63 22
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
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
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
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
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
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
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
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
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
15797 69451 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 446 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/1994 12:00:00 AM 1   Permit Number 33561 5985648.90845 2112873.99944 37.78071907161 -122.493297480343 (37.78071907161, -122.493297480343) 11 6 2 55 26
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
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
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
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
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
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
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
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
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
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
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
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
9308 262183 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 550 Delta St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3                        
11065 259366 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 1630 Revere Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/25/2019 12:00:00 AM 3     6014976.19391 2094504.46411 37.731951983893 -122.390555407158 (37.731951983893, -122.390555407158) 10 3 8 58 1
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
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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);