3,247 rows where qSpecies_id = 22 sorted by PlantDate descending

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)
80242 108622 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 244 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3   Permit Number 772819 6002313.92049 2109316.75363 37.7719124170473 -122.435390704283 (37.7719124170473, -122.435390704283) 15 5 11 29492 9
57184 68938 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 521 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 4   Permit Number 32923 5992494.17103 2111890.59208 37.7784169086099 -122.469545019028 (37.7784169086099, -122.469545019028) 11 6 2 54 11
189175 6662 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1550 Evans Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/1992 12:00:00 AM 6 3X3   6016012.05161 2098330.17252 37.7425140162093 -122.387240954701 (37.7425140162093, -122.387240954701) 10 3 8 58 1
17481 52506 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 180 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48613 6000220.46380878 2092503.12984203 37.7256271406599 -122.441425411243 (37.7256271406599, -122.441425411243) 9 7 6 28861 25
11309 44191 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 12 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
37647 44195 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
42164 44189 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
51369 44194 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 8 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
72872 44190 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 13 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
103647 44198 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM 4   Permit Number 43651 6015613.21564 2115159.68111 37.7887020993715 -122.389795273027 (37.7887020993715, -122.389795273027) 6 2 9 28855 6
111099 44201 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 9 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
121191 44192 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 11 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
132960 44196 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM 4   Permit Number 43651 6015590.27485 2115136.01269 37.7886358391193 -122.389872991572 (37.7886358391193, -122.389872991572) 6 2 9 28855 6
142441 44193 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 10 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
184190 44197 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM 4   Permit Number 43651 6015604.12637 2115150.5006 37.7886763877505 -122.389826079337 (37.7886763877505, -122.389826079337) 6 2 9 28855 6
103602 68859 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 378 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1993 12:00:00 AM     Permit Number 32822 5998916.65569414 2094404.18671819 37.730772635316 -122.44606923013 (37.730772635316, -122.44606923013) 9 7 4 59 40
149010 46119 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44476 6015543.8 2115940.8 37.7908430231508 -122.390090033136 (37.7908430231508, -122.390090033136) 6 2 9 28855 6
124981 40943 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 337 Capistrano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3   Permit Number 773706 6001124.10704 2092689.09329 37.726189192361 -122.438314913304 (37.726189192361, -122.438314913304) 9 7 6 28861 25
158956 108542 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 225 Capistrano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773703 6001152.31796 2093187.75047 37.7275599956139 -122.438253097429 (37.7275599956139, -122.438253097429) 9 7 6 28861 25
89821 102141 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 53 Wilder St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2012 12:00:00 AM 3 2x3 Permit Number 769415 6002570.6 2095528.3 37.7340671770771 -122.433517283514 (37.7340671770771, -122.433517283514) 2 7 5 63 7
111982 102142 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 53 Wilder St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2012 12:00:00 AM 5 2x3 Permit Number 769415 6002570.6 2095528.3 37.7340671770771 -122.433517283514 (37.7340671770771, -122.433517283514) 2 7 5 63 7
77218 14417 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10X Masonic Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   12/24/2003 12:00:00 AM 6 3X3   5998974.44495 2113166.80204 37.7822934388942 -122.447219282802 (37.7822934388942, -122.447219282802) 15 5 1 54 16
30397 31035 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 300 Bennington St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2015 12:00:00 AM 1   Permit Number 771782 6007054.85561 2096718.77749 37.7375893700518 -122.418098149219 (37.7375893700518, -122.418098149219) 2 7 7 28859 2
125027 108519 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1241 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773665 5994833.54334 2107094.83383 37.7653839436153 -122.461104605949 (37.7653839436153, -122.461104605949) 15 5 11 56 12
192106 108516 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 695-699X 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773792 5993787.87218 2111075.28381 37.7762529739024 -122.465010427519 (37.7762529739024, -122.465010427519) 11 6 2 54 11
5809 62467 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 710 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/1985 12:00:00 AM 10   Permit Number 22636 6011241.19795 2104960.20112 37.760453261625 -122.404203766595 (37.760453261625, -122.404203766595) 10 3 8 28856 29
133240 4174 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3809 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/22/2014 12:00:00 AM 3 3x3   6005074.45285 2100459.68403 37.7477493826385 -122.425211462866 (37.7477493826385, -122.425211462866) 2 4 5 63 22
184037 55930 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1680 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2009 12:00:00 AM   3x3 Permit Number 53115 5992813.78045219 2104035.719351 37.7568679811889 -122.467867918822 (37.7568679811889, -122.467867918822) 1 8 4 56 12
3744 39401 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
17318 39391 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 15 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
29930 39397 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 17 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
110065 39405 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
112855 39393 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 14 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
115675 39398 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 9 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
128334 39395 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 12 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
135278 39400 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
136039 39390 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 10 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
137798 39402 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
143628 39394 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 13 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
156544 39392 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
159940 39399 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 8 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
161029 39389 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 16 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
172309 39404 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
172550 39396 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 11 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
176882 39403 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1690 Church St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40927 6004593.43741133 2099046.93821221 37.7438431217943 -122.426774196771 (37.7438431217943, -122.426774196771) 2 7 5 63 22
71987 226129 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 468 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2016 12:00:00 AM 9 Width 3ft   6002897.69632 2099218.59818 37.7442184383445 -122.432649927259 (37.7442184383445, -122.432649927259) 2 7 5 63 22
87656 64270 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1649 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2012 12:00:00 AM     Permit Number 769488 6009729.21200973 2100183.41630946 37.7472526761303 -122.409095988159 (37.7472526761303, -122.409095988159) 2 7 7 28859 2
154256 44131 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2820 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2000 12:00:00 AM 4   Permit Number 43633 6005248.14777 2119695.60909 37.8005763744637 -122.425979944327 (37.8005763744637, -122.425979944327) 13 9 1 57 17
194343 265044 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1250 Eucalyptus Dr 3 Sidewalk: Property side : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
194346 265043 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1250 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
132750 5491 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 730 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/17/2007 12:00:00 AM 3 3X3   6004960.44837 2104097.58597 37.7577317737189 -122.425864595473 (37.7577317737189, -122.425864595473) 2 4 5 28862 3
182031 5198 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 635 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2001 12:00:00 AM 3 3x3   6001582.4984 2110645.9942 37.775520613317 -122.43801597154 (37.775520613317, -122.43801597154) 15 5 11 29492 10
70152 57739 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1430 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1992 12:00:00 AM 1   Permit Number 31420 6009340.15372 2118176.38357 37.7966353671694 -122.411712476165 (37.7966353671694, -122.411712476165) 3 1 10 308 4
146429 67806 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 867 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31457 6000839.18474715 2101975.25274037 37.751670596488 -122.439965416077 (37.751670596488, -122.439965416077) 2 4 5 28862 22
190998 61749 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3849 26TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1984 12:00:00 AM 12 3x3 Permit Number 21755 6004830.1 2100717.5 37.7484434784717 -122.426074773634 (37.7484434784717, -122.426074773634) 2 4 5 63 22
110749 53556 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 155 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/1969 12:00:00 AM 5   Permit Number 6468 5990822.61349 2114386.11588 37.7851721782666 -122.47550976424 (37.7851721782666, -122.47550976424) 11 6 2 54 26
154273 52406 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 51 Virginia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/2005 12:00:00 AM     Permit Number 48525 6006289.36692321 2098690.46221528 37.7429600597297 -122.420884755481 (37.7429600597297, -122.420884755481) 2 7 7 28859 2
107263 16534 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1420X Evans Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2004 12:00:00 AM 3 3X3   6016649.3386754 2097853.1412174 37.7412394571821 -122.385004155587 (37.7412394571821, -122.385004155587) 10 3 8 58 1
94289 59558 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 214 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/15/1992 12:00:00 AM 8   Permit Number 31386 6004840.03316 2093769.64251 37.7293667957293 -122.42554602055 (37.7293667957293, -122.42554602055) 9 7 6 28861 5
29912 55609 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 142 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/15/1972 12:00:00 AM 1   Permit Number 11586 5992448.32925563 2114520.13069232 37.7856342525233 -122.469895103767 (37.7856342525233, -122.469895103767) 11 6 2 54 11
162523 92855 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1101 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2009 12:00:00 AM     Permit Number 53074 6001966 2100891 37.7487575771252 -122.435991171851 (37.7487575771252, -122.435991171851) 2 4 5 28862 22
114600 24370 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 170 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2007 12:00:00 AM 3 3X3   6005596.02318 2108503.96371 37.7698665410346 -122.423979852088 (37.7698665410346, -122.423979852088) 8 4 5 28853 19
192668 46083 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 678 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2001 12:00:00 AM 1   Permit Number 44461 6009646.5972 2120203.7861 37.8022193006044 -122.4107953652 (37.8022193006044, -122.4107953652) 3 1 10 308 23
8668 39268 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 540 Delancey St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/1998 12:00:00 AM 8 3x3 Permit Number 40880 6015240.80145 2113614.13929 37.7844377354544 -122.390975718675 (37.7844377354544, -122.390975718675) 6 2 9 28856 6
18366 39267 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 540 Delancey St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/1998 12:00:00 AM 8 3x3 Permit Number 40880 6015247.62996 2113604.71354 37.7844122333873 -122.390951435185 (37.7844122333873, -122.390951435185) 6 2 9 28856 6
68756 52343 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 9 Madrone Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2005 12:00:00 AM     Permit Number 48487 5993020.12336705 2099071.55255043 37.7432495660688 -122.466793461069 (37.7432495660688, -122.466793461069) 1 8 4 59 40
191435 71800 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2169 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2008 12:00:00 AM   3x3 Permit Number 51966 5997498.69727055 2109850.09270913 37.7731021869441 -122.45208531215 (37.7731021869441, -122.45208531215) 15 5 11 29492 16
42742 81988 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 442 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2007 12:00:00 AM 3 3x3 Permit Number 50000 5982237.66367 2112787.15702 37.7802805115522 -122.505091982727 (37.7802805115522, -122.505091982727) 11 6 2 55 26
97347 23631 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 57 Virginia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2003 12:00:00 AM 3 3X3   6006306.857782 2098679.9716835 37.7429322409736 -122.420823532183 (37.7429322409736, -122.420823532183) 2 7 7 28859 2
48498 33757 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 16 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/1996 12:00:00 AM     Permit Number 37810 6003402.50922955 2107448.70310464 37.766844969098 -122.431491817447 (37.766844969098, -122.431491817447) 15 5 5 28862 3
144884 66772 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2 Pearl St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/10/1994 12:00:00 AM     Permit Number 30031 6005583.60582108 2109041.70693845 37.771342353738 -122.424061050426 (37.771342353738, -122.424061050426) 8 2 5 28853 19
73831 31450 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 515 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM 1 3x3 Permit Number 53997 6001863.73934 2102822.19649 37.754054372127 -122.436482991608 (37.754054372127, -122.436482991608) 2 4 5 28862 22
97514 28491 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1444 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/09/2003 12:00:00 AM 8 3X3   6005199.4144851 2099918.543192 37.7462705927584 -122.424740860946 (37.7462705927584, -122.424740860946) 2 7 5 63 22
6645 226161 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 126 Grattan St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/1993 12:00:00 AM 9 Width 4ft Permit Number 32799 5997997.11826 2106529.02842 37.76401192934 -122.450121798605 (37.76401192934, -122.450121798605) 15 5 11 29492 9
90305 58586 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 126 Grattan St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/1993 12:00:00 AM   4x4 Permit Number 32799 5998027.55181779 2106540.68640664 37.7640456807087 -122.450017378701 (37.7640456807087, -122.450017378701) 15 5 11 29492 9
177192 5603 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1126 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/08/2003 12:00:00 AM 3 3x3   6005088.25831 2101777.30613 37.7513680486157 -122.425257470357 (37.7513680486157, -122.425257470357) 2 4 5 28862 22
135489 46068 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2318 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2001 12:00:00 AM 4   Permit Number 44453 6011842.96838 2101888.73185 37.7520532897435 -122.401906592314 (37.7520532897435, -122.401906592314) 10 3 8 28856 29
40881 5297 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1600 Divisadero St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/07/1995 12:00:00 AM 3 2X3   6001162.4866 2114099.2454 37.7849784685073 -122.439716519057 (37.7849784685073, -122.439716519057) 15 6 11 29490 13
26417 66310 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 136 Hamerton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29425 6001332.72327258 2095407.42415394 37.7336649686266 -122.43778834571 (37.7336649686266, -122.43778834571) 9 7 5 63 40
41278 66312 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 143 Hamerton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29427 6001377.41574875 2095374.46813255 37.7335770202313 -122.437631471673 (37.7335770202313, -122.437631471673) 9 7 5 63 40
191260 66309 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 132 Hamerton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29424 6001336.27411679 2095419.91678069 37.7336994724005 -122.437776963861 (37.7336994724005, -122.437776963861) 9 7 5 63 40
28883 34868 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 448 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2007 12:00:00 AM   3x3 Permit Number 49951 6003547.62609569 2096418.61112327 37.7365671542892 -122.430202896046 (37.7365671542892, -122.430202896046) 2 7 5 63 7
65840 228317 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 119 Germania St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM 3 Width 3ft Permit Number 37770 6003543.43313 2108799.052 37.7705606845675 -122.4311007758 (37.7705606845675, -122.4311007758) 15 9 11 29492 10
61826 67724 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1346 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1992 12:00:00 AM     Permit Number 31342 5992116.05706304 2106274.73338322 37.7629754095582 -122.470443943147 (37.7629754095582, -122.470443943147) 1 8 11 56 12
137420 33661 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 483 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/03/1996 12:00:00 AM 2   Permit Number 37749 6005107.1966 2110751.602 37.7760104013227 -122.425830703288 (37.7760104013227, -122.425830703288) 7 9 11 28852 10
191006 52307 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 125 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/02/2005 12:00:00 AM     Permit Number 48466 6004248.12570039 2092925.52836922 37.7270155836301 -122.427532186974 (37.7270155836301, -122.427532186974) 9 7 6 28861 5
77760 50610 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 307 Spruce St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2003 12:00:00 AM 5   Permit Number 47207 5997118.78265 2115251.45908 37.7879111492194 -122.453789601717 (37.7879111492194, -122.453789601717) 11 6 1 54 31
150710 50609 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 307 Spruce St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2003 12:00:00 AM 5   Permit Number 47207 5997116.52559 2115267.78958 37.7879558590154 -122.45379859043 (37.7879558590154, -122.45379859043) 11 6 1 54 31
147257 114690 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 173 Girard St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM 1   Permit Number 774716 6010597.60785 2093917.85298 37.7300973914745 -122.405651885519 (37.7300973914745, -122.405651885519) 10 3 7 309 28
28328 45196 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3379 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/01/2001 12:00:00 AM     Permit Number 44041 6005846.47654917 2103129.45360257 37.7551235392216 -122.422731541054 (37.7551235392216, -122.422731541054) 2 4 5 28859 19
24674 12708 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1448 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/1992 12:00:00 AM 8 3X3   5990942.238 2114788.08158 37.7862827977651 -122.475125259251 (37.7862827977651, -122.475125259251) 11 6 1 54 33
164081 12702 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1415 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/1992 12:00:00 AM 6 3X3   5991067.52539 2114735.08687 37.7861445496005 -122.474687932397 (37.7861445496005, -122.474687932397) 11 6 2 54 26
142427 114668 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 176X Peralta Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM     Permit Number 774564 6009847.7 2100071.6 37.7469522901695 -122.408678376857 (37.7469522901695, -122.408678376857) 2 7 7 28859 2
158621 14415 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10X Masonic Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/30/2014 11:00:00 PM 3 3X3   5998974.44495 2113166.80204 37.7822934388942 -122.447219282802 (37.7822934388942, -122.447219282802) 15 5 1 54 16
63259 55483 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 541 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/1972 12:00:00 AM     Permit Number 11436 6002127.49962023 2110317.53066038 37.774649712906 -122.436107174272 (37.774649712906, -122.436107174272) 15 5 11 29492 10
134329 56346 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 615 Front St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2017 12:00:00 AM 3   Permit Number 12488 6012822.94142 2118342.56385 37.797286416082 -122.399672847242 (37.797286416082, -122.399672847242) 3 1 10 28860 6
8732 261131 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 205 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6002921 2092296 37.725211886246 -122.432075099304 (37.725211886246, -122.432075099304) 9 7 6 28861 5
42367 101840 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 654 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2012 12:00:00 AM 1 3x3 Permit Number 769499 6011223.03061 2105283.28605 37.7613393654344 -122.404289339783 (37.7613393654344, -122.404289339783) 10 3 8 28856 29
21207 33596 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 224 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/27/1996 12:00:00 AM     Permit Number 37704 6006764.88220944 2097872.66772056 37.7407413706298 -122.419182553853 (37.7407413706298, -122.419182553853) 2 7 7 28859 2
181157 33594 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 208 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/1996 12:00:00 AM     Permit Number 37702 6006803.38226824 2097943.62645623 37.7409383755984 -122.419054466757 (37.7409383755984, -122.419054466757) 2 7 7 28859 2

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