trees

1,626 rows where qSpecies_id = 53 sorted by qCareAssistant descending

✎ View and edit SQL

This data as json, CSV (advanced)

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)
65259 105658 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 5 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
179087 105657 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
11498 115743 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 1 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   28 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
35407 94294 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
66280 94296 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
86887 94302 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
97800 115748 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 6 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   24 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
99392 94300 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 4 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park     6x6   6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
106391 115747 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 5 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   16 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
107985 115744 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 2 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   24 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
112309 115745 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 3 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   20 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
112589 115746 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 4 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   28 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
121115 94298 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
134290 94304 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
5722 255886 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
20034 255882 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
41708 251371 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390 06th St 3 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
43430 112751 Undocumented 4 Ficus nitida :: Laurel Fig 53 135X TRENTON ST 5 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
50094 253202 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 800 Oak St 4 Sidewalk: Property side : Cutout Tree DPW 1 Private     6x6   6003064 2109976 37.77376511482 -122.432843231253 (37.77376511482, -122.432843231253) 15 5 11 29492 10
99464 112750 Undocumented 4 Ficus nitida :: Laurel Fig 53 135X TRENTON ST 4 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
185169 15159 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 13 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7 Private   18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
186181 251369 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390 06th St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
186352 255883 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
189496 255885 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
160693 108107 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
183181 108106 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
2027 32641 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
3559 55849 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2801X Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/13/2003 12:00:00 AM     Permit Number 46336 6001333.31634171 2116022.21010841 37.7902681559585 -122.439263383199 (37.7902681559585, -122.439263383199) 13 6 1 29490 27
12223 59958 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 515 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1981 12:00:00 AM 17   Permit Number 19435 6005418.82 2111104.349 37.7769965639956 -122.424777815426 (37.7769965639956, -122.424777815426) 7 9 11 28852 10
15312 59957 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1981 12:00:00 AM 12   Permit Number 19434 6005396.005 2111241.6 37.7773721331465 -122.424866506623 (37.7773721331465, -122.424866506623) 7 9 11 28852 10
16922 59787 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1755 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1981 12:00:00 AM     Permit Number 19237 6004552.42886001 2119092.68520918 37.7988815571833 -122.428344419585 (37.7988815571833, -122.428344419585) 13 9 1 57 17
17302 59963 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 523 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1981 12:00:00 AM 15   Permit Number 19442 6005413.5665 2111133.9591 37.777077569392 -122.424798095948 (37.777077569392, -122.424798095948) 7 9 11 28852 10
19484 77283 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1210 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6001986.2323 2110871.5472 37.7761628769629 -122.436635509753 (37.7761628769629, -122.436635509753) 15 5 11 29492 10
20107 41196 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
24140 32644 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
24912 32645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
54273 41195 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1996 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
55414 61158 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3347 20TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1983 12:00:00 AM 12 5x5 Permit Number 21016 6007930.5 2104397.2 37.758721842404 -122.415614115387 (37.758721842404, -122.415614115387) 2 4 7 28859 19
60538 32649 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2005 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
66641 32646 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
72803 32647 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
78771 41194 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
79179 41198 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
82003 41199 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
82935 39773 Permitted Site 7 Ficus nitida :: Laurel Fig 53 112 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/29/2001 12:00:00 AM 14 6x6 Permit Number 41140 6005154.17276637 2099634.09116827 37.7454869972987 -122.424877067697 (37.7454869972987, -122.424877067697) 2 7 5 63 22
84466 64020 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2344 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1987 12:00:00 AM     Permit Number 778144 6002015 2107091 37.7657840660528 -122.436265375372 (37.7657840660528, -122.436265375372) 15 5 5 28862 3
98717 33718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 25 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1996 12:00:00 AM 13   Permit Number 37786 6004139.32588988 2108866.31797637 37.7707791293659 -122.429044373837 (37.7707791293659, -122.429044373837) 7 9 11 29492 10
104097 62645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 400 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25453 6000705.45672766 2110331.40246789 37.7746069085927 -122.441027287197 (37.7746069085927, -122.441027287197) 15 5 11 29492 10
114328 50197 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3279@ DOLORES 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/2003 12:00:00 AM     Permit Number 46903 6005006.02996154 2106599.52754391 37.7646040888867 -122.425885045341 (37.7646040888867, -122.425885045341) 8 4 5 28859 19
115348 50571 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
156118 41200 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
165793 39111 Permitted Site 7 Ficus nitida :: Laurel Fig 53 145 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM 20   Permit Number 40799 6006719.36046982 2102938.94159671 37.7546496469874 -122.41969933167 (37.7546496469874, -122.41969933167) 2 4 7 28859 19
165827 41193 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
176242 41192 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
178044 48952 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3046 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/26/2002 12:00:00 AM 28   Permit Number 46137 6008657.12939462 2102169.92315078 37.7526470627455 -122.412943613067 (37.7526470627455, -122.412943613067) 2 4 7 28859 19
182282 32648 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2005 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
189703 66879 Permitted Site 7 Ficus nitida :: Laurel Fig 53 277 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1991 12:00:00 AM     Permit Number 768127 6001144.84674667 2104743.15871911 37.7592879918503 -122.439106757133 (37.7592879918503, -122.439106757133) 2 4 5 28862 3
41372 95268 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2245 Jones St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
73387 113573 Undocumented 4 Ficus nitida :: Laurel Fig 53 901 LOMBARD ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6007813 2120272 37.8023036186348 -122.417145352251 (37.8023036186348, -122.417145352251) 5 1 10 308 32
168362 95269 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2245 Jones St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     6x6   6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
177916 113574 Undocumented 4 Ficus nitida :: Laurel Fig 53 901 LOMBARD ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6007968 2120121 37.8018977290678 -122.416598272247 (37.8018977290678, -122.416598272247) 5 1 10 308 32
6288 254356 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 3 Sidewalk: Curb side : Cutout Tree Private 2 DPW                            
9010 253870 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW       Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection                    
17892 254355 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW                            
77923 256355 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
123904 98659 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2110 Greenwich St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   20 7x7   6002683.8 2119245.6 37.7991955081761 -122.434821422435 (37.7991955081761, -122.434821422435) 13 9 1 57 17
182487 256357 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
192030 256356 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
117 108152 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
261 119280 Undocumented 4 Ficus nitida :: Laurel Fig 53 95 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995293 2090512 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488) 9 8 6 28861 24
280 8072 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 661 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6005345.6576 2111619.4154 37.7784066780298 -122.425067563729 (37.7784066780298, -122.425067563729) 7 9 11 28852 10
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
349 253694 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 536 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005450 2111168 37.7771730951376 -122.424674483112 (37.7771730951376, -122.424674483112) 7 9 11 28852 10
371 251215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 175X Otis St 11 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
770 111807 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
1142 260393 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
1212 40354 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 12 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
2280 116028 Undocumented 4 Ficus nitida :: Laurel Fig 53 1500 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
2653 100053 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
2723 140583 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 949 FILLMORE ST 9 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6003424.6737 2111485.9504 37.7779315149131 -122.431703431668 (37.7779315149131, -122.431703431668) 15 9 11 29492 41
2956 139431 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 OCTAVIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6005398.6042 2111220.8061 37.7773151849796 -122.424856035409 (37.7773151849796, -122.424856035409) 7 9 11 28852 10
3159 94569 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100@ Cole Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998051 2107197 37.7658490933668 -122.449983584058 (37.7658490933668, -122.449983584058) 15 5 11 29492 9
3630 258965 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
3804 117402 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
3916 261241 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 840 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2020 12:00:00 AM 3 Width 4ft   5985843 2115056 37.786721565729 -122.492786794237 (37.786721565729, -122.492786794237) 11 6 1 55 33
3993 49288 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 19 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
4294 117126 Undocumented 4 Ficus nitida :: Laurel Fig 53 766 NOE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6003023 2103770 37.7567226205836 -122.432541687014 (37.7567226205836, -122.432541687014) 2 4 5 28862 3
4658 46466 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3310X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2002 12:00:00 AM 12 3x3 Permit Number 44668 6002328.64862435 2119517.88465055 37.7999229605029 -122.436069860968 (37.7999229605029, -122.436069860968) 13 9 1 57 17
4699 23132 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 610X Vallejo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/29/1999 12:00:00 AM 3 4x4   6010603.58879 2118945.35218 37.798817561298 -122.407394925794 (37.798817561298, -122.407394925794) 3 1 10 308 23
4983 112267 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
5064 258966 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 6 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
5715 140049 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 651 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6005353.1353 2111583.6293 37.778308840554 -122.42503914867 (37.778308840554, -122.42503914867) 7 9 11 28852 10
5822 16933 Permitted Site 7 Ficus nitida :: Laurel Fig 53 530 Oak St 1 Sidewalk: Property side : Cutout Tree Private 2     24 3X3   6004214.00427 2110149.16937 37.7743057532085 -122.428877532014 (37.7743057532085, -122.428877532014) 7 9 11 28852 10
6188 111792 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
6270 258961 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
6753 140065 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 612 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6005425.1416 2111379.12 37.7777513751906 -122.424775499228 (37.7777513751906, -122.424775499228) 7 9 11 28852 10
6921 95036 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
7085 260395 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
7207 249360 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 601 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008338.71076 2114562.35621 37.7866559051821 -122.41492178511 (37.7866559051821, -122.41492178511) 13 1 9 28858 36
7359 121255 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3

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