39,840 rows where qLegalStatus_id = 7 sorted by qCaretaker_id

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)
12757 27231 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 319X Silver Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6003407.79227 2093529.1013 37.7286252931888 -122.430480251933 (37.7286252931888, -122.430480251933) 9 7 6 28861 5
19694 91181 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 8 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
20892 98486 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 11 Sidewalk: Curb side : Cutout Tree DPW 1     9 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
36901 91180 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 7 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
37390 41431 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 352-360 06th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/26/2005 12:00:00 AM     Permit Number 42039 6011197 2111276 37.7777925370097 -122.404801285962 (37.7777925370097, -122.404801285962) 14 2 9 28853 34
38991 107888 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 6 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
65819 91179 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 6 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
72412 98474 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 6x6   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
72578 257907 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 44 Clarendon Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   5998004 2104650 37.7588529837709 -122.449962562921 (37.7588529837709, -122.449962562921) 15 5 4 28862 38
79021 111446 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172 241 Oneida Ave 36 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334) 9 7 6 28861 25
79993 85362 Permitted Site 7 Olea europaea :: Olive Tree 9 1250 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/17/2007 12:00:00 AM     Permit Number 49639 6000155.2862 2108898.36192 37.7706407896873 -122.442827504693 (37.7706407896873, -122.442827504693) 15 5 11 29492 9
80607 98485 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 10 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
83216 111448 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172 241 Oneida Ave 38 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD     6x7   5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334) 9 7 6 28861 25
84387 100665 Permitted Site 7 Tree(s) :: 17 63 Walter St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/04/2012 12:00:00 AM   3x3 Permit Number 769258 6003201.8 2107946.7 37.7682009695292 -122.432221606092 (37.7682009695292, -122.432221606092) 15 5 5 28862 3
87491 98483 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
92535 107891 Permitted Site 7 Tree(s) :: 17 941 Washington St 9 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
102600 107890 Permitted Site 7 Tree(s) :: 17 941 Washington St 8 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
114676 98482 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
122402 41576 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 200 Dolores St 4 Sidewalk: Curb side : Cutout Tree DPW 1   07/22/2010 12:00:00 AM 6 3x3 Permit Number 53640 6004804.85382115 2107218.95663379 37.7662935218736 -122.426624972491 (37.7662935218736, -122.426624972491) 8 4 5 28862 3
131047 85363 Permitted Site 7 Olea europaea :: Olive Tree 9 1250 Haight St 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/17/2007 12:00:00 AM     Permit Number 49639 6000155.2862 2108898.36192 37.7706407896873 -122.442827504693 (37.7706407896873, -122.442827504693) 15 5 11 29492 9
141293 91178 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
144463 43455 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172 241 Oneida Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD 07/18/2000 12:00:00 AM     Permit Number 43162 5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334) 9 7 6 28861 25
146709 254547 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2908 Bush St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 02/26/2018 12:00:00 AM 3 3x3 Permit Number 781446 5999588.42992 2114352.40043 37.7855838475934 -122.445180440387 (37.7855838475934, -122.445180440387) 15 6 1 29490 31
147980 111447 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172 241 Oneida Ave 37 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334) 9 7 6 28861 25
152782 104960 Permitted Site 7 :: 45 2895 San Bruno Ave   Sidewalk: Curb side : Cutout Tree DPW 1           6011715.1 2091289.8 37.7229437265236 -122.401603910944 (37.7229437265236, -122.401603910944) 10 3 7 309 28
153488 92522 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1350 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/07/2009 12:00:00 AM   3x3 Permit Number 52874 6009005 2109688 37.773309499002 -122.412271934387 (37.773309499002, -122.412271934387) 8 2 9 28853 34
159959 98480 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
172228 98475 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
172759 18033 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2800X Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/07/2013 12:00:00 AM 18 3X3 Permit Number 769913 6000469.28268 2114833.17246 37.7869541618338 -122.44216747883 (37.7869541618338, -122.44216747883) 13 6 1 29490 27
180790 98479 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
181260 98481 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
181623 95162 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 932 Divisadero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/26/2013 12:00:00 AM 3 3x3   6001579.15015 2111647.55622 37.778270460106 -122.438099315048 (37.778270460106, -122.438099315048) 15 5 11 29490 41
183621 98476 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
185188 98484 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 531X Franconia St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
187682 12736 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1625 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/26/2019 12:00:00 AM 3 3X3 Permit Number 782752 5990372.3863 2114714.93418 37.7860489118948 -122.477091430633 (37.7860489118948, -122.477091430633) 11 6 2 55 26
188686 539 Permitted Site 7 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 2862 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2016 07:55:00 AM 3 3X3   6009630.84107 2102242.33848 37.7529005086992 -122.409581443394 (37.7529005086992, -122.409581443394) 2 4 7 28859 19
188774 107889 Permitted Site 7 Tree(s) :: 17 941 Washington St 7 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD 11/03/2014 12:00:00 AM 3   Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
190499 98487 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 12 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
192979 89262 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1 Polk St   Sidewalk: Curb side : Cutout Tree DPW 1       3x3 Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
30 254372 Permitted Site 7 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 62 Tioga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2020 12:00:00 AM 3 3x3 Permit Number 778036 6010859.22958 2088882.34048 37.7162855403434 -122.404393121162 (37.7162855403434, -122.404393121162) 9 7 8 309 39
36 166891 Permitted Site 7 Banksia integrifolia :: Coast Banksia 21 174 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 3x3 Permit Number 787855 6003954.63071 2101612.59597 37.7508516839573 -122.429165942869 (37.7508516839573, -122.429165942869) 2 4 5 28862 22
70 264978 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1439 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2020 12:00:00 AM 3 3x3 Permit Number 787884 5989892.86343 2105570.52868 37.7609130564186 -122.47808163393 (37.7609130564186, -122.47808163393) 1 8 3 56 35
74 106076 Permitted Site 7 Tree(s) :: 17 2500 Arelious Walker Dr 13 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 772788 6016510.6 2089868.7 37.7193080887588 -122.384927739753 (37.7193080887588, -122.384927739753) 10 3 8 58 1
75 74661 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 165-167 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056) 8 2 9 28853 34
81 46536 Permitted Site 7 Tree(s) :: 17 73 Summer St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2002 12:00:00 AM     Permit Number 44686                    
94 260654 Permitted Site 7 :: 45 2590 Buchanan St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/03/2019 12:00:00 AM 3 3.5x3                      
108 44866 Permitted Site 7 Tree(s) :: 17   25 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
109 34921 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
110 45916 Permitted Site 7 Tree(s) :: 17   51 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
111 97355 Permitted Site 7 Tree(s) :: 17   5 Unaccepted Street : Yard Tree Private 2                              
112 33929 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
135 99586 Permitted Site 7 Tree(s) :: 17 2299 Market St 4 Sidewalk: Curb side : Cutout Tree Private 2           6002978.6 2106459.9 37.7641059209125 -122.432887400675 (37.7641059209125, -122.432887400675) 15 4 5 28862 3
158 100607 Permitted Site 7 Tree(s) :: 17 270x 05th St 5 Sidewalk: Curb side : Cutout Tree Private 2           6011410.5 2112131.8 37.7801542961347 -122.404122955966 (37.7801542961347, -122.404122955966) 14 2 9 28853 34
165 104843 Permitted Site 7 :: 45 1320 21st Ave   Sidewalk: Curb side : Cutout Tree Private 2           5989622 2106334.7 37.7629955389606 -122.479074319647 (37.7629955389606, -122.479074319647) 1 8 3 56 35
171 50655 Permitted Site 7 Tree(s) :: 17 430 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47238 6008643.36799877 2088325.11427356 37.7146314352433 -122.412012884014 (37.7146314352433, -122.412012884014) 9 7 8 309 18
193 100595 Permitted Site 7 Tree(s) :: 17 401x Clementina St 10 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
195 101535 Permitted Site 7 Tree(s) :: 17 1X Main St 12 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
203 56596 Permitted Site 7 Tree(s) :: 17 536 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003173.97949504 2096124.55404861 37.7357385703685 -122.431473765394 (37.7357385703685, -122.431473765394) 2 7 5 63 7
205 61223 Permitted Site 7 Tree(s) :: 17 420 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/1983 12:00:00 AM     Permit Number 21092 6011911.40369591 2116824.99897206 37.793068691891 -122.402720238707 (37.793068691891, -122.402720238707) 4 1 10 28854 6
220 64608 Permitted Site 7 Tree(s) :: 17 2449 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/1988 12:00:00 AM     Permit Number 25511 6008240.06203716 2104170.72475134 37.75811738928 -122.414527478763 (37.75811738928, -122.414527478763) 2 4 7 28859 19
222 59632 Permitted Site 7 Tree(s) :: 17 1726 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/1982 12:00:00 AM     Permit Number 19874 5999538.23629958 2110533.95574653 37.7750965176114 -122.445079484139 (37.7750965176114, -122.445079484139) 15 5 11 29492 16
223 65500 Permitted Site 7 Tree(s) :: 17 5322 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   12/19/1989 12:00:00 AM     Permit Number 28384 5990524.68926015 2112731.41132738 37.7806115451711 -122.47641956102 (37.7806115451711, -122.47641956102) 11 6 2 55 26
226 56655 Permitted Site 7 Tree(s) :: 17 491 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2           5993749.22353597 2090472.28724098 37.7196801529508 -122.463648462413 (37.7196801529508, -122.463648462413) 9 8 6 64 24
236 27345 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 664 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2008 12:00:00 AM 4 4x4   6004282.41706 2110648.93551 37.7756818605142 -122.428676512776 (37.7756818605142, -122.428676512776) 7 9 11 28852 10
241 57687 Permitted Site 7 Tree(s) :: 17 4124 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/1976 12:00:00 AM     Permit Number 16590 6001721.25492757 2103540.26074256 37.7560179062476 -122.437027141607 (37.7560179062476, -122.437027141607) 2 4 5 28862 3
257 115298 Permitted Site 7 :: 45 84 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231) 1 8 4 29491 40
260 56449 Permitted Site 7 Tree(s) :: 17 1439 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5982754.68200032 2105326.56088651 37.7598262733968 -122.502750996927 (37.7598262733968, -122.502750996927) 1 8 3 56 35
294 53493 Permitted Site 7 Tree(s) :: 17 262 Ralston St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1969 12:00:00 AM     Permit Number 6403 5992228.28376051 2089608.56362168 37.717220822263 -122.468842940668 (37.717220822263, -122.468842940668) 9 8 6 64 24
305 56460 Permitted Site 7 Tree(s) :: 17 2430 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2           6006920.19744074 2104198.59660265 37.7581196808576 -122.419094125211 (37.7581196808576, -122.419094125211) 2 4 7 28859 19
308 102295 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 1500 Michigan St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6016449 2101073.5 37.7500708170088 -122.385921283567 (37.7500708170088, -122.385921283567) 10 3 8 58 1
309 40920 Permitted Site 7 Tree(s) :: 17 720 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/23/1999 12:00:00 AM     Permit Number 41793 6012338.0511994 2113764.09224404 37.7846879743619 -122.401028836502 (37.7846879743619, -122.401028836502) 12 2 9 28853 6
319 96811 Permitted Site 7 Schinus molle :: California Pepper 91 356 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996379.5 2106960.2 37.7651031164685 -122.455747798641 (37.7651031164685, -122.455747798641) 15 5 11 29492 12
333 44989 Permitted Site 7 Tree(s) :: 17   83 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
340 42995 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 436 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42871 6004515.16540478 2110012.02065503 37.7739462176361 -122.42782598565 (37.7739462176361, -122.42782598565) 7 9 11 28852 10
341 232113 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 533 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/1991 12:00:00 AM 24 4x4 Permit Number 29534 6008027.37409 2096368.31937 37.7366817787289 -122.414710885994 (37.7366817787289, -122.414710885994) 2 7 7 28859 2
347 108327 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
348 58983 Permitted Site 7 Tree(s) :: 17 585 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/1980 12:00:00 AM     Permit Number 18272 5995294.04081777 2111581.66432509 37.7777300922573 -122.45983690137 (37.7777300922573, -122.45983690137) 11 6 2 54 11
376 33627 Permitted Site 7 Tree(s) :: 17 315 Lily St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/02/1996 12:00:00 AM     Permit Number 37728 6005028.27785393 2110030.93274628 37.7740271589488 -122.426052389372 (37.7740271589488, -122.426052389372) 7 9 11 28852 10
382 34903 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
407 56529 Permitted Site 7 Tree(s) :: 17 4721 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2           5998571.81433707 2105652.41045975 37.7616378261686 -122.448070980729 (37.7616378261686, -122.448070980729) 15 5 11 29492 12
414 8435 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1730 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   05/28/1997 12:00:00 AM 13 3X3   6003010.73492 2113853.74303 37.784409407274 -122.433304626878 (37.784409407274, -122.433304626878) 13 9 11 29490 13
435 108949 Permitted Site 7 :: 45 254 Dublin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6003932.1 2088992 37.7161971007686 -122.428344449747 (37.7161971007686, -122.428344449747) 9 7 6 28861 5
438 16548 Permitted Site 7 Ceratonia siliqua :: Carob 5 400X Newhall St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016043.45751 2097947.55726 37.7414651721818 -122.387105680372 (37.7414651721818, -122.387105680372) 10 3 8 58 1
453 53634 Permitted Site 7 Tree(s) :: 17 4046 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1969 12:00:00 AM     Permit Number 6568 6003580.8041803 2100716.80543934 37.7483708836629 -122.430394762659 (37.7483708836629, -122.430394762659) 2 4 5 28862 22
461 56448 Permitted Site 7 Tree(s) :: 17 1410 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5982800.36611702 2105511.04189371 37.7603354906122 -122.502606655486 (37.7603354906122, -122.502606655486) 1 8 3 56 35
462 33949 Permitted Site 7 Tree(s) :: 17 1238 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/09/1997 12:00:00 AM     Permit Number 37907 5999468.65195546 2108623.71254321 37.7698475030127 -122.445182824083 (37.7698475030127, -122.445182824083) 15 5 11 29492 9
492 44943 Permitted Site 7 Tree(s) :: 17   176 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
495 69056 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1235 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33064 5992348.34951393 2107046.09564514 37.7651067945026 -122.469696689595 (37.7651067945026, -122.469696689595) 11 8 11 56 12
499 180799 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 315 Mount Vernon Ave 1 Front Yard : Yard Tree Private 2   10/23/2019 12:00:00 AM 3 8x8 Permit Number 782754 5998557.73755 2089669.84713 37.7177527376786 -122.446969503064 (37.7177527376786, -122.446969503064) 9 7 6 28861 25
514 45011 Permitted Site 7 Tree(s) :: 17   93 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
517 30483 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
521 100638 Permitted Site 7 Tree(s) :: 17 401X Clementina St 8 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
525 33087 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   6 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
528 57932 Permitted Site 7 Tree(s) :: 17 583 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/1977 12:00:00 AM     Permit Number 16891 5999047.47505332 2086793.7936429 37.7098837148731 -122.445070058439 (37.7098837148731, -122.445070058439) 9 7 6 28861 5
530 35187 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   17 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
531 46009 Permitted Site 7 Tree(s) :: 17   195 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
532 261313 Permitted Site 7 :: 45 2700 Broadway 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/31/2019 12:00:00 AM 3 6x40   6000687.88763 2117206.96839 37.7934844433083 -122.441581569821 (37.7934844433083, -122.441581569821) 13 9 1 57 27
542 35050 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
548 48279 Permitted Site 7 Tree(s) :: 17   89 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
549 63156 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 1483 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1986 12:00:00 AM     Permit Number 23692 5992405.6320278 2105370.20909848 37.7605085633711 -122.4693765688 (37.7605085633711, -122.4693765688) 1 8 4 56 12

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