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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
164438 | 164438 | 205525 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 141 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995964.76572 | 2093711.7341900002 | 37.7287023163446 | -122.45622427066002 | (37.7287023163446, -122.45622427066) | |||
170226 | 170226 | 183539 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1410 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5988555.4867 | 2097656.6869 | 37.7391060350729 | -122.48212719150601 | (37.7391060350729, -122.482127191506) | |||
28456 | 28456 | 183540 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1412 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988533.1723 | 2097656.6869 | 37.739104737168105 | -122.48220434364299 | (37.7391047371681, -122.482204343643) | |||
180956 | 180956 | 183541 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1414 Vicente St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988516.3068 | 2097655.13 | 37.7390994813211 | -122.48226254214501 | (37.7390994813211, -122.482262542145) | |||
188738 | 188738 | 204257 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1419 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994248.63466 | 2105844.7666700003 | 37.76191790830379 | -122.463036948099 | (37.7619179083038, -122.463036948099) | |||
46002 | 46002 | 204258 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1420 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993993.00507 | 2105826.93841 | 37.7618542281975 | -122.46391976938999 | (37.7618542281975, -122.46391976939) | |||
160980 | 160980 | 33263 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1422 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 7 | Permit Number 37438 | 5988495.8087 | 2097654.8706 | 37.7390975767362 | -122.48233339540701 | (37.7390975767362, -122.482333395407) | |
162405 | 162405 | 33264 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1424 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 8 | Permit Number 37439 | 5988466.7481 | 2097653.8327 | 37.7390930364544 | -122.48243379651501 | (37.7390930364544, -122.482433796515) | |
48093 | 48093 | 205530 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 144 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995914.63015 | 2093636.3873599998 | 37.728492553972394 | -122.456392145303 | (37.7284925539724, -122.456392145303) | |||
132039 | 132039 | 205529 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 144 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995917.70633 | 2093646.88822 | 37.728521563409295 | -122.456382269849 | (37.7285215634093, -122.456382269849) | |||
62163 | 62163 | 205528 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1448 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995919.53308 | 2093656.1964599998 | 37.728547226470106 | -122.456376627506 | (37.7285472264701, -122.456376627506) | |||
138190 | 138190 | 205527 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1448 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995920.6034699995 | 2093687.8699299998 | 37.7286342556576 | -122.45637521646002 | (37.7286342556576, -122.45637521646) | |||
66942 | 66942 | 38846 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1470 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 7 | Permit Number 40676 | 5989942.607000001 | 2105373.0458 | 37.7603737086332 | -122.477895157521 | (37.7603737086332, -122.477895157521) | |
187529 | 187529 | 38847 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1470 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 9 | Permit Number 40676 | 5989942.9457 | 2105353.4021 | 37.7603197919591 | -122.47789255007099 | (37.7603197919591, -122.477892550071) | |
88076 | 88076 | 35089 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1483 FUNSTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38630 | 5992081.0 | 2105361.0 | 37.7604645121053 | -122.470498641045 | (37.7604645121053, -122.470498641045) | ||
36456 | 36456 | 205583 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994004.16046 | 2096866.7723599998 | 37.737252533472706 | -122.46323099482001 | (37.7372525334727, -122.46323099482) | |||
39814 | 39814 | 205577 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993988.87344 | 2096971.5680200001 | 37.737539395633604 | -122.46329145086099 | (37.7375393956336, -122.463291450861) | |||
48243 | 48243 | 205579 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993994.26166 | 2096934.2401 | 37.737437212859795 | -122.463270113518 | (37.7374372128598, -122.463270113518) | |||
53802 | 53802 | 205582 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994001.091440001 | 2096883.9077299999 | 37.7372994061387 | -122.463242848772 | (37.7372994061387, -122.463242848772) | |||
66902 | 66902 | 205581 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993999.7716 | 2096902.7135 | 37.737350966076 | -122.46324877623199 | (37.737350966076, -122.463248776232) | |||
150566 | 150566 | 205580 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993997.03811 | 2096919.5005400002 | 37.7373969016417 | -122.463259444867 | (37.7373969016417, -122.463259444867) | |||
155705 | 155705 | 205578 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993989.91477 | 2096955.84067 | 37.737496272231205 | -122.46328670960699 | (37.7374962722312, -122.463286709607) | |||
122013 | 122013 | 73893 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1501 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 10 | 6007549.1868 | 2116472.92184 | 37.7918574535089 | -122.417788830994 | (37.7918574535089, -122.417788830994) | ||
155622 | 155622 | 74125 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1501 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 9 | 6007522.57983 | 2116468.5162 | 37.7918438593627 | -122.417880578935 | (37.7918438593627, -122.417880578935) | ||
40682 | 40682 | 221167 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1511 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002614.763119999 | 2100979.87159 | 37.749038432187206 | -122.433754105874 | (37.7490384321872, -122.433754105874) | |||
60270 | 60270 | 221166 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1511 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002614.587619999 | 2100996.2714 | 37.749083452239496 | -122.433755884736 | (37.7490834522395, -122.433755884736) | |||
156387 | 156387 | 221165 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1511 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002609.85714 | 2101016.35214 | 37.7491383207878 | -122.433773677812 | (37.7491383207878, -122.433773677812) | |||
137823 | 137823 | 205540 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1526 Plymouth Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995874.39111 | 2094226.59962 | 37.730110824639794 | -122.456573917178 | (37.7301108246398, -122.456573917178) | |||
46720 | 46720 | 204269 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1534 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992157.82192 | 2104971.85791 | 37.7594004720591 | -122.47020461405899 | (37.7594004720591, -122.470204614059) | |||
170531 | 170531 | 204259 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993347.58252 | 2104972.77487 | 37.7594717019775 | -122.46608993960699 | (37.7594717019775, -122.466089939607) | |||
22355 | 22355 | 204264 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992423.56649 | 2104856.18392 | 37.7590982216204 | -122.469277127955 | (37.7590982216204, -122.469277127955) | |||
69853 | 69853 | 204260 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992419.35568 | 2104946.71184 | 37.7593465442125 | -122.46929828000499 | (37.7593465442125, -122.469298280005) | |||
73672 | 73672 | 204263 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992422.38407 | 2104872.65232 | 37.7591433711999 | -122.469282415954 | (37.7591433711999, -122.469282415954) | |||
116425 | 116425 | 204265 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992424.423769999 | 2104838.80888 | 37.7590505638561 | -122.46927289844999 | (37.7590505638561, -122.46927289845) | |||
147400 | 147400 | 204262 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992421.48169 | 2104887.89672 | 37.7591851761784 | -122.469286646366 | (37.7591851761784, -122.469286646366) | |||
165373 | 165373 | 204261 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992420.194 | 2104928.42371 | 37.7592963782498 | -122.46929404958401 | (37.7592963782498, -122.469294049584) | |||
46211 | 46211 | 38855 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1546 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 7 | Permit Number 40682 | 5989647.796 | 2104818.2381 | 37.7588332407039 | -122.478874180945 | (37.7588332407039, -122.478874180945) | |
79682 | 79682 | 52242 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
80403 | 80403 | 52245 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
105536 | 105536 | 52243 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
140544 | 140544 | 52244 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
30365 | 30365 | 204312 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 156 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992641.06046 | 2098150.29955 | 37.7406981546001 | -122.468037152598 | (37.7406981546001, -122.468037152598) | |||
44506 | 44506 | 204313 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 156 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992646.95853 | 2098168.40564 | 37.740748209955 | -122.46801807618601 | (37.740748209955, -122.468018076186) | |||
29668 | 29668 | 205564 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1570 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994021.91378 | 2104924.9541599997 | 37.7593792795413 | -122.46375431661501 | (37.7593792795413, -122.463754316615) | |||
133846 | 133846 | 34647 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1587 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38326 | 5987753.3744 | 2104509.5361 | 37.7578754422043 | -122.485403233386 | (37.7578754422043, -122.485403233386) | |
1621 | 1621 | 88501 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1599 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51438 | 6015120.9647 | 2094333.0532 | 37.7314893544439 | -122.390042929541 | (37.7314893544439, -122.390042929541) | |
89043 | 89043 | 113823 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1599x CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | |||
96908 | 96908 | 113825 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1599x CASTRO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/10/2015 12:00:00 AM | 8 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | |
111668 | 111668 | 113828 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1599x CASTRO ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | ||||
123167 | 123167 | 113824 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1599x CASTRO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | |||
58385 | 58385 | 125691 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 16 Iris Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 5997626.06875 | 2114398.69705 | 37.785598761105 | -122.45197294599899 | (37.785598761105, -122.451972945999) | |||
135058 | 135058 | 204242 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 160 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994277.66229 | 2093529.3248700001 | 37.7281044749175 | -122.462043425661 | (37.7281044749175, -122.462043425661) | |||
57560 | 57560 | 221158 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 160 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006960.355719999 | 2098557.64733 | 37.742633178187106 | -122.418555239545 | (37.7426331781871, -122.418555239545) | |||
18354 | 18354 | 29366 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2012 12:00:00 AM | 3 | 3X3 | 5992064.02141 | 2096527.0918599998 | 37.7362078962607 | -122.46991416090599 | (37.7362078962607, -122.469914160906) | ||
18576 | 18576 | 29362 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5991983.966469999 | 2096447.7248099998 | 37.7359853464519 | -122.470185163514 | (37.7359853464519, -122.470185163514) | ||
19218 | 19218 | 29363 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5992002.78104 | 2096471.37185 | 37.736051362971004 | -122.470121835975 | (37.736051362971, -122.470121835975) | ||
19222 | 19222 | 29357 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991847.829940001 | 2096308.81938 | 37.7355960757897 | -122.470645723443 | (37.7355960757897, -122.470645723443) | ||
20563 | 20563 | 29361 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991939.73246 | 2096403.05712 | 37.735860142840096 | -122.470334844889 | (37.7358601428401, -122.470334844889) | ||
20795 | 20795 | 29365 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992050.3612 | 2096514.70328 | 37.7361730907045 | -122.46996048768601 | (37.7361730907045, -122.469960487686) | ||
20965 | 20965 | 29364 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992027.40322 | 2096494.06765 | 37.7361151033221 | -122.470038359996 | (37.7361151033221, -122.470038359996) | ||
21756 | 21756 | 29359 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991917.55406 | 2096377.82265 | 37.735789573027205 | -122.470409686474 | (37.7357895730272, -122.470409686474) | ||
22089 | 22089 | 29358 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991885.18 | 2096342.85411 | 37.735691686328295 | -122.470519069219 | (37.7356916863283, -122.470519069219) | ||
22167 | 22167 | 29360 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991958.47705 | 2096423.3893400002 | 37.73591705373521 | -122.470271518219 | (37.7359170537352, -122.470271518219) | ||
22191 | 22191 | 29356 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991811.277419999 | 2096273.10994 | 37.7354959129041 | -122.47076949802201 | (37.7354959129041, -122.470769498022) | ||
51853 | 51853 | 204330 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5992106.1404800005 | 2096570.57144 | 37.73632971483521 | -122.46977170381099 | (37.7363297148352, -122.469771703811) | |||
69083 | 69083 | 204328 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5992078.39374 | 2096541.4666900001 | 37.7362481967035 | -122.469865516581 | (37.7362481967035, -122.469865516581) | |||
131052 | 131052 | 204331 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5992122.89854 | 2096586.89794 | 37.7363755119059 | -122.46971495297899 | (37.7363755119059, -122.469714952979) | |||
134823 | 134823 | 204329 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5992093.44259 | 2096556.1613599998 | 37.736289414430296 | -122.469814556494 | (37.7362894144303, -122.469814556494) | |||
67242 | 67242 | 246811 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 161 Brewster St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6010262.216659999 | 2098999.82172 | 37.7440326285028 | -122.40716947078998 | (37.7440326285028, -122.40716947079) | |||
172101 | 172101 | 246810 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 161 Brewster St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6010258.54095 | 2098989.94927 | 37.744005315193895 | -122.407181484852 | (37.7440053151939, -122.407181484852) | |||
15921 | 15921 | 29468 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1613 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/05/2015 07:24:00 AM | 3 | 3X3 | 6016802.5034 | 2093317.3698 | 37.7287936059494 | -122.384158766122 | (37.7287936059494, -122.384158766122) | ||
119181 | 119181 | 33327 | Significant Tree 6 | Arbutus unedo :: Strawberry Tree 61 | 1629 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2010 12:00:00 AM | 3x3 | Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued | 6005242.65792202 | 2118493.60609418 | 37.7972756709044 | -122.425913331435 | (37.7972756709044, -122.425913331435) | ||
113972 | 113972 | 51581 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1639 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2005 12:00:00 AM | 3 | Permit Number 47874 | 6006611.817858701 | 2116483.82002415 | 37.791834582054896 | -122.421032908654 | (37.7918345820549, -122.421032908654) | ||
177906 | 177906 | 221149 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 164 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997548.8030199995 | 2106785.1121799997 | 37.7646894057032 | -122.451690854773 | (37.7646894057032, -122.451690854773) | |||
98523 | 98523 | 40340 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1646 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | Permit Number 41471 | 5998688.07142674 | 2109026.60811122 | 37.770909165958 | -122.44791183337 | (37.770909165958, -122.44791183337) | |||
132275 | 132275 | 125715 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 165 Francisco St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 8ft | 6010453.93223 | 2121307.9619 | 37.8052963286168 | -122.408079498365 | (37.8052963286168, -122.408079498365) | |||
176140 | 176140 | 205544 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 170 Colon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5996146.907790001 | 2094084.3221599997 | 37.7297358073576 | -122.45562151801701 | (37.7297358073576, -122.455621518017) | |||
172705 | 172705 | 204228 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1701 Irving St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990307.20481 | 2106501.61444 | 37.7634936095645 | -122.476716651764 | (37.7634936095645, -122.476716651764) | |||
52243 | 52243 | 140387 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1701 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003030.1364 | 2113397.2369999997 | 37.783157057463605 | -122.433204874911 | (37.7831570574636, -122.433204874911) | |||
10430 | 10430 | 86483 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1706 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987833.1754 | 2103641.2255 | 37.7554959453769 | -122.48506354557101 | (37.7554959453769, -122.485063545571) | ||
60899 | 60899 | 175558 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1716 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006381.40886 | 2092046.2621799998 | 37.724721740686995 | -122.42009507583799 | (37.724721740687, -122.420095075838) | |||
11268 | 11268 | 86482 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1722 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987834.8749 | 2103544.3561 | 37.7552300671815 | -122.48505056143499 | (37.7552300671815, -122.485050561435) | ||
41519 | 41519 | 204289 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5992459.80825 | 2103811.38116 | 37.7562315606514 | -122.46907574904499 | (37.7562315606514, -122.469075749045) | |||
52394 | 52394 | 204288 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5992460.26987 | 2103777.38754 | 37.7561382497077 | -122.46907167872801 | (37.7561382497077, -122.469071678728) | |||
165173 | 165173 | 204287 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5992461.83589 | 2103758.6049200003 | 37.756086768014995 | -122.469064896048 | (37.756086768015, -122.469064896048) | |||
178092 | 178092 | 204291 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992458.815230001 | 2103838.74555 | 37.7563066387524 | -122.46908117467501 | (37.7563066387524, -122.469081174675) | |||
187366 | 187366 | 204290 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5992460.07118 | 2103823.87562 | 37.756265882372105 | -122.46907574903999 | (37.7562658823721, -122.46907574904) | |||
136505 | 136505 | 204286 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1730 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5992513.76724 | 2103653.9977599997 | 37.7558025444594 | -122.468877689564 | (37.7558025444594, -122.468877689564) | |||
151192 | 151192 | 31864 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1734 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 10 | Permit Number 35306 | 5992515.136390001 | 2103625.8443 | 37.75572532149229 | -122.468870905993 | (37.7557253214923, -122.468870905993) | ||
122653 | 122653 | 68037 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1739 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31773 | 5993085.35051865 | 2103638.79960604 | 37.755793820585104 | -122.46689988213001 | (37.7557938205851, -122.46689988213) | ||
183994 | 183994 | 204276 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1739 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993085.208980001 | 2103636.9214 | 37.7557886553491 | -122.466900235077 | (37.7557886553491, -122.466900235077) | |||
151597 | 151597 | 140386 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1739 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6002991.9931 | 2113391.544 | 37.783139262071096 | -122.433336428258 | (37.7831392620711, -122.433336428258) | |||
10877 | 10877 | 86480 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1742 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987841.1062 | 2103418.0293 | 37.754883570877105 | -122.485019744249 | (37.7548835708771, -122.485019744249) | ||
172622 | 172622 | 140385 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1745 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002953.8498 | 2113388.1282 | 37.7831277191493 | -122.433468144329 | (37.7831277191493, -122.433468144329) | |||
102399 | 102399 | 68058 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1749 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32368 | 5993397.30702034 | 2103583.39285974 | 37.7556596880509 | -122.46581701937299 | (37.7556596880509, -122.465817019373) | ||
182801 | 182801 | 204224 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1749 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5993399.01633 | 2103583.1375 | 37.75565908549979 | -122.465811089536 | (37.7556590854998, -122.465811089536) | |||
67360 | 67360 | 141771 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1749 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002929.9391 | 2113383.5737 | 37.7831138570318 | -122.433550539983 | (37.7831138570318, -122.433550539983) | |||
10488 | 10488 | 86479 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1750 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103389.1385 | 37.7548041785464 | -122.485021542908 | (37.7548041785464, -122.485021542908) | ||
11831 | 11831 | 86477 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1754 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103364.7795 | 37.754737295309 | -122.485019755857 | (37.754737295309, -122.485019755857) | ||
17785 | 17785 | 32763 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1754 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778589 | 6009301.89278 | 2099228.78566 | 37.7446075228294 | -122.410506232583 | (37.7446075228294, -122.410506232583) |
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");