Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8 | 8 | 122650 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 11 | 11 | 122658 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 12 | 12 | 122660 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 13 | 13 | 122648 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 16 | 16 | 122649 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 226 | 226 | 220498 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 217 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | 8 | Width 3ft | Permit Number 11470 | 6001117.07632 | 2105053.576 | 37.760138741716794 | -122.43922504972001 | (37.7601387417168, -122.43922504972) | |
| 236 | 236 | 8118 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 841 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003718.373 | 2111409.0283 | 37.777736949412606 | -122.430681932079 | (37.7777369494126, -122.430681932079) | ||
| 350 | 350 | 85805 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627.0 | 2111882.0 | 37.77948049775679 | -122.40335640121799 | (37.7794804977568, -122.403356401218) | |
| 351 | 351 | 251213 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 365 | 365 | 251211 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 384 | 384 | 85806 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627.0 | 2111882.0 | 37.77948049775679 | -122.40335640121799 | (37.7794804977568, -122.403356401218) | |
| 387 | 387 | 85807 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 396 | 396 | 251212 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 1371 | 1371 | 251505 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011658.68026 | 2112523.0235200003 | 37.781242368680296 | -122.403291911611 | (37.7812423686803, -122.403291911611) | ||||
| 1377 | 1377 | 8105 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 780 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 8 | 3X3 | 6004061.6732 | 2111513.0828 | 37.7780421005615 | -122.42950176141899 | (37.7780421005615, -122.429501761419) | ||
| 1452 | 1452 | 251537 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.0 | 2114247.0 | 37.7861081097809 | -122.395212511502 | (37.7861081097809, -122.395212511502) | ||||
| 1475 | 1475 | 187957 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 81 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014291.0 | 2114089.0 | 37.78568884516871 | -122.39429498812099 | (37.7856888451687, -122.394294988121) | |||
| 1577 | 1577 | 220490 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3040 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | Width 3ft | 6008734.34434 | 2102169.4736599997 | 37.75265016257671 | -122.41267655749901 | (37.7526501625767, -122.412676557499) | ||
| 2522 | 2522 | 141925 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900 MCALLISTER ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2013 12:00:00 AM | 2 | Width 0ft | 6004344.9249 | 2111897.598 | 37.7791139177501 | -122.42854930773399 | (37.7791139177501, -122.428549307734) | ||
| 2536 | 2536 | 141924 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 900 MCALLISTER ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004374.9759 | 2111902.445 | 37.7791289269844 | -122.428445694629 | (37.7791289269844, -122.428445694629) | |||
| 2719 | 2719 | 141993 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 818 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2008 12:00:00 AM | 2 | Width 0ft | 6003993.152000001 | 2111582.4748 | 37.778228754000004 | -122.429743751351 | (37.778228754, -122.429743751351) | ||
| 3264 | 3264 | 253390 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2529x Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 3726 | 3726 | 14780 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1019 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004321.3595 | 2111841.1408 | 37.7789575666093 | -122.42862680452801 | (37.7789575666093, -122.428626804528) | ||
| 6537 | 6537 | 22773 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1741 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001679.7734 | 2112097.4839 | 37.7795115699514 | -122.43778345572599 | (37.7795115699514, -122.437783455726) | |||
| 6538 | 6538 | 71898 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 455 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2015 12:00:00 AM | 3 | Permit Number 775644 | 6007926.40343 | 2114015.89838 | 37.7851322881578 | -122.416309554165 | (37.7851322881578, -122.416309554165) | |
| 9126 | 9126 | 2365 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2500 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | 6009712.991769 | 2102766.5035063997 | 37.7543443518018 | -122.409334337085 | (37.7543443518018, -122.409334337085) | |||
| 9188 | 9188 | 24853 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2434 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2009 12:00:00 AM | 5 | 3x3 | 6010702.6993234 | 2094455.8290061 | 37.7315804365911 | -122.40532643981899 | (37.7315804365911, -122.405326439819) | ||
| 9207 | 9207 | 84924 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2320 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009655.0 | 2103828.0 | 37.7572557336683 | -122.409609804431 | (37.7572557336683, -122.409609804431) | |||
| 9232 | 9232 | 903 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1176 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X6 | 6003354.20402 | 2094344.7552 | 37.7308618593504 | -122.430723691407 | (37.7308618593504, -122.430723691407) | ||
| 9403 | 9403 | 25513 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2575 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1996 12:00:00 AM | 6 | 3X4 | 6011006.096908799 | 2093637.3368888001 | 37.72934998707171 | -122.404219944137 | (37.7293499870717, -122.404219944137) | ||
| 10347 | 10347 | 87548 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2809 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2015 12:00:00 AM | 3 | 3x3 | 6011363.6591 | 2092480.1221 | 37.726192488710105 | -122.40290245438601 | (37.7261924887101, -122.402902454386) | ||
| 10401 | 10401 | 24863 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2636 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2015 12:00:00 AM | 5 | 4x4 | 6011074.2033 | 2093259.325 | 37.7283158506885 | -122.40395790213002 | (37.7283158506885, -122.40395790213) | ||
| 10649 | 10649 | 87528 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2684 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2012 12:00:00 AM | 3 | 4x4 | 6011133.0386 | 2093058.8298 | 37.727768619555896 | -122.403740403083 | (37.7277686195559, -122.403740403083) | ||
| 10848 | 10848 | 24888 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2774 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 8 | 4x4 | 6011251.1604 | 2092677.7834 | 37.7267289432293 | -122.403305257203 | (37.7267289432293, -122.403305257203) | ||
| 10876 | 10876 | 28683 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2961 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3X3 | 6011553.9607 | 2091855.0708 | 37.7244868510493 | -122.402200662543 | (37.7244868510493, -122.402200662543) | ||
| 10879 | 10879 | 27312 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2670 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 4x4 | 6011119.0302 | 2093108.0343 | 37.7279029423042 | -122.403792291485 | (37.7279029423042, -122.403792291485) | ||
| 11049 | 11049 | 24848 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2354 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/2013 12:00:00 AM | 3 | 3x3 | 6010497.60503 | 2095014.35127 | 37.7331025516429 | -122.406074827698 | (37.7331025516429, -122.406074827698) | ||
| 11051 | 11051 | 16382 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999194.33201 | 2088944.0721099998 | 37.7157962742582 | -122.444716950429 | (37.7157962742582, -122.444716950429) | ||
| 11114 | 11114 | 24872 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2675 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6011136.5589 | 2093211.8894 | 37.728189086016705 | -122.40373899855601 | (37.7281890860167, -122.403738998556) | ||
| 11275 | 11275 | 24866 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2675 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1996 12:00:00 AM | 3 | 3X3 | 6011160.2152 | 2093140.3949 | 37.727994098496204 | -122.403652189094 | (37.7279940984962, -122.403652189094) | ||
| 11321 | 11321 | 24880 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2473 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2015 12:00:00 AM | 5 | 3X3 | 6010833.7586 | 2094203.8757 | 37.73089595245371 | -122.40485560772899 | (37.7308959524537, -122.404855607729) | ||
| 11390 | 11390 | 887 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1132 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2016 12:00:00 AM | 3 | 3x4 | 6003641.7751 | 2094429.9895799998 | 37.731112181982205 | -122.429735588731 | (37.7311121819822, -122.429735588731) | ||
| 11396 | 11396 | 122654 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 11418 | 11418 | 122651 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 11649 | 11649 | 122647 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 12098 | 12098 | 24887 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2770 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 3 | 4x4 | 6011241.1722 | 2092707.2223 | 37.7268092184902 | -122.40334185639401 | (37.7268092184902, -122.403341856394) | ||
| 12270 | 12270 | 24873 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2585 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6011029.3172 | 2093570.939 | 37.7291689698102 | -122.40413499793101 | (37.7291689698102, -122.404134997931) | ||
| 12297 | 12297 | 122656 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 12338 | 12338 | 122652 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 12370 | 12370 | 27313 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2684 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 3X3 | 6011127.7854 | 2093073.5386 | 37.7278087133965 | -122.403759598129 | (37.7278087133965, -122.403759598129) | ||
| 12783 | 12783 | 24849 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2354 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2011 12:00:00 AM | 3 | 2x2 | 6010506.727580001 | 2094990.7524400002 | 37.7330382644924 | -122.40604162653 | (37.7330382644924, -122.40604162653) | ||
| 13022 | 13022 | 1124 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2463 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999036.51586 | 2088791.0726700001 | 37.715367165446 | -122.44525144000099 | (37.715367165446, -122.445251440001) | ||
| 13076 | 13076 | 921 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1252 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X3 | 6002917.86629 | 2094183.9473299999 | 37.730395586884 | -122.432220700641 | (37.730395586884, -122.432220700641) | ||
| 13147 | 13147 | 24862 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2626 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 4 | 3x3 | 6011036.3806 | 2093380.4977 | 37.728646452424705 | -122.40409718178101 | (37.7286464524247, -122.404097181781) | ||
| 13682 | 13682 | 86688 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 833 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011619.91608 | 2110365.80085 | 37.7753169695418 | -122.403274219231 | (37.7753169695418, -122.403274219231) | ||
| 13744 | 13744 | 115348 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014915.48611 | 2114547.7853200003 | 37.7869832575075 | -122.39216652446001 | (37.7869832575075, -122.39216652446) | |
| 13813 | 13813 | 115356 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014763.69701 | 2114705.74438 | 37.7874085478076 | -122.39270273893801 | (37.7874085478076, -122.392702738938) | |
| 13917 | 13917 | 115353 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014819.91687 | 2114646.3157900004 | 37.787248492781295 | -122.39250406973 | (37.7872484927813, -122.39250406973) | |
| 14125 | 14125 | 27452 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6X6 | 6015192.769090001 | 2100696.5145099997 | 37.7489660934285 | -122.390239101956 | (37.7489660934285, -122.390239101956) | |||
| 14319 | 14319 | 27172 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2240 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012891.710469999 | 2096272.40031 | 37.73669050935371 | -122.39788592938801 | (37.7366905093537, -122.397885929388) | ||
| 14382 | 14382 | 115352 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014845.33617 | 2114621.37484 | 37.7871814222392 | -122.392414378515 | (37.7871814222392, -122.392414378515) | |
| 14383 | 14383 | 118374 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x6 | 6014693.17098 | 2114681.8097099997 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | |||
| 14429 | 14429 | 115355 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014786.34664 | 2114681.69198 | 37.7873437633547 | -122.392622692086 | (37.7873437633547, -122.392622692086) | |
| 14524 | 14524 | 52852 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014360.0420699995 | 2114216.81563 | 37.7860436350529 | -122.394065071555 | (37.7860436350529, -122.394065071555) | |
| 14664 | 14664 | 27459 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1601 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 6X6 | 6015175.2959199995 | 2101002.60795 | 37.749805592554104 | -122.39032090789 | (37.7498055925541, -122.39032090789) | |||
| 14670 | 14670 | 108060 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014722.47105 | 2114748.4926400003 | 37.7875236349662 | -122.39284836525299 | (37.7875236349662, -122.392848365253) | ||
| 14673 | 14673 | 52844 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014342.2793 | 2114200.39615 | 37.785997563678706 | -122.39412537650401 | (37.7859975636787, -122.394125376504) | |
| 14677 | 14677 | 52149 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1566 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48340 | 6015439.23849 | 2096619.2496 | 37.737784433906995 | -122.389102155646 | (37.737784433907, -122.389102155646) |
| 14698 | 14698 | 27453 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6X6 | 6015188.65813 | 2100719.92865 | 37.7490301557222 | -122.390254953405 | (37.7490301557222, -122.390254953405) | |||
| 14738 | 14738 | 8260 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6015944.99866 | 2097559.42208 | 37.74039397959 | -122.38741905015301 | (37.74039397959, -122.387419050153) | ||
| 14909 | 14909 | 86671 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1155 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009854.63379 | 2108677.64485 | 37.7705829373798 | -122.409261609551 | (37.7705829373798, -122.409261609551) | ||
| 15073 | 15073 | 86684 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 855 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778066 | 6011500.82378 | 2110252.42097 | 37.7749990025284 | -122.403678209983 | (37.7749990025284, -122.403678209983) | |
| 15102 | 15102 | 115350 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014880.23802 | 2114582.9179 | 37.7870777663613 | -122.39229093398599 | (37.7870777663613, -122.392290933986) | |
| 15125 | 15125 | 8266 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 3 | 3x3 | 6016120.90063 | 2097426.65215 | 37.740039161084496 | -122.38680158822599 | (37.7400391610845, -122.386801588226) | ||
| 15143 | 15143 | 86673 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1157 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009836.98822 | 2108663.0502 | 37.770541875235 | -122.409321615924 | (37.770541875235, -122.409321615924) | ||
| 15322 | 15322 | 27454 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | 6015187.13368 | 2100745.31925 | 37.7490997884263 | -122.390261998696 | (37.7490997884263, -122.390261998696) | |||
| 15384 | 15384 | 52851 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014328.65794 | 2114187.65388 | 37.785961819236604 | -122.39417161065799 | (37.7859618192366, -122.394171610658) | |
| 15397 | 15397 | 52842 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014392.61709 | 2114247.3993599997 | 37.786129421386796 | -122.393954511599 | (37.7861294213868, -122.393954511599) | |
| 15478 | 15478 | 115354 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014804.627730001 | 2114662.16926 | 37.7872911737029 | -122.39255807669 | (37.7872911737029, -122.39255807669) | |
| 15549 | 15549 | 8265 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 4 | 3x3 | 6016061.13265 | 2097468.88208 | 37.7401518065476 | -122.387011187809 | (37.7401518065476, -122.387011187809) | ||
| 15617 | 15617 | 27455 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | 6015186.58653 | 2100768.66108 | 37.7491638498456 | -122.390265521335 | (37.7491638498456, -122.390265521335) | |||
| 15672 | 15672 | 8261 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6015960.32543 | 2097546.41144 | 37.7403591038818 | -122.387365148376 | (37.7403591038818, -122.387365148376) | ||
| 15710 | 15710 | 86672 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1155 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009883.68707 | 2108705.67197 | 37.77066152104221 | -122.409163091525 | (37.7706615210422, -122.409163091525) | ||
| 15760 | 15760 | 8264 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6016042.026869999 | 2097486.66692 | 37.74019958213879 | -122.38707848858401 | (37.7401995821388, -122.387078488584) | ||
| 15765 | 15765 | 116155 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167X Jessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777681 | 6011953.87529 | 2114523.8963900004 | 37.7867527801633 | -122.402411408766 | (37.7867527801633, -122.402411408766) | |
| 15935 | 15935 | 86687 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 833 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011571.17232 | 2110322.10121 | 37.7751942579517 | -122.40343976104602 | (37.7751942579517, -122.403439761046) | ||
| 15954 | 15954 | 86690 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 833 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011662.16026 | 2110406.91689 | 37.7754322239569 | -122.40313097880801 | (37.7754322239569, -122.403130978808) | ||
| 16093 | 16093 | 86683 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 925 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011000.86666 | 2109774.4042 | 37.7736585378513 | -122.40537400761299 | (37.7736585378513, -122.405374007613) | ||
| 16266 | 16266 | 115349 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014896.08459 | 2114567.05321 | 37.787035085459706 | -122.392234997951 | (37.7870350854597, -122.392234997951) | |
| 16307 | 16307 | 108061 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014711.31667 | 2114762.0418700003 | 37.7875602184789 | -122.392887905777 | (37.7875602184789, -122.392887905777) | ||
| 16337 | 16337 | 115351 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014858.418740001 | 2114606.67601 | 37.7871417890985 | -122.39236808681801 | (37.7871417890985, -122.392368086818) | |
| 16382 | 16382 | 108062 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014690.02107 | 2114784.12371 | 37.787619667256706 | -122.392963130455 | (37.7876196672567, -122.392963130455) | ||
| 16419 | 16419 | 86689 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 833 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011647.231000001 | 2110392.1587400003 | 37.775390867731794 | -122.40318158457701 | (37.7753908677318, -122.403181584577) | ||
| 16605 | 16605 | 52850 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014308.484180001 | 2114166.94411 | 37.7859038336441 | -122.39423995641701 | (37.7859038336441, -122.394239956417) | |
| 17188 | 17188 | 28843 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 338 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2008 12:00:00 AM | 3 | 3X3 | 5993062.32103 | 2089859.0124700002 | 37.7179566445716 | -122.465978279778 | (37.7179566445716, -122.465978279778) | ||
| 17211 | 17211 | 2422 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2837 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 3 | 3X3 | 6009869.07173 | 2100846.12379 | 37.7490801589169 | -122.408659105156 | (37.7490801589169, -122.408659105156) | ||
| 17525 | 17525 | 654 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3255X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6007301.1492800005 | 2102040.7128 | 37.7522160715366 | -122.417623684893 | (37.7522160715366, -122.417623684893) | ||
| 18035 | 18035 | 101991 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 18132 | 18132 | 25478 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2451X Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2002 12:00:00 AM | 6 | 3X3 | 6009740.95146 | 2103104.50441 | 37.7552739931277 | -122.40926149534401 | (37.7552739931277, -122.409261495344) | ||
| 18303 | 18303 | 122659 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 |
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");