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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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 | |||||||||
| 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 | |||||||||
| 7819 | 7819 | 74571 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1055 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774207 | 6008908.989 | 2115950.0282799997 | 37.7904981444129 | -122.413046908194 | (37.7904981444129, -122.413046908194) | |
| 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 | |||||||||
| 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) |
| 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) | ||
| 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) | |
| 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) | |
| 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) | ||||
| 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) |
| 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) | ||
| 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) | ||
| 10633 | 10633 | 78424 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 337 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 12 | 3x3 | 6001367.33803 | 2089018.36243 | 37.716124024086 | -122.43721136872499 | (37.716124024086, -122.437211368725) | |
| 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 | |||||||||
| 10912 | 10912 | 75399 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 12 | 4x6 | 5988689.6276 | 2099701.3205 | 37.7447278644639 | -122.48181312543501 | (37.7447278644639, -122.481813125435) | |
| 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) | ||
| 10939 | 10939 | 75321 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 9x4 | 5988672.5581 | 2099700.4669999997 | 37.7447245283024 | -122.481872085268 | (37.7447245283024, -122.481872085268) | |
| 10955 | 10955 | 109923 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 214 state st | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 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) | ||
| 11233 | 11233 | 108547 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773709 | 6002168.783340001 | 2093999.82608 | 37.7298475310412 | -122.43479722051799 | (37.7298475310412, -122.434797220518) |
| 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 | |||||||||
| 11277 | 11277 | 105244 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2398X 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | 5989539.9051 | 2099080.116 | 37.7430716095087 | -122.47882763740299 | (37.7430716095087, -122.478827637403) | |||
| 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) | |
| 11335 | 11335 | 106714 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201X Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6011615.93031 | 2088323.1081400001 | 37.7147922585389 | -122.401738295884 | (37.7147922585389, -122.401738295884) | |||
| 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 | |||||||||
| 11473 | 11473 | 40673 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 119 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | 3x3 | Permit Number 41658 | 6004193.53589 | 2093779.4786099999 | 37.7293572530177 | -122.427781722549 | (37.7293572530177, -122.427781722549) |
| 11604 | 11604 | 116262 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 35 La Grande Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x4 | 6005278.18089 | 2092026.4994299999 | 37.724605255111896 | -122.42390739821998 | (37.7246052551119, -122.42390739822) | ||
| 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) | ||
| 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 |
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");