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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108178 | 108178 | 112584 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
| 113705 | 113705 | 112586 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
| 38258 | 38258 | 113355 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 5982766.03998 | 2112575.4615 | 37.779730331527404 | -122.503248436763 | (37.7797303315274, -122.503248436763) | |||
| 80627 | 80627 | 24740 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/07/2012 12:00:00 AM | 3 | 3X3 | 5982774.3423 | 2112574.7084 | 37.779728751764104 | -122.503219660118 | (37.7797287517641, -122.503219660118) | ||
| 118920 | 118920 | 113357 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 POINT LOBOS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 5982777.0 | 2112621.0 | 37.779856011140204 | -122.50321389449499 | (37.7798560111402, -122.503213894495) | ||||
| 119386 | 119386 | 24739 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2004 12:00:00 AM | 3 | 3X3 | 5982782.27657 | 2112574.64249 | 37.7797290371816 | -122.503192207591 | (37.7797290371816, -122.503192207591) | ||
| 96869 | 96869 | 90309 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4115 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982775.05183 | 2110989.27027 | 37.7753756437209 | -122.503099794321 | (37.7753756437209, -122.503099794321) | ||
| 104405 | 104405 | 90971 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4101 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982789.9497 | 2110989.59501 | 37.775377411022205 | -122.503048284011 | (37.7753774110222, -122.503048284011) | ||
| 41737 | 41737 | 183303 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1286 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982766.9656 | 2106385.9546 | 37.7627357893861 | -122.502786935917 | (37.7627357893861, -122.502786935917) | |||
| 112446 | 112446 | 83301 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2194 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | ||
| 113043 | 113043 | 115237 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775536 | 5982900.6 | 2109891.1 | 37.772367765473795 | -122.502584200594 | (37.7723677654738, -122.502584200594) | |||
| 175819 | 175819 | 117934 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982916.92515 | 2109877.9656700003 | 37.7723326617078 | -122.502526759002 | (37.7723326617078, -122.502526759002) | |||
| 78895 | 78895 | 81730 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2346 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774950 | 5982707.54204511 | 2099147.52139682 | 37.7428575871403 | -122.502456702486 | (37.7428575871403, -122.502456702486) | |
| 32349 | 32349 | 184697 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1616 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982844.3503 | 2104136.3629 | 37.7565635951525 | -122.502352798468 | (37.7565635951525, -122.502352798468) | |||
| 1430 | 1430 | 183687 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 33196 | 5983043.3769 | 2106010.2341 | 37.7617204082059 | -122.50180314292801 | (37.7617204082059, -122.501803142928) | |
| 1417 | 1417 | 183690 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983045.4855 | 2105953.0685 | 37.7615635715471 | -122.50179162058001 | (37.7615635715471, -122.50179162058) | ||
| 1428 | 1428 | 183691 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.4226 | 2105931.5142 | 37.76150444459871 | -122.50178678479799 | (37.7615044445987, -122.501786784798) | ||
| 1386 | 1386 | 183693 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.6569 | 2105897.5428 | 37.7614111825323 | -122.501783460946 | (37.7614111825323, -122.501783460946) | ||
| 1390 | 1390 | 183692 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983047.3598 | 2105912.7714 | 37.761453037237 | -122.501782156698 | (37.761453037237, -122.501782156698) | ||
| 1404 | 1404 | 183694 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983048.5312 | 2105875.9885 | 37.7613521106328 | -122.501775383852 | (37.7613521106328, -122.501775383852) | ||
| 1408 | 1408 | 183696 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983051.3079 | 2105837.6039 | 37.7612468805065 | -122.50176294055599 | (37.7612468805065, -122.501762940556) | ||
| 1419 | 1419 | 183699 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983053.3747 | 2105791.1008 | 37.761119317578505 | -122.501752351825 | (37.7611193175785, -122.501752351825) | ||
| 76646 | 76646 | 46375 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2214 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51267 | 5982984.1214 | 2100027.2965 | 37.745289455195 | -122.501565454542 | (37.745289455195, -122.501565454542) | |
| 37433 | 37433 | 184723 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1635 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983115.9866 | 2103988.5253 | 37.7561736313112 | -122.501402462618 | (37.7561736313112, -122.501402462618) | |||
| 173458 | 173458 | 184640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1650 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983160.9711 | 2103902.0944 | 37.7559389581009 | -122.501240500695 | (37.7559389581009, -122.501240500695) | |||
| 147 | 147 | 58021 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4026 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:07:00 PM | 3 | Permit Number 16988 | 5983218.6194 | 2106316.5419 | 37.7625717348083 | -122.50121971656999 | (37.7625717348083, -122.50121971657) | ||
| 95544 | 95544 | 58020 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4020 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2016 11:16:00 AM | 3 | Permit Number 16987 | 5983299.23983496 | 2106318.86318391 | 37.7625828423592 | -122.500941055889 | (37.7625828423592, -122.500941055889) | ||
| 162362 | 162362 | 96799 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 438 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2012 12:00:00 AM | 2 | Permit Number 769004 | 5983479.2923099995 | 2112857.21489 | 37.780545845051705 | -122.500801866987 | (37.7805458450517, -122.500801866987) | ||
| 124642 | 124642 | 109265 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1970 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773567 | 5983260.0 | 2101732.7 | 37.7499882212347 | -122.50073761576701 | (37.7499882212347, -122.500737615767) |
| 175623 | 175623 | 184549 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3501 Moraga St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5983411.1343 | 2103548.3965 | 37.754982490057 | -122.50034921882099 | (37.754982490057, -122.500349218821) | |||
| 188215 | 188215 | 183121 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2327 41st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983581.7952 | 2099373.3538 | 37.7435289932417 | -122.49945051311 | (37.7435289932417, -122.49945051311) | |||
| 63459 | 63459 | 184208 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1474 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983740.5189 | 2105133.2538 | 37.759353393050105 | -122.49932723943 | (37.7593533930501, -122.49932723943) | |||
| 92779 | 92779 | 88094 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1474 40th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51098 | 5983765.2 | 2105129.7 | 37.759345083267796 | -122.499241618892 | (37.7593450832678, -122.499241618892) | |||
| 85422 | 85422 | 88095 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51099 | 5983752.7 | 2102993.7 | 37.7534794912156 | -122.49912702260201 | (37.7534794912156, -122.499127022602) | |||
| 129402 | 129402 | 88096 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51099 | 5983752.7 | 2102993.7 | 37.7534794912156 | -122.49912702260201 | (37.7534794912156, -122.499127022602) | |||
| 171120 | 171120 | 184598 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983770.321 | 2103008.0087 | 37.7535198125919 | -122.499067143504 | (37.7535198125919, -122.499067143504) | |||
| 66926 | 66926 | 184599 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983770.6594 | 2102984.6576 | 37.7534557168171 | -122.499064248064 | (37.7534557168171, -122.499064248064) | |||
| 124292 | 124292 | 43060 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3054 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2000 12:00:00 AM | Permit Number 53563 | 5983697.0 | 2098912.0 | 37.7422690003261 | -122.499018090006 | (37.7422690003261, -122.499018090006) | |||
| 77937 | 77937 | 106193 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3040 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5983698.2 | 2098878.7 | 37.742177638003994 | -122.499011481047 | (37.742177638004, -122.499011481047) | ||||
| 99795 | 99795 | 43061 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3050 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | Permit Number 53563 | 5983775.74745702 | 2098849.58098564 | 37.7421022336559 | -122.498741199638 | (37.7421022336559, -122.498741199638) | |||
| 12031 | 12031 | 37717 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3001 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2015 04:45:00 PM | 3 | 3x3 | Permit Number 774917 | 5983817.4661 | 2098794.1609 | 37.7419525119456 | -122.498592859082 | (37.7419525119456, -122.498592859082) | |
| 107556 | 107556 | 109136 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 635 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773405 | 5984096.474359999 | 2111505.41074 | 37.7768703987748 | -122.49856689090299 | (37.7768703987748, -122.498566890903) |
| 43893 | 43893 | 117895 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 635 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5984097.32613 | 2111483.29523 | 37.7768097259285 | -122.498562310404 | (37.7768097259285, -122.498562310404) | |||
| 11343 | 11343 | 37722 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3001 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2015 04:53:00 PM | 3 | 3x3 | Permit Number 774917 | 5983850.6165 | 2098795.1757 | 37.741957242405206 | -122.498478312402 | (37.7419572424052, -122.498478312402) | |
| 10693 | 10693 | 37723 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3001 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2015 05:05:00 PM | 3 | 3x3 | Permit Number 774917 | 5983867.1917 | 2098797.5436 | 37.741964716019396 | -122.498421176446 | (37.7419647160194, -122.498421176446) | |
| 10849 | 10849 | 37721 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3001 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2015 05:19:00 PM | 3 | 3x3 | Permit Number 774917 | 5983882.4138 | 2098796.867 | 37.74196375089279 | -122.498368494175 | (37.7419637508928, -122.498368494175) | |
| 33778 | 33778 | 52557 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1671 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 5 | Permit Number 48653 | 5984052.4061 | 2103791.5706 | 37.7556877987927 | -122.498149511058 | (37.7556877987927, -122.498149511058) | |
| 153529 | 153529 | 183672 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1254 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984312.3195 | 2106638.1262 | 37.7635188796404 | -122.497460805156 | (37.7635188796404, -122.497460805156) | |||
| 122176 | 122176 | 109275 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1437 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773660 | 5984291.9 | 2105367.5 | 37.7600289003771 | -122.4974376175 | (37.7600289003771, -122.4974376175) |
| 117474 | 117474 | 88087 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1254 38th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51087 | 5984334.6 | 2106629.9 | 37.7634975987144 | -122.497383137852 | (37.7634975987144, -122.497383137852) | |||
| 26976 | 26976 | 82736 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3219 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767127 | 5984285.2795 | 2103578.3364 | 37.755115968323395 | -122.49732843264 | (37.7551159683234, -122.49732843264) |
| 3788 | 3788 | 118108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3585 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2017 12:00:00 AM | 3 | Width 3ft | 5984519.42575 | 2111051.46948 | 37.7756488017479 | -122.497070281467 | (37.7756488017479, -122.497070281467) | ||
| 70054 | 70054 | 184494 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1875 38th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5984410.615 | 2102424.5695 | 37.7519553887834 | -122.496809845733 | (37.7519553887834, -122.496809845733) | |||
| 4697 | 4697 | 60547 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 507 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2017 09:50:00 AM | 3 | Permit Number 20157 | 5984999.38205 | 2112385.8100400004 | 37.779340631831495 | -122.49550845523501 | (37.7793406318315, -122.495508455235) | |
| 168844 | 168844 | 92401 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1215 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52801 | 5985169.7 | 2106911.6 | 37.764319978357896 | -122.494515603708 | (37.7643199783579, -122.494515603708) |
| 98532 | 98532 | 115939 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 607 34TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777685 | 5985316.0 | 2111712.0 | 37.7775090776113 | -122.49436347548901 | (37.7775090776113, -122.494363475489) | |
| 124146 | 124146 | 83176 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3301 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 6 | 3x3 | 5985317.61354 | 2111082.30707 | 37.77578021552279 | -122.494311467187 | (37.7757802155228, -122.494311467187) | |
| 177664 | 177664 | 118188 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 762 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985415.78787 | 2110692.34221 | 37.7747152280145 | -122.49394311659901 | (37.7747152280145, -122.493943116599) | |||
| 177014 | 177014 | 95521 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1510 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767313 | 5985302.4962 | 2104889.3961 | 37.7587753414156 | -122.49390726731899 | (37.7587753414156, -122.493907267319) |
| 95419 | 95419 | 117055 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 762 34th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2016 12:00:00 AM | 3 | Permit Number 778404 | 5985439.6 | 2110687.7 | 37.7747038750392 | -122.49386040463101 | (37.7747038750392, -122.493860404631) | |||
| 183647 | 183647 | 80237 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985295.5529 | 2103816.7715 | 37.7558298048279 | -122.49385223473601 | (37.7558298048279, -122.493852234736) | |||
| 152382 | 152382 | 250789 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 285 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5985873.63674 | 2113998.18517 | 37.7838189038641 | -122.492602865457 | (37.7838189038641, -122.492602865457) | |||
| 101502 | 101502 | 111713 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
| 145461 | 145461 | 111714 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
| 104102 | 104102 | 90248 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 3040 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986089.18026 | 2111167.85377 | 37.7760602246469 | -122.491648759198 | (37.7760602246469, -122.491648759198) | ||
| 81686 | 81686 | 90243 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2900X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2015 07:19:00 AM | 3 | 3x3 | 5986256.13943 | 2111172.66934 | 37.7760832028982 | -122.491071565578 | (37.7760832028982, -122.491071565578) | ||
| 172020 | 172020 | 184126 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1643 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986219.0266 | 2104040.7857 | 37.756498872957394 | -122.490675089245 | (37.7564988729574, -122.490675089245) | |||
| 67482 | 67482 | 92392 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2506 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52796 | 5986151.5297 | 2098152.0694 | 37.7403261082431 | -122.49047530282301 | (37.7403261082431, -122.490475302823) |
| 153218 | 153218 | 182607 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1867 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986269.2088 | 2102542.1488 | 37.7523869566931 | -122.49039129916001 | (37.7523869566931, -122.49039129916) | |||
| 107504 | 107504 | 90238 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2900X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986478.45159 | 2111179.35168 | 37.7761145368708 | -122.49030303077299 | (37.7761145368708, -122.490303030773) | ||
| 135392 | 135392 | 181684 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1347 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986459.3313 | 2106064.8642 | 37.7620704697574 | -122.48999290967501 | (37.7620704697574, -122.489992909675) | |||
| 70932 | 70932 | 119542 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 791 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986618.95807 | 2110548.82595 | 37.7743914964818 | -122.48977060648899 | (37.7743914964818, -122.489770606489) | |||
| 27407 | 27407 | 98851 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095.0 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | |
| 35363 | 35363 | 98849 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095.0 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | |
| 84200 | 84200 | 98848 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 3x3 | Permit Number 768753 | 5986486.2 | 2103095.0 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | ||
| 153201 | 153201 | 98850 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095.0 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | |
| 144924 | 144924 | 114895 | Private 5 | Lagunaria patersonii :: Primrose Tree 48 | 820 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2015 12:00:00 AM | Permit Number 775427 | 5986664.4 | 2110325.3 | 37.7737804103986 | -122.489596975753 | (37.7737804103986, -122.489596975753) | |||
| 164734 | 164734 | 120000 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 818 30th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5986676.70436 | 2110336.5469299997 | 37.7738120096448 | -122.489555240793 | (37.7738120096448, -122.489555240793) | |||
| 63806 | 63806 | 181949 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2450 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986451.9754 | 2098568.253 | 37.7414863814969 | -122.489467090095 | (37.7414863814969, -122.489467090095) | |||
| 130143 | 130143 | 182826 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1781 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986558.6884 | 2103101.4836 | 37.7539396409234 | -122.48943136928999 | (37.7539396409234, -122.48943136929) | |||
| 74076 | 74076 | 120009 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 746 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5986962.570590001 | 2110820.51914 | 37.775157546008 | -122.48860197556101 | (37.775157546008, -122.488601975561) | |||
| 162634 | 162634 | 95938 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 770 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767634 | 5986967.37973 | 2110670.26469 | 37.774745270265605 | -122.48857429400101 | (37.7747452702656, -122.488574294001) |
| 130069 | 130069 | 84554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 804 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 4 | 5986976.65331 | 2110412.96099 | 37.7740393278808 | -122.488523300237 | (37.7740393278808, -122.488523300237) | ||
| 110202 | 110202 | 84332 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 804 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51851 | 5986981.94009984 | 2110441.32651783 | 37.7741175201244 | -122.488507097746 | (37.7741175201244, -122.488507097746) | ||
| 132639 | 132639 | 183523 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2542 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986781.4828 | 2097933.2945 | 37.7397621847049 | -122.488281131206 | (37.7397621847049, -122.488281131206) | |||
| 28890 | 28890 | 182659 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2252 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986985.3742 | 2102363.8158 | 37.7519391046129 | -122.487901613135 | (37.7519391046129, -122.487901613135) | |||
| 185807 | 185807 | 182658 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2242 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987004.6631 | 2102364.6195 | 37.751942436508706 | -122.487834969288 | (37.7519424365087, -122.487834969288) | |||
| 167364 | 167364 | 182307 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1509 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987118.7965 | 2104973.5941 | 37.7591126281614 | -122.487631931758 | (37.7591126281614, -122.487631931758) | |||
| 56157 | 56157 | 95935 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767632 | 5987262.82019 | 2111075.2653 | 37.7758745231149 | -122.48758207690001 | (37.7758745231149, -122.4875820769) |
| 93530 | 93530 | 88397 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51376 | 5987436.1 | 2113196.8 | 37.781709762111795 | -122.487138517946 | (37.7817097621118, -122.487138517946) | ||
| 49688 | 49688 | 119982 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5987459.3505 | 2114288.69945 | 37.7847091625278 | -122.487138302864 | (37.7847091625278, -122.487138302864) | |||
| 176219 | 176219 | 88398 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51376 | 5987449.923219999 | 2113199.01189 | 37.7817166413541 | -122.48709085924 | (37.7817166413541, -122.48709085924) | |
| 182506 | 182506 | 83202 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5987450.31295 | 2113217.36399 | 37.7817670537285 | -122.487090859235 | (37.7817670537285, -122.487090859235) | |||
| 92798 | 92798 | 115268 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2275 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775658 | 5987276.1 | 2099806.2 | 37.744933531932794 | -122.486708467871 | (37.7449335319328, -122.486708467871) | |||
| 39095 | 39095 | 84344 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 581 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49738 | 5987802.4392099995 | 2112041.1140799997 | 37.778557929673205 | -122.485786324881 | (37.7785579296732, -122.485786324881) | |
| 166649 | 166649 | 50185 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 139 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49870 | 5987999.15348 | 2115065.15007 | 37.7868725355783 | -122.485327781661 | (37.7868725355783, -122.485327781661) | |
| 34436 | 34436 | 88394 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 139 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51373 | 5988000.05712 | 2115038.19323 | 37.78679857243979 | -122.485322676521 | (37.7867985724398, -122.485322676521) | ||
| 57488 | 57488 | 250555 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988156.37986 | 2115366.75845 | 37.7877098242971 | -122.484805955556 | (37.7877098242971, -122.484805955556) | |||
| 164675 | 164675 | 250554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988163.80572 | 2115366.95271 | 37.7877107901693 | -122.484780278081 | (37.7877107901693, -122.484780278081) | |||
| 47371 | 47371 | 250553 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5988175.48547 | 2115367.76095 | 37.787713689594796 | -122.484739928202 | (37.7877136895948, -122.484739928202) |
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");