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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105077 | 105077 | 85251 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1151 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | 3x3 | Under 3yr maintenance agreement. Expires 6/15/2010. | 6001497.16836 | 2088486.70556 | 37.714671592027294 | -122.43672457862 | (37.7146715920273, -122.43672457862) | |
| 36857 | 36857 | 53970 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1362 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1972 12:00:00 AM | 6 | Permit Number 9685 | 5988675.3296 | 2106056.0456 | 37.7621754078315 | -122.482328071622 | (37.7621754078315, -122.482328071622) | ||
| 703 | 703 | 204887 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 381 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2002 12:00:00 AM | 7 | Width 3ft | Permit Number 9510 | 5992671.12766 | 2094035.9384 | 37.729402884631 | -122.46763405038601 | (37.729402884631, -122.467634050386) | |
| 138172 | 138172 | 30425 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 367 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 5 | Permit Number 79 | 6011159.52441 | 2119665.62673 | 37.800826359895 | -122.405521953284 | (37.800826359895, -122.405521953284) | ||
| 3530 | 3530 | 123324 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 798 05th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Permit Number 780721 | 5994466.95086 | 2110266.43708 | 37.7740712286384 | -122.462602639066 | (37.7740712286384, -122.462602639066) | |||
| 3540 | 3540 | 123527 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2850 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | Permit Number 780721 | 5994500.1201 | 2110215.1995599996 | 37.77393245416361 | -122.462484184544 | (37.7739324541636, -122.462484184544) | ||
| 3579 | 3579 | 123325 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 798 05th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Permit Number 780721 | 5994467.5512 | 2110242.48836 | 37.7740055063811 | -122.46259882484101 | (37.7740055063811, -122.462598824841) | |||
| 3637 | 3637 | 253235 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 3647 | 3647 | 253240 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 3654 | 3654 | 253242 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 299X Moncada Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 3679 | 3679 | 253243 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 299X Moncada Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 2921 | 2921 | 64013 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3934 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2017 12:00:00 AM | 3 | 7x4 | Permit Number 780499 | 5995918.46244 | 2115550.14517 | 37.7886623715551 | -122.45796408748801 | (37.7886623715551, -122.457964087488) | |
| 2271 | 2271 | 88721 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 833 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780265 | 5987866.10195 | 2110280.46308 | 37.7737273853775 | -122.48543685868499 | (37.7737273853775, -122.485436858685) | |
| 4682 | 4682 | 213163 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 142 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780043 | 5995654.76041 | 2090862.8911099997 | 37.7208622740576 | -122.45708998411101 | (37.7208622740576, -122.457089984111) | |
| 1731 | 1731 | 245177 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 119 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Permit Number 780020 | 6000299.8756 | 2109409.2021 | 37.7720516702596 | -122.442364048942 | (37.7720516702596, -122.442364048942) | ||
| 13308 | 13308 | 25759 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1536 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2017 12:00:00 AM | 3 | 3X3 | Permit Number 779613 | 6003087.54114 | 2087663.41758 | 37.712501277897296 | -122.431168873349 | (37.7125012778973, -122.431168873349) | |
| 976 | 976 | 160371 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 868 Edinburgh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001686.38396 | 2088939.3945099998 | 37.7159253269669 | -122.43610294800199 | (37.7159253269669, -122.436102948002) | |
| 991 | 991 | 160369 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 868 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001700.06015 | 2088961.7176 | 37.715987398188894 | -122.436057273237 | (37.7159873981889, -122.436057273237) | |
| 994 | 994 | 160370 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 868 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001693.73373 | 2088950.71414 | 37.715956825716 | -122.436078353349 | (37.715956825716, -122.436078353349) | |
| 10697 | 10697 | 43158 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 251 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779279 | 6006275.83968 | 2092663.4534200002 | 37.7264104651465 | -122.420503806033 | (37.7264104651465, -122.420503806033) | |
| 9835 | 9835 | 121650 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 90 Fernwood Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2017 12:00:00 AM | 3 | 2x2 | Permit Number 779248 | 5994730.0 | 2095273.0 | 37.7329182144954 | -122.46060599283999 | (37.7329182144954, -122.46060599284) | |
| 2639 | 2639 | 253101 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
| 2642 | 2642 | 253105 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1295 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
| 2663 | 2663 | 253102 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
| 2666 | 2666 | 253103 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
| 2669 | 2669 | 253104 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000x Irving St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427.0 | 2106455.0 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | |
| 8728 | 8728 | 121206 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 930 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778903 | 6007356.48577 | 2120579.5282099997 | 37.803122321012296 | -122.418746939923 | (37.8031223210123, -122.418746939923) | |
| 78785 | 78785 | 88385 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 139 19th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778767 | 5989887.12414 | 2114429.03218 | 37.7852357408604 | -122.478749371232 | (37.7852357408604, -122.478749371232) | ||
| 91264 | 91264 | 37274 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3861 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2016 12:00:00 AM | 3 | Permit Number 778685 | 6002725.39128498 | 2102957.76189665 | 37.7544755272865 | -122.43351288179899 | (37.7544755272865, -122.433512881799) | |
| 87814 | 87814 | 117380 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 823 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778551 | 5981342.0 | 2110110.3 | 37.772877912923896 | -122.507991719286 | (37.7728779129239, -122.507991719286) | ||
| 117313 | 117313 | 117352 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2066 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778538 | 5986073.6 | 2101175.7 | 37.7486236329866 | -122.490967193042 | (37.7486236329866, -122.490967193042) | ||
| 82666 | 82666 | 115224 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 741 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778505 | 5985056.12254 | 2110795.86603 | 37.7749784243735 | -122.495194889307 | (37.7749784243735, -122.495194889307) | |
| 88055 | 88055 | 117315 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1359 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778500 | 5989234.9 | 2106072.8 | 37.762253944632704 | -122.480393979375 | (37.7622539446327, -122.480393979375) | ||
| 27331 | 27331 | 117477 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1999X Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | Permit Number 778454 | 6004121.651819999 | 2117991.3278099997 | 37.7958331278375 | -122.429756453008 | (37.7958331278375, -122.429756453008) | ||
| 12761 | 12761 | 86173 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1439 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778355 | 5988651.1741 | 2105513.6858 | 37.7606848299416 | -122.482371875236 | (37.7606848299416, -122.482371875236) | |
| 8916 | 8916 | 44823 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2440 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778318 | 6001806.8581 | 2114669.8819999998 | 37.7865819462822 | -122.43752808228201 | (37.7865819462822, -122.437528082282) | |
| 83107 | 83107 | 100228 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 701X 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778265 | 5983810.9 | 2111033.8 | 37.775558740409295 | -122.49951990172899 | (37.7755587404093, -122.499519901729) | |
| 87114 | 87114 | 62936 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 316 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777778 | 6006849.46263115 | 2097253.97380445 | 37.739047337768895 | -122.41884623801799 | (37.7390473377689, -122.418846238018) |
| 109932 | 109932 | 115278 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1820 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 777410 | 5989175.1 | 2105179.9 | 37.7597988071794 | -122.480535438141 | (37.7597988071794, -122.480535438141) | |||
| 90268 | 90268 | 115274 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1830 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 777408 | 5984468.3 | 2102689.1 | 37.7526850963295 | -122.496629885272 | (37.7526850963295, -122.496629885272) | |||
| 140914 | 140914 | 114321 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2118 47th Ave | 1 | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 01/14/2016 12:00:00 AM | 5x16 | Permit Number 777356 | 5981743.9 | 2100646.6 | 37.7469169691931 | -122.505899765145 | (37.7469169691931, -122.505899765145) | ||
| 2986 | 2986 | 114577 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3610 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | 30 | 3x3 | Permit Number 777195 | 5997470.267659999 | 2115762.68023 | 37.7893349711866 | -122.452610443035 | (37.7893349711866, -122.452610443035) | |
| 143485 | 143485 | 34546 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3625 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 776883 | 6008512.67488418 | 2097989.46495614 | 37.741160344838704 | -122.413147584008 | (37.7411603448387, -122.413147584008) | ||
| 133662 | 133662 | 113938 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3000 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776872 | 5999473.11509 | 2119163.08751 | 37.7987861417299 | -122.44592551514401 | (37.7987861417299, -122.445925515144) | |
| 82312 | 82312 | 100514 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Treat Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2015 12:00:00 AM | 3 | 18x18 | Permit Number 776854 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.41174358203101 | (37.7686337575832, -122.411743582031) | |
| 92159 | 92159 | 100518 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X FLORIDA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776854 | 6009099.0 | 2107996.0 | 37.768668935528204 | -122.41182719045601 | (37.7686689355282, -122.411827190456) | |
| 103168 | 103168 | 100519 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X FLORIDA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776854 | 6009099.0 | 2107996.0 | 37.768668935528204 | -122.41182719045601 | (37.7686689355282, -122.411827190456) | |
| 102288 | 102288 | 113549 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4500X 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 3x3 | Permit Number 776494 | 6001307.45082 | 2104071.52181 | 37.75745309114121 | -122.43849627302299 | (37.7574530911412, -122.438496273023) | ||
| 112298 | 112298 | 113550 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4500X 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 3x3 | Permit Number 776494 | 6001307.45082 | 2104071.52181 | 37.75745309114121 | -122.43849627302299 | (37.7574530911412, -122.438496273023) | ||
| 116543 | 116543 | 66904 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 225 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776293 | 6007580.09129508 | 2097612.98419124 | 37.7400742131662 | -122.41634547279699 | (37.7400742131662, -122.416345472797) | |
| 50165 | 50165 | 115003 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 291 Whitney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004325.9 | 2096691.0 | 37.737359123084005 | -122.42753146953999 | (37.737359123084, -122.42753146954) | |||
| 123218 | 123218 | 60670 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004331.68787007 | 2096689.31302497 | 37.737354818402 | -122.42751133803101 | (37.737354818402, -122.427511338031) | ||
| 155070 | 155070 | 32750 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776233 | 5995920.632230001 | 2088735.9867 | 37.7150375603089 | -122.456017264699 | (37.7150375603089, -122.456017264699) | |
| 87574 | 87574 | 111244 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 799X SANCHEZ ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 36 | 3x3 | Permit Number 776149 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | |
| 129086 | 129086 | 83288 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 164 Marietta Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 3x3 | Permit Number 776115 | 5998661.46033678 | 2097891.48861403 | 37.740333360985105 | -122.447202361917 | (37.7403333609851, -122.447202361917) | ||
| 124494 | 124494 | 114973 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 125 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 776087 | 5996468.6 | 2094435.0 | 37.7307171398869 | -122.454534722301 | (37.7307171398869, -122.454534722301) | |||
| 85058 | 85058 | 114963 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 284 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 776075 | 5994159.8 | 2088442.0 | 37.714129118114 | -122.462082099319 | (37.714129118114, -122.462082099319) | |||
| 100042 | 100042 | 115001 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 46 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | Permit Number 775910 | 5993155.2 | 2098864.2 | 37.742688023212295 | -122.46631133896999 | (37.7426880232123, -122.46631133897) | |||
| 75296 | 75296 | 115723 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 147 Baltimore Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2016 12:00:00 AM | 3 | Permit Number 775898 | 6002684.2 | 2086288.6 | 37.7087034632659 | -122.432464808573 | (37.7087034632659, -122.432464808573) | ||
| 129406 | 129406 | 115269 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2218 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775791 | 5986730.3 | 2100136.4 | 37.7458083387155 | -122.48861998421499 | (37.7458083387155, -122.488619984215) | |||
| 115419 | 115419 | 115756 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1514 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775783 | 5998796.2 | 2089378.8 | 37.7169672098689 | -122.44612432488 | (37.7169672098689, -122.44612432488) | ||
| 88519 | 88519 | 115311 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 483 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | Permit Number 775691 | 5994725.9 | 2091786.1 | 37.72334379710279 | -122.460367608597 | (37.7233437971028, -122.460367608597) | |||
| 78549 | 78549 | 115310 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1199 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | Permit Number 775586 | 5995022.2 | 2091844.5 | 37.7235211897184 | -122.459347589211 | (37.7235211897184, -122.459347589211) | |||
| 143740 | 143740 | 115229 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 677 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775542 | 5987138.4 | 2111350.8 | 37.776623806317 | -122.48803272311599 | (37.776623806317, -122.488032723116) | |||
| 99924 | 99924 | 114976 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 231 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 775532 | 5994424.6 | 2091464.1 | 37.722442325741795 | -122.46138580684601 | (37.7224423257418, -122.461385806846) | |||
| 98018 | 98018 | 115240 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 507 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775523 | 5981264.2 | 2112246.8 | 37.7787395279518 | -122.50841946002899 | (37.7787395279518, -122.508419460029) | |||
| 78982 | 78982 | 115236 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 742 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775515 | 5982957.8 | 2110723.0 | 37.7746552828593 | -122.502447924769 | (37.7746552828593, -122.502447924769) | |||
| 77563 | 77563 | 94632 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3600 16th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 3x3 | Permit Number 775358 | 6002902.0 | 2106490.0 | 37.764184223284396 | -122.433154488347 | (37.7641842232844, -122.433154488347) | ||
| 107398 | 107398 | 59326 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 130 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2015 12:00:00 AM | Permit Number 775294 | 5998173.48699395 | 2105389.83328333 | 37.760894077181895 | -122.449429707195 | (37.7608940771819, -122.449429707195) | ||
| 141647 | 141647 | 122627 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 34 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 3x4 | Permit Number 775279 | 5984731.0 | 2094410.0 | 37.729968312905505 | -122.49511098534401 | (37.7299683129055, -122.495110985344) | |
| 106011 | 106011 | 115163 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 41 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775222 | 6001328.5 | 2108884.4 | 37.7706692687709 | -122.438768350781 | (37.7706692687709, -122.438768350781) | |||
| 15243 | 15243 | 109931 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2822 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775171 | |||||
| 20298 | 20298 | 115181 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2166 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775165 | 5981753.9 | 2100346.3 | 37.7460930178281 | -122.505842927008 | (37.7460930178281, -122.505842927008) | |||
| 110905 | 110905 | 115178 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2582 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775071 | 5982161.7 | 2097535.9 | 37.7384004300806 | -122.50422468152 | (37.7384004300806, -122.50422468152) | |||
| 186114 | 186114 | 114812 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1315-- 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 8 | Permit Number 775040 | 5987054.5 | 2106285.6 | 37.7627112856961 | -122.487950697253 | (37.7627112856961, -122.487950697253) | ||
| 188192 | 188192 | 114813 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1315-- 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 775040 | 5987054.5 | 2106285.6 | 37.7627112856961 | -122.487950697253 | (37.7627112856961, -122.487950697253) | |||
| 80998 | 80998 | 110310 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 899x Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774992 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972128999 | (37.7668387037649, -122.45306972129) | |
| 82781 | 82781 | 110311 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 899x Stanyan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774992 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972128999 | (37.7668387037649, -122.45306972129) | |
| 53784 | 53784 | 113548 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1911 20th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 774960 | 6012300.00129 | 2104664.7502 | 37.759701124429796 | -122.400521077012 | (37.7597011244298, -122.400521077012) | ||
| 38394 | 38394 | 64633 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 194 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774889 | 6013135.37911 | 2106215.95355 | 37.7640069398975 | -122.397740705065 | (37.7640069398975, -122.397740705065) | ||
| 118642 | 118642 | 108108 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 901x YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774841 | 6009981.0 | 2103887.0 | 37.757435996605395 | -122.408486525898 | (37.7574359966054, -122.408486525898) | |
| 102720 | 102720 | 109330 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1329 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2015 12:00:00 AM | 3 | 2.5x2.5 | Permit Number 774837 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |
| 84823 | 84823 | 109188 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 482 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774830 | 5981628.45653 | 2112492.50566 | 37.7794356235543 | -122.507177609428 | (37.7794356235543, -122.507177609428) |
| 119741 | 119741 | 109189 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 482 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774830 | 5981625.7586 | 2112517.84773 | 37.7795050464814 | -122.507188823101 | (37.7795050464814, -122.507188823101) |
| 104439 | 104439 | 109152 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 56-98X Capistrano Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2015 12:00:00 AM | 3 | Permit Number 774812 | 6001217.27385 | 2093926.25582 | 37.7295914563619 | -122.438081423517 | (37.7295914563619, -122.438081423517) | ||
| 110842 | 110842 | 109150 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 56-98X Capistrano Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2015 12:00:00 AM | 3 | Permit Number 774812 | 6001217.27385 | 2093926.25582 | 37.7295914563619 | -122.438081423517 | (37.7295914563619, -122.438081423517) | ||
| 111228 | 111228 | 109148 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 56-98X Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2015 12:00:00 AM | 3 | Permit Number 774812 | 6001217.27385 | 2093926.25582 | 37.7295914563619 | -122.438081423517 | (37.7295914563619, -122.438081423517) | ||
| 126082 | 126082 | 109149 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 56-98X Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2015 12:00:00 AM | 3 | Permit Number 774812 | 6001217.27385 | 2093926.25582 | 37.7295914563619 | -122.438081423517 | (37.7295914563619, -122.438081423517) | ||
| 122211 | 122211 | 36938 | Private 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 351 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774744 | 5992449.52236815 | 2113091.8234389997 | 37.781712581861 | -122.46978695177602 | (37.781712581861, -122.469786951776) | |
| 50494 | 50494 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 131X Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.796266453658795 | -122.397554954018 | (37.7962664536588, -122.397554954018) | |
| 126031 | 126031 | 110476 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3700 Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 5997015.1 | 2115715.0 | 37.7891779638687 | -122.454181816252 | (37.7891779638687, -122.454181816252) | |
| 96612 | 96612 | 64961 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 120 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774717 | 6004261.49676722 | 2097472.14872907 | 37.739500336982296 | -122.427809784477 | (37.7395003369823, -122.427809784477) | |||
| 141854 | 141854 | 81731 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2371 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2015 12:00:00 AM | 3x3 | Permit Number 774678 | 5982660.98623523 | 2098988.34584031 | 37.7424177991727 | -122.502605897625 | (37.7424177991727, -122.502605897625) | ||
| 85391 | 85391 | 108840 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 171 Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774672 | 6004535.74354 | 2092399.5717799999 | 37.7255876870469 | -122.426500461978 | (37.7255876870469, -122.426500461978) | |
| 109575 | 109575 | 108838 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 267 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774666 | 6004068.9172 | 2089601.41292 | 37.717878156846 | -122.42791494359501 | (37.717878156846, -122.427914943595) | |
| 141571 | 141571 | 108835 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 582 Paris St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774664 | 6001569.98355 | 2090273.86395 | 37.7195828682199 | -122.436600744727 | (37.7195828682199, -122.436600744727) | |
| 18196 | 18196 | 108832 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 60 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774659 | 6003833.887 | 2093995.50335 | 37.7299300570357 | -122.429040457944 | (37.7299300570357, -122.429040457944) | |
| 86927 | 86927 | 108735 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1514 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774640 | 5989640.683680001 | 2105037.22287 | 37.759434101142 | -122.478914795236 | (37.759434101142, -122.478914795236) | |
| 114314 | 114314 | 108701 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 478 30th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774626 | 6003507.49152 | 2098366.3309400002 | 37.7419128730633 | -122.43048058961 | (37.7419128730633, -122.43048058961) | |
| 1767 | 1767 | 108696 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3219 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774620 | 6003723.121830001 | 2119813.07153 | 37.8008125903965 | -122.431265542364 | (37.8008125903965, -122.431265542364) |
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");