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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21616 | 21616 | 25457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/10/1997 12:00:00 AM | 6 | 3X3 | 5993681.7949 | 2088543.8714 | 37.7143812997511 | -122.463741645146 | (37.7143812997511, -122.463741645146) | ||
| 21638 | 21638 | 18577 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/12/1998 12:00:00 AM | 6 | 3X3 | 5993712.2633 | 2088544.8235 | 37.7143856696584 | -122.46363640417201 | (37.7143856696584, -122.463636404172) | ||
| 87998 | 87998 | 78960 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50072 | 6007769.24409179 | 2106089.05083821 | 37.7633582084166 | -122.41629164267599 | (37.7633582084166, -122.416291642676) | |
| 135364 | 135364 | 198121 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Venus St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012854.74593 | 2094309.4604599997 | 37.731298624935 | -122.397876080041 | (37.731298624935, -122.397876080041) | |||
| 67628 | 67628 | 242297 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004276.66198 | 2097448.18955 | 37.739435408412795 | -122.42775564310301 | (37.7394354084128, -122.427755643103) | |||
| 3754 | 3754 | 253538 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 6 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 02:43:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3832 | 3832 | 253545 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 13 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:58:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 4040 | 4040 | 253539 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 7 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/05/2017 04:07:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 4116 | 4116 | 253537 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 5 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/05/2017 04:02:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 91659 | 91659 | 87769 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Chenery St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50473 | 6000787.0 | 2096209.0 | 37.7358348629687 | -122.439732514448 | (37.7358348629687, -122.439732514448) | |||
| 113970 | 113970 | 8149 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/2007 12:00:00 AM | 3 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | ||
| 17015 | 17015 | 17008 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2006 12:00:00 AM | 3 | 3x3 | 6002174.9677 | 2109860.4544 | 37.7733973919924 | -122.435910261161 | (37.7733973919924, -122.435910261161) | ||
| 20182 | 20182 | 17009 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2015 11:40:00 AM | 3 | 3x3 | 6002160.0291 | 2109858.3203 | 37.773390683656395 | -122.43596178308 | (37.7733906836564, -122.43596178308) | ||
| 21426 | 21426 | 17010 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2015 11:33:00 AM | 3 | 3x3 | 6002136.5542 | 2109854.7635 | 37.773379583966495 | -122.43604273138399 | (37.7733795839665, -122.436042731384) | ||
| 125555 | 125555 | 198253 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Oakdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6018226.96048 | 2093133.1999700002 | 37.728366565251605 | -122.3792214842 | (37.7283665652516, -122.3792214842) | ||||
| 134966 | 134966 | 63038 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1986 12:00:00 AM | 7 | Permit Number 23508 | 6007306.538930001 | 2114741.30314 | 37.7870891967428 | -122.41850555290002 | (37.7870891967428, -122.4185055529) | |
| 76622 | 76622 | 214857 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000x Kirkham St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 5991776.8185 | 2105223.32879 | 37.7600689102828 | -122.471540622615 | (37.7600689102828, -122.471540622615) | |||
| 1469 | 1469 | 247378 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/1991 12:00:00 AM | 5 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | ||
| 106539 | 106539 | 17012 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/1991 12:00:00 AM | 6 | 3X3 | 6002208.6674 | 2109818.8585900003 | 37.773285094559895 | -122.43579071263001 | (37.7732850945599, -122.43579071263) | ||
| 27046 | 27046 | 136881 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009094.10364 | 2115978.2019 | 37.7905858921869 | -122.41240841293998 | (37.7905858921869, -122.41240841294) | |||
| 169515 | 169515 | 52021 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2005 12:00:00 AM | 3 | Permit Number 48237 | 6009039.147580001 | 2115969.08388 | 37.7905577721826 | -122.412597913578 | (37.7905577721826, -122.412597913578) | ||
| 7925 | 7925 | 22616 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005581.297 | 2112717.6262 | 37.7814354041528 | -122.424330527926 | (37.7814354041528, -122.424330527926) | |||
| 106939 | 106939 | 83172 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52725 | 5993010.18342246 | 2098349.46528224 | 37.74126632336 | -122.46677535093599 | (37.74126632336, -122.466775350936) | ||
| 15948 | 15948 | 101850 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001X Rhode Island St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 2 | 3x3 | Permit Number 774983 | 6011937.4679 | 2103668.00433 | 37.7569440557359 | -122.401704847401 | (37.7569440557359, -122.401704847401) | |
| 3769 | 3769 | 136887 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
| 3772 | 3772 | 136889 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
| 3785 | 3785 | 136888 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
| 4211 | 4211 | 136890 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 01:59:00 PM | 3 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | ||
| 17249 | 17249 | 28766 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005756.3593 | 2103044.9501900002 | 37.7548864275923 | -122.423037187213 | (37.7548864275923, -122.423037187213) | |||
| 37305 | 37305 | 31761 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35247 | 5990066.9971 | 2099007.5245 | 37.7429028843685 | -122.47699981190901 | (37.7429028843685, -122.476999811909) | |
| 37903 | 37903 | 31762 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35247 | 5990024.3559 | 2099006.1709 | 37.7428966939048 | -122.477147152853 | (37.7428966939048, -122.477147152853) | |
| 180419 | 180419 | 97315 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35247 | 5990088.3176 | 2099007.1861 | 37.7429031920496 | -122.476926067611 | (37.7429031920496, -122.476926067611) | ||
| 19770 | 19770 | 24365 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2013 12:00:00 AM | 3 | 3x3 | 6005973.11011 | 2108523.59872 | 37.769941736057895 | -122.42267691073201 | (37.7699417360579, -122.422676910732) | ||
| 87010 | 87010 | 90418 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2015 01:56:00 PM | 3 | 3x3 | 6006054.864608999 | 2108514.3846529997 | 37.7699210485793 | -122.422393468309 | (37.7699210485793, -122.422393468309) | ||
| 1458 | 1458 | 246242 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999462.0 | 2107723.0 | 37.7673739936786 | -122.445141068115 | (37.7673739936786, -122.445141068115) | |||
| 1467 | 1467 | 246243 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999462.0 | 2107723.0 | 37.7673739936786 | -122.445141068115 | (37.7673739936786, -122.445141068115) | |||
| 66739 | 66739 | 90402 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X McCoppin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006023.914808 | 2109144.349895 | 37.7716490364194 | -122.422545294145 | (37.7716490364194, -122.422545294145) | ||
| 83238 | 83238 | 90400 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006023.914808 | 2109144.349895 | 37.7716490364194 | -122.422545294145 | (37.7716490364194, -122.422545294145) | ||
| 98669 | 98669 | 90401 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006023.914808 | 2109144.349895 | 37.7716490364194 | -122.422545294145 | (37.7716490364194, -122.422545294145) | ||
| 159947 | 159947 | 120380 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5987993.342019999 | 2115259.54167 | 37.78740594078629 | -122.485362157504 | (37.7874059407863, -122.485362157504) | |||
| 102497 | 102497 | 32364 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36916 | 6005767.33287279 | 2099031.81897703 | 37.743867909048205 | -122.422714061246 | (37.7438679090482, -122.422714061246) | |||
| 127405 | 127405 | 32365 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36916 | 6005767.33287279 | 2099031.81897703 | 37.743867909048205 | -122.422714061246 | (37.7438679090482, -122.422714061246) | |||
| 184371 | 184371 | 140268 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998235.1003 | 2110285.9342 | 37.7743410503874 | -122.44956942301201 | (37.7743410503874, -122.449569423012) | |||
| 86968 | 86968 | 60636 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1991 12:00:00 AM | 3x3 | Permit Number 29895 | 6004821.44439287 | 2097233.75118826 | 37.738877411473105 | -122.42585676358601 | (37.7388774114731, -122.425856763586) | |
| 141734 | 141734 | 112979 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Fairmount St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6004821.44439287 | 2097233.75118826 | 37.738877411473105 | -122.42585676358601 | (37.7388774114731, -122.425856763586) | |||
| 144971 | 144971 | 112978 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Fairmount St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6004821.44439287 | 2097233.75118826 | 37.738877411473105 | -122.42585676358601 | (37.7388774114731, -122.425856763586) | |||
| 182724 | 182724 | 241579 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999507.07027 | 2107703.03573 | 37.7673217492226 | -122.444983741515 | (37.7673217492226, -122.444983741515) | |||
| 2022 | 2022 | 198027 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010199.0 | 2110711.0 | 37.7761853461059 | -122.40821387035 | (37.7761853461059, -122.40821387035) | |||
| 166389 | 166389 | 214920 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Northgate Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994398.89243 | 2094048.76996 | 37.7295377235746 | -122.461661978232 | (37.7295377235746, -122.461661978232) | |||
| 173318 | 173318 | 137755 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Pinar Ln | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000699.5333 | 2112350.481 | 37.780150448397706 | -122.44119267191799 | (37.7801504483977, -122.441192671918) | |||
| 25113 | 25113 | 137738 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000674.4901 | 2112530.5214 | 37.780643366815504 | -122.44129222933901 | (37.7806433668155, -122.441292229339) | |||
| 33175 | 33175 | 137742 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000683.6274 | 2112456.0686 | 37.7804394589456 | -122.44125527558901 | (37.7804394589456, -122.441255275589) | |||
| 59349 | 59349 | 137735 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000666.7064 | 2112585.6841 | 37.780794386091706 | -122.441323116023 | (37.7807943860917, -122.441323116023) | |||
| 71266 | 71266 | 137748 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000691.4111 | 2112421.5495 | 37.7803451216971 | -122.441225870769 | (37.7803451216971, -122.441225870769) | |||
| 72096 | 72096 | 137736 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000670.0906 | 2112567.0709 | 37.780743471784604 | -122.44131007253701 | (37.7807434717846, -122.441310072537) | |||
| 135795 | 135795 | 137741 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000681.9353 | 2112475.6969999997 | 37.780493257130296 | -122.441262538089 | (37.7804932571303, -122.441262538089) | |||
| 154612 | 154612 | 137737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000673.1364 | 2112546.4272 | 37.7806869629645 | -122.44129805402099 | (37.7806869629645, -122.441298054021) | |||
| 155700 | 155700 | 137757 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000706.9785 | 2112308.1782 | 37.7800347197931 | -122.44116387970101 | (37.7800347197931, -122.441163879701) | |||
| 160999 | 160999 | 137756 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000702.2406 | 2112329.8372 | 37.7800939200036 | -122.441181824601 | (37.7800939200036, -122.441181824601) | |||
| 162930 | 162930 | 137747 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000687.3501 | 2112439.4859 | 37.7803941391444 | -122.441241206915 | (37.7803941391444, -122.441241206915) | |||
| 174007 | 174007 | 137732 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000660.4455 | 2112640.6777 | 37.780945027799 | -122.441348722594 | (37.780945027799, -122.441348722594) | |||
| 82924 | 82924 | 32545 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 83121 | 83121 | 32550 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 86753 | 86753 | 32544 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 90973 | 90973 | 32551 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 103567 | 103567 | 32552 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 113135 | 113135 | 32553 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Valencia St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | |||
| 25579 | 25579 | 242205 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003186.42364 | 2107753.3281099997 | 37.7676691456397 | -122.43226097948799 | (37.7676691456397, -122.432260979488) | |||
| 174517 | 174517 | 218485 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1010 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995061.27255 | 2090658.8523400002 | 37.7202679310146 | -122.45912671113001 | (37.7202679310146, -122.45912671113) | |||
| 147683 | 147683 | 180398 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1011 Munich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002492.33471 | 2087599.91152 | 37.712293156769206 | -122.433221553446 | (37.7122931567692, -122.433221553446) | |||
| 184315 | 184315 | 180397 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1011 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002469.75801 | 2087564.3183799998 | 37.7121941450283 | -122.433297043449 | (37.7121941450283, -122.433297043449) | |||
| 35520 | 35520 | 59616 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1011 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2011 12:00:00 AM | 2 | Permit Number 767194 | 6015550.11535 | 2104384.66837 | 37.7591127987462 | -122.389260889583 | (37.7591127987462, -122.389260889583) | ||
| 122325 | 122325 | 42193 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1016 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42470 | 6010410.48288619 | 2109291.59089856 | 37.772299817533 | -122.407382201369 | (37.772299817533, -122.407382201369) | ||
| 123581 | 123581 | 42194 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1016 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42470 | 6010410.48288619 | 2109291.59089856 | 37.772299817533 | -122.407382201369 | (37.772299817533, -122.407382201369) | ||
| 166616 | 166616 | 241695 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1018 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005690.09574 | 2103002.00673 | 37.754764775380295 | -122.423263292966 | (37.7547647753803, -122.423263292966) | |||
| 86392 | 86392 | 31763 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1018 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35248 | 5990018.1797 | 2099070.5556 | 37.7430731192473 | -122.477173212243 | (37.7430731192473, -122.477173212243) | |
| 88740 | 88740 | 31764 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1018 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35248 | 5990072.01927063 | 2099066.23490799 | 37.7430643792619 | -122.476986735886 | (37.7430643792619, -122.476986735886) | ||
| 43466 | 43466 | 61653 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2015 12:00:00 AM | 1 | Permit Number 773687 | 5993009.87039 | 2114787.90553 | 37.7864019320171 | -122.467971834489 | (37.7864019320171, -122.467971834489) | |
| 109292 | 109292 | 90414 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X McCoppin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006026.109844 | 2109104.410168 | 37.7715394953365 | -122.422534862848 | (37.7715394953365, -122.422534862848) | ||
| 111734 | 111734 | 90413 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006026.109844 | 2109104.410168 | 37.7715394953365 | -122.422534862848 | (37.7715394953365, -122.422534862848) | ||
| 128094 | 128094 | 90412 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006026.109844 | 2109104.410168 | 37.7715394953365 | -122.422534862848 | (37.7715394953365, -122.422534862848) | ||
| 106370 | 106370 | 41975 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X NORTHGATE DR | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51393 | 5994409.0 | 2094096.0 | 37.7296679875594 | -122.461630458557 | (37.7296679875594, -122.461630458557) | ||
| 9496 | 9496 | 19512 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6000653.0003 | 2112676.212 | 37.781042171769705 | -122.441377029637 | (37.7810421717697, -122.441377029637) | |||
| 9512 | 9512 | 19511 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000658.415 | 2112657.2603 | 37.7809904437075 | -122.44135693728902 | (37.7809904437075, -122.441356937289) | |||
| 171519 | 171519 | 242114 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 102 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004092.370680001 | 2102414.1734 | 37.753060424318704 | -122.428746761659 | (37.7530604243187, -122.428746761659) | |||
| 171523 | 171523 | 74199 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1020 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1988 12:00:00 AM | 5 | 6007263.22393 | 2114733.09636 | 37.787064224370205 | -122.418654831377 | (37.7870642243702, -122.418654831377) | ||
| 165676 | 165676 | 182097 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1020 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5990001.597 | 2099070.5556 | 37.7430721571395 | -122.477230550126 | (37.7430721571395, -122.477230550126) | |||
| 86160 | 86160 | 49033 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1026 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51460 | 6003769.51621429 | 2102291.73865454 | 37.7527059694214 | -122.429854522688 | (37.7527059694214, -122.429854522688) | ||
| 175334 | 175334 | 242105 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1026 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003766.99419 | 2102287.31977 | 37.7526936933823 | -122.42986292912902 | (37.7526936933823, -122.429862929129) | |||
| 41240 | 41240 | 241912 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1027 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009191.98331 | 2103167.16216 | 37.7554152658072 | -122.411164423924 | (37.7554152658072, -122.411164423924) | |||
| 39491 | 39491 | 242040 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 103 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005654.86586 | 2099026.99842 | 37.743848326850205 | -122.42310260391001 | (37.7438483268502, -122.42310260391) | |||
| 179341 | 179341 | 32366 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 103 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 5 | Permit Number 36916 | 6005686.90758 | 2099028.442 | 37.7438540987038 | -122.422991913571 | (37.7438540987038, -122.422991913571) | ||
| 145472 | 145472 | 38184 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 103 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2013 12:00:00 AM | Permit Number 769585 | 6011280.82748459 | 2091572.16346792 | 37.7236947961561 | -122.403124961994 | (37.7236947961561, -122.403124961994) | ||
| 17304 | 17304 | 17016 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1030 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2014 10:45:00 AM | 3 | 3x3 | 6002064.7067 | 2109844.0931 | 37.7733462037226 | -122.436290497808 | (37.7733462037226, -122.436290497808) | ||
| 173268 | 173268 | 218609 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1030 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990759.53808 | 2102496.2873400003 | 37.7525222708937 | -122.474859817922 | (37.7525222708937, -122.474859817922) | |||
| 159628 | 159628 | 52470 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1030@ 11th AVE Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51589 | 5992346.66414 | 2111391.66807 | 37.777038472757 | -122.470018958474 | (37.777038472757, -122.470018958474) | |
| 176118 | 176118 | 249541 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1031 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006016.726419999 | 2113765.1480900003 | 37.7843362199808 | -122.42289862237699 | (37.7843362199808, -122.422898622377) | |||
| 46576 | 46576 | 123777 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1033 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992375.070730001 | 2110654.80372 | 37.7750168848669 | -122.469867030032 | (37.7750168848669, -122.469867030032) | |||
| 132162 | 132162 | 67370 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1033 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | 2 | Permit Number 30863 | 5992388.573530001 | 2110655.28285 | 37.7750189809249 | -122.46982035623199 | (37.7750189809249, -122.469820356232) | |
| 155654 | 155654 | 82866 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1034 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52362 | 6013991.3555 | 2090013.1137 | 37.7195649546626 | -122.393645991886 | (37.7195649546626, -122.393645991886) |
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");