trees
603 rows where qSpecies_id = 172 sorted by qAddress
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3382 | 46731 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
5647 | 46732 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
9758 | 46722 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
10645 | 46730 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
15472 | 46729 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
1168 | 39947 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
1286 | 39945 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
6590 | 39944 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
7296 | 39946 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
11952 | 39952 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
12633 | 39951 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
14549 | 39950 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
14616 | 39953 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
17495 | 39948 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
18303 | 39949 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
157676 | 246710 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1 Bonview St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6007732.83024 | 2099171.31283 | 37.7443616257 | -122.415927685808 | (37.7443616257, -122.415927685808) | 2 | 7 | 7 | 28859 | 2 | ||||
103542 | 26915 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 10 Caine Ave | 11 | Median : Cutout | Tree | DPW 1 | 01/26/1999 12:00:00 AM | 3 | 10 | 5997570.4467 | 2089598.14436 | 37.7174994031582 | -122.450376943463 | (37.7174994031582, -122.450376943463) | 9 | 8 | 6 | 28861 | 24 | ||
179483 | 214001 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 10 Caine Ave | 14 | : | Tree | Private 2 | 5 | Width 0ft | 5997555.12173 | 2089578.95708 | 37.7174458422426 | -122.450428532174 | (37.7174458422426, -122.450428532174) | 9 | 8 | 6 | 28861 | 24 | |||
30357 | 116670 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100 Esmeralda Ave | 8 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
63486 | 116675 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100 Esmeralda Ave | 14 | Unaccepted Street : Yard | Tree | DPW 1 | 14 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | ||||
46599 | 43461 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1000 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43163 | 6000647.65925572 | 2091203.91791776 | 37.722084128815 | -122.439855525614 | (37.722084128815, -122.439855525614) | 9 | 7 | 6 | 28861 | 25 | |||
69210 | 43463 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1000 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43163 | 6000647.65925572 | 2091203.91791776 | 37.722084128815 | -122.439855525614 | (37.722084128815, -122.439855525614) | 9 | 7 | 6 | 28861 | 25 | |||
108187 | 43469 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1000 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43163 | 6000647.65925572 | 2091203.91791776 | 37.722084128815 | -122.439855525614 | (37.722084128815, -122.439855525614) | 9 | 7 | 6 | 28861 | 25 | |||
109566 | 43462 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1000 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43163 | 6000647.65925572 | 2091203.91791776 | 37.722084128815 | -122.439855525614 | (37.722084128815, -122.439855525614) | 9 | 7 | 6 | 28861 | 25 | |||
55180 | 240213 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1000 San Jose Ave | 101 | Front Yard : Yard | Tree | Private 2 | 3 | 6005074.47126 | 2096982.94014 | 37.738203036831 | -122.424964073757 | (37.738203036831, -122.424964073757) | 2 | 7 | 5 | 28859 | 7 | ||||
95771 | 240212 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1000 San Jose Ave | 82 | Front Yard : Yard | Tree | Private 2 | 7 | 6005076.07974 | 2097014.35872 | 37.738289396023 | -122.424960747163 | (37.738289396023, -122.424960747163) | 2 | 7 | 5 | 63 | 7 | ||||
14736 | 92056 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 06/16/2009 12:00:00 AM | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
161427 | 92055 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
140654 | 240211 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1001 San Jose Ave | 17 | Front Yard : Yard | Tree | Private 2 | 2 | 6005198.75303 | 2096936.51441 | 37.7380825816504 | -122.424531067257 | (37.7380825816504, -122.424531067257) | 2 | 7 | 5 | 28859 | 2 | ||||
59515 | 52864 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 100@ HARRY ST Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50507 | 6003408.66397097 | 2097802.42500626 | 37.7403589183971 | -122.430782070435 | (37.7403589183971, -122.430782070435) | 2 | 7 | 5 | 63 | 7 | ||
13698 | 179341 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100x Mansell St | 9 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6011434.85378 | 2090631.08875 | 37.7211193983363 | -122.402526372706 | (37.7211193983363, -122.402526372706) | 10 | 7 | 8 | 309 | 28 | |||
18370 | 247631 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1021 Jarboe Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6009422.11073 | 2096880.05562 | 37.7381651609976 | -122.409924771417 | (37.7381651609976, -122.409924771417) | 10 | 7 | 7 | 28859 | 2 | ||||
168943 | 247632 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1021 Jarboe Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6009462.56888 | 2096880.39519 | 37.7381683607742 | -122.409784910667 | (37.7381683607742, -122.409784910667) | 10 | 7 | 7 | 28859 | 2 | ||||
84794 | 200174 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1022 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6013889.8173 | 2089740.206 | 37.718809961526 | -122.393977881076 | (37.718809961526, -122.393977881076) | 10 | 3 | 8 | 58 | 1 | |||
103485 | 200173 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1022 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6013894.556 | 2089735.8088 | 37.7187981510491 | -122.393961193506 | (37.7187981510491, -122.393961193506) | 10 | 3 | 8 | 58 | 1 | |||
135496 | 136280 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1080 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6008340.68232 | 2118631.36541 | 37.797828516615 | -122.415203104753 | (37.797828516615, -122.415203104753) | 5 | 1 | 10 | 308 | 21 | ||||
178842 | 247918 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1098 Esmeralda Ave | 3 | Side Yard : Yard | Tree | Private 2 | 4 | 6010239.20977 | 2098728.38698 | 37.7432860401182 | -122.407229893555 | (37.7432860401182, -122.407229893555) | 10 | 7 | 7 | 28859 | 2 | ||||
77611 | 179340 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 10x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6011654.04439 | 2090707.03922 | 37.7213401773752 | -122.401774025963 | (37.7213401773752, -122.401774025963) | 10 | 7 | 8 | 309 | 28 | |||
95375 | 28089 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1100 Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3x4 | 6018138.7903974 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | 10 | 3 | 8 | 58 | 1 | ||
109546 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
110019 | 96485 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
85848 | 247534 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Waller St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6000131.92851 | 2108487.4209 | 37.7695111172828 | -122.442878784742 | (37.7695111172828, -122.442878784742) | 15 | 5 | 11 | 29492 | 9 | ||||
143972 | 247528 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Waller St | 9 | Side Yard : Yard | Tree | Private 2 | 2 | 6000060.08033 | 2108486.82414 | 37.7695053822964 | -122.443127261125 | (37.7695053822964, -122.443127261125) | 15 | 5 | 11 | 29492 | 9 | ||||
55357 | 179347 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 111 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6004743.78868 | 2092719.75542 | 37.7264785996005 | -122.42580404683 | (37.7264785996005, -122.42580404683) | 9 | 7 | 6 | 28861 | 5 | ||||
101569 | 179348 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 111 Vienna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6004744.90542 | 2092721.69826 | 37.7264839973183 | -122.425800324532 | (37.7264839973183, -122.425800324532) | 9 | 7 | 6 | 28861 | 5 | ||||
170903 | 179346 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 111 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004743.0308 | 2092717.80551 | 37.7264732027495 | -122.425806528059 | (37.7264732027495, -122.425806528059) | 9 | 7 | 6 | 28861 | 5 | ||||
85274 | 136279 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1151 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6006698.81265 | 2120089.55435 | 37.8017399263049 | -122.420988029784 | (37.8017399263049, -122.420988029784) | 5 | 1 | 1 | 28858 | 32 | ||||
4654 | 240225 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006210.25986 | 2095801.94104 | 37.7350243668737 | -122.420953246717 | (37.7350243668737, -122.420953246717) | 2 | 7 | 7 | 28859 | 2 | |||
11645 | 240229 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 10ft | 6006267.81246 | 2095797.32513 | 37.7350149365947 | -122.420753938963 | (37.7350149365947, -122.420753938963) | 2 | 7 | 7 | 28859 | 2 | |||
30406 | 240234 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006339.6227 | 2095791.19011 | 37.7350021383438 | -122.420505229653 | (37.7350021383438, -122.420505229653) | 2 | 7 | 7 | 28859 | 2 | |||
31893 | 240235 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 10ft | 6006361.75511 | 2095789.26395 | 37.7349980967903 | -122.420428573244 | (37.7349980967903, -122.420428573244) | 2 | 7 | 7 | 28859 | 2 | |||
34820 | 240239 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 6006416.61409 | 2095785.43959 | 37.7349906872665 | -122.420238634604 | (37.7349906872665, -122.420238634604) | 2 | 7 | 7 | 28859 | 2 | |||
36674 | 240226 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 6006225.25616 | 2095800.40659 | 37.735020998922 | -122.420901290175 | (37.735020998922, -122.420901290175) | 2 | 7 | 7 | 28859 | 2 | |||
43964 | 240231 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006293.37748 | 2095794.59249 | 37.7350088742503 | -122.420665357522 | (37.7350088742503, -122.420665357522) | 2 | 7 | 7 | 28859 | 2 | |||
46694 | 240227 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006241.01631 | 2095800.08306 | 37.7350209989201 | -122.420846778675 | (37.7350209989201, -122.420846778675) | 2 | 7 | 7 | 28859 | 2 | |||
50121 | 240237 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006385.38025 | 2095788.04313 | 37.7349960760111 | -122.420346805985 | (37.7349960760111, -122.420346805985) | 2 | 7 | 7 | 28859 | 2 | |||
50577 | 240228 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 6006254.27366 | 2095797.84836 | 37.735015610176 | -122.420800784622 | (37.735015610176, -122.420800784622) | 2 | 7 | 7 | 28859 | 2 | |||
55433 | 240233 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006323.63645 | 2095792.4995 | 37.7350048327147 | -122.420560592807 | (37.7350048327147, -122.420560592807) | 2 | 7 | 7 | 28859 | 2 | |||
62582 | 240221 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 10ft | 6006157.32873 | 2095808.02352 | 37.735038084223 | -122.421136680529 | (37.735038084223, -122.421136680529) | 2 | 7 | 7 | 28859 | 2 | |||
67039 | 240238 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 6006395.96407 | 2095787.5806 | 37.7349954024064 | -122.420310181081 | (37.7349954024064, -122.420310181081) | 2 | 7 | 7 | 28859 | 2 | |||
89065 | 240223 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 10ft | 6006186.16746 | 2095804.3982 | 37.7350297556078 | -122.421036717266 | (37.7350297556078, -122.421036717266) | 2 | 7 | 7 | 28859 | 2 | |||
89949 | 240232 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 6006307.89643 | 2095793.80384 | 37.7350075270705 | -122.420615104301 | (37.7350075270705, -122.420615104301) | 2 | 7 | 7 | 28859 | 2 | |||
91473 | 240224 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 6006199.93235 | 2095802.88902 | 37.7350263876647 | -122.42098901994 | (37.7350263876647, -122.42098901994) | 2 | 7 | 7 | 28859 | 2 | |||
104429 | 240219 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 6006128.27553 | 2095809.77949 | 37.7350412678419 | -122.421237252614 | (37.7350412678419, -122.421237252614) | 2 | 7 | 7 | 28859 | 2 | |||
120975 | 240241 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 25 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 10ft | 6006438.75683 | 2095784.00392 | 37.7349879928987 | -122.420161977306 | (37.7349879928987, -122.420161977306) | 2 | 7 | 7 | 28859 | 2 | |||
122995 | 240230 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006284.0301 | 2095795.275 | 37.7350102214481 | -122.420697723227 | (37.7350102214481, -122.420697723227) | 2 | 7 | 7 | 28859 | 2 | |||
125678 | 240240 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 24 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 10ft | 6006428.42427 | 2095784.70659 | 37.7349893400784 | -122.420197750546 | (37.7349893400784, -122.420197750546) | 2 | 7 | 7 | 28859 | 2 | |||
133309 | 240217 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 6006077.44236 | 2095815.28321 | 37.73505351389 | -122.421413392023 | (37.73505351389, -122.421413392023) | 2 | 7 | 7 | 28859 | 2 | |||
172657 | 240236 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 20 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006373.31907 | 2095788.53598 | 37.7349967496044 | -122.420388540807 | (37.7349967496044, -122.420388540807) | 2 | 7 | 7 | 28859 | 2 | |||
176496 | 240218 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 6006103.73166 | 2095810.88544 | 37.7350429207983 | -122.421322188175 | (37.7350429207983, -122.421322188175) | 2 | 7 | 7 | 28859 | 2 | |||
188140 | 240220 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 10ft | 6006143.46511 | 2095809.04412 | 37.735040105008 | -122.421184684532 | (37.735040105008, -122.421184684532) | 2 | 7 | 7 | 28859 | 2 | |||
191864 | 240222 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 6006171.40758 | 2095805.43718 | 37.7350317763766 | -122.421087821261 | (37.7350317763766, -122.421087821261) | 2 | 7 | 7 | 28859 | 2 | |||
64997 | 186834 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200 Sunset Blvd | 92 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984853.6973 | 2106574.7357 | 37.7633765440011 | -122.495583703829 | (37.7633765440011, -122.495583703829) | 1 | 8 | 3 | 56 | 35 | |||
74369 | 186768 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984836.614 | 2106754.4403 | 37.7638689619924 | -122.495656044374 | (37.7638689619924, -122.495656044374) | 1 | 8 | 3 | 56 | 35 | |||
86482 | 186743 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984861.5978 | 2106643.5898 | 37.7635660606667 | -122.495561457732 | (37.7635660606667, -122.495561457732) | 1 | 8 | 3 | 56 | 35 | |||
160539 | 186816 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200 Sunset Blvd | 111 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984817.9648 | 2106815.6539 | 37.7640359452212 | -122.495725060944 | (37.7640359452212, -122.495725060944) | 1 | 8 | 3 | 56 | 35 | |||
170203 | 186826 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200 Sunset Blvd | 99 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984816.4913 | 2106624.0982 | 37.7635099007919 | -122.495716026683 | (37.7635099007919, -122.495716026683) | 1 | 8 | 3 | 56 | 35 | |||
40489 | 6510 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200X Evans Ave | 2 | Median : Cutout | Tree | DPW 1 | 18 | 15 | 6017613.51756 | 2097076.90112 | 37.7391613427334 | -122.381616361724 | (37.7391613427334, -122.381616361724) | 10 | 3 | 8 | 58 | 1 | |||
64317 | 240305 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1239 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003249.69063 | 2101046.30006 | 37.7492568370432 | -122.431563264742 | (37.7492568370432, -122.431563264742) | 2 | 4 | 5 | 28862 | 22 | |||
93802 | 184351 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1251 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984664.2495 | 2106477.5617 | 37.76309863602 | -122.496231762252 | (37.76309863602, -122.496231762252) | 1 | 8 | 3 | 56 | 35 | |||
159166 | 184356 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1251 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984656.2754 | 2106611.6026 | 37.7634662075597 | -122.496269232033 | (37.7634662075597, -122.496269232033) | 1 | 8 | 3 | 56 | 35 | |||
29268 | 181535 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984891.4503 | 2105792.8068 | 37.7612317968807 | -122.495395459242 | (37.7612317968807, -122.495395459242) | 1 | 8 | 3 | 56 | 35 | |||
80427 | 181533 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984877.5263 | 2105773.8702 | 37.7611789869773 | -122.495442219064 | (37.7611789869773, -122.495442219064) | 1 | 8 | 3 | 56 | 35 | |||
121111 | 186722 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984874.928 | 2106184.6404 | 37.7623066948709 | -122.495481502109 | (37.7623066948709, -122.495481502109) | 1 | 8 | 3 | 56 | 35 | |||
137603 | 181532 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984901.4756 | 2105774.4271 | 37.7611819183613 | -122.495359430973 | (37.7611819183613, -122.495359430973) | 1 | 8 | 3 | 56 | 35 | |||
147827 | 186721 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984840.7181 | 2106188.7756 | 37.7623160457552 | -122.495600124584 | (37.7623160457552, -122.495600124584) | 1 | 8 | 3 | 56 | 35 | |||
152028 | 186718 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984858.7629 | 2106161.3325 | 37.7622417513471 | -122.495535691127 | (37.7622417513471, -122.495535691127) | 1 | 8 | 3 | 56 | 35 | |||
86307 | 197178 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 24 | Median : Yard | Tree | DPW 1 | 1 | 6012271.91368 | 2102115.47955 | 37.7526998195515 | -122.400439152361 | (37.7526998195515, -122.400439152361) | 10 | 3 | 8 | 28856 | 29 | ||||
87367 | 197179 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 13 | Median : Yard | Tree | DPW 1 | 2 | 6012255.14184 | 2102164.55152 | 37.7528336251844 | -122.400500599441 | (37.7528336251844, -122.400500599441) | 10 | 3 | 8 | 28856 | 29 | ||||
152360 | 197180 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 11 | Median : Yard | Tree | DPW 1 | 1 | 6012255.35088 | 2102175.8421 | 37.752864638318 | -122.400500669565 | (37.752864638318, -122.400500669565) | 10 | 3 | 8 | 28856 | 29 | ||||
193001 | 117207 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 1 | Median : Cutout | Tree | Private 2 | 13 | 6012255.77341 | 2102253.00873 | 37.753076544652 | -122.40050462841 | (37.753076544652, -122.40050462841) | 10 | 3 | 8 | 28856 | 29 | ||||
71600 | 197181 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1301 Rhode Island St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 7ft | 6011998.69489 | 2102279.56036 | 37.7531351094233 | -122.401395527392 | (37.7531351094233, -122.401395527392) | 10 | 3 | 8 | 28856 | 29 | |||
33720 | 184764 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1301 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984675.2613 | 2106104.8671 | 37.7620759662771 | -122.496166178125 | (37.7620759662771, -122.496166178125) | 1 | 8 | 3 | 56 | 35 | |||
76127 | 184769 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1301 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984710.0056 | 2106073.3504 | 37.7619914653387 | -122.496043687563 | (37.7619914653387, -122.496043687563) | 1 | 8 | 3 | 56 | 35 | |||
79415 | 184748 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1301 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984700.7025 | 2106122.714 | 37.762126459046 | -122.496079504872 | (37.762126459046, -122.496079504872) | 1 | 8 | 3 | 56 | 35 | |||
105617 | 240306 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 134 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003388.16897 | 2105086.9505 | 37.7603593535203 | -122.431372807229 | (37.7603593535203, -122.431372807229) | 2 | 4 | 5 | 28862 | 3 | |||
88123 | 101366 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 1348 Noe St | Unaccepted Street : Yard | Tree | Private 2 | 24 | Owner: Brent Sommer 519-1119 nocmout@gmail.com | 6003163.2 | 2100416 | 37.7475212781449 | -122.43181735246 | (37.7475212781449, -122.43181735246) | 2 | 4 | 5 | 63 | 22 | ||||
163826 | 240278 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1369 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006475.64332 | 2101625.709 | 37.7510300797762 | -122.420448963552 | (37.7510300797762, -122.420448963552) | 2 | 4 | 7 | 28859 | 19 | |||
191810 | 240279 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1369 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006475.19087 | 2101646.9491 | 37.7510883747358 | -122.420452035657 | (37.7510883747358, -122.420452035657) | 2 | 4 | 7 | 28859 | 19 | |||
187040 | 68765 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 138 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50779 | 6003386.47101078 | 2105092.952527 | 37.7603757374175 | -122.431379108138 | (37.7603757374175, -122.431379108138) | 2 | 4 | 5 | 28862 | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );