7,322 rows where qSpecies_id = 1 sorted by Supervisor Districts

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)
90 259864 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1398x Brussels St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
1095 255202 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
1138 260594 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3090x Jennings St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
2475 259866 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 101x Desmond St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
4112 255223 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1051 Silver Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
6640 255204 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 5 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
6981 259867 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 101x Desmond St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
7570 36838 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
7587 259089 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1201 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2019 12:00:00 AM 3                        
7844 36854 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
8196 255225 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 400 Bacon St 6 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
8832 260593 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3090x Jennings St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
10581 260591 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3090x Jennings St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
11185 98268 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 401X Esmeralda Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3                      
11245 255201 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
11633 259865 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 101x Desmond St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
11767 255200 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
12758 260592 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3090x Jennings St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
13636 36840 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   6 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
13881 255222 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1051 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
14357 36839 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   5 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
14394 36837 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   3 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
15903 255203 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
18459 36836 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
679 258141 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 312 Walnut St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 1x3   5998583.51543 2115521.94134 37.7887376884438 -122.448741405189 (37.7887376884438, -122.448741405189) 13 6 1 54 31
897 136834 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2189 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6003723.70254 2116916.18398 37.7928585158644 -122.43105665684 (37.7928585158644, -122.43105665684) 13 9 1 29490 27
1073 108979 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3298 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2017 12:00:00 AM 3 3x3   6001360.79576 2119668.58087 37.800281699894 -122.43942979746 (37.800281699894, -122.43942979746) 13 9 1 57 17
1112 8732 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3210 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   02/21/1996 12:00:00 AM 6 3X3   5997102.31429 2113088.26659 37.7819706522719 -122.453690315182 (37.7819706522719, -122.453690315182) 11 6 1 54 31
2270 139543 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 254 Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6000646.9933 2113045.3455 37.7820553756462 -122.441424306243 (37.7820553756462, -122.441424306243) 15 5 1 29490 41
4362 72167 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2157 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     5999876.34149 2120874.18187 37.8035073648317 -122.444653277524 (37.8035073648317, -122.444653277524) 13 9 1 57 17
4767 40166 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3031 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1999 12:00:00 AM 8 6x6 Permit Number 41359 6004240.20521 2119600.37832 37.8002578795473 -122.429461041019 (37.8002578795473, -122.429461041019) 13 9 1 57 17
5090 72166 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2164 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5999887.26115 2120921.40259 37.8036376433293 -122.444618885675 (37.8036376433293, -122.444618885675) 13 9 1 57 17
5139 19520 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 127 Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 4X4   6000564 2112525 37.7806219117946 -122.44167407009 (37.7806219117946, -122.44167407009) 15 5 1 29490 16
5190 19521 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 130X Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000722.7955642 2112514.8377136 37.7806030550121 -122.441123992492 (37.7806030550121, -122.441123992492) 15 5 1 29490 41
5520 66956 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2253 Webster St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/21/1992 12:00:00 AM 18 4x4 Permit Number 30287 6003206.54821 2116495.06774 37.7916729207242 -122.432815936723 (37.7916729207242, -122.432815936723) 13 9 1 29490 27
5649 136764 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1900 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003765.13271 2119380.44822 37.7996270995734 -122.43108927166 (37.7996270995734, -122.43108927166) 13 9 1 57 17
5739 52729 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2015 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/2006 12:00:00 AM 5   Permit Number 48785 6003207.48866 2119256.92944 37.7992563342625 -122.433010091366 (37.7992563342625, -122.433010091366) 13 9 1 57 17
5918 103690 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 147 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3 Permit Number 775299 6001175.90706 2121214.18027 37.804514981434 -122.440180480455 (37.804514981434, -122.440180480455) 13 9 1 57 17
5997 14446 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 100 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2012 12:00:00 AM 3 3x3   5998938.7246 2112487.711 37.7804267900707 -122.447293967252 (37.7804267900707, -122.447293967252) 15 5 1 54 16
6711 62157 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2158 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/04/1985 12:00:00 AM 10   Permit Number 22272 5999899.60106 2120922.78087 37.8036421318499 -122.444576282063 (37.8036421318499, -122.444576282063) 13 9 1 57 17
7078 62154 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2016 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/04/1985 12:00:00 AM 12   Permit Number 22268 5999531.33121 2121219.56404 37.8044359975872 -122.445872051358 (37.8044359975872, -122.445872051358) 13 9 1 57 17
7240 62150 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2033 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/1985 12:00:00 AM 11   Permit Number 22264 5999463.73231 2121165.54346 37.8042838116209 -122.446102094357 (37.8042838116209, -122.446102094357) 13 9 1 57 17
7867 62156 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2165 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/04/1985 12:00:00 AM 9   Permit Number 22270 5999843.40545 2120869.57146 37.8034928263957 -122.444766922157 (37.8034928263957, -122.444766922157) 13 9 1 57 17
7999 62155 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2252 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/04/1985 12:00:00 AM 13   Permit Number 22269 5999444.38711 2120859.49312 37.8034423753191 -122.446147011887 (37.8034423753191, -122.446147011887) 13 9 1 57 17
8300 62006 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1307 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/31/1985 12:00:00 AM 7   Permit Number 22075 6004472.06597 2120817.82099 37.8036137870071 -122.428745548466 (37.8036137870071, -122.428745548466) 13 9 1 28858 17
9465 260400 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 190 Parker Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2019 12:00:00 AM 3     5996965.93026 2113053.17261 37.7818664738231 -122.454159603161 (37.7818664738231, -122.454159603161) 11 6 1 54 31
10039 62160 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2129 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/04/1985 12:00:00 AM 10   Permit Number 22275 6000012.6105 2120894.62285 37.8035712652717 -122.444183183902 (37.8035712652717, -122.444183183902) 13 9 1 57 17
10132 136901 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2333 Leavenworth St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2020 12:00:00 AM 3 Width 5ft   6007536.47447 2120305.57509 37.8023802472184 -122.41810464953 (37.8023802472184, -122.41810464953) 5 1 1 28858 32
10204 104021 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3700X Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2013 12:00:00 AM 1 6x9 Permit Number 770321 5997065.89783 2115379.84227 37.7882606230845 -122.453981848003 (37.7882606230845, -122.453981848003) 11 6 1 54 31
11402 83501 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1915 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2008 12:00:00 AM 4 3x3 Permit Number 50771 6005502.6509 2116836.33115 37.7927399024791 -122.424895720767 (37.7927399024791, -122.424895720767) 13 9 1 28858 27
11724 81872 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3132 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6003807.91186 2119539.89269 37.8000673168179 -122.430952625964 (37.8000673168179, -122.430952625964) 13 9 1 57 17
11796 137756 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 101 Saint Joseph's Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6000702.2406 2112329.8372 37.7800939200036 -122.441181824601 (37.7800939200036, -122.441181824601) 15 5 1 29490 16
12001 19526 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 139X Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 4X4   6000543 2112633 37.7809172556433 -122.441754472162 (37.7809172556433, -122.441754472162) 15 5 1 29490 16
12024 66137 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3248 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/17/1990 12:00:00 AM 5   Permit Number 29200 5999873.32355 2119767.07624 37.8004673775197 -122.444584102586 (37.8004673775197, -122.444584102586) 13 9 1 57 17
12230 107510 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2141 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2014 12:00:00 AM 3 3x3   6001605.27547 2119726.96625 37.8004559210497 -122.438587988867 (37.8004559210497, -122.438587988867) 13 9 1 57 17
12608 136833 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2189 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003703.80591 2116912.36582 37.7928469047218 -122.431125227456 (37.7928469047218, -122.431125227456) 13 9 1 29490 27
13188 51663 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2041 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/11/2005 12:00:00 AM 6   Permit Number 47942 5999392.0644 2115915.2572 37.7898638328006 -122.445972252917 (37.7898638328006, -122.445972252917) 13 6 1 29490 31
13920 18997 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3006 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2007 12:00:00 AM 3 3X3PL   6000330.42565 2115511.74748 37.7888094379519 -122.442696633353 (37.7888094379519, -122.442696633353) 13 6 1 29490 27
14251 136806 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2308 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5999799.52174 2116827.90784 37.7923929898903 -122.44462811629 (37.7923929898903, -122.44462811629) 13 6 1 29490 27
14781 256563 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2504 Bush St   Sidewalk: Curb side : Cutout Tree Private 2   09/24/2019 12:00:00 AM 3 3x3   6001466 2114633 37.7864612926293 -122.438704721697 (37.7864612926293, -122.438704721697) 13 6 1 29490 27
15266 62148 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2040 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/1985 12:00:00 AM 11   Permit Number 22262 5999472.96679 2121211.62683 37.8044108714347 -122.446073454522 (37.8044108714347, -122.446073454522) 13 9 1 57 17
15442 48410 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2701X Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2002 12:00:00 AM 4   Permit Number 45790 5999879.07462 2118793.03652 37.7977932524078 -122.444494158697 (37.7977932524078, -122.444494158697) 13 9 1 57 17
16665 136767 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3520 Baker St 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5999224.40422 2120935.42639 37.8036383025204 -122.446913736078 (37.8036383025204, -122.446913736078) 13 9 1 57 17
17065 72113 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3214 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5997155.9186 2113032.4009 37.7818203327249 -122.453500835003 (37.7818203327249, -122.453500835003) 11 6 1 54 31
17596 62149 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2037 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/1985 12:00:00 AM 10   Permit Number 22263 5999450.73523 2121163.30158 37.8042769138086 -122.446146910269 (37.8042769138086, -122.446146910269) 13 9 1 57 17
17875 123870 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 850 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5992756.18098 2114853.11188 37.7865663175005 -122.468854274745 (37.7865663175005, -122.468854274745) 11 6 1 54 11
17890 136458 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3801 Sacramento St 5 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5996623 2114922 37.7869781063352 -122.455481088021 (37.7869781063352, -122.455481088021) 11 6 1 54 31
17970 62153 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2022 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/04/1985 12:00:00 AM 10   Permit Number 22267 5999519.37482 2121217.44002 37.8044294828978 -122.44591327448 (37.8044294828978, -122.44591327448) 13 9 1 57 17
17975 136753 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3104 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003385.31973 2119082.57835 37.7987876966409 -122.432382275515 (37.7987876966409, -122.432382275515) 13 9 1 57 17
18936 260399 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 190 Parker Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2019 12:00:00 AM 3     5996965.93026 2113053.17261 37.7818664738231 -122.454159603161 (37.7818664738231, -122.454159603161) 11 6 1 54 31
19173 12566 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 311 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2007 12:00:00 AM 6 3X3   5994509.60276 2114857.89716 37.7866806017071 -122.462788257982 (37.7866806017071, -122.462788257982) 11 6 1 54 11
19199 258106 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3400 California St 2 Sidewalk: Curb side : Tree DPW 1           5998152.86517 2114854.93765 37.7868816373151 -122.45018328933 (37.7868816373151, -122.45018328933) 11 6 1 54 31
19405 136810 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2509 Pierce St 4 Sidewalk: Property side : Yard Tree Private 2     5 Width 4ft   6001666.14129 2117099.39038 37.7932447477064 -122.438189033412 (37.7932447477064, -122.438189033412) 13 6 1 29490 27
19712 138355 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2499 Bush St 8 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6001788.5584 2114613.8194 37.7864269723095 -122.437587378273 (37.7864269723095, -122.437587378273) 13 6 1 29490 27
20033 139113 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2350 GEARY BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6000448.9678 2113438.8392 37.7831245249854 -122.442137637075 (37.7831245249854, -122.442137637075) 15 5 1 29490 13
20248 138232 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 250 Masonic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5998975.2742 2112235.5868 37.7797366106808 -122.447149375515 (37.7797366106808, -122.447149375515) 15 5 1 54 16
20458 42640 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1651 Union St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/25/2015 02:08:00 PM 3 3x3 Permit Number 42688 6005273.82097 2118847.7065 37.7982497015198 -122.425830717123 (37.7982497015198, -122.425830717123) 13 9 1 57 17
20536 12866 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2527 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/2015 12:00:00 AM 4 3X3   5987590.69016 2114609.53889 37.7855977534892 -122.486707484323 (37.7855977534892, -122.486707484323) 11 6 1 55 26
20970 31216 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2302 Steiner St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/04/1995 12:00:00 AM 8   Permit Number 34907 6002328.19974 2116193.32144 37.7907945474797 -122.435833412206 (37.7907945474797, -122.435833412206) 13 9 1 29490 27
21152 102108 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 160 25th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/13/2013 12:00:00 AM 1 3x3 Permit Number 770061 5988061.62738 2114927.67902 37.7864987186466 -122.485101549027 (37.7864987186466, -122.485101549027) 11 6 1 55 33
22327 12791 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2014 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/19/2005 12:00:00 AM 8 3X3   5989167.53166 2114722.07806 37.7859985535362 -122.481260378022 (37.7859985535362, -122.481260378022) 11 6 1 55 33
22950 116203 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3773 Sacramento St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF         5996831.55660521 2114970.89612566 37.787124327035 -122.454763067438 (37.787124327035, -122.454763067438) 11 6 1 54 31
22952 136779 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2700 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6004443.0325 2118468.37808 37.7971611791972 -122.428678439257 (37.7971611791972, -122.428678439257) 13 9 1 57 17
23071 139545 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 209 Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6000636.8406 2112831.8014 37.7814684598582 -122.441444101851 (37.7814684598582, -122.441444101851) 15 5 1 29490 16
23210 136827 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2792 Fillmore St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6002597.11005 2117761.57869 37.7951158492703 -122.435015205399 (37.7951158492703, -122.435015205399) 13 9 1 29490 27
23214 84608 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1307 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2008 12:00:00 AM   3x3 Permit Number 50841 6005059.05085072 2120549.16999723 37.8029093444786 -122.426695114755 (37.8029093444786, -122.426695114755) 13 9 1 57 17
23780 136812 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2509 Pierce St 6 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   6001667.70874 2117080.51294 37.7931930043084 -122.438182257008 (37.7931930043084, -122.438182257008) 13 6 1 29490 27
23781 138358 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2499 Bush St 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6001852.4631 2114622.4219 37.7864542257348 -122.437366900718 (37.7864542257348, -122.437366900718) 13 6 1 29490 27
23814 79341 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 121 Spruce St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2008 12:00:00 AM 3 3x3 Permit Number 50675 5997033.65308 2115866.03405 37.789593726811 -122.454128538208 (37.789593726811, -122.454128538208) 11 6 1 54 31
23839 136837 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2189 Jackson St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003780.76406 2116920.29251 37.7928730300301 -122.430859514663 (37.7928730300301, -122.430859514663) 13 9 1 29490 27
23994 42610 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1778 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 7   Permit Number 42677 6004517.51154 2118442.44969 37.7970942013016 -122.428418874228 (37.7970942013016, -122.428418874228) 13 9 1 57 17
24269 19529 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 141 Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6000533 2112672 37.7810237698712 -122.441791866828 (37.7810237698712, -122.441791866828) 15 5 1 29490 16
24352 124853 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 55 Casa Way 1 Sidewalk: Curb side : Yard Tree Private 2   05/25/2018 12:00:00 AM 3 Width 3ft Permit Number 781938 6001524.844 2121579.60518 37.8055382003848 -122.43899915981 (37.8055382003848, -122.43899915981) 13 9 1 57 17
24633 116207 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3773 Sacramento St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF         5996831.55660521 2114970.89612566 37.787124327035 -122.454763067438 (37.787124327035, -122.454763067438) 11 6 1 54 31
24687 34671 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2001X Filbert St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/24/2013 12:00:00 AM 3   Permit Number 770195 6003313.06094 2118924.86911 37.7983505703751 -122.432621042824 (37.7983505703751, -122.432621042824) 13 9 1 57 17
25042 104020 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3700X Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2013 12:00:00 AM 1 6x9 Permit Number 770321 5997075.95217 2115381.62732 37.7882661008363 -122.453947190815 (37.7882661008363, -122.453947190815) 11 6 1 54 31
25817 83357 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3036-3038 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 4 3x3 Permit Number 52341 6004710.71346 2120028.26822 37.8014593828022 -122.427863403488 (37.8014593828022, -122.427863403488) 13 9 1 57 17
25819 139556 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 210 Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6000684.5581 2112796.9439 37.7813754683985 -122.441276520969 (37.7813754683985, -122.441276520969) 15 5 1 29490 41
26185 136818 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2800 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6002582.05936 2117878.42798 37.7954358325571 -122.435075644328 (37.7954358325571, -122.435075644328) 13 9 1 57 17
26251 136802 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3125 Pacific Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5999207.19907 2116610.32204 37.7917617395614 -122.446661898044 (37.7917617395614, -122.446661898044) 13 6 1 29490 31

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