trees
256 rows where qSpecies_id = 51 sorted by qCareAssistant descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
158582 | 108904 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772986 | 6008567.7 | 2096169.9 | 37.7361673058735 | -122.412828714971 | (37.7361673058735, -122.412828714971) | 10 | 7 | 7 | 28859 | 2 |
574 | 259403 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1318 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5x5 | 6016589.71081 | 2093303.84603 | 37.7287447049521 | -122.384893469396 | (37.7287447049521, -122.384893469396) | 10 | 3 | 8 | 58 | 1 | |
4060 | 258132 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 521 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6010235.16029 | 2091735.83795 | 37.7240857609146 | -122.406751201397 | (37.7240857609146, -122.406751201397) | 10 | 3 | 7 | 309 | 28 | ||
4890 | 264632 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1220 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2020 12:00:00 AM | 4x6 | 6015246 | 2090493 | 37.7209522659136 | -122.389342597629 | (37.7209522659136, -122.389342597629) | 10 | 3 | 8 | 58 | 1 | ||
5135 | 258130 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 290 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3X5 | 6009566.32704 | 2093048.73199 | 37.7276532465172 | -122.409155864667 | (37.7276532465172, -122.409155864667) | 10 | 3 | 7 | 309 | 28 | ||
5732 | 258358 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 341 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009791.92467 | 2094008.68962 | 37.7303017232085 | -122.408443651573 | (37.7303017232085, -122.408443651573) | 10 | 3 | 7 | 309 | 28 | ||||
6620 | 258386 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 100 Hamilton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6009028.92475 | 2093781.29726 | 37.7296345936181 | -122.411065400912 | (37.7296345936181, -122.411065400912) | 9 | 3 | 7 | 309 | 28 | ||||
8517 | 258182 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 340 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009780.20088 | 2094046.93295 | 37.7304060747264 | -122.408486879094 | (37.7304060747264, -122.408486879094) | 10 | 3 | 7 | 309 | 28 | ||
10021 | 258360 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 355 Silliman St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009753.35872 | 2093996.86693 | 37.7302671007809 | -122.408576146225 | (37.7302671007809, -122.408576146225) | 10 | 3 | 7 | 309 | 28 | |||
10616 | 73417 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1501 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982464.5527 | 2104844.8944 | 37.7584866992539 | -122.503718723326 | (37.7584866992539, -122.503718723326) | 1 | 8 | 3 | 56 | 35 | |||
10662 | 171831 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 621 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6008914.70938 | 2093737.22092 | 37.7295071637126 | -122.411457144242 | (37.7295071637126, -122.411457144242) | 9 | 3 | 7 | 309 | 28 | ||
10792 | 148083 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 615 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009912.93462 | 2091638.65703 | 37.7238008879822 | -122.407858241787 | (37.7238008879822, -122.407858241787) | 10 | 3 | 7 | 309 | 28 | ||
10815 | 37070 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1382 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 6 | Permit Number 39673 | 5982789.8395 | 2105718.3045 | 37.7609039563223 | -122.502658403201 | (37.7609039563223, -122.502658403201) | 1 | 8 | 3 | 56 | 35 | |
11417 | 108972 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 10 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772927 | 6005770.7 | 2106026.5 | 37.7630738748169 | -122.423199517734 | (37.7630738748169, -122.423199517734) | 8 | 4 | 5 | 28859 | 19 |
13001 | 256877 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 633 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6008874 | 2093704 | 37.7294136626873 | -122.411595534882 | (37.7294136626873, -122.411595534882) | 9 | 3 | 7 | 309 | 28 | |||
13632 | 258133 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2579 29th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 5987367.52261 | 2097738.52962 | 37.7392615861063 | -122.486240585494 | (37.7392615861063, -122.486240585494) | 1 | 8 | 3 | 29491 | 35 | |||
13705 | 258131 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 290 Holyoke St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009566.32704 | 2093048.73199 | 37.7276532465172 | -122.409155864667 | (37.7276532465172, -122.409155864667) | 10 | 3 | 7 | 309 | 28 | |||
15336 | 258173 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 212 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010143.89662 | 2094158.42668 | 37.7307325742143 | -122.407237382197 | (37.7307325742143, -122.407237382197) | 10 | 3 | 7 | 309 | 28 | |||
16565 | 171995 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 206 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | Width 3ft | 6010113.09838 | 2094151.91118 | 37.7307129603226 | -122.407343397875 | (37.7307129603226, -122.407343397875) | 10 | 3 | 7 | 309 | 28 | ||
16765 | 258174 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 218 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010127.41072 | 2094153.3728 | 37.7307177746626 | -122.407294020659 | (37.7307177746626, -122.407294020659) | 10 | 3 | 7 | 309 | 28 | ||
31884 | 255500 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 463 Arlington St | : | Tree | Private 2 | FUF | 06/01/2018 12:00:00 AM | 3 | Permit Number 779226 | 6003846.45772 | 2095958.75203 | 37.7353214068723 | -122.429136928426 | (37.7353214068723, -122.429136928426) | 2 | 7 | 5 | 63 | 7 | ||
35799 | 37227 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1823 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 6 | Permit Number 39791 | 5985639.2314 | 2102798.4516 | 37.7530538796523 | -122.49258870721 | (37.7530538796523, -122.49258870721) | 1 | 8 | 3 | 56 | 35 | |
39185 | 108613 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 859 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774597 | 6007577.26936 | 2095354.40031 | 37.7338724793659 | -122.416195309142 | (37.7338724793659, -122.416195309142) | 2 | 7 | 7 | 28859 | 2 | |
46053 | 169690 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 143 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781233 | 6002625.75671 | 2096823.83531 | 37.7376275489772 | -122.43341913811 | (37.7376275489772, -122.43341913811) | 2 | 7 | 5 | 63 | 7 |
47403 | 178684 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 161 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781357 | 6009805.30528 | 2088917.07553 | 37.716321963062 | -122.408038458724 | (37.716321963062, -122.408038458724) | 9 | 7 | 8 | 309 | 39 |
48316 | 109234 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 1888 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773192 | 6004570 | 2097679.6 | 37.7400873981114 | -122.426757883918 | (37.7400873981114, -122.426757883918) | 2 | 7 | 5 | 63 | 7 |
48649 | 46187 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | 3x3 | Permit Number 770441 | 5997143.11969578 | 2107935.34407244 | 37.7678244064417 | -122.453177040971 | (37.7678244064417, -122.453177040971) | 15 | 5 | 11 | 29492 | 9 | |
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 | ||
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 | |
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 |
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 | |
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 |
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 |
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 | |
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 |
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 | |
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 |
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 | |
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 |
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 | |
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 |
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 |
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 | |
151191 | 36551 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 859 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 774597 | 6007583.24246776 | 2095353.82916435 | 37.7338712469843 | -122.416174617809 | (37.7338712469843, -122.416174617809) | 2 | 7 | 7 | 28859 | 2 | ||
153328 | 66163 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 115 Venus St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 4 | Permit Number 53981 | 6012889.43142 | 2094249.39792 | 37.7311356371996 | -122.39775195381 | (37.7311356371996, -122.39775195381) | 10 | 3 | 8 | 58 | 1 | |
159426 | 225657 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 6 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781317 | 6007484.20689 | 2099531.29764 | 37.7453360824988 | -122.416812874134 | (37.7453360824988, -122.416812874134) | 2 | 7 | 7 | 28859 | 2 |
163308 | 69411 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 400 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2017 12:00:00 PM | 3 | Permit Number 33516 | 6002017.91695 | 2087759.83784 | 37.7127053547461 | -122.434872710526 | (37.7127053547461, -122.434872710526) | 9 | 7 | 6 | 28861 | 5 | |
165144 | 107893 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 73X Kissling St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 |
185432 | 92325 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1451 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52757 | 5987103.8402 | 2105396.114 | 37.7602718797133 | -122.487714698332 | (37.7602718797133, -122.487714698332) | 1 | 8 | 3 | 56 | 35 |
190172 | 66791 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2417 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2018 12:00:00 AM | 3 | Permit Number 782035 | 6006674.15789 | 2119535.82066 | 37.8002181241347 | -122.421034007614 | (37.8002181241347, -122.421034007614) | 5 | 9 | 1 | 28858 | 32 | |
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 | |
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 | |
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 | |||
107 | 264818 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 101x Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | |||||||||||||
539 | 178708 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 500 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 3ft | 6001593.53028 | 2090821.75006 | 37.721088578565 | -122.436558547244 | (37.721088578565, -122.436558547244) | 9 | 7 | 6 | 28861 | 5 | ||
584 | 170688 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 499X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000526.86487 | 2092744.73897 | 37.726307994602 | -122.440383530269 | (37.726307994602, -122.440383530269) | 9 | 7 | 6 | 28861 | 25 | ||
786 | 143093 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 487 Greenwich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 6010518.569 | 2120277.0289 | 37.8024692600192 | -122.407783074103 | (37.8024692600192, -122.407783074103) | 3 | 1 | 10 | 308 | 23 | |||
1333 | 152105 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 99 Woodward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6006517.15656 | 2107967.63961 | 37.7684458838038 | -122.420755586526 | (37.7684458838038, -122.420755586526) | 8 | 4 | 7 | 28853 | 19 | |||
1425 | 170341 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 56 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6001088.08008 | 2093656.24889 | 37.7288427310959 | -122.438508720824 | (37.7288427310959, -122.438508720824) | 9 | 7 | 6 | 28861 | 25 | ||
1441 | 262458 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 236 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 2ft | 6002498 | 2094223 | 37.730479001636 | -122.433675025832 | (37.730479001636, -122.433675025832) | 9 | 7 | 5 | 28861 | 25 | ||
2616 | 139137 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1750 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003531.4353 | 2113968.7391 | 37.7847546833549 | -122.431511396859 | (37.7847546833549, -122.431511396859) | 13 | 9 | 11 | 29490 | 13 | |||
3510 | 262437 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 500 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2020 12:00:00 AM | 3 | Width 3ft | 6001593.53028 | 2090821.75006 | 37.721088578565 | -122.436558547244 | (37.721088578565, -122.436558547244) | 9 | 7 | 6 | 28861 | 5 | ||
3836 | 261734 | Section 806 (d) 5 | Podocarpus gracilor :: Fern Pine 51 | 540 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
3944 | 137213 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 3601 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 6002583.70734 | 2121034.52442 | 37.8041017420685 | -122.435295807367 | (37.8041017420685, -122.435295807367) | 13 | 9 | 1 | 57 | 17 | |||
4331 | 219827 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 291 Whitney St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004325 | 2096691 | 37.7373590721786 | -122.427534581259 | (37.7373590721786, -122.427534581259) | 2 | 7 | 5 | 63 | 7 | |||
4350 | 261755 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
4604 | 261733 | Section 806 (d) 5 | Podocarpus gracilor :: Fern Pine 51 | 540 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
7368 | 168515 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1999 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004111.08983 | 2117627.84996 | 37.7948345125635 | -122.429767061412 | (37.7948345125635, -122.429767061412) | 13 | 9 | 1 | 28858 | 27 | |||
8007 | 261753 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 3 | Back Yard : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
9022 | 259567 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 200 Public Park | 6 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
9302 | 152106 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 99 Woodward St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6006515.83678 | 2107993.45255 | 37.7685166856291 | -122.420761984296 | (37.7685166856291, -122.420761984296) | 8 | 4 | 7 | 28853 | 19 | |||
9541 | 151619 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2742 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6010731.34402 | 2101826.94097 | 37.7518215236653 | -122.405746421383 | (37.7518215236653, -122.405746421383) | 10 | 4 | 8 | 28859 | 19 | |||
9560 | 160641 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 538 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001479.16071 | 2090640.1306 | 37.7205833924964 | -122.436940893107 | (37.7205833924964, -122.436940893107) | 9 | 7 | 6 | 28861 | 5 | ||
9574 | 139141 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1730 GEARY BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003375.8185 | 2113943.8659 | 37.7846775665641 | -122.432048002548 | (37.7846775665641, -122.432048002548) | 13 | 9 | 11 | 29490 | 13 | |||
9908 | 215094 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 218 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.20309 | 37.7123610457095 | -122.459746958272 | (37.7123610457095, -122.459746958272) | 9 | 8 | 6 | 28861 | 24 | |
10887 | 160642 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 552 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001431.26484 | 2090565.22993 | 37.7203750096919 | -122.437101093851 | (37.7203750096919, -122.437101093851) | 9 | 7 | 6 | 28861 | 5 | ||
10895 | 112844 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 2200 KEITH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014766 | 2092880 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | 10 | 3 | 8 | 58 | 1 | ||||
11083 | 53568 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 712 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2014 12:00:00 AM | 3 | 6x7 | Permit Number 774472 | 6002289.86675011 | 2108835.21130526 | 37.7705888548661 | -122.435439454682 | (37.7705888548661, -122.435439454682) | 15 | 5 | 11 | 29492 | 9 | |
11494 | 259566 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 200 Public Park | 5 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
11628 | 261752 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 2 | Back Yard : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
11750 | 156512 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 458 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2.5x4 | 6007850.10821 | 2096721.59201 | 37.7376418266109 | -122.415348774236 | (37.7376418266109, -122.415348774236) | 2 | 7 | 7 | 28859 | 2 | |||
12322 | 170690 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 499X San Juan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | Width 3ft | 6000565.44218 | 2092713.91239 | 37.7262255483502 | -122.440247961077 | (37.7262255483502, -122.440247961077) | 9 | 7 | 6 | 28861 | 25 | ||
12529 | 256148 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1669 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010597 | 2100121 | 37.7471298703057 | -122.406090831159 | (37.7471298703057, -122.406090831159) | 2 | 7 | 7 | 28859 | 2 | ||||
12643 | 264817 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 101x Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | |||||||||||||
14771 | 152104 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 99 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6006517.82562 | 2107949.84717 | 37.7683970676925 | -122.420752009018 | (37.7683970676925, -122.420752009018) | 8 | 4 | 7 | 28853 | 19 | |||
15207 | 171363 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 35 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6002659.06191 | 2092590.504 | 37.7260056740221 | -122.433001623328 | (37.7260056740221, -122.433001623328) | 9 | 7 | 6 | 28861 | 5 | |||
15638 | 261754 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
15802 | 251596 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 3698 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 4x4 | Permit Number 39496 | 6005038 | 2104916 | 37.7599833282319 | -122.42565463807 | (37.7599833282319, -122.42565463807) | 2 | 4 | 5 | 28859 | 19 | ||
16078 | 170689 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 499X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000540.92778 | 2092733.68669 | 37.7262784482906 | -122.440334123336 | (37.7262784482906, -122.440334123336) | 9 | 7 | 6 | 28861 | 25 | ||
16545 | 262457 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 230 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 2ft | 6002522 | 2094231 | 37.7305023295928 | -122.43359262597 | (37.7305023295928, -122.43359262597) | 9 | 7 | 5 | 28861 | 25 | ||
16671 | 237075 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 3779 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 4ft | 6005306.75052 | 2101349.20074 | 37.750204911337 | -122.424471450323 | (37.750204911337, -122.424471450323) | 2 | 4 | 5 | 28859 | 19 | ||
16725 | 264661 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1031 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014696.24098 | 2089784.84247 | 37.7189773103018 | -122.39119349116 | (37.7189773103018, -122.39119349116) | 10 | 3 | 8 | 58 | 1 | |||
17256 | 160459 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 90 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001198.86277 | 2090341.59094 | 37.7197477343465 | -122.437888420609 | (37.7197477343465, -122.437888420609) | 9 | 7 | 6 | 28861 | 5 | ||
17316 | 258023 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 157 Lunado Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 782791 | 5991571 | 2092608 | 37.7254185405379 | -122.471333259188 | (37.7254185405379, -122.471333259188) | 9 | 8 | 4 | 59 | 40 | |||
18205 | 262139 | Section 806 (d) 5 | Podocarpus gracilor :: Fern Pine 51 | 1582 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782766 | 5981929 | 2104333 | 37.7570496794991 | -122.505532928251 | (37.7570496794991, -122.505532928251) | 1 | 8 | 3 | 56 | 35 | |
18338 | 160460 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 90 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001209.98941 | 2090333.79491 | 37.7197269609185 | -122.437849401749 | (37.7197269609185, -122.437849401749) | 9 | 7 | 6 | 28861 | 5 | ||
18769 | 254850 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 110 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x4 | 5998307 | 2110250 | 37.774246497277 | -122.449318120214 | (37.774246497277, -122.449318120214) | 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) );