Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| 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) | ||
| 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) |
| 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) | |
| 2260 | 2260 | 49946 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2865 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 5 | 3x9 | Permit Number 46704 | 5985860.2058 | 2096036.9196 | 37.7345014493544 | -122.491326934377 | (37.7345014493544, -122.491326934377) |
| 2261 | 2261 | 49948 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2875@ SLOAT 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 6 | 3x9 | Permit Number 46705 | 5985861.2671 | 2096018.8777 | 37.7344519730851 | -122.491321937714 | (37.7344519730851, -122.491321937714) |
| 2262 | 2262 | 49949 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2875@ SLOAT 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 5 | 10x3 | Permit Number 46705 | 5985862.3284 | 2096008.2648 | 37.7344228948841 | -122.491317487651 | (37.7344228948841, -122.491317487651) |
| 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) | |
| 3813 | 3813 | 43299 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 615 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 7 | Permit Number 43068 | 6011854.0 | 2105476.0 | 37.761903752987706 | -122.402120617661 | (37.7619037529877, -122.402120617661) | |
| 3815 | 3815 | 43300 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 615 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 10 | Permit Number 43068 | 6011854.0 | 2105476.0 | 37.761903752987706 | -122.402120617661 | (37.7619037529877, -122.402120617661) | |
| 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) | |
| 4164 | 4164 | 57912 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1653 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 6 | Permit Number 16870 | 6006600.1246 | 2116572.8469 | 37.7920783685385 | -122.42107969148998 | (37.7920783685385, -122.42107969149) | |
| 4905 | 4905 | 44497 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1531 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 10 | Permit Number 43799 | 6006322.0 | 2092922.0 | 37.727122979083205 | -122.420362574607 | (37.7271229790832, -122.420362574607) | |
| 5124 | 5124 | 56265 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 15 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 12391 | 6006208.27079513 | 2104027.08283356 | 37.7576086269531 | -122.42154409690501 | (37.7576086269531, -122.421544096905) | ||
| 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 | |||||||||
| 5786 | 5786 | 108707 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1849 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773000 | 6003000.77487 | 2119918.27171 | 37.801060480419395 | -122.433772685874 | (37.8010604804194, -122.433772685874) |
| 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 | |||||||||
| 6309 | 6309 | 63514 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1937 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769639 | 6000284.9286 | 2111624.1423 | 37.778132482558 | -122.44257480934799 | (37.778132482558, -122.442574809348) |
| 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) | ||
| 7158 | 7158 | 30976 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1950 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 24 | 6x12 | Permit Number 34765 | 6004885.74764 | 2117123.17132 | 37.7934926287434 | -122.427050672647 | (37.7934926287434, -122.427050672647) |
| 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 | |||||||||
| 7558 | 7558 | 30975 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1950 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 24 | 6x9 | Permit Number 34765 | 6004860.3383 | 2117120.17233 | 37.7934829574257 | -122.42713837725799 | (37.7934829574257, -122.427138377258) |
| 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 | |||||||||
| 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) | |
| 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 | |||||||||
| 9693 | 9693 | 50208 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 763 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 8 | 3x3 | Permit Number 46916 | 5987522.0 | 2110774.0 | 37.7750624459683 | -122.48666339258301 | (37.7750624459683, -122.486663392583) |
| 9815 | 9815 | 40304 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 276 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 10 | Permit Number 46688 | 6006675.32022229 | 2104512.13520977 | 37.7589667921547 | -122.419963267076 | (37.7589667921547, -122.419963267076) | |
| 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) | ||
| 10275 | 10275 | 32464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99x Deming St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36974 | 5999085.33670349 | 2105174.9537063 | 37.7603561904001 | -122.446260575093 | (37.7603561904001, -122.446260575093) | ||
| 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) | ||
| 10443 | 10443 | 109691 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 926 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774277 | 6003588.14539 | 2089614.80455 | 37.7178877169308 | -122.42957771366699 | (37.7178877169308, -122.429577713667) |
| 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) | |||
| 10521 | 10521 | 108564 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 208 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772581 | 6010035.655230001 | 2093553.92933 | 37.7290666937725 | -122.407568987434 | (37.7290666937725, -122.407568987434) |
| 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) |
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");