Data source: data.sfgov.org
This data as json, CSV (advanced)
qSiteInfo ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3748 | 3748 | 175358 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5992915.27224 | 2087806.8926400002 | 37.7123135327144 | -122.466337499576 | (37.7123135327144, -122.466337499576) | |||
| 4008 | 4008 | 216051 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 48 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 02:54:00 PM | 3 | 5996419.4156599995 | 2088710.03455 | 37.7149949180514 | -122.454291392827 | (37.7149949180514, -122.454291392827) | |||
| 4030 | 4030 | 216055 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 52 Lobos St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 02:49:00 PM | 3 | 5996381.618969999 | 2088696.9088599999 | 37.714956710372 | -122.454421085891 | (37.714956710372, -122.454421085891) | |||
| 4092 | 4092 | 216045 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 36 Lobos St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:04:00 PM | 3 | 5996513.0629 | 2088696.2251900001 | 37.7149623706927 | -122.45396671331999 | (37.7149623706927, -122.45396671332) | |||
| 4097 | 4097 | 216058 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 58 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 02:35:00 PM | 3 | 5996320.31527 | 2088710.5585599998 | 37.7149906732676 | -122.45463396169599 | (37.7149906732676, -122.454633961696) | |||
| 4103 | 4103 | 216046 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 38 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:02:00 PM | 3 | 5996487.74032 | 2088710.41168 | 37.7149998715299 | -122.454055262356 | (37.7149998715299, -122.454055262356) | |||
| 4117 | 4117 | 216048 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 02:58:00 PM | 3 | 5996463.1782599995 | 2088711.43982 | 37.7150012861457 | -122.45414023299999 | (37.7150012861457, -122.454140233) | |||
| 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) | |
| 4185 | 4185 | 175269 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 72 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 11:02:00 AM | 3 | Width 4ft | 6001060.69663 | 2088020.77374 | 37.7133674320474 | -122.438199842368 | (37.7133674320474, -122.438199842368) | ||
| 4289 | 4289 | 175270 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 72 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 11:06:00 AM | 3 | Width 4ft | 6001043.39915 | 2088014.71934 | 37.7133498242071 | -122.438259194899 | (37.7133498242071, -122.438259194899) | ||
| 4337 | 4337 | 180894 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 887 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:58:00 AM | 3 | Width 1ft | 6000229.00431 | 2089321.38405 | 37.716891277996 | -122.441167710317 | (37.716891277996, -122.441167710317) | ||
| 4464 | 4464 | 222031 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004133.844959999 | 2109890.1232 | 37.7735899384632 | -122.429136343468 | (37.7735899384632, -122.429136343468) | |||
| 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) | |
| 5245 | 5245 | 205593 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 30 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995699.652000001 | 2100090.8564 | 37.746202601761105 | -122.45760214624201 | (37.7462026017611, -122.457602146242) | |||
| 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 | |||||||||
| 7013 | 7013 | 18868 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2245 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2014 12:05:00 PM | 3 | 3X4 | 6004021.14791 | 2115967.48717 | 37.7902704855414 | -122.42995977804199 | (37.7902704855414, -122.429959778042) | ||
| 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 | |||||||||
| 7909 | 7909 | 115530 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007332.44961 | 2111311.79762 | 37.7776740647351 | -122.418172674243 | (37.7776740647351, -122.418172674243) | |
| 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) | ||
| 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) | |
| 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 | |||||||||
| 9723 | 9723 | 173650 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80 Entrada Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.456569999 | 2092194.59394 | 37.7243327619491 | -122.46835290122299 | (37.7243327619491, -122.468352901223) | ||
| 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) | |
| 9934 | 9934 | 102961 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 9935 | 9935 | 102960 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 9936 | 9936 | 102965 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 9937 | 9937 | 102966 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 9939 | 9939 | 102963 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 9940 | 9940 | 102969 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 9941 | 9941 | 102968 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 9943 | 9943 | 102967 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 9944 | 9944 | 11821 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | ||
| 9945 | 9945 | 102971 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 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) | ||
| 9959 | 9959 | 57959 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 336 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774423 | 5999490.29697456 | 2086502.70799744 | 37.7091097236101 | -122.443518692288 | (37.7091097236101, -122.443518692288) | |
| 10129 | 10129 | 173878 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 89 Montana St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995989.0 | 2089223.0 | 37.7163787086702 | -122.455816142362 | (37.7163787086702, -122.455816142362) | ||||
| 10295 | 10295 | 86058 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1583 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987441.2276 | 2104514.7604 | 37.7578715963284 | -122.486483137481 | (37.7578715963284, -122.486483137481) | ||
| 10301 | 10301 | 86223 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2490X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988629.212 | 2098360.9697 | 37.7410440994961 | -122.48192386283199 | (37.7410440994961, -122.481923862832) | ||
| 10327 | 10327 | 86040 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1307 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987380.4546 | 2106353.8076 | 37.762917573839104 | -122.48682835991 | (37.7629175738391, -122.48682835991) | ||
| 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) | ||
| 10399 | 10399 | 86345 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2375 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988557.6358 | 2099173.0128 | 37.743269593853704 | -122.482230823598 | (37.7432695938537, -122.482230823598) | ||
| 10405 | 10405 | 86230 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2434 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988618.0441 | 2098730.8647 | 37.742059084770105 | -122.481989567109 | (37.7420590847701, -122.481989567109) | ||
| 10420 | 10420 | 86166 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1371 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988635.288 | 2105993.2776 | 37.7620007347072 | -122.48246195923299 | (37.7620007347072, -122.482461959233) | ||
| 10423 | 10423 | 86471 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1814 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987856.6219 | 2102916.0794 | 37.7535062555598 | -122.48492926433501 | (37.7535062555598, -122.484929264335) | ||
| 10428 | 10428 | 86141 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1454 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5988697.0081 | 2105426.1429 | 37.7604471269304 | -122.482206944127 | (37.7604471269304, -122.482206944127) | ||
| 10456 | 10456 | 86365 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2527 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988592.98 | 2098098.1742 | 37.7403204245752 | -122.482029891514 | (37.7403204245752, -122.482029891514) | ||
| 10478 | 10478 | 86216 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2619 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/18/2015 03:11:00 PM | 3 | 3x3 | 5988925.4466 | 2097480.2521 | 37.7386431021416 | -122.48083513933202 | (37.7386431021416, -122.480835139332) | ||
| 10481 | 10481 | 86342 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2347 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988550.1905 | 2099342.5621 | 37.743734698566996 | -122.482268986695 | (37.743734698567, -122.482268986695) | ||
| 10485 | 10485 | 86147 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 8 | 3x3 | 5988673.7063 | 2106118.8136 | 37.7623476572695 | -122.482338285023 | (37.7623476572695, -122.482338285023) | ||
| 10499 | 10499 | 86552 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1807 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.5941 | 2102964.5337 | 37.7536362092428 | -122.485116198466 | (37.7536362092428, -122.485116198466) | ||
| 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) | |||
| 10533 | 10533 | 86042 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1311 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987382.8738 | 2106304.4567 | 37.7627822108774 | -122.48681636863701 | (37.7627822108774, -122.486816368637) | ||
| 10540 | 10540 | 86470 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1822 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987859.0288 | 2102867.5421 | 37.7533731253955 | -122.484917380259 | (37.7533731253955, -122.484917380259) | ||
| 10561 | 10561 | 86012 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1642 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/04/2007 12:00:00 AM | 3 | 3x3 | 5987499.1098 | 2104097.2319 | 37.7567285504541 | -122.486252307696 | (37.7567285504541, -122.486252307696) | ||
| 10563 | 10563 | 86468 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1830 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 10 | 3x3 | 5987859.0288 | 2102813.3889 | 37.753224435288 | -122.484913407703 | (37.753224435288, -122.484913407703) | ||
| 10564 | 10564 | 116803 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 931 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2016 12:00:00 AM | 3 | 3x3 | 6007342.71844 | 2093540.3953900002 | 37.728878425184796 | -122.416877747635 | (37.7288784251848, -122.416877747635) | ||
| 10588 | 10588 | 29186 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3109 Ortega St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984375.9268 | 2102211.0253 | 37.751367022759105 | -122.49691404116001 | (37.7513670227591, -122.49691404116) | ||
| 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) | |
| 10600 | 10600 | 86037 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1215 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987357.4179 | 2106982.0087 | 37.76464109793461 | -122.48695417155899 | (37.7646410979346, -122.486954171559) | ||
| 10602 | 10602 | 86245 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2306 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988589.4098 | 2099609.5524 | 37.744470064859 | -122.48215293338001 | (37.744470064859, -122.48215293338) | ||
| 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) | ||
| 10646 | 10646 | 86167 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988635.288 | 2105938.085 | 37.761849190827796 | -122.48245791496599 | (37.7618491908278, -122.482457914966) | ||
| 10654 | 10654 | 86358 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2467 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988579.1256 | 2098528.4885 | 37.741501149228895 | -122.482109310709 | (37.7415011492289, -122.482109310709) | ||
| 10692 | 10692 | 86045 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1359 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987391.0989 | 2106016.5765 | 37.7619922504501 | -122.48676678064899 | (37.7619922504501, -122.486766780649) | ||
| 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) | |
| 10718 | 10718 | 2162 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2000 12:00:00 AM | 3 | 3x100 | 6009718.66444 | 2090180.91439 | 37.7197873521964 | -122.40842702879299 | (37.7197873521964, -122.408427028793) | ||
| 10734 | 10734 | 29192 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3109 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5984182.3495 | 2102207.3027 | 37.751345456571606 | -122.497583168809 | (37.7513454565716, -122.497583168809) | ||
| 10750 | 10750 | 25354 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 600 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 16 | 3X3 | 5999152.66634 | 2090412.41545 | 37.719825631818296 | -122.44496645924102 | (37.7198256318183, -122.444966459241) | ||
| 10768 | 10768 | 25389 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1161 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2003 12:00:00 AM | 3 | 3X3 | 6001515.64851 | 2088443.1982900002 | 37.7145531809608 | -122.436657591376 | (37.7145531809608, -122.436657591376) |
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");