Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116288 | 116288 | 38652 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1276 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/1998 12:00:00 AM | Permit Number 40574 | 5982148.09911045 | 2106418.94720672 | 37.762789987906 | -122.504929783979 | (37.762789987906, -122.504929783979) | |||
| 169971 | 169971 | 184438 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2118 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982650.6525 | 2100679.8359 | 37.7470615561433 | -122.50276680933399 | (37.7470615561433, -122.502766809334) | |||
| 183394 | 183394 | 69157 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1259 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 8 | Permit Number 33193 | 5983030.0636 | 2106498.5077 | 37.7630602867444 | -122.501885316454 | (37.7630602867444, -122.501885316454) | |
| 47820 | 47820 | 70445 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2471 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 5 | 5982997.1409 | 2098317.8833 | 37.740596640895795 | -122.501394010052 | (37.7405966408958, -122.501394010052) | ||
| 75941 | 75941 | 73418 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2483 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 3 | 5983001.5767 | 2098246.6338 | 37.740401269768796 | -122.50137340388001 | (37.7404012697688, -122.50137340388) | ||
| 131758 | 131758 | 63193 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 435 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 12 | Permit Number 23733 | 5984052.79771 | 2112895.3666 | 37.78068425281221 | -122.498820690126 | (37.7806842528122, -122.498820690126) | |
| 117131 | 117131 | 31678 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 568 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35184 | 5984441.54106734 | 2111980.46046246 | 37.7781949786835 | -122.497408297818 | (37.7781949786835, -122.497408297818) | |||
| 10673 | 10673 | 121353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1221 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2016 12:00:00 AM | 3 | 3x3 | 5984567.3281 | 2106871.8527 | 37.76417557031971 | -122.496596073864 | (37.7641755703197, -122.496596073864) | ||
| 52875 | 52875 | 186786 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984829.112000001 | 2106870.9818 | 37.7641885128796 | -122.495690587985 | (37.7641885128796, -122.495690587985) | |||
| 67038 | 67038 | 69446 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 443 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 10 | Permit Number 33556 | 5985911.814680001 | 2112907.20872 | 37.7808256288006 | -122.492390419974 | (37.7808256288006, -122.492390419974) | |
| 40165 | 40165 | 32579 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1247 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 5 | Permit Number 37053 | 5985814.1748 | 2106726.0184 | 37.763848120851705 | -122.49227291177401 | (37.7638481208517, -122.492272911774) | |
| 180337 | 180337 | 181742 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1219 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986119.9697 | 2106920.2395 | 37.7643992701936 | -122.491229569586 | (37.7643992701936, -122.491229569586) | |||
| 177509 | 177509 | 181743 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1219 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986121.7407 | 2106913.1555 | 37.7643799229814 | -122.491222922878 | (37.7643799229814, -122.491222922878) | |||
| 3796 | 3796 | 182316 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2726 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | 3 | Width 0ft | Permit Number 43905 | 5986380.5744 | 2105064.6172 | 37.759319468361 | -122.490191716108 | (37.759319468361, -122.490191716108) | |
| 136013 | 136013 | 44808 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1371 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 4 | Permit Number 43903 | 5986465.0991 | 2105937.0115 | 37.7617197583894 | -122.489963557407 | (37.7617197583894, -122.489963557407) | |
| 51501 | 51501 | 44809 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1371 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 3 | Permit Number 43903 | 5986466.0604 | 2105911.3769 | 37.7616494289947 | -122.48995834721501 | (37.7616494289947, -122.489958347215) | |
| 63595 | 63595 | 181646 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1266 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986485.3888 | 2106651.0455 | 37.7636814828681 | -122.489945903056 | (37.7636814828681, -122.489945903056) | |||
| 149741 | 149741 | 78348 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 2 | 5986606.5677 | 2110833.2599299997 | 37.7751717483754 | -122.489834389598 | (37.7751717483754, -122.489834389598) | ||
| 42881 | 42881 | 78349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5986607.90066 | 2110854.65361 | 37.7752305672016 | -122.489831352395 | (37.7752305672016, -122.489831352395) | ||
| 153717 | 153717 | 69152 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1245 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1994 12:00:00 AM | 5 | Permit Number 33187 | 5986742.1857 | 2106776.7875 | 37.764041727251396 | -122.48906697906 | (37.7640417272514, -122.48906697906) | |
| 158243 | 158243 | 119916 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3801 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5986867.2095099995 | 2111818.56024 | 37.777892319492295 | -122.489005232889 | (37.7778923194923, -122.489005232889) | |||
| 176616 | 176616 | 112176 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 607 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 5986882.73557 | 2111785.73395 | 37.7778030939685 | -122.48894910976601 | (37.7778030939685, -122.488949109766) | |||
| 123294 | 123294 | 112175 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 607 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5986883.70014 | 2111802.41515 | 37.7778489521099 | -122.488946999613 | (37.7778489521099, -122.488946999613) | |||
| 147105 | 147105 | 182416 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1555 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987127.1216 | 2104695.2134 | 37.758348756439204 | -122.487582689554 | (37.7583487564392, -122.487582689554) | |||
| 151263 | 151263 | 43591 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2278 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 4 | Permit Number 43252 | 5987031.7486 | 2099759.5703 | 37.744791251078 | -122.487549954339 | (37.744791251078, -122.487549954339) | |
| 175230 | 175230 | 181661 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2706 Irving St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5987293.6389 | 2106455.5367 | 37.7631918321241 | -122.48713609337601 | (37.7631918321241, -122.487136093376) | |||
| 167487 | 167487 | 181677 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2704 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987307.2214 | 2106457.8989 | 37.7631991100618 | -122.48708929014799 | (37.7631991100618, -122.487089290148) | |||
| 165870 | 165870 | 181676 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2702 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5987326.1189 | 2106457.3084 | 37.763198590581105 | -122.487023887472 | (37.7631985905811, -122.487023887472) | |||
| 61469 | 61469 | 181675 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2700 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987341.4731 | 2106458.4895 | 37.763202728798106 | -122.486970869844 | (37.7632027287981, -122.486970869844) | |||
| 91837 | 91837 | 38107 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1295 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | ||
| 102452 | 102452 | 38105 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1295 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | ||
| 117884 | 117884 | 38104 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1295 28th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | ||
| 145944 | 145944 | 38106 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1295 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | ||
| 40373 | 40373 | 37238 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.755729192821704 | -122.48675431687 | (37.7557291928217, -122.48675431687) | ||
| 179896 | 179896 | 56330 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2526 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1973 12:00:00 AM | 8 | Permit Number 12466 | 5987579.5629 | 2113304.9613200002 | 37.7820151066388 | -122.48665015476801 | (37.7820151066388, -122.486650154768) | ||
| 95289 | 95289 | 37234 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 95392 | 95392 | 37236 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 115986 | 115986 | 37239 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 143102 | 143102 | 37235 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 131032 | 131032 | 33248 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2591 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37429 | 5987367.1404 | 2097667.8262 | 37.7390674308693 | -122.486236717873 | (37.7390674308693, -122.486236717873) |
| 70052 | 70052 | 47793 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2578 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 3 | Permit Number 45565 | 5987410.8144 | 2097738.044 | 37.7392627758453 | -122.48609086811899 | (37.7392627758453, -122.486090868119) | |
| 72162 | 72162 | 38103 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1339 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 6 | Permit Number 40274 | 5987697.8486 | 2106168.016 | 37.7624259403231 | -122.48571698139601 | (37.7624259403231, -122.485716981396) | |
| 39548 | 39548 | 72980 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1730 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1999 12:00:00 AM | 7 | 5987835.4413 | 2103488.2738 | 37.7550761133303 | -122.48504448823499 | (37.7550761133303, -122.485044488235) | ||
| 76460 | 76460 | 65960 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2514 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | 11 | Permit Number 28982 | 5988016.2527 | 2098169.589 | 37.740482951266706 | -122.48402919603399 | (37.7404829512667, -122.484029196034) | |
| 176335 | 176335 | 183924 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2118 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5988539.4126 | 2100905.5456 | 37.7480256114084 | -122.482420751779 | (37.7480256114084, -122.482420751779) | |||
| 167088 | 167088 | 175765 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5988629.85447 | 2089774.3019599998 | 37.7174673468061 | -122.481292995899 | (37.7174673468061, -122.481292995899) | ||||
| 111008 | 111008 | 116626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 5732X GEARY BLVD | 7 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 41975 | 41975 | 65113 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 363 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 10 | Permit Number 27082 | 5989323.435380001 | 2112903.08855 | 37.781013182321104 | -122.480587794991 | (37.7810131823211, -122.480587794991) | |
| 102034 | 102034 | 19417 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5988998.102828201 | 2096024.0271709 | 37.7346489082814 | -122.48047736602301 | (37.7346489082814, -122.480477366023) | ||
| 131805 | 131805 | 71996 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 340 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1989 12:00:00 AM | 7 | 5989363.9833 | 2113075.9914599997 | 37.7814902817874 | -122.48046018125 | (37.7814902817874, -122.48046018125) | ||
| 29332 | 29332 | 61172 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 346 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 11 | Permit Number 27084 | 5989366.0565 | 2113024.18126 | 37.781348145965296 | -122.480449215491 | (37.7813481459653, -122.480449215491) | |
| 178155 | 178155 | 71997 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 362 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1989 12:00:00 AM | 6 | 5989369.28583 | 2112922.15861 | 37.7810682079879 | -122.48043057365 | (37.7810682079879, -122.48043057365) | ||
| 153879 | 153879 | 181761 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1246 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989269.0192 | 2106863.9805 | 37.7644282944678 | -122.480333887539 | (37.7644282944678, -122.480333887539) | |||
| 134933 | 134933 | 181746 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1246 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989272.8487 | 2106849.4285 | 37.7643885611619 | -122.480319577317 | (37.7643885611619, -122.480319577317) | |||
| 168676 | 168676 | 185068 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989159.6219 | 2096046.6038 | 37.7347202832405 | -122.47992059791001 | (37.7347202832405, -122.47992059791) | |||
| 44691 | 44691 | 175766 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989094.03032 | 2089506.27121 | 37.7167583770722 | -122.47966897135001 | (37.7167583770722, -122.47966897135) | ||||
| 153875 | 153875 | 72840 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2634 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 5 | 5989285.167 | 2097358.0202 | 37.7383283873436 | -122.479582470664 | (37.7383283873436, -122.479582470664) | ||
| 165657 | 165657 | 185126 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5989258.3218 | 2096043.9506 | 37.7347187320697 | -122.479579168443 | (37.7347187320697, -122.479579168443) | |||
| 107953 | 107953 | 19416 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 700X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989518.2187007 | 2096039.5354251 | 37.7347217027544 | -122.4786803033 | (37.7347217027544, -122.4786803033) | ||
| 124162 | 124162 | 44717 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1991 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | Permit Number 43839 | 5989704.86545465 | 2101822.42727681 | 37.7506108546658 | -122.47845774312599 | (37.7506108546658, -122.478457743126) | ||
| 41434 | 41434 | 175767 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | ||||
| 24183 | 24183 | 175768 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989578.68884 | 2089185.3656400002 | 37.7159053925979 | -122.47797031747801 | (37.7159053925979, -122.477970317478) | ||||
| 98718 | 98718 | 19415 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600X Sloat Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989744.831209299 | 2096044.8028161 | 37.7347493206824 | -122.477897219949 | (37.7347493206824, -122.477897219949) | ||
| 24841 | 24841 | 175769 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989661.94364 | 2089233.64885 | 37.716042798215206 | -122.477686080452 | (37.7160427982152, -122.477686080452) | ||||
| 125272 | 125272 | 110420 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
| 171701 | 171701 | 175770 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 5989758.80887 | 2089246.54995 | 37.7160838423675 | -122.477352214341 | (37.7160838423675, -122.477352214341) | ||||
| 154455 | 154455 | 175771 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5989791.935380001 | 2089208.15493 | 37.7159803412063 | -122.477234910356 | (37.7159803412063, -122.477234910356) | ||||
| 59851 | 59851 | 175772 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989911.02174 | 2089222.5365 | 37.716026738112 | -122.47682434649201 | (37.716026738112, -122.476824346492) | ||||
| 180214 | 180214 | 175773 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5990089.9017900005 | 2089410.48117 | 37.716553162587296 | -122.476219779021 | (37.7165531625873, -122.476219779021) | ||||
| 44057 | 44057 | 175774 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5990113.97654 | 2089437.91841 | 37.7166298945381 | -122.47613856845 | (37.7166298945381, -122.47613856845) | ||||
| 26245 | 26245 | 204609 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1382 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5990541.2449199995 | 2105988.9613 | 37.7620995740555 | -122.475869749413 | (37.7620995740555, -122.475869749413) | |||
| 175059 | 175059 | 204610 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1410 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990554.31015 | 2105766.55939 | 37.7614896754309 | -122.47580832029499 | (37.7614896754309, -122.475808320295) | |||
| 56301 | 56301 | 204608 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1563 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5990535.7174 | 2104763.29262 | 37.7587338945762 | -122.47579935676399 | (37.7587338945762, -122.475799356764) | |||
| 83292 | 83292 | 56149 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 426 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 18 | 4x4 | Permit Number 12256 | 5990938.77862 | 2112472.88916 | 37.7799257212488 | -122.474968166346 | (37.7799257212488, -122.474968166346) | |
| 31367 | 31367 | 204614 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1255 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5990910.22691 | 2105165.14407 | 37.7598589779192 | -122.474533471065 | (37.7598589779192, -122.474533471065) | |||
| 71944 | 71944 | 204615 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1255 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5990928.50457 | 2105165.0384299997 | 37.7598597468563 | -122.474470250504 | (37.7598597468563, -122.474470250504) | |||
| 124221 | 124221 | 44343 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 233 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2001 12:00:00 AM | Permit Number 43727 | 5991164.04904901 | 2113857.0036857 | 37.7837391697575 | -122.47428989169201 | (37.7837391697575, -122.474289891692) | |||
| 152106 | 152106 | 204613 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1440 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5991174.12963 | 2105607.5581900002 | 37.7610890166517 | -122.47365304285401 | (37.7610890166517, -122.473653042854) | |||
| 35496 | 35496 | 204653 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 131 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991405.61668 | 2090064.78105 | 37.718425920692795 | -122.47171971360599 | (37.7184259206928, -122.471719713606) | |||
| 157425 | 157425 | 124076 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 701 Funston Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5991934.28865 | 2110305.99584 | 37.7740336644487 | -122.471366355947 | (37.7740336644487, -122.471366355947) | |||
| 181339 | 181339 | 124077 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 701 Funston Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5991933.739630001 | 2110279.93645 | 37.7739620806591 | -122.471366355942 | (37.7739620806591, -122.471366355942) | |||
| 148883 | 148883 | 43665 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 241 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 3 | Permit Number 43308 | 5992118.30424 | 2113674.27096 | 37.7832926725519 | -122.47097524296001 | (37.7832926725519, -122.47097524296) | |
| 175431 | 175431 | 204612 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5992412.91605 | 2102688.13741 | 37.7531447159591 | -122.469156169131 | (37.7531447159591, -122.469156169131) | |||
| 185920 | 185920 | 204625 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5992281.41366 | 2095382.3817200002 | 37.733077373320896 | -122.469079268988 | (37.7330773733209, -122.469079268988) | |||
| 137747 | 137747 | 204626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5992297.08253 | 2095382.05199 | 37.7330773733083 | -122.46902507404499 | (37.7330773733083, -122.469025074045) | |||
| 161465 | 161465 | 30509 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1925 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 12 | Permit Number 34522 | 5992647.92392 | 2112025.91365 | 37.7787973496586 | -122.46902298556002 | (37.7787973496586, -122.46902298556) | ||
| 139018 | 139018 | 111080 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2811 14TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5992341.0 | 2097126.0 | 37.737868354045204 | -122.469000113007 | (37.7378683540452, -122.469000113007) | |||
| 168361 | 168361 | 123817 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1925 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992665.27685 | 2112027.3966200002 | 37.7788024241016 | -122.468963063439 | (37.7788024241016, -122.468963063439) | |||
| 58207 | 58207 | 204627 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5992327.28359 | 2095380.5803 | 37.7330750773552 | -122.46892055484301 | (37.7330750773552, -122.468920554843) | |||
| 175761 | 175761 | 204654 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 222 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992216.41936 | 2089361.24223 | 37.7165410523041 | -122.46886596240299 | (37.7165410523041, -122.468865962403) | |||
| 28542 | 28542 | 204628 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5992344.57273 | 2095377.42888 | 37.733067423224 | -122.46886055298701 | (37.733067423224, -122.468860552987) | |||
| 100338 | 100338 | 33375 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | Permit Number 37501 | 5992405.97715527 | 2095379.41663179 | 37.7330764284901 | -122.46864840809799 | (37.7330764284901, -122.468648408098) | |||
| 101974 | 101974 | 33374 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | Permit Number 37501 | 5992405.97715527 | 2095379.41663179 | 37.7330764284901 | -122.46864840809799 | (37.7330764284901, -122.468648408098) | |||
| 115328 | 115328 | 33376 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45124 | 5992405.97715527 | 2095379.41663179 | 37.7330764284901 | -122.46864840809799 | (37.7330764284901, -122.468648408098) | ||
| 145192 | 145192 | 33403 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 384 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2003 12:00:00 AM | Permit Number 46425 | 5992447.80765363 | 2094243.66151518 | 37.729960344135996 | -122.468421188533 | (37.729960344136, -122.468421188533) | ||
| 95376 | 95376 | 45782 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 243 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2001 12:00:00 AM | Permit Number 44422 | 5992531.14944144 | 2097322.97472388 | 37.738420181663706 | -122.46835700549299 | (37.7384201816637, -122.468357005493) | |||
| 87901 | 87901 | 94146 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1715 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53554 | 5992756.7 | 2103771.7 | 37.7561397565087 | -122.468046118338 | (37.7561397565087, -122.468046118338) | ||
| 153571 | 153571 | 204611 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1715 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992772.93939 | 2103781.0166 | 37.7561662752808 | -122.467990635168 | (37.7561662752808, -122.467990635168) | |||
| 124368 | 124368 | 35610 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 325 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1998 12:00:00 AM | Permit Number 38967 | 5992638.71984217 | 2094691.8038829 | 37.7312018573426 | -122.467793768821 | (37.7312018573426, -122.467793768821) | |||
| 180450 | 180450 | 218271 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1456 Portola Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 5992773.33281 | 2097243.56743 | 37.738216134576795 | -122.467513887457 | (37.7382161345768, -122.467513887457) |
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");