169 rows where qSpecies_id = 3 sorted by rowid 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)
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
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
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
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
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
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
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
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
184142 6604 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 1400 Evans Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   6016747.6410828 2097755.6169144 37.7409771122017 -122.384657465748 (37.7409771122017, -122.384657465748) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
144863 19102 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 286 Sagamore St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/2000 12:00:00 AM 3 3X3   5994140.1842159 2087463.5149143 37.7114413003767 -122.462078982125 (37.7114413003767, -122.462078982125) 9 8 6 28861 24
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
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
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
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
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
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
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
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
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
128206 26749 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 2099X Post St 11 Sidewalk: Curb side : Cutout Tree Rec/Park 5   09/28/1999 12:00:00 AM 3 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199) 13 6 11 29490 13
125974 1404 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 63 Ardath Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/30/1996 12:00:00 AM 6 3X4   6017388.8354209 2095314.9218023 37.7343108905935 -122.382270670557 (37.7343108905935, -122.382270670557) 10 3 8 58 1
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
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
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
121223 6643 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 1499 Evans Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2009 12:00:00 AM 3 3X3   6016187.3727289 2098094.9741145 37.7418779170755 -122.386618343631 (37.7418779170755, -122.386618343631) 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
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
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
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
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
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
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
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
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
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
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
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
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
107040 82648 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 56 Julian Ave 10 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM 3 3x3 Permit Number 52215 6006376.13216739 2107553.16833294 37.7672998944856 -122.421213943138 (37.7672998944856, -122.421213943138) 8 4 7 28853 19
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
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
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
101551 14519 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 607 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/27/1999 12:00:00 AM 8 3X3   5999088.24175 2110697.41803 37.7755196490068 -122.446647872043 (37.7755196490068, -122.446647872043) 15 5 11 29492 16
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
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
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
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
97832 87856 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 330X Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2008 12:00:00 AM 3 3x3 Permit Number 50790 6002852.8 2106288.8 37.7636289858331 -122.433310278834 (37.7636289858331, -122.433310278834) 15 4 5 28862 3
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
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
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
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
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
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
91803 72659 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 56 Julian Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM 3 3x3 Permit Number 52215 6006374.23290867 2107587.4469069 37.7673939082567 -122.421222946795 (37.7673939082567, -122.421222946795) 8 4 7 28853 19
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
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
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
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
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
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
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
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
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
80157 24936 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 2099X Post St 17 Sidewalk: Curb side : Cutout Tree Rec/Park 5   12/21/2007 12:00:00 AM 36 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199) 13 6 11 29490 13
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
78960 36710 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 56 Julian Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM 3 3x3 Permit Number 52215 6006374.23290867 2107587.4469069 37.7673939082567 -122.421222946795 (37.7673939082567, -122.421222946795) 8 4 7 28853 19
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
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
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
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
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

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