trees
39,840 rows where qLegalStatus_id = 7 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
94 | 260654 | Permitted Site 7 | :: 45 | 2590 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3.5x3 | ||||||||||||
532 | 261313 | Permitted Site 7 | :: 45 | 2700 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x40 | 6000687.88763 | 2117206.96839 | 37.7934844433083 | -122.441581569821 | (37.7934844433083, -122.441581569821) | 13 | 9 | 1 | 57 | 27 | ||
2087 | 261314 | Permitted Site 7 | :: 45 | 2601 Divisadero St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x106 | ||||||||||||
2338 | 260969 | Permitted Site 7 | :: 45 | 897 37th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 11/05/2019 12:00:00 AM | 3 | 10X27 | 5984476.51719 | 2109749.52706 | 37.7720715265353 | -122.497122586729 | (37.7720715265353, -122.497122586729) | 11 | 6 | 2 | 55 | 26 | ||
2737 | 258983 | Permitted Site 7 | :: 45 | 1355 27th Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 07/03/2019 12:00:00 AM | 3 | 5.5x17 | Permit Number 782298 | 5987701.73439 | 2106071.48854 | 37.7621611287816 | -122.48569645736 | (37.7621611287816, -122.48569645736) | 1 | 8 | 3 | 56 | 35 | |
6593 | 261297 | Permitted Site 7 | :: 45 | 3180 18th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/01/2013 12:00:00 AM | 3 | 6008239.4944 | 2105648.95562 | 37.762176240156 | -122.414634049312 | (37.762176240156, -122.414634049312) | 8 | 4 | 7 | 28859 | 19 | ||||
7664 | 261543 | Permitted Site 7 | :: 45 | 1305 Lombard St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 20x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
8663 | 258698 | Permitted Site 7 | :: 45 | 32 Clifford Ter | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/11/2019 12:00:00 AM | 3 | 5999959.18713 | 2106432.26938 | 37.76385833527 | -122.443328653185 | (37.76385833527, -122.443328653185) | 15 | 5 | 5 | 29492 | 3 | |||
8883 | 261542 | Permitted Site 7 | :: 45 | 1305 Lombard St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 10x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
8983 | 258699 | Permitted Site 7 | :: 45 | 32 Clifford Ter | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/11/2019 12:00:00 AM | 3 | 5999959.18713 | 2106432.26938 | 37.76385833527 | -122.443328653185 | (37.76385833527, -122.443328653185) | 15 | 5 | 5 | 29492 | 3 | |||
11448 | 96234 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/15/2011 12:00:00 AM | Permit Number 767856 | |||||||||||||||
12231 | 96231 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
12982 | 258981 | Permitted Site 7 | :: 45 | 480 Warren Dr | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/03/2019 12:00:00 AM | 3 | 11x8 | Permit Number 782233 | 5994337.77577 | 2104623.93258 | 37.7585709481755 | -122.462640083314 | (37.7585709481755, -122.462640083314) | 1 | 5 | 4 | 63 | 12 | |
14351 | 109754 | Permitted Site 7 | :: 45 | 601 Steiner St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1x12 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | ||||
15191 | 96232 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
18926 | 258980 | Permitted Site 7 | :: 45 | 480 Warren Dr | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/03/2019 12:00:00 AM | 3 | 16x8 | Permit Number 782233 | 5994337.77577 | 2104623.93258 | 37.7585709481755 | -122.462640083314 | (37.7585709481755, -122.462640083314) | 1 | 5 | 4 | 63 | 12 | |
52669 | 254715 | Permitted Site 7 | :: 45 | 636 Vermont St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 5x5.5 | 6011227.55095 | 2105388.49702 | 37.7616285037909 | -122.404281111091 | (37.7616285037909, -122.404281111091) | 10 | 3 | 8 | 28856 | 29 | ||
53078 | 255962 | Permitted Site 7 | :: 45 | 2518 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/08/2018 12:00:00 AM | 3 | 5x7 | 6003674.59495 | 2116996.308 | 37.7930757331753 | -122.431232293197 | (37.7930757331753, -122.431232293197) | 13 | 9 | 1 | 29490 | 27 | ||
57021 | 255180 | Permitted Site 7 | :: 45 | 619 06th Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 04/18/2018 12:00:00 AM | 3 | 5994069.31075 | 2111288.088 | 37.7768535012339 | -122.464052313375 | (37.7768535012339, -122.464052313375) | 11 | 6 | 2 | 54 | 11 | |||
59691 | 255179 | Permitted Site 7 | :: 45 | 619 06th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/18/2018 12:00:00 AM | 3 | 5994069.31075 | 2111288.088 | 37.7768535012339 | -122.464052313375 | (37.7768535012339, -122.464052313375) | 11 | 6 | 2 | 54 | 11 | |||
67891 | 255961 | Permitted Site 7 | :: 45 | 2518 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/08/2018 12:00:00 AM | 3 | 5x7 | 6003674.59495 | 2116996.308 | 37.7930757331753 | -122.431232293197 | (37.7930757331753, -122.431232293197) | 13 | 9 | 1 | 29490 | 27 | ||
86162 | 254706 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
93333 | 254714 | Permitted Site 7 | :: 45 | 636 Vermont St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 10x5.5 | 6011227.55095 | 2105388.49702 | 37.7616285037909 | -122.404281111091 | (37.7616285037909, -122.404281111091) | 10 | 3 | 8 | 28856 | 29 | ||
98772 | 66797 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2655 Polk St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 11/26/2018 12:00:00 AM | 3 | Permit Number 782624 | 6006123.61383 | 2119959.43623 | 37.8013502149967 | -122.422969232649 | (37.8013502149967, -122.422969232649) | 13 | 9 | 1 | 28858 | 32 | |
109923 | 254704 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
115102 | 254629 | Permitted Site 7 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 321 Page St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | 6x18 | Permit Number 782768 | 6005023.51354 | 2109862.79569 | 37.7735652261688 | -122.426056898155 | (37.7735652261688, -122.426056898155) | 7 | 9 | 11 | 28852 | 10 |
140484 | 92775 | Permitted Site 7 | Tree(s) :: 17 | 2701 Pacific Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | 13 | 6 | 1 | 29490 | 27 | ||||
154536 | 254705 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
157116 | 256250 | Permitted Site 7 | :: 45 | 2532 Sutter St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x18 | 6000473.43497 | 2114128.52893 | 37.7850196296057 | -122.442102513681 | (37.7850196296057, -122.442102513681) | 15 | 6 | 1 | 29490 | 27 | ||||
169546 | 254703 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
30 | 254372 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 62 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778036 | 6010859.22958 | 2088882.34048 | 37.7162855403434 | -122.404393121162 | (37.7162855403434, -122.404393121162) | 9 | 7 | 8 | 309 | 39 |
36 | 166891 | Permitted Site 7 | Banksia integrifolia :: Coast Banksia 21 | 174 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 787855 | 6003954.63071 | 2101612.59597 | 37.7508516839573 | -122.429165942869 | (37.7508516839573, -122.429165942869) | 2 | 4 | 5 | 28862 | 22 | |
70 | 264978 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1439 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2020 12:00:00 AM | 3 | 3x3 | Permit Number 787884 | 5989892.86343 | 2105570.52868 | 37.7609130564186 | -122.47808163393 | (37.7609130564186, -122.47808163393) | 1 | 8 | 3 | 56 | 35 | |
74 | 106076 | Permitted Site 7 | Tree(s) :: 17 | 2500 Arelious Walker Dr | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 772788 | 6016510.6 | 2089868.7 | 37.7193080887588 | -122.384927739753 | (37.7193080887588, -122.384927739753) | 10 | 3 | 8 | 58 | 1 | ||||
75 | 74661 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 165-167 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52456 | 6007907.04639866 | 2109821.22082045 | 37.7736136206967 | -122.416079354056 | (37.7736136206967, -122.416079354056) | 8 | 2 | 9 | 28853 | 34 | ||
81 | 46536 | Permitted Site 7 | Tree(s) :: 17 | 73 Summer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2002 12:00:00 AM | Permit Number 44686 | |||||||||||||
108 | 44866 | Permitted Site 7 | Tree(s) :: 17 | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
109 | 34921 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
110 | 45916 | Permitted Site 7 | Tree(s) :: 17 | 51 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
111 | 97355 | Permitted Site 7 | Tree(s) :: 17 | 5 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
112 | 33929 | Permitted Site 7 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1997 12:00:00 AM | Permit Number 37893 | ||||||||||||||
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 | |||||
158 | 100607 | Permitted Site 7 | Tree(s) :: 17 | 270x 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | |||||
165 | 104843 | Permitted Site 7 | :: 45 | 1320 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5989622 | 2106334.7 | 37.7629955389606 | -122.479074319647 | (37.7629955389606, -122.479074319647) | 1 | 8 | 3 | 56 | 35 | ||||||
171 | 50655 | Permitted Site 7 | Tree(s) :: 17 | 430 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47238 | 6008643.36799877 | 2088325.11427356 | 37.7146314352433 | -122.412012884014 | (37.7146314352433, -122.412012884014) | 9 | 7 | 8 | 309 | 18 | ||||
193 | 100595 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
195 | 101535 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46305 | 6014036.2 | 2116698.9 | 37.7928408582284 | -122.395359428861 | (37.7928408582284, -122.395359428861) | 12 | 2 | 9 | 28855 | 6 | ||||
203 | 56596 | Permitted Site 7 | Tree(s) :: 17 | 536 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003173.97949504 | 2096124.55404861 | 37.7357385703685 | -122.431473765394 | (37.7357385703685, -122.431473765394) | 2 | 7 | 5 | 63 | 7 | |||||
205 | 61223 | Permitted Site 7 | Tree(s) :: 17 | 420 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1983 12:00:00 AM | Permit Number 21092 | 6011911.40369591 | 2116824.99897206 | 37.793068691891 | -122.402720238707 | (37.793068691891, -122.402720238707) | 4 | 1 | 10 | 28854 | 6 | |||
220 | 64608 | Permitted Site 7 | Tree(s) :: 17 | 2449 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1988 12:00:00 AM | Permit Number 25511 | 6008240.06203716 | 2104170.72475134 | 37.75811738928 | -122.414527478763 | (37.75811738928, -122.414527478763) | 2 | 4 | 7 | 28859 | 19 | |||
222 | 59632 | Permitted Site 7 | Tree(s) :: 17 | 1726 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/1982 12:00:00 AM | Permit Number 19874 | 5999538.23629958 | 2110533.95574653 | 37.7750965176114 | -122.445079484139 | (37.7750965176114, -122.445079484139) | 15 | 5 | 11 | 29492 | 16 | |||
223 | 65500 | Permitted Site 7 | Tree(s) :: 17 | 5322 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/1989 12:00:00 AM | Permit Number 28384 | 5990524.68926015 | 2112731.41132738 | 37.7806115451711 | -122.47641956102 | (37.7806115451711, -122.47641956102) | 11 | 6 | 2 | 55 | 26 | |||
226 | 56655 | Permitted Site 7 | Tree(s) :: 17 | 491 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993749.22353597 | 2090472.28724098 | 37.7196801529508 | -122.463648462413 | (37.7196801529508, -122.463648462413) | 9 | 8 | 6 | 64 | 24 | |||||
236 | 27345 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 664 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2008 12:00:00 AM | 4 | 4x4 | 6004282.41706 | 2110648.93551 | 37.7756818605142 | -122.428676512776 | (37.7756818605142, -122.428676512776) | 7 | 9 | 11 | 28852 | 10 | ||
241 | 57687 | Permitted Site 7 | Tree(s) :: 17 | 4124 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/1976 12:00:00 AM | Permit Number 16590 | 6001721.25492757 | 2103540.26074256 | 37.7560179062476 | -122.437027141607 | (37.7560179062476, -122.437027141607) | 2 | 4 | 5 | 28862 | 3 | |||
257 | 115298 | Permitted Site 7 | :: 45 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | 1 | 8 | 4 | 29491 | 40 | |||||
260 | 56449 | Permitted Site 7 | Tree(s) :: 17 | 1439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5982754.68200032 | 2105326.56088651 | 37.7598262733968 | -122.502750996927 | (37.7598262733968, -122.502750996927) | 1 | 8 | 3 | 56 | 35 | |||||
294 | 53493 | Permitted Site 7 | Tree(s) :: 17 | 262 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | Permit Number 6403 | 5992228.28376051 | 2089608.56362168 | 37.717220822263 | -122.468842940668 | (37.717220822263, -122.468842940668) | 9 | 8 | 6 | 64 | 24 | |||
305 | 56460 | Permitted Site 7 | Tree(s) :: 17 | 2430 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006920.19744074 | 2104198.59660265 | 37.7581196808576 | -122.419094125211 | (37.7581196808576, -122.419094125211) | 2 | 4 | 7 | 28859 | 19 | |||||
308 | 102295 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1500 Michigan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016449 | 2101073.5 | 37.7500708170088 | -122.385921283567 | (37.7500708170088, -122.385921283567) | 10 | 3 | 8 | 58 | 1 | ||||
309 | 40920 | Permitted Site 7 | Tree(s) :: 17 | 720 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.7846879743619 | -122.401028836502 | (37.7846879743619, -122.401028836502) | 12 | 2 | 9 | 28853 | 6 | |||
319 | 96811 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 356 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996379.5 | 2106960.2 | 37.7651031164685 | -122.455747798641 | (37.7651031164685, -122.455747798641) | 15 | 5 | 11 | 29492 | 12 | ||||
333 | 44989 | Permitted Site 7 | Tree(s) :: 17 | 83 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
340 | 42995 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 436 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42871 | 6004515.16540478 | 2110012.02065503 | 37.7739462176361 | -122.42782598565 | (37.7739462176361, -122.42782598565) | 7 | 9 | 11 | 28852 | 10 | ||
341 | 232113 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 533 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1991 12:00:00 AM | 24 | 4x4 | Permit Number 29534 | 6008027.37409 | 2096368.31937 | 37.7366817787289 | -122.414710885994 | (37.7366817787289, -122.414710885994) | 2 | 7 | 7 | 28859 | 2 | |
347 | 108327 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
348 | 58983 | Permitted Site 7 | Tree(s) :: 17 | 585 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1980 12:00:00 AM | Permit Number 18272 | 5995294.04081777 | 2111581.66432509 | 37.7777300922573 | -122.45983690137 | (37.7777300922573, -122.45983690137) | 11 | 6 | 2 | 54 | 11 | |||
376 | 33627 | Permitted Site 7 | Tree(s) :: 17 | 315 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37728 | 6005028.27785393 | 2110030.93274628 | 37.7740271589488 | -122.426052389372 | (37.7740271589488, -122.426052389372) | 7 | 9 | 11 | 28852 | 10 | |||
382 | 34903 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
407 | 56529 | Permitted Site 7 | Tree(s) :: 17 | 4721 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998571.81433707 | 2105652.41045975 | 37.7616378261686 | -122.448070980729 | (37.7616378261686, -122.448070980729) | 15 | 5 | 11 | 29492 | 12 | |||||
414 | 8435 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1730 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/1997 12:00:00 AM | 13 | 3X3 | 6003010.73492 | 2113853.74303 | 37.784409407274 | -122.433304626878 | (37.784409407274, -122.433304626878) | 13 | 9 | 11 | 29490 | 13 | ||
435 | 108949 | Permitted Site 7 | :: 45 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003932.1 | 2088992 | 37.7161971007686 | -122.428344449747 | (37.7161971007686, -122.428344449747) | 9 | 7 | 6 | 28861 | 5 | |||
438 | 16548 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016043.45751 | 2097947.55726 | 37.7414651721818 | -122.387105680372 | (37.7414651721818, -122.387105680372) | 10 | 3 | 8 | 58 | 1 | |||
453 | 53634 | Permitted Site 7 | Tree(s) :: 17 | 4046 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | Permit Number 6568 | 6003580.8041803 | 2100716.80543934 | 37.7483708836629 | -122.430394762659 | (37.7483708836629, -122.430394762659) | 2 | 4 | 5 | 28862 | 22 | |||
461 | 56448 | Permitted Site 7 | Tree(s) :: 17 | 1410 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5982800.36611702 | 2105511.04189371 | 37.7603354906122 | -122.502606655486 | (37.7603354906122, -122.502606655486) | 1 | 8 | 3 | 56 | 35 | |||||
462 | 33949 | Permitted Site 7 | Tree(s) :: 17 | 1238 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1997 12:00:00 AM | Permit Number 37907 | 5999468.65195546 | 2108623.71254321 | 37.7698475030127 | -122.445182824083 | (37.7698475030127, -122.445182824083) | 15 | 5 | 11 | 29492 | 9 | |||
492 | 44943 | Permitted Site 7 | Tree(s) :: 17 | 176 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
495 | 69056 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | 11 | 8 | 11 | 56 | 12 | ||
499 | 180799 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Mount Vernon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 8x8 | Permit Number 782754 | 5998557.73755 | 2089669.84713 | 37.7177527376786 | -122.446969503064 | (37.7177527376786, -122.446969503064) | 9 | 7 | 6 | 28861 | 25 | |
514 | 45011 | Permitted Site 7 | Tree(s) :: 17 | 93 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
517 | 30483 | Permitted Site 7 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1956 12:00:00 AM | Permit Number 147 | ||||||||||||||
521 | 100638 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
525 | 33087 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
528 | 57932 | Permitted Site 7 | Tree(s) :: 17 | 583 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | Permit Number 16891 | 5999047.47505332 | 2086793.7936429 | 37.7098837148731 | -122.445070058439 | (37.7098837148731, -122.445070058439) | 9 | 7 | 6 | 28861 | 5 | |||
530 | 35187 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
531 | 46009 | Permitted Site 7 | Tree(s) :: 17 | 195 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
542 | 35050 | Permitted Site 7 | Tree(s) :: 17 | 700 Peninsula Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1998 12:00:00 AM | Permit Number 38613 | |||||||||||||
548 | 48279 | Permitted Site 7 | Tree(s) :: 17 | 89 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
549 | 63156 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1483 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1986 12:00:00 AM | Permit Number 23692 | 5992405.6320278 | 2105370.20909848 | 37.7605085633711 | -122.4693765688 | (37.7605085633711, -122.4693765688) | 1 | 8 | 4 | 56 | 12 | ||
554 | 63105 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23825 | 6006733.57538349 | 2099199.19959074 | 37.7443819667232 | -122.41938488452 | (37.7443819667232, -122.41938488452) | 2 | 7 | 7 | 28859 | 2 | ||
557 | 44837 | Permitted Site 7 | Tree(s) :: 17 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
571 | 91075 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 576 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2008 12:00:00 AM | 3x3 | Permit Number 51977 | 6007858 | 2104570 | 37.7591922359052 | -122.415877090614 | (37.7591922359052, -122.415877090614) | 2 | 4 | 7 | 28859 | 19 | ||
589 | 108776 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 500X Lathrop Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
608 | 40723 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 374 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/1999 12:00:00 AM | 11 | 3x4 | Permit Number 41702 | 6007686.24299886 | 2097355.04576879 | 37.739371939893 | -122.415960181331 | (37.739371939893, -122.415960181331) | 2 | 7 | 7 | 28859 | 2 | |
611 | 10613 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 34 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1993 12:00:00 AM | 18 | 3X3 | 6016953.5018076 | 2095595.9312574 | 37.7350584319022 | -122.383795333225 | (37.7350584319022, -122.383795333225) | 10 | 3 | 8 | 58 | 1 | ||
622 | 48348 | Permitted Site 7 | Tree(s) :: 17 | 153 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
627 | 34919 | Permitted Site 7 | Tree(s) :: 17 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
630 | 106356 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 74 Brady St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2014 12:00:00 AM | 3x3 | Permit Number 771746 | 6006716.8 | 2109464.1 | 37.7725660586042 | -122.420171254703 | (37.7725660586042, -122.420171254703) | 8 | 2 | 9 | 28853 | 19 | ||
633 | 9792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
637 | 35060 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 5545 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | Permit Number 41350 | 6014167.69706675 | 2092844.73590691 | 37.7273498207281 | -122.393234476852 | (37.7273498207281, -122.393234476852) | 10 | 3 | 8 | 58 | 1 |
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) );