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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2901 | 2901 | 253237 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | ||||
| 3637 | 3637 | 253235 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 3647 | 3647 | 253240 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 86089 | 86089 | 46712 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44842 | 5992166.503410401 | 2093783.90158663 | 37.728681705159396 | -122.469360230164 | (37.7286817051594, -122.469360230164) | ||
| 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) | |
| 87862 | 87862 | 35975 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Porter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39132 | 6007026.56427019 | 2095399.94161299 | 37.7339665448459 | -122.418102495053 | (37.7339665448459, -122.418102495053) | ||
| 89203 | 89203 | 35977 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Porter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39132 | 6007026.56427019 | 2095399.94161299 | 37.7339665448459 | -122.418102495053 | (37.7339665448459, -122.418102495053) | ||
| 97968 | 97968 | 35978 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Porter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39132 | 6007026.56427019 | 2095399.94161299 | 37.7339665448459 | -122.418102495053 | (37.7339665448459, -122.418102495053) | ||
| 124397 | 124397 | 35976 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39132 | 6007026.56427019 | 2095399.94161299 | 37.7339665448459 | -122.418102495053 | (37.7339665448459, -122.418102495053) | ||
| 136217 | 136217 | 204944 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5994019.05211 | 2097121.33108 | 37.7379523463344 | -122.463197973519 | (37.7379523463344, -122.463197973519) | |||
| 165557 | 165557 | 204945 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5994007.17215 | 2097079.9143 | 37.737837941769 | -122.463236043629 | (37.737837941769, -122.463236043629) | |||
| 170049 | 170049 | 204946 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994008.44212 | 2097065.4765599999 | 37.7377983724866 | -122.463230605425 | (37.7377983724866, -122.463230605425) | |||
| 187833 | 187833 | 204943 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5994032.70638 | 2097142.34763 | 37.7380108391394 | -122.46315228886101 | (37.7380108391394, -122.463152288861) | |||
| 123254 | 123254 | 31174 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34872 | 5993758.54176751 | 2089808.63578079 | 37.717858462466204 | -122.463568114182 | (37.7178584624662, -122.463568114182) | ||
| 145606 | 145606 | 19318 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5993758.5543723 | 2089809.6356688999 | 37.717861208645296 | -122.46356814314 | (37.7178612086453, -122.46356814314) | |||
| 34811 | 34811 | 123844 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1011 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995507.23666 | 2112130.26628 | 37.7792486660092 | -122.45913912341899 | (37.7792486660092, -122.459139123419) | |||
| 62825 | 62825 | 123843 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1011 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995491.96282 | 2112130.0777 | 37.7792472701373 | -122.459191947942 | (37.7792472701373, -122.459191947942) | |||
| 28787 | 28787 | 219699 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1015 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009184.81215 | 2103289.34282 | 37.755750344206206 | -122.411197854394 | (37.7557503442062, -122.411197854394) | |||
| 112507 | 112507 | 25406 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101X GENEVA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/28/1996 12:00:00 AM | 18 | 3X3 | 5997747.0 | 2091304.0 | 37.7221933892695 | -122.449889553304 | (37.7221933892695, -122.449889553304) | ||
| 80274 | 80274 | 110263 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101x HEARST AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6000711.0 | 2094308.0 | 37.730610832400295 | -122.439859019702 | (37.7306108324003, -122.439859019702) | |||
| 97322 | 97322 | 110260 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101x HEARST AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6000711.0 | 2094308.0 | 37.730610832400295 | -122.439859019702 | (37.7306108324003, -122.439859019702) | |||
| 120784 | 120784 | 110262 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101x HEARST AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | 15 | 3x3 | 6000711.0 | 2094308.0 | 37.730610832400295 | -122.439859019702 | (37.7306108324003, -122.439859019702) | ||
| 139861 | 139861 | 110261 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101x HEARST AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | 12 | 3x3 | 6000711.0 | 2094308.0 | 37.730610832400295 | -122.439859019702 | (37.7306108324003, -122.439859019702) | ||
| 55475 | 55475 | 175437 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 102 Congdon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004660.46167 | 2094270.7676400002 | 37.730732625792996 | -122.426202478869 | (37.730732625793, -122.426202478869) | |||
| 152388 | 152388 | 175436 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 102 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004661.30083 | 2094285.5514099998 | 37.7307732661621 | -122.426200629869 | (37.7307732661621, -122.426200629869) | |||
| 141834 | 141834 | 32044 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 102 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1995 12:00:00 AM | Permit Number 35426 | 6005391.10010699 | 2108448.61490265 | 37.769702995030606 | -122.424684739035 | (37.7697029950306, -122.424684739035) | |||
| 155324 | 155324 | 175433 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 102 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6004068.31585 | 2094279.1547700001 | 37.730722167580105 | -122.428250217191 | (37.7307221675801, -122.428250217191) | |||
| 181516 | 181516 | 175434 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 102 Trumbull St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004079.40639 | 2094279.64745 | 37.730724147895 | -122.428211910562 | (37.730724147895, -122.428211910562) | |||
| 42484 | 42484 | 92827 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1021 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2009 12:00:00 AM | 3 | Permit Number 53044 | 5989678.4888 | 2099680.6455 | 37.744728552992605 | -122.478392360363 | (37.7447285529926, -122.478392360363) | ||
| 30895 | 30895 | 72325 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1024 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 17 | 5995456.74462 | 2112185.6673 | 37.7793978796409 | -122.459317808209 | (37.7793978796409, -122.459317808209) | ||
| 96646 | 96646 | 89752 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1025 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995478.0169 | 2112129.57687 | 37.779245093230294 | -122.459240156052 | (37.7792450932303, -122.459240156052) | ||
| 25283 | 25283 | 205057 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1025 Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991223.562000001 | 2089987.2848599998 | 37.7182026001538 | -122.472343348471 | (37.7182026001538, -122.472343348471) | |||
| 62169 | 62169 | 205056 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1025 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991222.33845 | 2089929.23762 | 37.7180431458659 | -122.47234334847 | (37.7180431458659, -122.47234334847) | |||
| 155736 | 155736 | 205055 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1025 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991220.59788 | 2089906.16988 | 37.7179797067747 | -122.472347684119 | (37.7179797067747, -122.472347684119) | |||
| 169670 | 169670 | 205058 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1025 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991233.3641099995 | 2090125.07986 | 37.71858151869421 | -122.472319506539 | (37.7185815186942, -122.472319506539) | |||
| 183244 | 183244 | 205054 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1025 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5991216.77969 | 2089873.7791799998 | 37.717890548876 | -122.472358521848 | (37.717890548876, -122.472358521848) | |||
| 18855 | 18855 | 2108 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1027 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | 3 | 3X3 | 6001243.13078 | 2095612.35205 | 37.7342225583259 | -122.438112767284 | (37.7342225583259, -122.438112767284) | ||
| 38037 | 38037 | 92828 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1027 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2009 12:00:00 AM | 4 | Permit Number 53045 | 5989655.1377 | 2099678.615 | 37.744721622125 | -122.478472954618 | (37.744721622125, -122.478472954618) | ||
| 66411 | 66411 | 98226 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1028 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6010317.208330001 | 2111841.0343400002 | 37.7792947743702 | -122.407884658475 | (37.7792947743702, -122.407884658475) | |||
| 137859 | 137859 | 204922 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 103 San Ramon Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995651.07753 | 2092771.4543299999 | 37.726102522010606 | -122.45724071051201 | (37.7261025220106, -122.457240710512) | |||
| 181432 | 181432 | 204923 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 103 San Ramon Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995675.72699 | 2092757.2436799998 | 37.726064918639395 | -122.45715447181601 | (37.7260649186394, -122.457154471816) | |||
| 186734 | 186734 | 96640 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1030 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2011 12:00:00 AM | 1 | 3x3 | Permit Number 58521 | 6014191.0963 | 2102328.42234 | 37.753391354137705 | -122.393817130265 | (37.7533913541377, -122.393817130265) | |
| 84133 | 84133 | 48924 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1032 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46114 | 6009149.10279146 | 2103141.64576642 | 37.7553427986566 | -122.41131091591002 | (37.7553427986566, -122.41131091591) | ||
| 158752 | 158752 | 219890 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1032 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009167.21352 | 2102952.2968599997 | 37.754823904907106 | -122.41123490827299 | (37.7548239049071, -122.411234908273) | |||
| 57553 | 57553 | 92829 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1033 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2009 12:00:00 AM | 3 | Permit Number 53046 | 5989633.8172 | 2099677.5997 | 37.7447175965695 | -122.47854660173999 | (37.7447175965695, -122.47854660174) | ||
| 12610 | 12610 | 25367 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1034 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 15 | 3x3 | 6000865.40343 | 2088735.44534 | 37.715318651499096 | -122.438926026914 | (37.7153186514991, -122.438926026914) | ||
| 186778 | 186778 | 123842 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1035 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995401.61974 | 2112125.62556 | 37.7792298515065 | -122.45950415741001 | (37.7792298515065, -122.45950415741) | |||
| 62121 | 62121 | 59801 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1035 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 3 | Permit Number 19252 | 6008957.26664 | 2115956.46154 | 37.7905185185761 | -122.412880324992 | (37.7905185185761, -122.412880324992) | |
| 39796 | 39796 | 175517 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1037 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007740.75021 | 2093646.27829 | 37.7291915376517 | -122.41550921327801 | (37.7291915376517, -122.415509213278) | |||
| 85085 | 85085 | 89749 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1037X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995362.72182 | 2112125.11853 | 37.7792262226622 | -122.459638683737 | (37.7792262226622, -122.459638683737) | ||
| 107678 | 107678 | 89750 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1037X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995341.744659999 | 2112124.76503 | 37.779224045770896 | -122.459711226291 | (37.7792240457709, -122.459711226291) | ||
| 124819 | 124819 | 89751 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1037X Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995503.784329 | 2112134.227086 | 37.7792593428601 | -122.459151353267 | (37.7792593428601, -122.459151353267) | ||
| 139936 | 139936 | 89748 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1037X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995381.19776 | 2112126.4499 | 37.7792309406569 | -122.45957486471701 | (37.7792309406569, -122.459574864717) | ||
| 12650 | 12650 | 25395 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1039 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1996 12:00:00 AM | 15 | 3X3 | 6000907.995680001 | 2088802.01255 | 37.7155038534055 | -122.438783577018 | (37.7155038534055, -122.438783577018) | ||
| 64738 | 64738 | 92830 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1039 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2009 12:00:00 AM | 3 | Permit Number 53047 | 5989606.0666 | 2099677.9381 | 37.744716914538294 | -122.478642581627 | (37.7447169145383, -122.478642581627) | ||
| 166607 | 166607 | 204213 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 104 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000101.35333 | 2094132.20207 | 37.7300934101846 | -122.44195404064301 | (37.7300934101846, -122.441954040643) | |||
| 40337 | 40337 | 219870 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 104 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007365.34315 | 2097704.9849099996 | 37.740314748413 | -122.417094503132 | (37.740314748413, -122.417094503132) | |||
| 145681 | 145681 | 89374 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1040 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/2008 12:00:00 AM | 3 | 3x3 | 5995397.1325900005 | 2112182.46845 | 37.7793856689534 | -122.45952379817899 | (37.7793856689534, -122.459523798179) | ||
| 11956 | 11956 | 25368 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1040 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 16 | 3X3 | 6000898.99381 | 2088714.73107 | 37.7152636858484 | -122.438808440557 | (37.7152636858484, -122.438808440557) | ||
| 19033 | 19033 | 2111 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1041 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001197.43418 | 2095624.8112700002 | 37.7342541694939 | -122.43827164693 | (37.7342541694939, -122.43827164693) | |||
| 85804 | 85804 | 83561 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1045 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52318 | 6003821.83513364 | 2089523.45974109 | 37.7176501332056 | -122.42876344310899 | (37.7176501332056, -122.428763443109) | ||
| 87530 | 87530 | 83560 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1045 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52318 | 6003821.83513364 | 2089523.45974109 | 37.7176501332056 | -122.42876344310899 | (37.7176501332056, -122.428763443109) | ||
| 92922 | 92922 | 83559 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1045 Russia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52318 | 6003821.83513364 | 2089523.45974109 | 37.7176501332056 | -122.42876344310899 | (37.7176501332056, -122.428763443109) | ||
| 80861 | 80861 | 27055 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1045 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2005 12:00:00 AM | 3 | 2X3 | 6007783.087590001 | 2093664.3007099999 | 37.7292434029751 | -122.41536412429899 | (37.7292434029751, -122.415364124299) | ||
| 121422 | 121422 | 27056 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1045 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 2X3 | 6007783.087590001 | 2093664.3007099999 | 37.7292434029751 | -122.41536412429899 | (37.7292434029751, -122.415364124299) | ||
| 101947 | 101947 | 89375 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1046 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/2008 12:00:00 AM | 3 | 3x3 | 5995381.20807 | 2112182.65377 | 37.77938526212421 | -122.45957890084101 | (37.7793852621242, -122.459578900841) | ||
| 103391 | 103391 | 50272 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 105 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46976 | 6004292.09535547 | 2095650.45140016 | 37.734500099757106 | -122.42757423633199 | (37.7345000997571, -122.427574236332) | ||
| 91839 | 91839 | 219755 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 105 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004265.288980001 | 2095671.6042900002 | 37.7345566645436 | -122.427668421478 | (37.7345566645436, -122.427668421478) | |||
| 38593 | 38593 | 188143 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6015462.26121 | 2109813.47257 | 37.7740142422074 | -122.38994395615299 | (37.7740142422074, -122.389943956153) | |||
| 133158 | 133158 | 188142 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6015460.440690001 | 2109852.46694 | 37.7741212111486 | -122.389952978159 | (37.7741212111486, -122.389952978159) | |||
| 155109 | 155109 | 188141 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015457.5985900005 | 2109911.3154700003 | 37.774282638555704 | -122.389966921238 | (37.7742826385557, -122.389966921238) | |||
| 168578 | 168578 | 188144 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015465.0795 | 2109753.44378 | 37.7738495727367 | -122.38993001307699 | (37.7738495727367, -122.389930013077) | |||
| 145057 | 145057 | 89376 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/2008 12:00:00 AM | 3 | 3x3 | 5995359.76276 | 2112182.21335 | 37.7793828196903 | -122.45965305677099 | (37.7793828196903, -122.459653056771) | ||
| 14734 | 14734 | 11223 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/1992 12:00:00 AM | 35 | 3X4 | 6018117.580709999 | 2094794.3731799999 | 37.7329217906146 | -122.379714982678 | (37.7329217906146, -122.379714982678) | ||
| 15154 | 15154 | 11220 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/1998 12:00:00 AM | 12 | 3X4 | 6018137.92275 | 2094713.0843099998 | 37.732699709329204 | -122.37963900885799 | (37.7326997093292, -122.379639008858) | ||
| 15421 | 15421 | 11222 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2015 12:00:00 AM | 3 | 3X4 | 6018123.812969999 | 2094772.15079 | 37.7328611160499 | -122.379691892563 | (37.7328611160499, -122.379691892563) | ||
| 16036 | 16036 | 11224 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 3 | 3X4 | 6018109.81504 | 2094815.3391900002 | 37.7329789308191 | -122.379743287027 | (37.7329789308191, -122.379743287027) | ||
| 124604 | 124604 | 11227 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1050X Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/1998 12:00:00 AM | 12 | 3X4 | 6018085.661882901 | 2094069.8743192002 | 37.7309306978843 | -122.379775016493 | (37.7309306978843, -122.379775016493) | ||
| 154656 | 154656 | 201401 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1051 Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6018098.35359 | 2094705.9412599998 | 37.7326779133429 | -122.37977531459299 | (37.7326779133429, -122.379775314593) | |||
| 172472 | 172472 | 201394 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1051 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6018060.23644 | 2094824.70218 | 37.733001904899396 | -122.379915345332 | (37.7330019048994, -122.379915345332) | |||
| 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) | ||
| 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) | |
| 134769 | 134769 | 75008 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1055 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 6 | 6008853.984569999 | 2115941.6403900003 | 37.7904720254258 | -122.41323662737699 | (37.7904720254258, -122.413236627377) | ||
| 165901 | 165901 | 74872 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1055 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 4 | 6008870.271980001 | 2115943.97085 | 37.7904793386892 | -122.413180438633 | (37.7904793386892, -122.413180438633) | ||
| 94390 | 94390 | 33339 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37478 | 5993028.3286634 | 2094300.77063214 | 37.730150666201205 | -122.466418423463 | (37.7301506662012, -122.466418423463) | ||
| 103315 | 103315 | 33338 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37478 | 5993028.3286634 | 2094300.77063214 | 37.730150666201205 | -122.466418423463 | (37.7301506662012, -122.466418423463) | ||
| 171548 | 171548 | 44395 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 16 | Permit Number 43751 | 6001724.925980001 | 2087542.0541599998 | 37.71209072926629 | -122.43586980595501 | (37.7120907292663, -122.435869805955) | |
| 74797 | 74797 | 221048 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000443.4144 | 2106214.92197 | 37.7632891541048 | -122.44163826349701 | (37.7632891541048, -122.441638263497) | |||
| 28101 | 28101 | 219696 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010400.6399300005 | 2099911.8446400003 | 37.7465445905578 | -122.406755093793 | (37.7465445905578, -122.406755093793) | |||
| 159079 | 159079 | 219695 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010418.98912 | 2099921.18688 | 37.746571268962896 | -122.406692302234 | (37.7465712689629, -122.406692302234) | |||
| 22056 | 22056 | 16608 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6002826.848230001 | 2107609.5605599997 | 37.7672540005999 | -122.43349442931999 | (37.7672540005999, -122.43349442932) | ||||
| 71279 | 71279 | 16610 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2014 12:00:00 AM | 8 | 3x3 | 6002827.08532 | 2107587.4381 | 37.76719327117971 | -122.43349202814801 | (37.7671932711797, -122.433492028148) | ||
| 12719 | 12719 | 25392 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1063 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1997 12:00:00 AM | 14 | 3X3 | 6001061.933019999 | 2088709.29333 | 37.7152580237143 | -122.438244863328 | (37.7152580237143, -122.438244863328) | ||
| 58611 | 58611 | 219953 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1065 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6003192.156719999 | 2102032.12446 | 37.7519604176556 | -122.431832598204 | (37.7519604176556, -122.431832598204) | |||
| 67998 | 67998 | 199991 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1068 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6017994.8958 | 2092283.7607 | 37.7260213698028 | -122.379964752149 | (37.7260213698028, -122.379964752149) | |||
| 29659 | 29659 | 219595 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1069 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6010265.38605 | 2103013.2851400003 | 37.7550528929921 | -122.40744140510701 | (37.7550528929921, -122.407441405107) | |||
| 157473 | 157473 | 74021 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1069 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2013 12:00:00 AM | 1 | Permit Number 770933 | 6008798.64457 | 2115935.54203 | 37.7904521737838 | -122.413427669467 | (37.7904521737838, -122.413427669467) | ||
| 33853 | 33853 | 250615 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 107 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987080.3378099995 | 2115303.7693 | 37.787474145255295 | -122.488524173771 | (37.7874741452553, -122.488524173771) | |||
| 133973 | 133973 | 250614 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 107 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5987083.69063 | 2115313.12063 | 37.7875000169526 | -122.48851326139999 | (37.7875000169526, -122.4885132614) | |||
| 187900 | 187900 | 250616 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 107 28th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5987080.55182 | 2115289.10715 | 37.7874338997015 | -122.488522355317 | (37.7874338997015, -122.488522355317) |
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");