trees
11,761 rows where qSpecies_id = 17 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80873 | 99972 | Undocumented 4 | Tree(s) :: 17 | 143 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3x3 | Permit Number 776811 | 5988622.1 | 2114374.2 | 37.7850116539768 | -122.483121892919 | (37.7850116539768, -122.483121892919) | 11 | 6 | 2 | 55 | 26 | ||
33189 | 99969 | Undocumented 4 | Tree(s) :: 17 | 2270 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2013 12:00:00 AM | Permit Number 767924 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||
36492 | 99946 | DPW Maintained 1 | Tree(s) :: 17 | 499X FOLSOM ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769035 | 6014477 | 2114572 | 37.787025389439 | -122.393685294607 | (37.787025389439, -122.393685294607) | 6 | 2 | 9 | 28855 | 6 | |
44771 | 99937 | Undocumented 4 | Tree(s) :: 17 | 315 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2012 12:00:00 AM | 3c3 | Permit Number 768708 | 6006226 | 2098169 | 37.7415246698481 | -122.421066843418 | (37.7415246698481, -122.421066843418) | 2 | 7 | 7 | 28859 | 2 | ||
132137 | 99933 | Undocumented 4 | Tree(s) :: 17 | 63 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2012 12:00:00 AM | 3x3 | Permit Number 768712 | 6008250 | 2099654 | 37.7457160396744 | -122.41417355851 | (37.7457160396744, -122.41417355851) | 2 | 7 | 7 | 28859 | 2 | ||
179415 | 99885 | DPW Maintained 1 | Tree(s) :: 17 | 1500@ Lane St Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | Permit Number 768901 | 6015749.6 | 2095358.3 | 37.7343393212403 | -122.387941112569 | (37.7343393212403, -122.387941112569) | 10 | 3 | 8 | 58 | 1 | |||
180655 | 99884 | DPW Maintained 1 | Tree(s) :: 17 | 1500@ Lane St Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | Permit Number 768901 | 6015749.6 | 2095358.3 | 37.7343393212403 | -122.387941112569 | (37.7343393212403, -122.387941112569) | 10 | 3 | 8 | 58 | 1 | |||
29206 | 99883 | DPW Maintained 1 | Tree(s) :: 17 | 1500@ Lane St Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | Permit Number 768901 | 6015749.6 | 2095358.3 | 37.7343393212403 | -122.387941112569 | (37.7343393212403, -122.387941112569) | 10 | 3 | 8 | 58 | 1 | |||
127658 | 99882 | DPW Maintained 1 | Tree(s) :: 17 | 1500@ Lane St Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | Permit Number 768901 | 6015749.6 | 2095358.3 | 37.7343393212403 | -122.387941112569 | (37.7343393212403, -122.387941112569) | 10 | 3 | 8 | 58 | 1 | |||
138846 | 99881 | DPW Maintained 1 | Tree(s) :: 17 | 1500@ Lane St Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 0 | Permit Number 768901 | 6015749.6 | 2095358.3 | 37.7343393212403 | -122.387941112569 | (37.7343393212403, -122.387941112569) | 10 | 3 | 8 | 58 | 1 | ||
152441 | 99822 | Permitted Site 7 | Tree(s) :: 17 | 1499X 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2012 12:00:00 AM | Permit Number 769141 | 5994283 | 2105334 | 37.7605174549789 | -122.462881035671 | (37.7605174549789, -122.462881035671) | 1 | 5 | 11 | 56 | 12 | |||
31732 | 99815 | Undocumented 4 | Tree(s) :: 17 | 730 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769053 | 6001682 | 2102065 | 37.7519649632224 | -122.437057281239 | (37.7519649632224, -122.437057281239) | 2 | 4 | 5 | 28862 | 22 | ||
29790 | 99768 | Undocumented 4 | Tree(s) :: 17 | 545 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2012 12:00:00 AM | 22 | 3x3 | Permit Number 769091 | 6001628 | 2101442 | 37.750251284489 | -122.437199418076 | (37.750251284489, -122.437199418076) | 2 | 4 | 5 | 28862 | 22 | |
3101 | 99753 | Undocumented 4 | Tree(s) :: 17 | 526 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | Permit Number 776170 | 6001772 | 2100900 | 37.748771266015 | -122.436662665796 | (37.748771266015, -122.436662665796) | 2 | 4 | 5 | 28862 | 22 | ||
116479 | 99752 | Undocumented 4 | Tree(s) :: 17 | 526 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2015 12:00:00 AM | 3x3 | Permit Number 776170 | 6001772 | 2100900 | 37.748771266015 | -122.436662665796 | (37.748771266015, -122.436662665796) | 2 | 4 | 5 | 28862 | 22 | ||
22722 | 99750 | Undocumented 4 | Tree(s) :: 17 | 4210 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002521.3 | 2100652.6 | 37.7481345176555 | -122.434053910222 | (37.7481345176555, -122.434053910222) | 2 | 4 | 5 | 28862 | 22 | |||||
307 | 99748 | Undocumented 4 | Tree(s) :: 17 | 4224 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002441 | 2100645 | 37.7481090922721 | -122.434331041256 | (37.7481090922721, -122.434331041256) | 2 | 4 | 5 | 28862 | 22 | ||||
127413 | 99743 | Undocumented 4 | Tree(s) :: 17 | 447 Clipper St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002285 | 2100894 | 37.7487839315189 | -122.43488828753 | (37.7487839315189, -122.43488828753) | 2 | 4 | 5 | 28862 | 22 | ||||||
171377 | 99688 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
99360 | 99687 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
157508 | 99686 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
193525 | 99685 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
23622 | 99684 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 8 | 3x3 | Permit Number 770537 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 |
67135 | 99683 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 8 | 3x3 | Permit Number 770537 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 |
56802 | 99677 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 16 | 3x3 | Permit Number 770537 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 |
24577 | 99676 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
117961 | 99675 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
37865 | 99674 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 4x4 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
176228 | 99673 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 4x4 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
114759 | 99670 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
175889 | 99669 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x6 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
167 | 99668 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
55011 | 99667 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
81109 | 99665 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
66778 | 99664 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997932 | 2106516 | 37.7639724300488 | -122.450346083136 | (37.7639724300488, -122.450346083136) | 15 | 5 | 11 | 29492 | 9 | ||
43892 | 99623 | Significant Tree 6 | Tree(s) :: 17 | 380 Connecticut St | 1 | Front Yard : Yard | Tree | Private 2 | 05/23/2012 12:00:00 AM | Permit Number 768850 | 6013171.4 | 2105301.7 | 37.7614986071193 | -122.397551993257 | (37.7614986071193, -122.397551993257) | 10 | 3 | 8 | 28856 | 29 | |||
186942 | 99610 | DPW Maintained 1 | Tree(s) :: 17 | 111 Corwin St | Unaccepted Street : Yard | Landscaping | Private 2 | 6000616 | 2104331 | 37.7581261988062 | -122.44090619354 | (37.7581261988062, -122.44090619354) | 2 | 4 | 5 | 28862 | 38 | ||||||
88182 | 99608 | Permitted Site 7 | Tree(s) :: 17 | 1 Entrada Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768939 | 5992743 | 2092489 | 37.7251595224946 | -122.467273147781 | (37.7251595224946, -122.467273147781) | 9 | 8 | 4 | 59 | 40 | |||
31122 | 99589 | Permitted Site 7 | Tree(s) :: 17 | 2299 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002978.6 | 2106459.9 | 37.7641059209125 | -122.432887400675 | (37.7641059209125, -122.432887400675) | 15 | 4 | 5 | 28862 | 3 | |||||
85161 | 99588 | Permitted Site 7 | Tree(s) :: 17 | 2299 Market St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002978.6 | 2106459.9 | 37.7641059209125 | -122.432887400675 | (37.7641059209125, -122.432887400675) | 15 | 4 | 5 | 28862 | 3 | |||||
108527 | 99587 | Permitted Site 7 | Tree(s) :: 17 | 2299 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002978.6 | 2106459.9 | 37.7641059209125 | -122.432887400675 | (37.7641059209125, -122.432887400675) | 15 | 4 | 5 | 28862 | 3 | |||||
135 | 99586 | Permitted Site 7 | Tree(s) :: 17 | 2299 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002978.6 | 2106459.9 | 37.7641059209125 | -122.432887400675 | (37.7641059209125, -122.432887400675) | 15 | 4 | 5 | 28862 | 3 | |||||
93883 | 99582 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
111010 | 99581 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
99288 | 99579 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
185260 | 99578 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
2991 | 99574 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
108209 | 99567 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
2857 | 99536 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5x9 | 6014774.7 | 2116168.9 | 37.7914266467329 | -122.392767069159 | (37.7914266467329, -122.392767069159) | 12 | 2 | 9 | 28855 | 6 | ||||
170913 | 99535 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5x9 | 6014774.7 | 2116168.9 | 37.7914266467329 | -122.392767069159 | (37.7914266467329, -122.392767069159) | 12 | 2 | 9 | 28855 | 6 | ||||
160040 | 99534 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5x9 | 6014774.7 | 2116168.9 | 37.7914266467329 | -122.392767069159 | (37.7914266467329, -122.392767069159) | 12 | 2 | 9 | 28855 | 6 | ||||
138736 | 99533 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5x9 | 6014774.7 | 2116168.9 | 37.7914266467329 | -122.392767069159 | (37.7914266467329, -122.392767069159) | 12 | 2 | 9 | 28855 | 6 | ||||
144676 | 99532 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 6 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
86616 | 99531 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 5 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
73650 | 99530 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
18729 | 99529 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
179378 | 99528 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
120956 | 99527 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
34349 | 99438 | Permitted Site 7 | Tree(s) :: 17 | 1151 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2012 12:00:00 AM | 3x3 | Permit Number 768919 | 6001368.9 | 2087746.9 | 37.7126329596264 | -122.43711498955 | (37.7126329596264, -122.43711498955) | 9 | 7 | 6 | 28861 | 5 | ||
99410 | 99297 | Permitted Site 7 | Tree(s) :: 17 | 947 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992761.5 | 2107248.3 | 37.7656858649034 | -122.468282426864 | (37.7656858649034, -122.468282426864) | 11 | 8 | 11 | 56 | 12 | |||||
151984 | 99296 | Permitted Site 7 | Tree(s) :: 17 | 947 Lincoln Way | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5992761.5 | 2107248.3 | 37.7656858649034 | -122.468282426864 | (37.7656858649034, -122.468282426864) | 11 | 8 | 11 | 56 | 12 | |||||
82368 | 99295 | Permitted Site 7 | Tree(s) :: 17 | 947 Lincoln Way | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5992761.5 | 2107248.3 | 37.7656858649034 | -122.468282426864 | (37.7656858649034, -122.468282426864) | 11 | 8 | 11 | 56 | 12 | |||||
65832 | 99279 | Permitted Site 7 | Tree(s) :: 17 | 230 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001309.9 | 2109637.7 | 37.7727365843062 | -122.43888668006 | (37.7727365843062, -122.43888668006) | 15 | 5 | 11 | 29492 | 9 | |||||
89589 | 99277 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 3 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
20715 | 99276 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 2 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
103261 | 99275 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 1 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
37259 | 99270 | Permitted Site 7 | Tree(s) :: 17 | 671 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2013 12:00:00 AM | Permit Number 770239 | 5994371.6 | 2110963.3 | 37.7759791371047 | -122.462983041349 | (37.7759791371047, -122.462983041349) | 11 | 6 | 2 | 54 | 11 | |||
33827 | 99268 | Property Tree 8 | Tree(s) :: 17 | 292 Whitney St | Front Yard : Cutout | Tree | Private 2 | 6004280 | 2096681 | 37.7373290690714 | -122.427689454915 | (37.7373290690714, -122.427689454915) | 2 | 7 | 5 | 63 | 7 | ||||||
130413 | 99225 | Permitted Site 7 | Tree(s) :: 17 | 201@ Mariposa Missouri St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2012 12:00:00 AM | 3x3 | Permit Number 768857 | 6013503.3 | 2106114.2 | 37.7637480286929 | -122.396461033594 | (37.7637480286929, -122.396461033594) | 14 | 3 | 8 | 28856 | 29 | ||
5659 | 99223 | Permitted Site 7 | Tree(s) :: 17 | 201@ Mariposa Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2012 12:00:00 AM | Permit Number 768857 | 6013503.3 | 2106114.2 | 37.7637480286929 | -122.396461033594 | (37.7637480286929, -122.396461033594) | 14 | 3 | 8 | 28856 | 29 | |||
27176 | 99217 | Permitted Site 7 | Tree(s) :: 17 | 4015 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6x12 | 6003750.3 | 2100656.7 | 37.7482154478391 | -122.429804363677 | (37.7482154478391, -122.429804363677) | 2 | 4 | 5 | 63 | 22 | |||
37701 | 99207 | Permitted Site 7 | Tree(s) :: 17 | 779 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2012 12:00:00 AM | Permit Number 768713 | 5987219.2 | 2110642.3 | 37.7746831781174 | -122.487701152769 | (37.7746831781174, -122.487701152769) | 11 | 6 | 2 | 55 | 26 | |||
11972 | 99201 | DPW Maintained 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | FUF | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | 2 | 4 | 5 | 28862 | 22 | ||
23342 | 99014 | Permitted Site 7 | Tree(s) :: 17 | 125x Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006331.3 | 2098231.1 | 37.7417011178952 | -122.420707158841 | (37.7417011178952, -122.420707158841) | 2 | 7 | 7 | 28859 | 2 | |||||
126251 | 98944 | Undocumented 4 | Tree(s) :: 17 | 877 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6007988 | 2102823 | 37.7544026804938 | -122.415303814875 | (37.7544026804938, -122.415303814875) | 2 | 4 | 7 | 28859 | 19 | |||
85302 | 98927 | Permitted Site 7 | Tree(s) :: 17 | 112 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2012 12:00:00 AM | 3x3 | Permit Number 768611 | 6005385 | 2103055 | 37.7548930594212 | -122.424322167644 | (37.7548930594212, -122.424322167644) | 2 | 4 | 5 | 28859 | 19 | ||
55978 | 98912 | Permitted Site 7 | Tree(s) :: 17 | 2088@Clay Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2012 12:00:00 AM | 3x3 | Permit Number 768723 | 6000424 | 2115788 | 37.7895732892814 | -122.442392720884 | (37.7895732892814, -122.442392720884) | 13 | 6 | 1 | 29490 | 27 | ||
90504 | 98893 | Property Tree 8 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998910 | 2100761 | 37.7482265448319 | -122.446549410607 | (37.7482265448319, -122.446549410607) | 2 | 5 | 5 | 63 | 38 | ||||||
105747 | 98892 | Property Tree 8 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998935 | 2100753 | 37.7482060067302 | -122.44646238624 | (37.7482060067302, -122.44646238624) | 2 | 5 | 5 | 63 | 38 | ||||||
113384 | 98890 | Property Tree 8 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5999134 | 2100748 | 37.7482036421854 | -122.44577389345 | (37.7482036421854, -122.44577389345) | 2 | 5 | 5 | 63 | 38 | ||||||
192149 | 98878 | Property Tree 8 | Tree(s) :: 17 | 11 Panorama Dr | Back Yard : Yard | Landscaping | Private 2 | 5998029 | 2100213 | 37.7466715093679 | -122.449556386849 | (37.7466715093679, -122.449556386849) | 2 | 5 | 4 | 63 | 38 | ||||||
31719 | 98841 | Permitted Site 7 | Tree(s) :: 17 | 679 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2014 12:00:00 AM | 7x8 | Permit Number 772885 | 5992203.9 | 2110873.6 | 37.7756077444917 | -122.470475079569 | (37.7756077444917, -122.470475079569) | 11 | 6 | 2 | 54 | 11 | ||
91714 | 98821 | Undocumented 4 | Tree(s) :: 17 | 373 Castenada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 778219 | 5993476.3 | 2100002.1 | 37.7458309308973 | -122.465283713064 | (37.7458309308973, -122.465283713064) | 1 | 8 | 4 | 29491 | 40 | ||
194229 | 98736 | Undocumented 4 | Tree(s) :: 17 | 89 Paradise Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 6000827.4 | 2096045.9 | 37.7353893278652 | -122.439581147409 | (37.7353893278652, -122.439581147409) | 2 | 7 | 5 | 63 | 7 | ||||||
170462 | 98697 | Permitted Site 7 | Tree(s) :: 17 | 140 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2014 12:00:00 AM | 6 | 3x3 | Permit Number 773280 | 5999032.7 | 2116062.2 | 37.790246771973 | -122.447226195798 | (37.790246771973, -122.447226195798) | 13 | 6 | 1 | 29490 | 31 | |
87067 | 98675 | Permitted Site 7 | Tree(s) :: 17 | 199X Park St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
133386 | 98658 | DPW Maintained 1 | Tree(s) :: 17 | 2110 Greenwich St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 06/20/2014 12:00:00 AM | 6x6 | Permit Number 772915 | 6002683.8 | 2119245.6 | 37.7991955081761 | -122.434821422435 | (37.7991955081761, -122.434821422435) | 13 | 9 | 1 | 57 | 17 | |
84890 | 98654 | Permitted Site 7 | Tree(s) :: 17 | 801 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2012 12:00:00 AM | 3x3 | Permit Number 768836 | 6008750 | 2115238 | 37.7885341615981 | -122.413546621934 | (37.7885341615981, -122.413546621934) | 5 | 1 | 10 | 28858 | 21 | ||
120612 | 98653 | Permitted Site 7 | Tree(s) :: 17 | 801 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2012 12:00:00 AM | 3x3 | Permit Number 768836 | 6008750 | 2115238 | 37.7885341615981 | -122.413546621934 | (37.7885341615981, -122.413546621934) | 5 | 1 | 10 | 28858 | 21 | ||
100910 | 98587 | Permitted Site 7 | Tree(s) :: 17 | 200 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/29/2012 12:00:00 AM | Permit Number 768509 | 6011190 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | 3 | 1 | 10 | 28860 | 23 | |||
149153 | 98536 | Permitted Site 7 | Tree(s) :: 17 | 637A Capp St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/23/2012 12:00:00 AM | 3x3 | Permit Number 768694 | 6007346.4 | 2103619.4 | 37.756553332027 | -122.41757907963 | (37.756553332027, -122.41757907963) | 2 | 4 | 7 | 28859 | 19 | ||
98565 | 98512 | Undocumented 4 | Tree(s) :: 17 | 100 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2015 12:00:00 AM | 24 | 3x3 | Permit Number 775766 | 5995016.6 | 2091971.4 | 37.7238693046984 | -122.459376132933 | (37.7238693046984, -122.459376132933) | 9 | 8 | 4 | 28861 | 24 | |
187968 | 98511 | Undocumented 4 | Tree(s) :: 17 | 1209 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2015 12:00:00 AM | 3x3 | Permit Number 775766 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328 | (37.7238271478872, -122.45935081328) | 9 | 8 | 4 | 28861 | 24 | ||
53906 | 98510 | Undocumented 4 | Tree(s) :: 17 | 1209 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2015 12:00:00 AM | 3x3 | Permit Number 775766 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328 | (37.7238271478872, -122.45935081328) | 9 | 8 | 4 | 28861 | 24 | ||
95952 | 98507 | Undocumented 4 | Tree(s) :: 17 | 135 Sussex St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/2012 12:00:00 AM | 3x3 | Permit Number 768601 | 6002042 | 2096528 | 37.7367821173785 | -122.435416304249 | (37.7367821173785, -122.435416304249) | 2 | 7 | 5 | 63 | 7 | |
92726 | 98506 | Undocumented 4 | Tree(s) :: 17 | 135 Sussex St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/2012 12:00:00 AM | 3x3 | Permit Number 768601 | 6002042 | 2096528 | 37.7367821173785 | -122.435416304249 | (37.7367821173785, -122.435416304249) | 2 | 7 | 5 | 63 | 7 | |
27329 | 98505 | Undocumented 4 | Tree(s) :: 17 | 135 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/2012 12:00:00 AM | 3x3 | Permit Number 768601 | 6002042 | 2096528 | 37.7367821173785 | -122.435416304249 | (37.7367821173785, -122.435416304249) | 2 | 7 | 5 | 63 | 7 | |
54211 | 98502 | Property Tree 8 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5999066 | 2100737 | 37.7481695560511 | -122.446008243376 | (37.7481695560511, -122.446008243376) | 2 | 5 | 5 | 63 | 38 | ||||||
137488 | 98501 | Property Tree 8 | Tree(s) :: 17 | 232 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998998 | 2100740 | 37.7481739100487 | -122.446243600021 | (37.7481739100487, -122.446243600021) | 2 | 5 | 5 | 63 | 38 | ||||||
45129 | 98465 | Property Tree 8 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard | Landscaping | Private 2 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | 2 | 5 | 5 | 63 | 38 |
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) );