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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 134 | 134 | 47510 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 54X Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 45390 | 6003705.560409999 | 2094600.28554 | 37.731583388063 | -122.42952721221901 | (37.731583388063, -122.429527212219) | |
| 380 | 380 | 54250 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1278 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769471 | 5988656.6839 | 2106624.6375 | 37.7637355217759 | -122.48243422269199 | (37.7637355217759, -122.482434222692) | |
| 675 | 675 | 47038 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 716 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45030 | ||||||||
| 681 | 681 | 204889 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 351 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | 8 | Width 3ft | Permit Number 46076 | 5992804.92706 | 2094302.99556 | 37.7301438819374 | -122.467190906752 | (37.7301438819374, -122.467190906752) | |
| 683 | 683 | 204884 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 374 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45127 | 5992717.9561 | 2094174.3336900002 | 37.7297855875163 | -122.467482221425 | (37.7297855875163, -122.467482221425) | |
| 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) | |
| 708 | 708 | 204885 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 396 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2002 12:00:00 AM | 10 | Width 3ft | Permit Number 45128 | 5992604.93972 | 2093995.7294599998 | 37.7292886590466 | -122.46785994299101 | (37.7292886590466, -122.467859942991) | |
| 742 | 742 | 35926 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2660 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773492 | 6001423.81293 | 2116968.31873 | 37.7928710739952 | -122.43901810580799 | (37.7928710739952, -122.439018105808) | |
| 1220 | 1220 | 219835 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2400 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1997 12:00:00 AM | 6 | Width 2ft | Permit Number 38465 | 6001895.79302 | 2097114.95245 | 37.7383854481198 | -122.43596379140301 | (37.7383854481198, -122.435963791403) | |
| 1617 | 1617 | 88497 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1701 Lane St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51438 | 6015090.0 | 2094306.0 | 37.7314133544089 | -122.390148092066 | (37.7314133544089, -122.390148092066) | |
| 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) | ||
| 1828 | 1828 | 35192 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 1869 | 1869 | 35202 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 1949 | 1949 | 108019 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 552 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | 6x4 | Permit Number 773435 | 6005203.0 | 2110989.0 | 37.7766676518469 | -122.42551619292699 | (37.7766676518469, -122.425516192927) | |
| 2080 | 2080 | 34119 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37980 | |||||||||
| 2204 | 2204 | 204163 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 44 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 13 | Width 3ft | Permit Number 46258 | 5995611.132540001 | 2092478.8947 | 37.7252969291056 | -122.45735764125 | (37.7252969291056, -122.45735764125) | |
| 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) | |
| 2429 | 2429 | 219807 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 522 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1998 12:00:00 AM | 14 | Width 3ft | Permit Number 39569 | 6001164.11598 | 2103211.29019 | 37.7550829492327 | -122.438930334693 | (37.7550829492327, -122.438930334693) | |
| 2445 | 2445 | 219809 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 580 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2005 12:00:00 AM | 5 | Width 3ft | Permit Number 48458 | 6001172.43948 | 2103032.03043 | 37.754591218817 | -122.438888704171 | (37.754591218817, -122.438888704171) | |
| 2459 | 2459 | 219808 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 522 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1998 12:00:00 AM | 13 | Width 3ft | Permit Number 39569 | 6001164.78093 | 2103190.57053 | 37.7550260958884 | -122.43892655033702 | (37.7550260958884, -122.438926550337) | |
| 2594 | 2594 | 222084 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 300 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2016 12:00:00 AM | 2 | Width 3ft | Permit Number 770631 | 6007340.7660300005 | 2107872.4021900003 | 37.7682307704588 | -122.417900035784 | (37.7682307704588, -122.417900035784) | |
| 2785 | 2785 | 247358 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 509 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1980 12:00:00 AM | 7 | Width 0ft | Permit Number 18665 | 5998905.5536 | 2108960.7075 | 37.7707406483319 | -122.44715481647499 | (37.7707406483319, -122.447154816475) | |
| 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) | |
| 3062 | 3062 | 34116 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37979 | |||||||||
| 3077 | 3077 | 35211 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 3096 | 3096 | 107442 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2915 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2014 12:00:00 AM | 3 | Permit Number 773608 | 5999618.41032 | 2117367.6595900003 | 37.793864669274605 | -122.445293589454 | (37.7938646692746, -122.445293589454) | ||
| 3212 | 3212 | 34102 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37975 | |||||||||
| 3420 | 3420 | 35199 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 3622 | 3622 | 34463 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 3663 | 3663 | 36860 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 3742 | 3742 | 219632 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 878 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2015 12:00:00 AM | 1 | Width 3ft | Permit Number 774094 | 6010166.130969999 | 2104121.45382 | 37.7580901202723 | -122.40786279863899 | (37.7580901202723, -122.407862798639) | |
| 4154 | 4154 | 142830 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1651 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 2 | Width 0ft | Permit Number 18599 | 6006599.2401 | 2116591.8637 | 37.7921305340759 | -122.42108410275499 | (37.7921305340759, -122.421084102755) | |
| 4161 | 4161 | 142831 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1639 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2005 12:00:00 AM | 2 | Width 0ft | Permit Number 47874 | 6006604.1049 | 2116553.8302 | 37.792026377789504 | -122.421064568723 | (37.7920263777895, -122.421064568723) | |
| 5377 | 5377 | 96642 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2111 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2013 12:00:00 AM | 10 | Permit Number 767176 | 6002359.83736 | 2115647.31598 | 37.7892971538 | -122.435684867558 | (37.7892971538, -122.435684867558) | ||
| 5605 | 5605 | 34138 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37987 | |||||||||
| 5673 | 5673 | 46713 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 5690 | 5690 | 34100 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37975 | |||||||||
| 5885 | 5885 | 46715 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 6242 | 6242 | 35188 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 6282 | 6282 | 46717 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 7021 | 7021 | 46542 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1359 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 52262 | 6008297.30174 | 2116578.9750900003 | 37.7921907215636 | -122.41520785497299 | (37.7921907215636, -122.415207854973) | |
| 7139 | 7139 | 74724 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1055 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774207 | 6008888.65221 | 2115945.87795 | 37.7904856069694 | -122.41311697887899 | (37.7904856069694, -122.413116978879) | ||
| 7169 | 7169 | 34120 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37980 | |||||||||
| 7174 | 7174 | 5920 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1300X Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1997 12:00:00 AM | 3 | 4X4 | 6004118.5014 | 2112905.1017 | 37.781867456720704 | -122.42940446540001 | (37.7818674567207, -122.4294044654) | ||
| 7188 | 7188 | 34462 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 7206 | 7206 | 46718 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 7464 | 7464 | 35185 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7568 | 7568 | 107400 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3176 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2014 12:00:00 AM | 3 | Permit Number 773290 | 5999574.99056 | 2115728.9104299997 | 37.7893626172302 | -122.44532594346 | (37.7893626172302, -122.44532594346) | ||
| 7694 | 7694 | 36863 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7712 | 7712 | 35193 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7970 | 7970 | 96643 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2111 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2013 12:00:00 AM | 10 | Permit Number 767176 | 6002360.87078 | 2115637.1355 | 37.7892692595105 | -122.435680563404 | (37.7892692595105, -122.435680563404) | ||
| 8041 | 8041 | 46716 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 8175 | 8175 | 18056 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2872 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000171.5399 | 2114786.4403 | 37.7868088744704 | -122.44319424037701 | (37.7868088744704, -122.443194240377) | |||
| 8295 | 8295 | 18867 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2245 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2014 12:00:00 AM | 3 | 3X3 | 6003997.87429 | 2115967.42809 | 37.790269005258004 | -122.43004029884399 | (37.790269005258, -122.430040298844) | ||
| 8802 | 8802 | 50777 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47304 | ||||||||||
| 8884 | 8884 | 34133 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37986 | |||||||||
| 9299 | 9299 | 29089 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2280 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009652.0 | 2104061.0 | 37.7578953310723 | -122.40963662473301 | (37.7578953310723, -122.409636624733) | ||
| 9307 | 9307 | 18043 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2817 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2011 12:00:00 AM | 6 | 3x3 | 6000257.4375 | 2114746.9392 | 37.7867053122561 | -122.442894218022 | (37.7867053122561, -122.442894218022) | ||
| 9308 | 9308 | 102869 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2290X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2016 12:00:00 AM | 10 | 3x3 | 6009662.0 | 2103968.0 | 37.7576405343874 | -122.40959547655301 | (37.7576405343874, -122.409595476553) | ||
| 9418 | 9418 | 34114 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37978 | |||||||||
| 9430 | 9430 | 47039 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 771 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45031 | ||||||||
| 9498 | 9498 | 36866 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9542 | 9542 | 34136 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37986 | |||||||||
| 9578 | 9578 | 24736 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7630 Geary Blvd To Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774506 | 5983286.15671 | 2112505.7286099996 | 37.7795694254676 | -122.501443995349 | (37.7795694254676, -122.501443995349) | |
| 9591 | 9591 | 36856 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9614 | 9614 | 36864 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9947 | 9947 | 11824 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | PUC 13 | 03/13/2013 12:00:00 AM | 2 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | ||
| 10373 | 10373 | 27050 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6007605.2431 | 2093552.0049599998 | 37.72892506581471 | -122.415971000784 | (37.7289250658147, -122.415971000784) | ||
| 10507 | 10507 | 115755 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 30 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | 6000910.63041 | 2087495.48281 | 37.711916563873 | -122.438680905912 | (37.711916563873, -122.438680905912) | |||
| 10590 | 10590 | 82568 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 215 Dublin St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52308 | 6004119.416680001 | 2089176.12127 | 37.7167132553824 | -122.427710104164 | (37.7167132553824, -122.427710104164) | |
| 10594 | 10594 | 47511 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 54X Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45390 | 6003674.452380001 | 2094589.01838 | 37.7315506895908 | -122.429633955464 | (37.7315506895908, -122.429633955464) | |
| 10614 | 10614 | 25398 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 855 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1996 12:00:00 AM | 20 | 3X3 | 6000161.72104 | 2089444.17614 | 37.7172246045192 | -122.441409081159 | (37.7172246045192, -122.441409081159) | ||
| 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) | |
| 10854 | 10854 | 34134 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37986 | |||||||||
| 10862 | 10862 | 34464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 10907 | 10907 | 34118 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37979 | |||||||||
| 10915 | 10915 | 27240 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 261 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6002975.310190001 | 2093743.15075 | 37.729188515926 | -122.431990645067 | (37.729188515926, -122.431990645067) | ||
| 11057 | 11057 | 46152 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44491 | |||||||||
| 11062 | 11062 | 27097 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 707 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 6 | 2X3 | 6006020.66402 | 2093592.0564299999 | 37.7289458221845 | -122.42145185693899 | (37.7289458221845, -122.421451856939) | ||
| 11070 | 11070 | 34466 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 11077 | 11077 | 25379 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1306 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2014 12:00:00 AM | 25 | 3x3 | Permit Number 770716 | 6002169.48596 | 2087962.88023 | 37.7132714689796 | -122.434363348013 | (37.7132714689796, -122.434363348013) | |
| 11105 | 11105 | 83902 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 451 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50518 | 5999574.303230001 | 2091368.33238 | 37.7224744158531 | -122.44357764611601 | (37.7224744158531, -122.443577646116) | |
| 11107 | 11107 | 34137 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37987 | |||||||||
| 11193 | 11193 | 25385 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1231 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2011 12:00:00 AM | 3 | 3x3 | 6001822.88806 | 2088260.8804099998 | 37.71407003188121 | -122.435582613755 | (37.7140700318812, -122.435582613755) | ||
| 11262 | 11262 | 34121 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37980 | |||||||||
| 11285 | 11285 | 83683 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 215 Dublin St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52308 | 6004110.69577 | 2089162.29942 | 37.716674810270206 | -122.42773926378 | (37.7166748102702, -122.42773926378) | |
| 11449 | 11449 | 35191 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11627 | 11627 | 88529 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51479 | |||||||||
| 11640 | 11640 | 25776 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1927 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1997 12:00:00 AM | 18 | 2X3 | 6005592.75122 | 2086370.79672 | 37.709093663004495 | -122.42241829446199 | (37.7090936630045, -122.422418294462) | ||
| 11658 | 11658 | 86163 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1351 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988630.418 | 2106174.0062 | 37.7624966829905 | -122.482492045676 | (37.7624966829905, -122.482492045676) | ||
| 11660 | 11660 | 27047 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 880 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 3x3 | 6007095.12349 | 2093540.35463 | 37.728864383186895 | -122.41773369987601 | (37.7288643831869, -122.417733699876) | ||
| 11667 | 11667 | 25357 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 826 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1996 12:00:00 AM | 30 | 3X3 | 6000014.56048 | 2089501.0524099998 | 37.7173723892107 | -122.44192182424999 | (37.7173723892107, -122.44192182425) | ||
| 11728 | 11728 | 35200 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11752 | 11752 | 25755 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1500X Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1997 12:00:00 AM | 12 | 5 | 6002973.26044 | 2087695.8045299998 | 37.7125837286265 | -122.431566173166 | (37.7125837286265, -122.431566173166) | ||
| 11762 | 11762 | 47040 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 771 Walter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45031 | ||||||||
| 11870 | 11870 | 25764 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1686 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1997 12:00:00 AM | 16 | 2X3 | 6004225.91042 | 2087173.5217 | 37.7112205731354 | -122.427199443002 | (37.7112205731354, -122.427199443002) | ||
| 11902 | 11902 | 86165 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1351 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988632.0413 | 2106102.0394 | 37.762299176167495 | -122.482481157841 | (37.7622991761675, -122.482481157841) | ||
| 11948 | 11948 | 25355 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 600 Geneva Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2001 12:00:00 AM | 8 | 2X3 | 5999172.673169999 | 2090392.4667 | 37.7197719989595 | -122.44489586965099 | (37.7197719989595, -122.444895869651) | ||
| 11956 | 11956 | 25368 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1040 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 16 | 3X3 | 6000898.99381 | 2088714.73107 | 37.7152636858484 | -122.438808440557 | (37.7152636858484, -122.438808440557) | ||
| 12036 | 12036 | 58780 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 54 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1979 12:00:00 AM | 8 | 3x3 | Permit Number 18023 | 6001656.090559999 | 2087766.6362400001 | 37.712703471549396 | -122.43612378171001 | (37.7127034715494, -122.43612378171) |
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");