508 rows where qSpecies_id = 25 sorted by XCoord

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)
1940 43017 Permitted Site 7 Geijera parviflora :: Australian Willow 25   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
2319 34069 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
3439 43015 Permitted Site 7 Geijera parviflora :: Australian Willow 25   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
5259 45154 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1683 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2001 12:00:00 AM     Permit Number 44007                    
5523 38232 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
6572 34068 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
6767 38234 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
7060 38233 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
7097 34072 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
7436 43016 Permitted Site 7 Geijera parviflora :: Australian Willow 25   4 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
9043 43018 Permitted Site 7 Geijera parviflora :: Australian Willow 25   3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
9398 264655 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1099 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/08/2020 04:53:00 PM   3x3                      
12809 38231 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
14576 34071 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
16742 34070 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
17098 34067 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
43773 21413 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2692X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree DPW 1     2     5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
31262 69447 Permitted Site 7 Geijera parviflora :: Australian Willow 25 479 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/1994 12:00:00 AM     Permit Number 33557 5985917.32246977 2112668.61009419 37.7801708274431 -122.492353790965 (37.7801708274431, -122.492353790965) 11 6 2 55 26
732 181868 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2335 28th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   02/24/2020 12:00:00 AM 3 5x5   5987618.1769 2099375.389 37.7437705756333 -122.485494034638 (37.7437705756333, -122.485494034638) 1 8 3 29491 35
29569 105213 Undocumented 4 Geijera parviflora :: Australian Willow 25 2400X 21ST AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5989837 2098691 37.7420204448441 -122.477771936587 (37.7420204448441, -122.477771936587) 1 8 3 29491 35
161550 105214 Undocumented 4 Geijera parviflora :: Australian Willow 25 2400X 21ST AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5989837 2098691 37.7420204448441 -122.477771936587 (37.7420204448441, -122.477771936587) 1 8 3 29491 35
178381 254173 Significant Tree 6 Geijera parviflora :: Australian Willow 25 1850 19th Ave 1 Front Yard : Yard Tree Private 2       3x6   5990394 2102783 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826) 1 8 4 56 12
37585 105310 Undocumented 4 Geijera parviflora :: Australian Willow 25 355 17TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3 x4   5990544.7 2113008.3 37.781372965217 -122.476370566984 (37.781372965217, -122.476370566984) 11 6 2 55 26
63451 105311 Undocumented 4 Geijera parviflora :: Australian Willow 25 455 17TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4x3   5990571.2 2112282.7 37.7793822053088 -122.476225875432 (37.7793822053088, -122.476225875432) 11 6 2 55 26
130161 122086 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 459 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5990589.94258 2112248.552 37.7792895311955 -122.476158542806 (37.7792895311955, -122.476158542806) 11 6 2 55 26
165027 81695 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 539 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2009 12:00:00 AM 5 3x3 Permit Number 52514 5990609.14307 2111709.86868 37.7778115687685 -122.476052767078 (37.7778115687685, -122.476052767078) 11 6 2 55 26
52069 60140 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1807 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1982 12:00:00 AM     Permit Number 19670 5991211.56683637 2103102.96288703 37.7542142276367 -122.473340885597 (37.7542142276367, -122.473340885597) 1 8 4 56 12
164529 60139 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1825 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1982 12:00:00 AM     Permit Number 19669 5991215.5539121 2102985.82371421 37.7538928250767 -122.473318554461 (37.7538928250767, -122.473318554461) 1 8 4 56 12
180292 217005 Permitted Site 7 Geijera parviflora :: Australian Willow 25 532 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2018 12:00:00 AM 3 3x12 Permit Number 782164 5991273.49549 2097061.96197 37.737630785637 -122.472686293253 (37.737630785637, -122.472686293253) 1 8 4 29491 40
151826 255813 Permitted Site 7 Geijera parviflora :: Australian Willow 25 532 Wawona St 1 Front Yard : Yard Tree Private 2   07/24/2018 12:00:00 AM 3 3X3 Permit Number 782164 5991340.67425 2097062.85197 37.7376371178542 -122.472454091358 (37.7376371178542, -122.472454091358) 1 8 4 29491 40
149342 35091 Permitted Site 7 Geijera parviflora :: Australian Willow 25 920 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 15 3x3 Permit Number 42238 5992055.93239281 2105259.4330846 37.7601841866451 -122.470577939927 (37.7601841866451, -122.470577939927) 1 8 4 56 12
163091 35092 Permitted Site 7 Geijera parviflora :: Australian Willow 25 920 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1998 12:00:00 AM 25 3x3 Permit Number 38633 5992055.93239281 2105259.4330846 37.7601841866451 -122.470577939927 (37.7601841866451, -122.470577939927) 1 8 4 56 12
8908 69088 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1474 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33098 5992145.68632685 2105413.48754834 37.7606123691548 -122.470278745237 (37.7606123691548, -122.470278745237) 1 8 4 56 12
43636 94704 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 670 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM 2 3x3 Permit Number 53844 5992265.91007 2110887.94739 37.7756507238334 -122.470261618584 (37.7756507238334, -122.470261618584) 11 6 2 54 11
11255 70154 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 339 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     5992446.53753 2113177.4125 37.7819474134806 -122.469803511026 (37.7819474134806, -122.469803511026) 11 6 2 54 11
15349 122920 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 330 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2020 12:00:00 AM 3 Width 2ft   5992493.10071 2113220.22773 37.7820676636923 -122.469645543184 (37.7820676636923, -122.469645543184) 11 6 2 54 11
22267 82278 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 245 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2008 12:00:00 AM 5 3x3 Permit Number 50610 5992733.47806 2113805.1753 37.7836876598148 -122.468856534024 (37.7836876598148, -122.468856534024) 11 6 2 54 11
183813 219000 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1775 11th Ave 1 Sidewalk: Property side : Yard Tree Private 2     29 Width 3ft   5992776.7043 2103406.16926 37.7551372592989 -122.467950350926 (37.7551372592989, -122.467950350926) 1 8 4 56 12
88273 219005 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1838 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5992852.04405 2102933.06242 37.7538425808737 -122.467655401194 (37.7538425808737, -122.467655401194) 1 8 4 56 12
22131 49877 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1331@ IRVING 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2003 12:00:00 AM     Permit Number 46643 5992989.81423972 2106408.90402865 37.7633942890183 -122.467431700246 (37.7633942890183, -122.467431700246) 1 8 11 56 12
135416 219002 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1333 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5992990.51198 2106402.84909 37.7633777040321 -122.467428846685 (37.7633777040321, -122.467428846685) 1 8 11 56 12
45794 108472 Permitted Site 7 Geijera parviflora :: Australian Willow 25 462 09th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 773779 5993142.3505 2112335.01081 37.7796746015568 -122.467335065866 (37.7796746015568, -122.467335065866) 11 6 2 54 11
179219 123212 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 462 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5993143.5323 2112325.5219 37.7796486158053 -122.467330287378 (37.7796486158053, -122.467330287378) 11 6 2 54 11
82591 219004 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1655 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 3ft   5993378.4627 2104217.9895 37.7574010390349 -122.46592829725 (37.7574010390349, -122.46592829725) 1 8 4 56 12
180610 219003 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1461 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5993948.08517 2105555.37526 37.7611059976579 -122.464055414128 (37.7611059976579, -122.464055414128) 1 5 11 56 12
129612 46907 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1461 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2002 12:00:00 AM     Permit Number 44964 5993949.00931755 2105566.46922701 37.7611365120681 -122.464053023285 (37.7611365120681, -122.464053023285) 1 5 11 56 12
16772 113034 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 251 06th Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5993975.1139 2113804.1265 37.7837564355183 -122.464560902617 (37.7837564355183, -122.464560902617) 11 6 2 54 11
15256 259564 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 200 Public Park 3 Unaccepted Street : Cutout Tree Private 2       5x10   5994204 2098512 37.741781429361 -122.462659374294 (37.741781429361, -122.462659374294) 1 8 4 59 40
57319 65448 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 72 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/08/1989 12:00:00 AM 9   Permit Number 28322 5994279.76671 2115099.74179 37.7873314010144 -122.463600988074 (37.7873314010144, -122.463600988074) 11 6 1 54 11
15108 113387 Permitted Site 7 Geijera parviflora :: Australian Willow 25 185 CASTENADA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     3     5994493 2100782 37.7480309194949 -122.461824674651 (37.7480309194949, -122.461824674651) 1 8 4 29491 40
55201 113388 Permitted Site 7 Geijera parviflora :: Australian Willow 25 185 CASTENADA AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     3     5994493 2100782 37.7480309194949 -122.461824674651 (37.7480309194949, -122.461824674651) 1 8 4 29491 40
89613 113389 Permitted Site 7 Geijera parviflora :: Australian Willow 25 185 CASTENADA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     3     5994493 2100782 37.7480309194949 -122.461824674651 (37.7480309194949, -122.461824674651) 1 8 4 29491 40
68866 219001 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1225 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5994518.05416 2107169.56941 37.7655709877426 -122.462201222508 (37.7655709877426, -122.462201222508) 11 5 11 56 12
6809 65477 Permitted Site 7 Geijera parviflora :: Australian Willow 25 400 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/12/1989 12:00:00 AM     Permit Number 28358 5994782.15079154 2091255.17859292 37.7218892499679 -122.460134715976 (37.7218892499679, -122.460134715976) 9 8 4 28861 24
19037 163093 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 207 Minerva St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/30/2020 12:00:00 AM 3 Width 0ft   5994973.89241 2089001.27362 37.7157115895984 -122.459308778876 (37.7157115895984, -122.459308778876) 9 8 6 28861 24
35598 102652 Permitted Site 7 Geijera parviflora :: Australian Willow 25 203X Farallones St 1 Sidewalk: Curb side : Cutout Tree Private 2           5994989.5 2088377.3 37.7139992025898 -122.459209674514 (37.7139992025898, -122.459209674514) 9 8 6 28861 24
109140 102653 Permitted Site 7 Geijera parviflora :: Australian Willow 25 203X Farallones St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994989.5 2088377.3 37.7139992025898 -122.459209674514 (37.7139992025898, -122.459209674514) 9 8 6 28861 24
126710 46930 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1 Pacheco St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.7435241958304 -122.459369067857 (37.7435241958304, -122.459369067857) 1 8 4 59 40
159651 46927 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1 Pacheco St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.7435241958304 -122.459369067857 (37.7435241958304, -122.459369067857) 1 8 4 59 40
162728 46929 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1 Pacheco St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.7435241958304 -122.459369067857 (37.7435241958304, -122.459369067857) 1 8 4 59 40
177469 46928 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1 Pacheco St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.7435241958304 -122.459369067857 (37.7435241958304, -122.459369067857) 1 8 4 59 40
94709 219008 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 171 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 1ft Permit Number 781866 5995303 2091035 37.7213146365991 -122.45831835627 (37.7213146365991, -122.45831835627) 9 8 6 28861 24
35443 73660 Permitted Site 7 Geijera parviflora :: Australian Willow 25 157 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2013 12:00:00 AM 15   Permit Number 770522 5995314.7940966 2090940.29616255 37.7210552801536 -122.458270736601 (37.7210552801536, -122.458270736601) 9 8 6 28861 24
76115 71877 Permitted Site 7 Geijera parviflora :: Australian Willow 25 157 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2013 12:00:00 AM 10   Permit Number 770522 5995314.7940966 2090940.29616255 37.7210552801536 -122.458270736601 (37.7210552801536, -122.458270736601) 9 8 6 28861 24
123075 219012 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 139 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5995316.47386 2090822.54609 37.7207320630034 -122.458256412004 (37.7207320630034, -122.458256412004) 9 8 6 28861 24
31931 219011 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 157 Miramar Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5995317.53334 2090902.82075 37.7209525389978 -122.458258556883 (37.7209525389978, -122.458258556883) 9 8 6 28861 24
161331 219010 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 157 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5995318.05663 2090927.82531 37.7210212256375 -122.458258556898 (37.7210212256375, -122.458258556898) 9 8 6 28861 24
114891 219009 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 161 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5995318.79946 2090948.50153 37.7210780403007 -122.458257484914 (37.7210780403007, -122.458257484914) 9 8 6 28861 24
76881 219007 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 207 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5995325.39637 2091321.08064 37.7221014328296 -122.458261634395 (37.7221014328296, -122.458261634395) 9 8 4 28861 24
165638 219006 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 221 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5995326.92312 2091423.08508 37.7223816004164 -122.458263736089 (37.7223816004164, -122.458263736089) 9 8 4 28861 24
166847 219013 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 154 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5995360.70731 2090920.75617 37.721004266213 -122.458110615707 (37.721004266213, -122.458110615707) 9 8 6 28861 24
110586 219014 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 154 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5995361.04968 2090937.11704 37.721049208941 -122.45811061572 (37.721049208941, -122.45811061572) 9 8 6 28861 24
138084 219015 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 178 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5995362.975 2091073.58019 37.7214240148917 -122.458113831693 (37.7214240148917, -122.458113831693) 9 8 6 28861 24
116552 65468 Permitted Site 7 Geijera parviflora :: Australian Willow 25 55 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1989 12:00:00 AM     Permit Number 28348 5995598.18541989 2090265.07086982 37.7192175521634 -122.457242320925 (37.7192175521634, -122.457242320925) 9 8 6 28861 24
9850 30919 Permitted Site 7 Geijera parviflora :: Australian Willow 25 212 Granada Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1995 12:00:00 AM     Permit Number 34735 5995669.33198455 2091339.19890433 37.722170938941 -122.457074050715 (37.722170938941, -122.457074050715) 9 8 4 28861 24
179902 30918 Permitted Site 7 Geijera parviflora :: Australian Willow 25 212 Granada Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1995 12:00:00 AM     Permit Number 34735 5995669.33198455 2091339.19890433 37.722170938941 -122.457074050715 (37.722170938941, -122.457074050715) 9 8 4 28861 24
189829 141447 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 196 Beaumont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5996894.8261 2111600.0306 37.7778724506652 -122.454300593509 (37.7778724506652, -122.454300593509) 15 6 2 54 16
28535 41155 Permitted Site 7 Geijera parviflora :: Australian Willow 25 21 Cook St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/1999 12:00:00 AM     Permit Number 41884 5997452.09163541 2113544.02640038 37.7832420947214 -122.452513152989 (37.7832420947214, -122.452513152989) 15 6 1 54 31
67850 140156 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 2155 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5997581.2766 2109865.28 37.7731486172497 -122.451800756951 (37.7731486172497, -122.451800756951) 15 5 11 29492 16
102399 62468 Permitted Site 7 Geijera parviflora :: Australian Willow 25 400 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2011 12:00:00 AM     Permit Number 767707 5997942.58905548 2109236.69156954 37.7714433619175 -122.450505611482 (37.7714433619175, -122.450505611482) 15 5 11 29492 9
136233 244047 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 400 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5997955.5586 2109119.1735 37.7711214297529 -122.450452276113 (37.7711214297529, -122.450452276113) 15 5 11 29492 9
173191 225928 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1106 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5998173.76607 2106499.88804 37.7639420241322 -122.449508728942 (37.7639420241322, -122.449508728942) 15 5 11 29492 9
25511 94960 Permitted Site 7 Geijera parviflora :: Australian Willow 25 20 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998206 2108519 37.7694878371786 -122.449542741076 (37.7694878371786, -122.449542741076) 15 5 11 29492 9
40882 219016 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 23 Gaviota Way 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5998493.11217 2097521.42795 37.7393076426268 -122.447757806504 (37.7393076426268, -122.447757806504) 9 7 4 59 40
132169 65670 Permitted Site 7 Geijera parviflora :: Australian Willow 25 954 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1990 12:00:00 AM     Permit Number 28590 5998557.99448518 2095716.03586207 37.7343541747365 -122.447403560759 (37.7343541747365, -122.447403560759) 9 7 4 59 40
118274 85304 Permitted Site 7 Geijera parviflora :: Australian Willow 25 417 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2007 12:00:00 AM     Permit Number 49590 5998857 2109314 37.7717079252645 -122.447348195836 (37.7717079252645, -122.447348195836) 15 5 11 29492 9
4752 107181 Undocumented 4 Geijera parviflora :: Australian Willow 25 1520 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 6x9   5999172.7 2109108.7 37.7711622584795 -122.446241403234 (37.7711622584795, -122.446241403234) 15 5 11 29492 9
40896 247270 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1520 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5999196.9373 2109093.7955 37.7711227186713 -122.446156493551 (37.7711227186713, -122.446156493551) 15 5 11 29492 9
25095 244549 Undocumented 4 Geijera parviflora :: Australian Willow 25 1500 Page St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5999267.0062 2109103.195 37.7711525285338 -122.445914799778 (37.7711525285338, -122.445914799778) 15 5 11 29492 9
111282 244548 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1500 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5999285.3779 2109104.904 37.7711582700312 -122.445851374555 (37.7711582700312, -122.445851374555) 15 5 11 29492 9
145759 59939 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1778 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1981 12:00:00 AM 1   Permit Number 19412 5999341.88585809 2110158.12282899 37.7740533674999 -122.445731667127 (37.7740533674999, -122.445731667127) 15 5 11 29492 16
131118 59938 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1774 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1981 12:00:00 AM     Permit Number 19411 5999360.65261909 2110160.72458075 37.7740615827199 -122.445666937047 (37.7740615827199, -122.445666937047) 15 5 11 29492 16
98749 59936 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1757 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1981 12:00:00 AM 14   Permit Number 19409 5999437.2024 2110127.1563 37.7739737829513 -122.44539972496 (37.7739737829513, -122.44539972496) 15 5 11 29492 16
187975 59935 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1743 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1981 12:00:00 AM 12   Permit Number 19408 5999522.2814 2110138.642 37.7740101761611 -122.445106249319 (37.7740101761611, -122.445106249319) 15 5 11 29492 16
177554 59937 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1738 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2015 12:00:00 AM     Permit Number 19410 5999529.55338039 2110184.14033447 37.7741355180618 -122.445084365992 (37.7741355180618, -122.445084365992) 15 5 11 29492 16
32550 59941 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1706 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1981 12:00:00 AM 0   Permit Number 19415 5999632.27517388 2110547.02087839 37.7751377580465 -122.444755123369 (37.7751377580465, -122.444755123369) 15 5 11 29492 16
186208 59942 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 625 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1981 12:00:00 AM 13   Permit Number 19416 5999638.7469 2110673.4971 37.7754853988158 -122.444741829234 (37.7754853988158, -122.444741829234) 15 5 11 29492 16
99856 48556 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 615 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/23/2002 12:00:00 AM 3   Permit Number 45872 5999645.29400405 2110579.50430317 37.7752276921804 -122.444712423834 (37.7752276921804, -122.444712423834) 15 5 11 29492 16
119488 59933 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 549 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1981 12:00:00 AM 9   Permit Number 19406 5999664.8686 2110448.6759 37.7748695877317 -122.444635305779 (37.7748695877317, -122.444635305779) 15 5 11 29492 16
87972 112871 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 549 Central Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     5999666.6578 2110431.976 37.7748238361568 -122.444627916028 (37.7748238361568, -122.444627916028) 15 5 11 29492 16

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