Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33396 | 33396 | 52147 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 991 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 3 | Permit Number 48338 | 6018752.39982 | 2094769.7701 | 37.7328892306529 | -122.377518518074 | (37.7328892306529, -122.377518518074) | |
| 171411 | 171411 | 193297 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1013 Oakdale Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6018142.28211 | 2093130.97171 | 37.7283557769992 | -122.379514069636 | (37.7283557769992, -122.379514069636) | |||
| 47923 | 47923 | 193296 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1013 Oakdale Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6018120.52005 | 2093146.9977400003 | 37.728398581107 | -122.379590415761 | (37.728398581107, -122.379590415761) | |||
| 93920 | 93920 | 10841 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1139X Hudson Ave | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 3 | 3X4 | 6018009.01401 | 2094605.73201 | 37.732397829987896 | -122.38007722584801 | (37.7323978299879, -122.380077225848) | ||
| 80201 | 80201 | 10840 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1139X Hudson Ave | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 3 | 3X4 | 6017999.90001 | 2094605.73201 | 37.7323973271712 | -122.380108735409 | (37.7323973271712, -122.380108735409) | ||
| 43709 | 43709 | 193287 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1333 Hudson Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017994.802069999 | 2094589.40818 | 37.7323522238796 | -122.380125226414 | (37.7323522238796, -122.380125226414) | |||
| 152672 | 152672 | 193286 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1333 Hudson Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017977.93865 | 2094591.23202 | 37.7323563014062 | -122.380183654476 | (37.7323563014062, -122.380183654476) | |||
| 15138 | 15138 | 85593 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1035 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017785.7597 | 2093054.1055 | 37.7281250477035 | -122.38074125570299 | (37.7281250477035, -122.380741255703) | ||
| 15880 | 15880 | 85592 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1035 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017759.3783 | 2093071.6931 | 37.7281718838379 | -122.380833680203 | (37.7281718838379, -122.380833680203) | ||
| 14814 | 14814 | 85594 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1039 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017732.9969 | 2093089.2807 | 37.728218719899395 | -122.38092610482 | (37.7282187198994, -122.38092610482) | ||
| 15482 | 15482 | 85595 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1043 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017691.776000001 | 2093118.9598 | 37.728297937685795 | -122.38107067117399 | (37.7282979376858, -122.381070671174) | ||
| 16473 | 16473 | 85596 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1081 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017650.0054 | 2093150.2876 | 37.728381651957704 | -122.381217252784 | (37.7283816519577, -122.381217252784) | ||
| 118432 | 118432 | 6711 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1200X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/20/2015 05:42:00 PM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 136994 | 136994 | 193298 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1040 Palou Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6017507.81667 | 2093329.7899200001 | 37.7288666800305 | -122.38172129012 | (37.7288666800305, -122.38172129012) | |||
| 31224 | 31224 | 60350 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1101 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 4 | Permit Number 19928 | 6017464.7861 | 2093286.0419 | 37.72874418038629 | -122.381867009636 | (37.7287441803863, -122.381867009636) | |
| 20846 | 20846 | 4906 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 94 Ardath Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2004 12:00:00 AM | 3 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | ||
| 169566 | 169566 | 193295 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1013 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017437.79116 | 2093660.55631 | 37.7297710328838 | -122.38198637428002 | (37.7297710328838, -122.38198637428) | |||
| 178805 | 178805 | 193290 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Ardath Ct | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017463.55131 | 2095291.12818 | 37.734249684563 | -122.38201069645099 | (37.734249684563, -122.382010696451) | |||
| 131610 | 131610 | 193291 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Ardath Ct | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017457.59567 | 2095286.9396900001 | 37.7342378548914 | -122.382030995952 | (37.7342378548914, -122.382030995952) | |||
| 26259 | 26259 | 193294 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1013 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017423.214930001 | 2093673.93611 | 37.729806966204 | -122.38203769679701 | (37.729806966204, -122.382037696797) | |||
| 131622 | 131622 | 193293 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1013 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017403.2868099995 | 2093687.4235599998 | 37.7298428995102 | -122.382107529135 | (37.7298428995102, -122.382107529135) | |||
| 106667 | 106667 | 1399 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 54 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017410.5516844 | 2095373.0690166 | 37.7344717507601 | -122.382199633479 | (37.7344717507601, -122.382199633479) | ||
| 152442 | 152442 | 193314 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1215 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017437.09281 | 2096794.30817 | 37.73837565632311 | -122.382206710884 | (37.7383756563231, -122.382206710884) | |||
| 15878 | 15878 | 6748 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1215 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6017436.89509 | 2096796.0516400002 | 37.7383804326225 | -122.382207515766 | (37.7383804326225, -122.382207515766) | ||
| 186466 | 186466 | 199882 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1131 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017363.6575 | 2093361.8884 | 37.728946855007 | -122.382221895551 | (37.728946855007, -122.382221895551) | |||
| 165435 | 165435 | 193100 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1224 Fairfax Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6017433.94384 | 2096880.5876 | 37.7386123884484 | -122.38222359924801 | (37.7386123884484, -122.382223599248) | |||
| 171547 | 171547 | 193289 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Ardath Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017396.94192 | 2095313.3929599999 | 37.7343071404432 | -122.38224253716601 | (37.7343071404432, -122.382242537166) | |||
| 168528 | 168528 | 193292 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1013 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017364.44288 | 2093716.31678 | 37.7299200892409 | -122.38224382770599 | (37.7299200892409, -122.382243827706) | |||
| 116984 | 116984 | 1405 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 63 Ardath Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017388.835420901 | 2095314.9218022998 | 37.7343108905935 | -122.382270670557 | (37.7343108905935, -122.382270670557) | ||
| 15738 | 15738 | 85600 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1139 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017318.5893 | 2093398.7124 | 37.7290454771777 | -122.38238026214898 | (37.7290454771777, -122.382380262149) | ||
| 30480 | 30480 | 193101 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1224 Fairfax Ave | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6017385.96084 | 2096915.0483 | 37.7387043603066 | -122.382391900165 | (37.7387043603066, -122.382391900165) | |||
| 128424 | 128424 | 1398 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 47 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/2004 12:00:00 AM | 3 | 3X4 | 6017352.5573683 | 2095370.3956040002 | 37.734461206815794 | -122.382399955055 | (37.7344612068158, -122.382399955055) | ||
| 14929 | 14929 | 6764 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1275 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2016 12:00:00 AM | 2 | 3x3 | 6017334.578 | 2096870.9361 | 37.7385803986719 | -122.38256649097299 | (37.7385803986719, -122.382566490973) | ||
| 16426 | 16426 | 85601 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1155 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017239.4451 | 2093453.6736 | 37.7291920178595 | -122.382657695444 | (37.7291920178595, -122.382657695444) | ||
| 34631 | 34631 | 193299 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1040 Palou Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017230.76066 | 2093531.8057400002 | 37.7294060736082 | -122.382693153289 | (37.7294060736082, -122.382693153289) | |||
| 62921 | 62921 | 193300 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1040 Palou Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017214.21978 | 2093544.8554099998 | 37.72944099160829 | -122.38275124498301 | (37.7294409916083, -122.382751244983) | |||
| 158336 | 158336 | 193288 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017236.66649 | 2095426.16645 | 37.734607940290104 | -122.382804511829 | (37.7346079402901, -122.382804511829) | |||
| 67062 | 67062 | 193102 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1298 Fairfax Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017232.4115699995 | 2097031.5064 | 37.739015648063294 | -122.382930908836 | (37.7390156480633, -122.382930908836) | |||
| 14554 | 14554 | 85564 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1180 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017158.96801 | 2093588.1335200001 | 37.7295567721058 | -122.38294526831001 | (37.7295567721058, -122.38294526831) | ||
| 9388 | 9388 | 6758 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1355 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6017217.4089567 | 2096970.3613046003 | 37.738846926957706 | -122.382978527185 | (37.7388469269577, -122.382978527185) | ||
| 13375 | 13375 | 26662 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1275 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2001 12:00:00 AM | 8 | 3x3 | 6017216.3972 | 2096959.142 | 37.73881606509521 | -122.382981244792 | (37.7388160650952, -122.382981244792) | ||
| 14168 | 14168 | 6760 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1275 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6017216.38852 | 2096959.4605400001 | 37.7388169392625 | -122.38298129696699 | (37.7388169392625, -122.382981296967) | ||
| 15624 | 15624 | 85602 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1179 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017122.3777 | 2093542.7108 | 37.7294300284364 | -122.38306860583201 | (37.7294300284364, -122.383068605832) | ||
| 13420 | 13420 | 85563 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1186 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017119.22187 | 2093617.0442599999 | 37.7296339591237 | -122.383084687511 | (37.7296339591237, -122.383084687511) | ||
| 154335 | 154335 | 193099 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1275 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017167.81158 | 2096994.8385400001 | 37.7389113959363 | -122.383151716704 | (37.7389113959363, -122.383151716704) | |||
| 16704 | 16704 | 6778 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1275 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2015 12:46:00 PM | 3 | 3x3 | 6017160.06774 | 2096999.6033400001 | 37.738924051197 | -122.38317882313801 | (37.738924051197, -122.383178823138) | ||
| 14811 | 14811 | 85603 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1187 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017079.5079 | 2093574.5883 | 37.7295151888321 | -122.38321903025299 | (37.7295151888321, -122.383219030253) | ||
| 35234 | 35234 | 193313 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1353 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017070.664 | 2097068.65347 | 37.739108708094605 | -122.38349274858601 | (37.7391087080946, -122.383492748586) | |||
| 74690 | 74690 | 193098 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1301 Fairfax Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017070.0677 | 2097067.7936 | 37.739106314107396 | -122.383494750497 | (37.7391063141074, -122.383494750497) | |||
| 179479 | 179479 | 59843 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1234 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | 3 | Permit Number 19298 | 6016839.42379 | 2093825.06532 | 37.730189678993 | -122.384066468412 | (37.730189678993, -122.384066468412) | |
| 13676 | 13676 | 6743 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1300X Fairfax Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016859.78768 | 2097310.83297 | 37.7397620268834 | -122.38423873174101 | (37.7397620268834, -122.384238731741) | |||
| 15204 | 15204 | 85571 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1252 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016751.401219999 | 2093891.75216 | 37.730367921037704 | -122.384375419698 | (37.7303679210377, -122.384375419698) | ||
| 186696 | 186696 | 193301 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1252 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016734.51502 | 2093904.2827400002 | 37.7304013937892 | -122.384434670625 | (37.7304013937892, -122.384434670625) | |||
| 15777 | 15777 | 6783 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1360 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2008 12:00:00 AM | 4 | 3x3 | 6016785.69492 | 2097365.6274 | 37.739908384353704 | -122.38449873115201 | (37.7399083843537, -122.384498731152) | ||
| 35665 | 35665 | 193302 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1252 Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016713.98205 | 2093918.10551 | 37.730438212946 | -122.3845066191 | (37.730438212946, -122.3845066191) | |||
| 169334 | 169334 | 193103 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1360 Fairfax Ave | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6016766.03407 | 2097379.43395 | 37.739945207105706 | -122.38456767227501 | (37.7399452071057, -122.384567672275) | |||
| 78220 | 78220 | 34235 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1997 12:00:00 AM | Permit Number 38048 | 6016895.91787464 | 2103845.69851644 | 37.757707418448895 | -122.38456887610201 | (37.7577074184489, -122.384568876102) | ||||
| 61600 | 61600 | 60377 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1264 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 4 | Permit Number 19957 | 6016692.94797 | 2093937.42445 | 37.7304900957418 | -122.384580682763 | (37.7304900957418, -122.384580682763) | |
| 57919 | 57919 | 60356 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1261 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1982 12:00:00 AM | 4 | Permit Number 19934 | 6016682.1383 | 2093866.4324 | 37.73029456782329 | -122.384613110545 | (37.7302945678233, -122.384613110545) | ||
| 15876 | 15876 | 10708 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 15 Hillview Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/13/1992 12:00:00 AM | 6 | 3X3 | 6016671.96235 | 2095749.03192 | 37.735463248631895 | -122.384779387057 | (37.7354632486319, -122.384779387057) | ||
| 58628 | 58628 | 59850 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1274 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | 4 | Permit Number 19305 | 6016629.87582 | 2093981.66592 | 37.7306080858771 | -122.38480181525101 | (37.7306080858771, -122.384801815251) | |
| 186262 | 186262 | 199764 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1255 Thomas Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016594.3244 | 2092538.983 | 37.7266447967684 | -122.384824257677 | (37.7266447967684, -122.384824257677) | |||
| 169361 | 169361 | 47052 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1276 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 3 | Permit Number 45040 | 6016615.094219999 | 2093992.32561 | 37.730636537723996 | -122.38485366028401 | (37.730636537724, -122.384853660284) | |
| 49424 | 49424 | 199763 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1255 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016578.9006 | 2092551.6525 | 37.7266787316474 | -122.38487845999501 | (37.7266787316474, -122.384878459995) | |||
| 87061 | 87061 | 41151 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1255 Thomas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1999 12:00:00 AM | Permit Number 41882 | 6016576.16767017 | 2092557.57832043 | 37.7266948516275 | -122.38488832038799 | (37.7266948516275, -122.384888320388) | |||
| 97814 | 97814 | 41150 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1255 Thomas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1999 12:00:00 AM | Permit Number 41882 | 6016576.16767017 | 2092557.57832043 | 37.7266948516275 | -122.38488832038799 | (37.7266948516275, -122.384888320388) | |||
| 122419 | 122419 | 41152 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1255 Thomas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1999 12:00:00 AM | Permit Number 41882 | 6016576.16767017 | 2092557.57832043 | 37.7266948516275 | -122.38488832038799 | (37.7266948516275, -122.384888320388) | |||
| 15933 | 15933 | 85566 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1276 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016597.9205 | 2094005.7762099998 | 37.7306725205231 | -122.384913969722 | (37.7306725205231, -122.384913969722) | ||
| 178967 | 178967 | 199762 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1255 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016551.909 | 2092571.4831 | 37.726731689633006 | -122.384973150968 | (37.726731689633, -122.384973150968) | |||
| 72662 | 72662 | 38579 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1362 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40539 | 6016531.7201 | 2093711.98 | 37.7298621524902 | -122.385122374239 | (37.7298621524902, -122.385122374239) | |
| 30549 | 30549 | 193312 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1381 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016602.66581 | 2097418.43823 | 37.7400432691891 | -122.385135254204 | (37.7400432691891, -122.385135254204) | |||
| 808 | 808 | 193091 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1395 Fairfax Ave | 1 | : 4 | Tree 1 | DPW 2 | 01/27/2015 12:22:00 PM | 6 | Width 3ft | 6016598.40823 | 2097419.6759099998 | 37.7400464320877 | -122.38515006152201 | (37.7400464320877, -122.385150061522) | ||
| 117934 | 117934 | 6806 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1395 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/2006 12:00:00 AM | 6 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | ||
| 15805 | 15805 | 6811 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1400X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016498.596480001 | 2097579.9662200003 | 37.7404810348687 | -122.38550634055599 | (37.7404810348687, -122.385506340556) | ||
| 86625 | 86625 | 38545 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1553 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40517 | 6016422.80620482 | 2093917.0086828 | 37.7304190951777 | -122.385513188555 | (37.7304190951777, -122.385513188555) | ||
| 59625 | 59625 | 38544 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1390x Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 10 | Permit Number 40517 | 6016416.5284 | 2093796.8581 | 37.7300888381629 | -122.385526521894 | (37.7300888381629, -122.385526521894) | |
| 48197 | 48197 | 38542 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1390x Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40517 | 6016397.5824 | 2093808.2257 | 37.7301190030539 | -122.385592813155 | (37.7301190030539, -122.385592813155) | |
| 15048 | 15048 | 6813 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1400X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/15/1998 12:00:00 AM | 6 | 3X3 | 6016463.58165 | 2097607.01609 | 37.740553370940106 | -122.38562929405799 | (37.7405533709401, -122.385629294058) | ||
| 54377 | 54377 | 38543 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1390x Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40517 | 6016380.1521 | 2093821.1090000002 | 37.730153413587104 | -122.385653970047 | (37.7301534135871, -122.385653970047) | |
| 155929 | 155929 | 38541 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1543 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40516 | 6016381.1458 | 2093874.2412 | 37.7302993590512 | -122.385654236285 | (37.7302993590512, -122.385654236285) | |
| 16072 | 16072 | 85572 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1318 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016383.60339 | 2094168.56913 | 37.731107661074 | -122.38566624542 | (37.731107661074, -122.38566624542) | ||
| 130002 | 130002 | 193090 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1401 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6016442.7129999995 | 2097535.30475 | 37.7403553114351 | -122.385696453647 | (37.7403553114351, -122.385696453647) | |||
| 70707 | 70707 | 38546 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1553 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 8 | Permit Number 40517 | 6016366.8237 | 2093859.9191 | 37.730259240913206 | -122.385702752376 | (37.7302592409132, -122.385702752376) | |
| 67368 | 67368 | 193089 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1401 Fairfax Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6016423.24645 | 2097547.7805 | 37.740388490129 | -122.38576463122601 | (37.740388490129, -122.385764631226) | |||
| 16607 | 16607 | 85573 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1326 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016350.412819999 | 2094192.0947599998 | 37.731170421177296 | -122.385782631175 | (37.7311704211773, -122.385782631175) | ||
| 14479 | 14479 | 11386 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1435 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/1994 12:00:00 AM | 6 | 3X4 | 6016388.35933 | 2096530.1840400002 | 37.737592445724395 | -122.385814348454 | (37.7375924457244, -122.385814348454) | ||
| 143581 | 143581 | 8229 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1500X Galvez Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 08:40:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 58416 | 58416 | 193092 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1400 Fairfax Ave | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016395.45108 | 2097656.02756 | 37.7406841764345 | -122.385868280805 | (37.7406841764345, -122.385868280805) | |||
| 150384 | 150384 | 193093 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1400 Fairfax Ave | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016378.42726 | 2097668.39024 | 37.7407171797429 | -122.385928004771 | (37.7407171797429, -122.385928004771) | |||
| 154971 | 154971 | 193308 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1433 Galvez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6016349.7682 | 2097340.5734599996 | 37.739815475409706 | -122.386004251994 | (37.7398154754097, -122.386004251994) | |||
| 76466 | 76466 | 193088 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1445 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016353.82584 | 2097602.79871 | 37.740535717244605 | -122.386008496795 | (37.7405357172446, -122.386008496795) | |||
| 14878 | 14878 | 85605 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1331X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016284.219 | 2094162.6734 | 37.7310859728112 | -122.38600942688299 | (37.7310859728112, -122.386009426883) | ||
| 33773 | 33773 | 199865 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1600 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6016268.2217 | 2093791.063 | 37.730064719169505 | -122.386038837831 | (37.7300647191695, -122.386038837831) | |||
| 14562 | 14562 | 85574 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1340 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016270.51718 | 2094251.9136599998 | 37.7313302504855 | -122.386063015505 | (37.7313302504855, -122.386063015505) | ||
| 184205 | 184205 | 199866 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1600 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016259.959 | 2093780.5969 | 37.7300355240413 | -122.386066673972 | (37.7300355240413, -122.386066673972) | |||
| 70022 | 70022 | 83708 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1408 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52294 | 6016257.9441 | 2093910.7968 | 37.730392915588205 | -122.386082712621 | (37.7303929155882, -122.386082712621) | |
| 180114 | 180114 | 199867 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1600 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6016252.7979 | 2093769.029 | 37.7300033645512 | -122.386090624912 | (37.7300033645512, -122.386090624912) | |||
| 25815 | 25815 | 200083 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1699 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6016251.1454 | 2093700.7237 | 37.7298157202983 | -122.386091578066 | (37.7298157202983, -122.386091578066) | |||
| 160145 | 160145 | 193309 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1433 Galvez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6016323.77034 | 2097360.91546 | 37.7398698915759 | -122.38609556018 | (37.7398698915759, -122.38609556018) | |||
| 15801 | 15801 | 85606 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1339 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016251.7919 | 2094186.3067 | 37.7311490704717 | -122.38612318092301 | (37.7311490704717, -122.386123180923) |
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");