Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53366 | 53366 | 203468 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 2ft | 5998155.09728 | 2094421.38368 | 37.7307763355428 | -122.448703284436 | (37.7307763355428, -122.448703284436) | |||
| 153900 | 153900 | 203467 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5998177.872280001 | 2094421.44457 | 37.730777805043104 | -122.448624552388 | (37.7307778050431, -122.448624552388) | |||
| 134166 | 134166 | 203466 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5998189.167859999 | 2094420.9335599998 | 37.7307770478103 | -122.448585465162 | (37.7307770478103, -122.448585465162) | |||
| 71361 | 71361 | 203465 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5998202.03163 | 2094421.3515299999 | 37.7307789309899 | -122.448541023359 | (37.7307789309899, -122.448541023359) | |||
| 132173 | 132173 | 203487 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 828 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998282.181969999 | 2096469.8668799999 | 37.736408249925 | -122.44841139867201 | (37.736408249925, -122.448411398672) | |||
| 165566 | 165566 | 203486 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998423.088169999 | 2096045.87835 | 37.7352521336624 | -122.447893712922 | (37.7352521336624, -122.447893712922) | |||
| 60506 | 60506 | 203484 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998423.23469 | 2096036.13552 | 37.7352253905456 | -122.447892505138 | (37.7352253905456, -122.447892505138) | |||
| 136680 | 136680 | 203485 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998424.41404 | 2096025.6755 | 37.7351967372311 | -122.447887674883 | (37.7351967372311, -122.447887674883) | |||
| 167219 | 167219 | 203460 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 451 Hearst Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998498.644119999 | 2094367.6439099999 | 37.730648417773104 | -122.44751172680901 | (37.7306484177731, -122.447511726809) | |||
| 55188 | 55188 | 203461 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 409 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998653.32929 | 2094365.51359 | 37.7306514071182 | -122.446976805539 | (37.7306514071182, -122.446976805539) | |||
| 140160 | 140160 | 17102 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1711 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998685.53291 | 2109300.56616 | 37.771661239802 | -122.44794034143601 | (37.771661239802, -122.447940341436) | |||
| 25297 | 25297 | 203469 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 300 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998711.4385400005 | 2094111.50955 | 37.7299572914866 | -122.446757644361 | (37.7299572914866, -122.446757644361) | ||||
| 43939 | 43939 | 203498 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 234 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999190.87551 | 2094097.9228400001 | 37.72994736206179 | -122.445099202768 | (37.7299473620618, -122.445099202768) | |||
| 70954 | 70954 | 125443 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2298 Beach St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999265.80635 | 2120844.85189 | 37.8033919746241 | -122.446763941418 | (37.8033919746241, -122.446763941418) | |||
| 153001 | 153001 | 92753 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3356 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999299.39389 | 2120397.7877700003 | 37.802166375831106 | -122.446615526285 | (37.8021663758311, -122.446615526285) | |
| 24395 | 24395 | 92752 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3356 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999300.27951 | 2120375.08626 | 37.8021040941904 | -122.446610827352 | (37.8021040941904, -122.446610827352) | |
| 155798 | 155798 | 203493 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 227 Stillings Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5999314.08769 | 2095746.28692 | 37.7344804146435 | -122.444791684116 | (37.7344804146435, -122.444791684116) | |||
| 66904 | 66904 | 203470 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 Staples Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5999333.68862 | 2093807.8865599998 | 37.72915914047 | -122.444584644873 | (37.72915914047, -122.444584644873) | ||||
| 185204 | 185204 | 203464 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 312 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5999389.85516 | 2094399.0679799998 | 37.730785591378606 | -122.44443294273701 | (37.7307855913786, -122.444432942737) | ||||
| 64600 | 64600 | 203500 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 77 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5999471.94159 | 2093749.5809 | 37.729006934723 | -122.444102506626 | (37.729006934723, -122.444102506626) | |||
| 144315 | 144315 | 88208 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 607 Central Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51212 | 5999619.0 | 2110591.2 | 37.775258305073 | -122.444804221322 | (37.775258305073, -122.444804221322) | |||
| 161472 | 161472 | 203494 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 363 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5999675.09138 | 2094930.6164 | 37.732261369848 | -122.443485006944 | (37.732261369848, -122.443485006944) | |||
| 48836 | 48836 | 203495 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 363 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5999677.596390001 | 2094931.24105 | 37.732263227850204 | -122.443476391437 | (37.7322632278502, -122.443476391437) | |||
| 108891 | 108891 | 95368 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 960 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2011 12:00:00 AM | 3x3 | Permit Number 767465 | 5999728.0 | 2101957.0 | 37.751557160755205 | -122.443806713729 | (37.7515571607552, -122.443806713729) | ||
| 169661 | 169661 | 220617 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 960 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999730.468230001 | 2101939.14181 | 37.7515082672912 | -122.44379689543699 | (37.7515082672912, -122.443796895437) | |||
| 94647 | 94647 | 88118 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 956 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51122 | 5999752.6 | 2102008.2 | 37.7516991466356 | -122.44372532203501 | (37.7516991466356, -122.443725322035) | ||
| 169437 | 169437 | 220616 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 956 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999753.1781 | 2101988.06706 | 37.7516438994494 | -122.44372187666599 | (37.7516438994494, -122.443721876666) | |||
| 76457 | 76457 | 125449 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3101 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5999876.27718 | 2115725.0378099997 | 37.789369177790206 | -122.444283251471 | (37.7893691777902, -122.444283251471) | |||
| 121499 | 121499 | 37576 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 124 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40009 | 5999906.30838792 | 2105075.4680497 | 37.7601298795068 | -122.44341407918002 | (37.7601298795068, -122.44341407918) | ||
| 148413 | 148413 | 203491 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 27 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999912.45047 | 2095466.00696 | 37.733744960750705 | -122.44270283418899 | (37.7337449607507, -122.442702834189) | |||
| 39883 | 39883 | 203492 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 23 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5999946.35958 | 2095464.23555 | 37.7337420298607 | -122.442585473564 | (37.7337420298607, -122.442585473564) | |||
| 183455 | 183455 | 221765 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 165 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000037.69587 | 2106199.4106799997 | 37.7632234397255 | -122.443040392005 | (37.7632234397255, -122.443040392005) | |||
| 69728 | 69728 | 125437 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.44406922002199 | (37.8045448847905, -122.444069220022) | |||
| 54337 | 54337 | 175154 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000079.77144 | 2092298.5573 | 37.7250574153596 | -122.44189709559299 | (37.7250574153596, -122.441897095593) | |||
| 183613 | 183613 | 175155 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000081.06235 | 2092299.82458 | 37.7250609685792 | -122.441892723985 | (37.7250609685792, -122.441892723985) | |||
| 179679 | 179679 | 175156 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000083.66792 | 2092301.69867 | 37.7250662628724 | -122.441883851284 | (37.7250662628724, -122.441883851284) | |||
| 65811 | 65811 | 175157 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000084.80379 | 2092303.48045 | 37.7250712199557 | -122.44188005254 | (37.7250712199557, -122.44188005254) | |||
| 70001 | 70001 | 175158 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000088.06493 | 2092305.57905 | 37.7250771680567 | -122.44186892971399 | (37.7250771680567, -122.441868929714) | |||
| 160711 | 160711 | 175159 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000090.185269999 | 2092307.21266 | 37.7250817743959 | -122.441861717141 | (37.7250817743959, -122.441861717141) | |||
| 24123 | 24123 | 175160 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000093.42571 | 2092311.2225 | 37.7250929691415 | -122.44185080298 | (37.7250929691415, -122.44185080298) | |||
| 184886 | 184886 | 175161 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000095.42068 | 2092313.2586299998 | 37.7250986735632 | -122.44184405267 | (37.7250986735632, -122.44184405267) | |||
| 57123 | 57123 | 175162 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000098.0141199995 | 2092315.01212 | 37.7251036360216 | -122.441835213242 | (37.7251036360216, -122.441835213242) | |||
| 33529 | 33529 | 175163 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.44182642145701 | (37.7251102235329, -122.441826421457) | |||
| 76902 | 76902 | 175164 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000102.2336800005 | 2092318.3901400003 | 37.7251131517233 | -122.44182086904301 | (37.7251131517233, -122.441820869043) | |||
| 131923 | 131923 | 125440 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.44342510578801 | (37.8021484793247, -122.443425105788) | |||
| 148997 | 148997 | 125441 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000221.62171 | 2120363.5906700003 | 37.8021251149445 | -122.443421726125 | (37.8021251149445, -122.443421726125) | |||
| 33859 | 33859 | 220622 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 58 Fountain St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000334.98133 | 2101342.05017 | 37.7499032598351 | -122.441663574927 | (37.7499032598351, -122.441663574927) | |||
| 159347 | 159347 | 220623 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 58 Fountain St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6000335.70641 | 2101336.8621 | 37.7498890559574 | -122.44166069529699 | (37.7498890559574, -122.441660695297) | |||
| 48805 | 48805 | 220628 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 907 Elizabeth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6000553.10276 | 2101957.71166 | 37.751606143208 | -122.44095346395201 | (37.751606143208, -122.440953463952) | |||
| 76565 | 76565 | 220629 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 907 Elizabeth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6000561.393680001 | 2101957.84527 | 37.7516069822761 | -122.440924802556 | (37.7516069822761, -122.440924802556) | |||
| 43148 | 43148 | 32487 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 257 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36994 | 6000562.081590001 | 2106647.6707099997 | 37.7644841354656 | -122.441258885382 | (37.7644841354656, -122.441258885382) | |
| 146408 | 146408 | 220630 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 901 Elizabeth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6000579.189809999 | 2101957.47614 | 37.7516069822848 | -122.44086323496 | (37.7516069822848, -122.44086323496) | |||
| 152269 | 152269 | 220631 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 901 Elizabeth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000591.194080001 | 2101959.06133 | 37.751612018500204 | -122.440821836477 | (37.7516120185002, -122.440821836477) | |||
| 56342 | 56342 | 125442 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3719 Scott St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6000612.64349 | 2121133.3219999997 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | |||
| 267 | 267 | 175151 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000727.04119 | 2093604.3094 | 37.728679573387495 | -122.43975313162399 | (37.7286795733875, -122.439753131624) | |
| 11199 | 11199 | 79973 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 983 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773711 | 6000743.92966 | 2091299.8612400002 | 37.722353046939 | -122.439529617696 | (37.722353046939, -122.439529617696) | |
| 271 | 271 | 175152 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Santa Rosa Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000750.8705 | 2093589.3929700002 | 37.728639972642604 | -122.43966968351002 | (37.7286399726426, -122.43966968351) | |
| 134639 | 134639 | 203462 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 112 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6000775.11209 | 2094438.40357 | 37.7309725397368 | -122.43964672021299 | (37.7309725397368, -122.439646720213) | |||
| 160402 | 160402 | 203463 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 112 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6000775.43585 | 2094454.02267 | 37.731015444602896 | -122.43964672024099 | (37.7310154446029, -122.439646720241) | |||
| 101777 | 101777 | 91377 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 49 Seward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52069 | 6000873.0 | 2104304.0 | 37.7580666971462 | -122.440015443053 | (37.7580666971462, -122.440015443053) | |||
| 51714 | 51714 | 125450 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 44 Normandie Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000949.24806 | 2117425.20451 | 37.79409854965171 | -122.44069290604999 | (37.7940985496517, -122.44069290605) | |||
| 12679 | 12679 | 17228 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1880X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000994.2729400005 | 2091122.49333 | 37.721880279621 | -122.43865153853201 | (37.721880279621, -122.438651538532) | |||
| 158252 | 158252 | 221757 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Seward St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6001069.49524 | 2104258.14697 | 37.7579519799282 | -122.43933259334699 | (37.7579519799282, -122.439332593347) | |||
| 155868 | 155868 | 125451 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2601 Vallejo St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001095.19419 | 2117566.7818299998 | 37.7944955940578 | -122.44019807567499 | (37.7944955940578, -122.440198075675) | |||
| 41144 | 41144 | 175153 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 783 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6001323.552619999 | 2092431.0494099997 | 37.7254920046417 | -122.43760697060101 | (37.7254920046417, -122.437606970601) | |||
| 63403 | 63403 | 221758 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001348.5727699995 | 2104052.2530799997 | 37.757402522937 | -122.438352676761 | (37.757402522937, -122.438352676761) | |||
| 8942 | 8942 | 19287 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2810X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001358.59585 | 2115648.89401 | 37.7892445650455 | -122.439149150528 | (37.7892445650455, -122.439149150528) | |||
| 49294 | 49294 | 221759 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001360.92884 | 2104054.05926 | 37.7574081850601 | -122.438310074049 | (37.7574081850601, -122.438310074049) | |||
| 54829 | 54829 | 221760 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001372.8328 | 2104055.08022 | 37.7574116654297 | -122.43826897865101 | (37.7574116654297, -122.438268978651) | |||
| 121821 | 121821 | 17031 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1160X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001440.12949 | 2109757.61689 | 37.7730732545652 | -122.43844479592501 | (37.7730732545652, -122.438444795925) | |||
| 156178 | 156178 | 33132 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2927 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | 4x5 | Permit Number 37362 | 6001472.71004 | 2118540.58919 | 37.7971908999849 | -122.438961648188 | (37.7971908999849, -122.438961648188) |
| 47631 | 47631 | 221761 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4441 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001542.762080001 | 2104063.39418 | 37.75744415704379 | -122.437681892224 | (37.7574441570438, -122.437681892224) | |||
| 18805 | 18805 | 27714 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001610.45471 | 2097108.7336400002 | 37.7383521588292 | -122.436949905209 | (37.7383521588292, -122.436949905209) | |||
| 31793 | 31793 | 221773 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | |||
| 133444 | 133444 | 221774 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6001628.85719 | 2097123.02869 | 37.7383924556487 | -122.43688730163 | (37.7383924556487, -122.43688730163) | |||
| 73496 | 73496 | 220620 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 747 Duncan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6001698.74806 | 2099680.01267 | 37.745417306567 | -122.43682864783001 | (37.745417306567, -122.43682864783) | |||
| 32542 | 32542 | 221762 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4407 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001705.956180001 | 2104074.38405 | 37.7574836102927 | -122.43711828977399 | (37.7574836102927, -122.437118289774) | |||
| 49806 | 49806 | 221764 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3809 16th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6001727.44948 | 2106346.3994299998 | 37.7637232334694 | -122.437206631108 | (37.7637232334694, -122.437206631108) | |||
| 30740 | 30740 | 221771 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | |||
| 183969 | 183969 | 221770 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6001816.47531 | 2096513.16567 | 37.736728574973604 | -122.436194979235 | (37.7367285749736, -122.436194979235) | |||
| 179987 | 179987 | 221769 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6001830.02285 | 2096488.5302 | 37.7366617013818 | -122.436146377158 | (37.7366617013818, -122.436146377158) | |||
| 56741 | 56741 | 220619 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 618 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6001863.58646 | 2099454.0588599998 | 37.744806257700205 | -122.43624249671801 | (37.7448062577002, -122.436242496718) | ||||
| 151194 | 151194 | 220621 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 714 Duncan St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001868.87894 | 2099747.43156 | 37.745612090735506 | -122.43624518748999 | (37.7456120907355, -122.43624518749) | |||
| 41684 | 41684 | 203490 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 29 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001874.24208 | 2094906.2061700001 | 37.7323195164307 | -122.43588030914302 | (37.7323195164307, -122.435880309143) | |||
| 48809 | 48809 | 125436 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3157 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001892.570830001 | 2119015.7946 | 37.798519569189 | -122.437542875929 | (37.798519569189, -122.437542875929) | |||
| 127147 | 127147 | 17018 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1048 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001982.80486 | 2109858.7796099996 | 37.7733818753695 | -122.436574858617 | (37.7733818753695, -122.436574858617) | ||
| 7458 | 7458 | 18926 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 2689 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001985.03027 | 2115691.49541 | 37.7893971628975 | -122.43698481780599 | (37.7893971628975, -122.436984817806) | |||
| 5093 | 5093 | 18924 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2675 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2013 12:00:00 AM | 3 | 4x4 | Permit Number 770153 | 6002021.65815 | 2115693.95851 | 37.7894060077371 | -122.43685826610701 | (37.7894060077371, -122.436858266107) | |
| 8590 | 8590 | 102757 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002051.958459999 | 2117801.7316900003 | 37.795195129895895 | -122.436904386043 | (37.7951951298959, -122.436904386043) | |||
| 34506 | 34506 | 125457 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.795171616221104 | -122.43689843522101 | (37.7951716162211, -122.436898435221) | |||
| 53916 | 53916 | 220624 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6002066.32428 | 2102040.31203 | 37.7519190137697 | -122.435726468425 | (37.7519190137697, -122.435726468425) | |||
| 64478 | 64478 | 125452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002068.61749 | 2117342.59163 | 37.7939353973611 | -122.436813859368 | (37.7939353973611, -122.436813859368) | |||
| 54839 | 54839 | 125453 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002078.25785 | 2117342.70193 | 37.793936248105 | -122.43678051073299 | (37.793936248105, -122.436780510733) | |||
| 52304 | 52304 | 220625 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002079.843669999 | 2102040.673 | 37.751920772823794 | -122.43567974235 | (37.7519207728238, -122.43567974235) | |||
| 157035 | 157035 | 125454 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002093.86703 | 2117345.7842200003 | 37.7939455983674 | -122.43672672227 | (37.7939455983674, -122.43672672227) | |||
| 131618 | 131618 | 125455 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002099.50591 | 2117347.8348 | 37.7939515491883 | -122.436707358076 | (37.7939515491883, -122.436707358076) | |||
| 153719 | 153719 | 125456 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6002104.20596 | 2117349.59529 | 37.79395665014079 | -122.436691221543 | (37.7939566501408, -122.436691221543) | |||
| 156515 | 156515 | 220626 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002107.5344 | 2102041.80892 | 37.7519254645963 | -122.43558406527599 | (37.7519254645963, -122.435584065276) | |||
| 170392 | 170392 | 125444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | |||
| 49472 | 49472 | 41212 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 6 | Permit Number 41921 | 6002149.73701 | 2121055.69726 | 37.804135222937 | -122.43679910691002 | (37.804135222937, -122.43679910691) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");