trees
256 rows where qSpecies_id = 51
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50182 | 107502 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 998 CHESTNUT ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 773456 | 6007102 | 2120561.3 | 37.8030579393401 | -122.419626302363 | (37.8030579393401, -122.419626302363) | 5 | 1 | 1 | 28858 | 32 | ||
51236 | 243740 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 550 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 776473 | 6003047.05577 | 2096015.80768 | 37.7354327831918 | -122.431904827248 | (37.7354327831918, -122.431904827248) | 2 | 7 | 5 | 63 | 7 | |
53637 | 181036 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 170 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:16:00 PM | 3 | Width 4ft | 6000944.46471 | 2088397.62402 | 37.7143955675655 | -122.438628565353 | (37.7143955675655, -122.438628565353) | 9 | 7 | 6 | 28861 | 5 | ||
55340 | 106365 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1970 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 4x2 | 5981684.7966 | 2101671.2426 | 37.7497268716349 | -122.506180099858 | (37.7497268716349, -122.506180099858) | 1 | 8 | 3 | 29491 | 35 | ||
55362 | 200091 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2230 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6014724.5498 | 2092764.8713 | 37.7271614489349 | -122.391303841402 | (37.7271614489349, -122.391303841402) | 10 | 3 | 8 | 58 | 1 | |||
55425 | 112845 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 2200 KEITH ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014766 | 2092880 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | 10 | 3 | 8 | 58 | 1 | ||||
55458 | 255165 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 371 Prospect Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781717 | 6006352.58239 | 2097791.19314 | 37.7404944317648 | -122.420602351048 | (37.7404944317648, -122.420602351048) | 2 | 7 | 7 | 28859 | 2 | |
56257 | 120653 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 4000x 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003791 | 2101344 | 37.7501049179003 | -122.42971263777 | (37.7501049179003, -122.42971263777) | 2 | 4 | 5 | 28862 | 22 | |||
58345 | 234843 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 141 Albion St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6005925.31783 | 2106426.47013 | 37.7641808229188 | -122.422693171361 | (37.7641808229188, -122.422693171361) | 8 | 4 | 5 | 28859 | 19 | |||
58754 | 160609 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 750X France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2017 03:56:00 PM | 3 | Width 0ft | 6002789.45595 | 2089340.35461 | 37.7170888824363 | -122.432318838255 | (37.7170888824363, -122.432318838255) | 9 | 7 | 6 | 28861 | 5 | ||
58947 | 69306 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1518 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | 1 | Permit Number 33385 | 5986858.656 | 2104895.6313 | 37.7588833876571 | -122.488525879562 | (37.7588833876571, -122.488525879562) | 1 | 8 | 3 | 56 | 35 | |
61203 | 63398 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 4515 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/2015 12:00:00 AM | 24 | 3x3 | Permit Number 770790 | 6001413.63019954 | 2104052.61523798 | 37.7574072175095 | -122.438127708744 | (37.7574072175095, -122.438127708744) | 2 | 4 | 5 | 28862 | 3 |
62553 | 185519 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2201 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984858.6139 | 2100160.4269 | 37.7457649124522 | -122.495093683302 | (37.7457649124522, -122.495093683302) | 1 | 8 | 3 | 29491 | 35 | |||
64558 | 107418 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 300 Seacliff Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.7884965174911 | -122.489505906992 | (37.7884965174911, -122.489505906992) | 11 | 6 | 1 | 55 | 33 | ||
65781 | 187072 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2600 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985184.617 | 2096917.4415 | 37.7368796277559 | -122.493727498225 | (37.7368796277559, -122.493727498225) | 1 | 8 | 3 | 29491 | 35 | |||
67276 | 107894 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 230X 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998917 | (37.7726012817916, -122.41519998917) | 8 | 2 | 9 | 28853 | 19 | |
70508 | 115312 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 1125 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | Permit Number 775539 | 5992848.6 | 2091172.9 | 37.7215519289961 | -122.466812473031 | (37.7215519289961, -122.466812473031) | 9 | 8 | 6 | 64 | 24 | |||
70645 | 86799 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 71 Miguel St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 49752 | 6003860 | 2097292 | 37.7389829690297 | -122.429185143196 | (37.7389829690297, -122.429185143196) | 2 | 7 | 5 | 63 | 7 | ||
71232 | 256150 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1669 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010597 | 2100121 | 37.7471298703057 | -122.406090831159 | (37.7471298703057, -122.406090831159) | 2 | 7 | 7 | 28859 | 2 | ||||
73337 | 140757 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2303 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000331.3271 | 2112998.0313 | 37.7819074748635 | -122.442512966292 | (37.7819074748635, -122.442512966292) | 15 | 5 | 1 | 29490 | 16 | |||
75538 | 138343 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2250 Sutter St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001783.0488 | 2114314.9363 | 37.7856060025516 | -122.437585027866 | (37.7856060025516, -122.437585027866) | 13 | 6 | 1 | 29490 | 27 | |||
76049 | 122398 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1 Marne Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5995245 | 2097844 | 37.7400071651049 | -122.459011607771 | (37.7400071651049, -122.459011607771) | 9 | 7 | 4 | 59 | 40 | ||||
76230 | 91402 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 567 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52097 | 6010859.945 | 2118931.7794 | 37.7987946386979 | -122.406506888518 | (37.7987946386979, -122.406506888518) | 3 | 1 | 10 | 308 | 23 | |
78847 | 160610 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 750X France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2017 04:01:00 PM | 3 | Width 0ft | 6002805.02204 | 2089330.87742 | 37.7170637427805 | -122.432264357312 | (37.7170637427805, -122.432264357312) | 9 | 7 | 6 | 28861 | 5 | ||
80106 | 114666 | Private 9 | Podocarpus gracilor :: Fern Pine 51 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774512 | 6007233.6 | 2095963.6 | 37.7355258779344 | -122.417426639907 | (37.7355258779344, -122.417426639907) | 2 | 7 | 7 | 28859 | 2 | |||
81166 | 120652 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 4000x 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003791 | 2101344 | 37.7501049179003 | -122.42971263777 | (37.7501049179003, -122.42971263777) | 2 | 4 | 5 | 28862 | 22 | |||
86498 | 234842 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 141 Albion St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6005925.78637 | 2106423.26838 | 37.7641720581045 | -122.422691323269 | (37.7641720581045, -122.422691323269) | 8 | 4 | 5 | 28859 | 19 | |||
89512 | 116065 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 693 Vermont St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/30/2018 12:00:00 AM | 3 | 8x7 | 6011274.01561 | 2105377.63125 | 37.7616012651139 | -122.404119643106 | (37.7616012651139, -122.404119643106) | 10 | 3 | 8 | 28856 | 29 | |
91182 | 254736 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 1611 31st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781587 | 5986522.26781 | 2104276.26182 | 37.7571631347478 | -122.489643703651 | (37.7571631347478, -122.489643703651) | 1 | 8 | 3 | 56 | 35 | |
92335 | 216804 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 297 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 02:14:00 PM | 3 | Width 2ft | 5994075.3134 | 2088701.73413 | 37.7148374215779 | -122.462392942697 | (37.7148374215779, -122.462392942697) | 9 | 8 | 6 | 28861 | 24 | ||
93094 | 106927 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 4150 24th St | Sidewalk: Property side : Cutout | Tree | Private 2 | 1.5X1.5 | Permit Number 772519 | 6002207.56819 | 2101805.30097 | 37.7512817512061 | -122.435221219626 | (37.7512817512061, -122.435221219626) | 2 | 4 | 5 | 28862 | 22 | ||||
94397 | 94678 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 160 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778668 | 6004537 | 2097560 | 37.7397571378771 | -122.426863468968 | (37.7397571378771, -122.426863468968) | 2 | 7 | 5 | 63 | 7 |
95176 | 186191 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1701 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984752.6191 | 2103570.02 | 37.7551205130891 | -122.495711647305 | (37.7551205130891, -122.495711647305) | 1 | 8 | 3 | 56 | 35 | |||
95365 | 112846 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 2200 KEITH ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014766 | 2092880 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | 10 | 3 | 8 | 58 | 1 | ||||
97686 | 254340 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 45 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781300 | 6006812.15908 | 2099551.95878 | 37.745354989783 | -122.419138175127 | (37.745354989783, -122.419138175127) | 2 | 7 | 7 | 28859 | 2 |
103410 | 107897 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 230X 11th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998917 | (37.7726012817916, -122.41519998917) | 8 | 2 | 9 | 28853 | 19 | |
103655 | 107895 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 230X 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998917 | (37.7726012817916, -122.41519998917) | 8 | 2 | 9 | 28853 | 19 | |
104086 | 115378 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 42 Leese St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777462 | 6005449.5 | 2096333.6 | 37.7364412712621 | -122.423621255026 | (37.7364412712621, -122.423621255026) | 2 | 7 | 7 | 28859 | 2 | ||
104499 | 107984 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2401x SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001096 | 2116670 | 37.7920333111805 | -122.440130949989 | (37.7920333111805, -122.440130949989) | 13 | 6 | 1 | 29490 | 27 | ||||
106425 | 116064 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 693 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/30/2018 12:00:00 AM | 3 | 8x7 | 6011272.30638 | 2105412.17877 | 37.7616960293658 | -122.404127986133 | (37.7616960293658, -122.404127986133) | 10 | 3 | 8 | 28856 | 29 | |
106668 | 107427 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 222 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 9x7 | Permit Number 774709 | 5997126.23025 | 2106741.3016 | 37.7645449031863 | -122.453149251746 | (37.7645449031863, -122.453149251746) | 15 | 5 | 11 | 29492 | 12 | ||
106839 | 200094 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2220 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6014757.7183 | 2092808.7972 | 37.7272839014089 | -122.391192246384 | (37.7272839014089, -122.391192246384) | 10 | 3 | 8 | 58 | 1 | |||
107238 | 122401 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1 Marne Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5995245 | 2097844 | 37.7400071651049 | -122.459011607771 | (37.7400071651049, -122.459011607771) | 9 | 7 | 4 | 59 | 40 | ||||
107621 | 112848 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 2200 KEITH ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014766 | 2092880 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | 10 | 3 | 8 | 58 | 1 | ||||
107984 | 112850 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 2200 KEITH ST | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014766 | 2092880 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | 10 | 3 | 8 | 58 | 1 | ||||
108618 | 107896 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 230X 11th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998917 | (37.7726012817916, -122.41519998917) | 8 | 2 | 9 | 28853 | 19 | |
110761 | 106902 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 370 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2014 12:00:00 AM | 15 | 3x3 | Permit Number 772995 | 6009514.3 | 2121304 | 37.8052327952843 | -122.411330948142 | (37.8052327952843, -122.411330948142) | 3 | 1 | 10 | 308 | 23 | |
111085 | 10251 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 120 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6005509.0088 | 2109632.4226 | 37.7729601045446 | -122.424361107182 | (37.7729601045446, -122.424361107182) | 7 | 9 | 11 | 28852 | 10 | |||
111218 | 160608 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 750X France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:37:00 PM | 3 | Width 0ft | 6002772.88317 | 2089351.94517 | 37.7171197678315 | -122.432376949735 | (37.7171197678315, -122.432376949735) | 9 | 7 | 6 | 28861 | 5 | |
111290 | 106058 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 301 FILBERT ST | 1 | Front Yard : Yard | Tree | Private 2 | 10 | 6011273 | 2120044 | 37.8018716248897 | -122.405155936594 | (37.8018716248897, -122.405155936594) | 3 | 1 | 10 | 308 | 23 | ||||
112340 | 178683 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 161 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781357 | 6009800.07713 | 2088901.30264 | 37.7162783612237 | -122.408055418121 | (37.7162783612237, -122.408055418121) | 9 | 7 | 8 | 309 | 39 |
113297 | 112847 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 2200 KEITH ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014766 | 2092880 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | 10 | 3 | 8 | 58 | 1 | ||||
113421 | 160611 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 750X France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 04:11:00 PM | 3 | Width 0ft | 6002821.18646 | 2089320.89201 | 37.717037241564 | -122.432207771993 | (37.717037241564, -122.432207771993) | 9 | 7 | 6 | 28861 | 5 | |
113669 | 159358 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 49 Naglee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998584.62871 | 2087583.88571 | 37.712026700246 | -122.446726546692 | (37.712026700246, -122.446726546692) | 9 | 7 | 6 | 28861 | 25 | |
114068 | 143092 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 487 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010505.1787 | 2120274.7202 | 37.80246217128 | -122.407829248503 | (37.80246217128, -122.407829248503) | 3 | 1 | 10 | 308 | 23 | |||
114840 | 212833 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 468 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5996396.78511 | 2096388.5906 | 37.7360771087699 | -122.454924099162 | (37.7360771087699, -122.454924099162) | 9 | 7 | 4 | 59 | 40 | |||
117414 | 122753 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 693 Vermont St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 15 | 6011277.81019 | 2105311.62173 | 37.7614202297665 | -122.404101873421 | (37.7614202297665, -122.404101873421) | 10 | 3 | 8 | 28856 | 29 | |||
118657 | 115383 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 324 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777467 | 6006881.6 | 2096254.2 | 37.7363039898307 | -122.418664241464 | (37.7363039898307, -122.418664241464) | 2 | 7 | 7 | 28859 | 2 | ||
118927 | 186107 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1901 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984859.3561 | 2101642.6122 | 37.7498346320289 | -122.495200398918 | (37.7498346320289, -122.495200398918) | 1 | 8 | 3 | 29491 | 35 | |||
121519 | 121218 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 441 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005284 | 2110767 | 37.7760626702732 | -122.425220189207 | (37.7760626702732, -122.425220189207) | 7 | 9 | 11 | 28852 | 10 | ||||
122570 | 92295 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1372 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52740 | 5989296.944 | 2106014.5102 | 37.7620975019283 | -122.480175128724 | (37.7620975019283, -122.480175128724) | 1 | 8 | 3 | 56 | 35 |
122900 | 107501 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 998 CHESTNUT ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 773456 | 6007102 | 2120561.3 | 37.8030579393401 | -122.419626302363 | (37.8030579393401, -122.419626302363) | 5 | 1 | 1 | 28858 | 32 | ||
123907 | 212832 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1201 Funston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5992025.01275 | 2107217.63828 | 37.765559111278 | -122.47082751867 | (37.765559111278, -122.47082751867) | 11 | 8 | 11 | 56 | 12 | |||
123963 | 44251 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1735 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 43686 | 6000810.1983 | 2111352.5828 | 37.7774167767615 | -122.440738231786 | (37.7774167767615, -122.440738231786) | 15 | 5 | 11 | 29492 | 41 | |||
124820 | 252888 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 301x Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 04:03:00 PM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
125335 | 185634 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2100 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985067.4201 | 2100372.3359 | 37.7463589790483 | -122.494387290002 | (37.7463589790483, -122.494387290002) | 1 | 8 | 3 | 29491 | 35 | |||
125934 | 256878 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009121.70897 | 2101021.23838 | 37.7495190982493 | -122.411255871462 | (37.7495190982493, -122.411255871462) | 2 | 4 | 7 | 28859 | 19 | |
128054 | 108818 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 583 Naples St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774655 | 6002868.5584 | 2090237.17355 | 37.7195558341056 | -122.432109426582 | (37.7195558341056, -122.432109426582) | 9 | 7 | 6 | 28861 | 5 | |
128563 | 117383 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1601 POLK ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6006595 | 2116425 | 37.7916721288605 | -122.421086920214 | (37.7916721288605, -122.421086920214) | 13 | 9 | 10 | 28858 | 21 | |||||
129229 | 115230 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 743 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775535 | 5987210.9 | 2110869.6 | 37.775306795851 | -122.487746566566 | (37.775306795851, -122.487746566566) | 11 | 6 | 2 | 55 | 26 | |||
129348 | 251179 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 1043 Minna St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007668 | 2109797 | 37.7735336727503 | -122.41690453761 | (37.7735336727503, -122.41690453761) | 8 | 2 | 9 | 28853 | 19 | ||||
130403 | 117387 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1601 POLK ST | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6006595 | 2116425 | 37.7916721288605 | -122.421086920214 | (37.7916721288605, -122.421086920214) | 13 | 9 | 10 | 28858 | 21 | |||||
130616 | 116421 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 621 STOCKTON ST | 1 | Front Yard : Yard | Tree | Private 2 | 6010507 | 2116333 | 37.7916392690679 | -122.407544875665 | (37.7916392690679, -122.407544875665) | 5 | 1 | 10 | 28857 | 21 | |||||
132864 | 186404 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1801 Sunset Blvd | 71 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984797.7578 | 2102308.2226 | 37.7516586088355 | -122.495462490222 | (37.7516586088355, -122.495462490222) | 1 | 8 | 3 | 56 | 35 | |||
133393 | 200090 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2250 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6014714.6889 | 2092749.6317 | 37.7271190567752 | -122.391336865844 | (37.7271190567752, -122.391336865844) | 10 | 3 | 8 | 58 | 1 | |||
133482 | 156498 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 414 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781293 | 6007484.42025 | 2096871.98526 | 37.7380342134096 | -122.416623786263 | (37.7380342134096, -122.416623786263) | 2 | 7 | 7 | 28859 | 2 |
133531 | 187642 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2526 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006264 | 2119500 | 37.8000966404513 | -122.42245076966 | (37.8000966404513, -122.42245076966) | 13 | 9 | 1 | 28858 | 32 | ||||
133785 | 185530 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2201 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984911.0151 | 2100096.2189 | 37.7455916823633 | -122.494907756827 | (37.7455916823633, -122.494907756827) | 1 | 8 | 3 | 29491 | 35 | |||
133926 | 143219 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 55 BELLAIR PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010028.7855 | 2121230.0223 | 37.805058512663 | -122.409545274895 | (37.805058512663, -122.409545274895) | 3 | 1 | 10 | 308 | 23 | |||
135799 | 254662 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 2378 22nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781550 | 5989531.15374 | 2099172.87776 | 37.7433258009473 | -122.478864680026 | (37.7433258009473, -122.478864680026) | 1 | 8 | 3 | 29491 | 35 | |
138609 | 251178 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 1043 Minna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007668 | 2109797 | 37.7735336727503 | -122.41690453761 | (37.7735336727503, -122.41690453761) | 8 | 2 | 9 | 28853 | 19 | ||||
140248 | 37080 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1224 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | Permit Number 39681 | 5982132.793 | 2106739.5272 | 37.7636693082228 | -122.505006479579 | (37.7636693082228, -122.505006479579) | 1 | 8 | 3 | 56 | 35 | |
140468 | 150667 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 549 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781211 | 6011817.87875 | 2105812.76187 | 37.7628264097369 | -122.40226922595 | (37.7628264097369, -122.40226922595) | 8 | 3 | 8 | 28856 | 29 |
141016 | 141703 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 116 STANYAN BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5996565.9306 | 2112209.0509 | 37.7795257936095 | -122.455482379999 | (37.7795257936095, -122.455482379999) | 15 | 6 | 2 | 54 | 16 | |||
142298 | 143220 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 55 BELLAIR PL | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010031.3343 | 2121212.8177 | 37.8050114159252 | -122.409535239424 | (37.8050114159252, -122.409535239424) | 3 | 1 | 10 | 308 | 23 | |||
143788 | 143095 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 483 Greenwich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 6010551.3522 | 2120281.1845 | 37.8024825054705 | -122.407669920622 | (37.8024825054705, -122.407669920622) | 3 | 1 | 10 | 308 | 23 | |||
144002 | 183060 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2595 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983027.0823 | 2097502.8119 | 37.7383604357526 | -122.501230213026 | (37.7383604357526, -122.501230213026) | 1 | 8 | 3 | 29491 | 35 | |||
145101 | 200092 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2220 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6014736.2036 | 2092780.1109 | 37.7272039405869 | -122.391264618831 | (37.7272039405869, -122.391264618831) | 10 | 3 | 8 | 58 | 1 | |||
145129 | 98012 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 4515 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 8 | 3x3 | Permit Number 770790 | 6001417 | 2104061 | 37.7574304316811 | -122.43811665528 | (37.7574304316811, -122.43811665528) | 2 | 4 | 5 | 28862 | 3 | |
145244 | 138934 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 640 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004774.0843 | 2110917.8533 | 37.7764480564968 | -122.426994870545 | (37.7764480564968, -122.426994870545) | 7 | 9 | 11 | 28852 | 10 | |||
145995 | 117385 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1601 POLK ST | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6006595 | 2116425 | 37.7916721288605 | -122.421086920214 | (37.7916721288605, -122.421086920214) | 13 | 9 | 10 | 28858 | 21 | |||||
146166 | 175543 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 187 Seville St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 09:37:00 AM | 3 | Width 6ft | 6001178.34372 | 2087386.3168 | 37.7116320444605 | -122.437747801713 | (37.7116320444605, -122.437747801713) | 9 | 7 | 6 | 28861 | 5 | ||
146700 | 37210 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1927 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 6 | Permit Number 39776 | 5986283.4263 | 2102108.4415 | 37.751196944743 | -122.490310231538 | (37.751196944743, -122.490310231538) | 1 | 8 | 3 | 29491 | 35 | |
146848 | 109413 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 114 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773149 | 6006968.5 | 2095329.1 | 37.7337687610147 | -122.418298220412 | (37.7337687610147, -122.418298220412) | 2 | 7 | 7 | 28859 | 2 |
147455 | 122400 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1 Marne Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5995245 | 2097844 | 37.7400071651049 | -122.459011607771 | (37.7400071651049, -122.459011607771) | 9 | 7 | 4 | 59 | 40 | ||||
148409 | 115320 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 562 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | Permit Number 775637 | 5992882.5 | 2111642.9 | 37.7777592485634 | -122.468183632004 | (37.7777592485634, -122.468183632004) | 11 | 6 | 2 | 54 | 11 | ||
149837 | 244218 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1949 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997251.0447 | 2108771.6628 | 37.7701269078181 | -122.452864114834 | (37.7701269078181, -122.452864114834) | 15 | 5 | 11 | 29492 | 9 | |||
149885 | 186196 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1701 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984756.9045 | 2103549.1285 | 37.7550634017723 | -122.495695286455 | (37.7550634017723, -122.495695286455) | 1 | 8 | 3 | 56 | 35 | |||
150240 | 119609 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 228 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990599 | 2113870 | 37.7837421028695 | -122.476245677506 | (37.7837421028695, -122.476245677506) | 11 | 6 | 2 | 54 | 26 | ||||
150446 | 32788 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1668 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 11 | Permit Number 37154 | 5999777.7569 | 2110913.119 | 37.7761512712335 | -122.444278185514 | (37.7761512712335, -122.444278185514) | 15 | 5 | 11 | 29492 | 16 |
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) );