trees
7,322 rows where qSpecies_id = 1 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );