trees
254 rows where qSpecies_id = 78 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3491 | 30093 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 835 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 5 | 3x3 | 6015986 | 2096642 | 37.7378771959016 | -122.387213305704 | (37.7378771959016, -122.387213305704) | 10 | 3 | 8 | 58 | 1 | ||
61879 | 25474 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 830X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6015988.77798 | 2096759.23326 | 37.7381992484921 | -122.387211875796 | (37.7381992484921, -122.387211875796) | 10 | 3 | 8 | 58 | 1 | ||
13228 | 197239 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 830 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 4x4 | Permit Number 785334 | 6011827.26305 | 2104492.53285 | 37.7592018783746 | -122.40214394589 | (37.7592018783746, -122.40214394589) | 10 | 3 | 8 | 28856 | 29 | ||
160117 | 197267 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 822 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6015954.57272 | 2096709.3738 | 37.7380604502387 | -122.387326664599 | (37.7380604502387, -122.387326664599) | 10 | 3 | 8 | 58 | 1 | |||
96726 | 197266 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 818 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015992.31531 | 2096760.75352 | 37.738203618709 | -122.387199751367 | (37.738203618709, -122.387199751367) | 10 | 3 | 8 | 58 | 1 | |||
79318 | 11430 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 810X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 3 | 3x3 | 6016021.05885 | 2096802.45168 | 37.7383197051187 | -122.387103277147 | (37.7383197051187, -122.387103277147) | 10 | 3 | 8 | 58 | 1 | ||
94362 | 179342 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 700x Mansell St | 45 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6009054.2584 | 2089931.43239 | 37.7190650967554 | -122.410706045769 | (37.7190650967554, -122.410706045769) | 9 | 3 | 8 | 309 | 18 | |||
11056 | 111333 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
16757 | 111332 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
34139 | 111331 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
47021 | 111329 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
63631 | 111325 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
69479 | 111326 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
87605 | 111327 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
106469 | 111328 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
169584 | 111330 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
21876 | 240353 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 10 | Front Yard : Yard | Tree | Private 2 | 29 | Width 3ft | 6004318.10753 | 2104946.36781 | 37.7600260063222 | -122.428146563117 | (37.7600260063222, -122.428146563117) | 2 | 4 | 5 | 28862 | 3 | |||
29767 | 240355 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 18 | Front Yard : Yard | Tree | Private 2 | 19 | Width 3ft | 6004321.65497 | 2104972.99929 | 37.7600993307501 | -122.428136192147 | (37.7600993307501, -122.428136192147) | 2 | 4 | 5 | 28862 | 3 | |||
30444 | 240358 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 23 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6004302.67089 | 2105008.50736 | 37.760195753352 | -122.428204379638 | (37.760195753352, -122.428204379638) | 2 | 4 | 5 | 28862 | 3 | |||
30660 | 240354 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 17 | Front Yard : Yard | Tree | Private 2 | 13 | Width 3ft | 6004324.4915 | 2104963.90622 | 37.7600745238281 | -122.428125733918 | (37.7600745238281, -122.428125733918) | 2 | 4 | 5 | 28862 | 3 | |||
70692 | 240357 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 20 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004316.61445 | 2104979.98621 | 37.7601182299832 | -122.428154122837 | (37.7601182299832, -122.428154122837) | 2 | 4 | 5 | 28862 | 3 | |||
77159 | 240356 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 19 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6004321.88535 | 2104984.17972 | 37.760130042589 | -122.428136192158 | (37.760130042589, -122.428136192158) | 2 | 4 | 5 | 28862 | 3 | |||
129947 | 240359 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 24 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004303.32084 | 2105026.7227 | 37.7602458051206 | -122.428203429952 | (37.7602458051206, -122.428203429952) | 2 | 4 | 5 | 28862 | 3 | |||
185478 | 240352 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 9 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6004316.09652 | 2104917.27177 | 37.7599460017266 | -122.428151444657 | (37.7599460017266, -122.428151444657) | 2 | 4 | 5 | 28862 | 3 | |||
19693 | 119298 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 6700x Geary Blvd | 7 | Median : Yard | Tree | DPW 1 | 8 | 5986043.64284 | 2112521.46731 | 37.7797741997502 | -122.491905961239 | (37.7797741997502, -122.491905961239) | 11 | 6 | 2 | 55 | 26 | ||||
38940 | 95980 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 6700 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 6 | 5986162.43558 | 2112587.6567 | 37.7799628795758 | -122.491499884152 | (37.7799628795758, -122.491499884152) | 11 | 6 | 2 | 55 | 26 | |||
111989 | 65579 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/1990 12:00:00 AM | 4 | Permit Number 28479 | 6016251.26211 | 2097105.49291 | 37.739164539819 | -122.386328462099 | (37.739164539819, -122.386328462099) | 10 | 3 | 8 | 58 | 1 | ||
161842 | 15016 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 670 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2008 12:00:00 AM | 5 | 3x3 | 6016248.60441 | 2097127.21289 | 37.7392240313668 | -122.386339165233 | (37.7392240313668, -122.386339165233) | 10 | 3 | 8 | 58 | 1 | ||
82383 | 197225 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015963.59101 | 2106011.38061 | 37.7636023160031 | -122.387944392722 | (37.7636023160031, -122.387944392722) | 14 | 3 | 8 | 28856 | 29 | |||
90584 | 197232 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015969.52981 | 2105893.92675 | 37.7632801419786 | -122.38791565581 | (37.7632801419786, -122.38791565581) | 14 | 3 | 8 | 28856 | 29 | |||
109059 | 197227 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015965.05283 | 2105966.21151 | 37.7634783723591 | -122.38793618463 | (37.7634783723591, -122.38793618463) | 14 | 3 | 8 | 28856 | 29 | |||
109788 | 197230 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015968.5174 | 2105926.2015 | 37.7633687054139 | -122.387921409661 | (37.7633687054139, -122.387921409661) | 14 | 3 | 8 | 28856 | 29 | |||
146620 | 197228 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015966.4036 | 2105950.82285 | 37.7634361932415 | -122.387930438833 | (37.7634361932415, -122.387930438833) | 14 | 3 | 8 | 28856 | 29 | |||
147723 | 197229 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015967.79725 | 2105937.55997 | 37.7633998534335 | -122.387924693077 | (37.7633998534335, -122.387924693077) | 14 | 3 | 8 | 28856 | 29 | |||
163343 | 197226 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015965.03581 | 2105988.90006 | 37.7635406692923 | -122.387937826789 | (37.7635406692923, -122.387937826789) | 14 | 3 | 8 | 28856 | 29 | |||
166919 | 197231 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015968.40199 | 2105908.71514 | 37.7633206852369 | -122.387920588579 | (37.7633206852369, -122.387920588579) | 14 | 3 | 8 | 28856 | 29 | |||
13469 | 260844 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 651 06th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5994076.91489 | 2111079.35374 | 37.7762808110216 | -122.464010852721 | (37.7762808110216, -122.464010852721) | 11 | 6 | 2 | 54 | 11 | ||
14458 | 197268 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 623 Mendell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016457.45945 | 2097300.20103 | 37.7397105802781 | -122.385629084527 | (37.7397105802781, -122.385629084527) | 10 | 3 | 8 | 58 | 1 | |||
17414 | 197269 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 623 Mendell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016467.03521 | 2097318.03546 | 37.7397600798502 | -122.385597217932 | (37.7397600798502, -122.385597217932) | 10 | 3 | 8 | 58 | 1 | |||
65712 | 197270 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 621 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6016507.88272 | 2097368.67206 | 37.7399013777473 | -122.385459511073 | (37.7399013777473, -122.385459511073) | 10 | 3 | 8 | 58 | 1 | |||
125089 | 197271 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 621 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016522.12387 | 2097389.36221 | 37.7399589766173 | -122.385411712102 | (37.7399589766173, -122.385411712102) | 10 | 3 | 8 | 58 | 1 | |||
135673 | 197272 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 621 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016550.5665 | 2097428.77687 | 37.7400687748538 | -122.385316114164 | (37.7400687748538, -122.385316114164) | 10 | 3 | 8 | 58 | 1 | |||
49522 | 197273 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 618 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016318.01168 | 2097190.59348 | 37.7394019032644 | -122.386103601013 | (37.7394019032644, -122.386103601013) | 10 | 3 | 8 | 58 | 1 | |||
20000 | 15008 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 600X Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2008 12:00:00 AM | 12 | 3x3 | 6016372.25512 | 2097272.64218 | 37.7396301943656 | -122.385921767044 | (37.7396301943656, -122.385921767044) | 10 | 3 | 8 | 58 | 1 | ||
20136 | 219811 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 580 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782000 | 6001173.93519 | 2102998.57912 | 37.7544994546959 | -122.438881134568 | (37.7544994546959, -122.438881134568) | 2 | 4 | 5 | 28862 | 22 | |
19030 | 221366 | Planning Code 138.1 required 2 | Quercus suber :: Cork Oak 78 | 55 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2019 12:00:00 AM | 3 | 3x3 | Permit Number 778991 | 6000992.93047 | 2101385.53728 | 37.7500601303816 | -122.439391477336 | (37.7500601303816, -122.439391477336) | 2 | 4 | 5 | 28862 | 22 | |
6880 | 24222 | Section 806 (d) 5 | Quercus suber :: Cork Oak 78 | 54 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2010 12:00:00 AM | 3 | 4x4 | this is original dpw basin record. | 6017205.2608 | 2094992.48681 | 37.7334154068844 | -122.382882921904 | (37.7334154068844, -122.382882921904) | 10 | 3 | 8 | 58 | 1 | |
186057 | 93980 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 54 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53404 | 6016373.3 | 2096115.1 | 37.7364518752706 | -122.385837492382 | (37.7364518752706, -122.385837492382) | 10 | 3 | 8 | 58 | 1 | |
31353 | 15000 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 501 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6016547.41943 | 2097394.04536 | 37.7399732350602 | -122.385324575969 | (37.7399732350602, -122.385324575969) | 10 | 3 | 8 | 58 | 1 | |||
53291 | 15001 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 501 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6016547.41943 | 2097394.04536 | 37.7399732350602 | -122.385324575969 | (37.7399732350602, -122.385324575969) | 10 | 3 | 8 | 58 | 1 | ||
127157 | 15003 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 501 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6016547.41943 | 2097394.04536 | 37.7399732350602 | -122.385324575969 | (37.7399732350602, -122.385324575969) | 10 | 3 | 8 | 58 | 1 | ||
79040 | 14988 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 500 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/2013 12:00:00 AM | 3 | 3x3 | 6016447.53347 | 2097406.0602 | 37.7400006988631 | -122.385670780678 | (37.7400006988631, -122.385670780678) | 10 | 3 | 8 | 58 | 1 | ||
135622 | 14987 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 500 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/25/2008 12:00:00 AM | 2 | 3X3 | 6016458.61367 | 2097424.13027 | 37.7400509287079 | -122.38563372862 | (37.7400509287079, -122.38563372862) | 10 | 3 | 8 | 58 | 1 | ||
32722 | 14877 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017083.42225 | 2098683.73205 | 37.7435440924819 | -122.383561044027 | (37.7435440924819, -122.383561044027) | 10 | 3 | 8 | 58 | 1 | |||
36718 | 14879 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017057.00036 | 2098638.4724 | 37.7434183582727 | -122.383649254902 | (37.7434183582727, -122.383649254902) | 10 | 3 | 8 | 58 | 1 | |||
89094 | 14884 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017061.80062 | 2098665.73573 | 37.7434934831644 | -122.383634554347 | (37.7434934831644, -122.383634554347) | 10 | 3 | 8 | 58 | 1 | ||
116959 | 14878 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6017061.80062 | 2098665.73573 | 37.7434934831644 | -122.383634554347 | (37.7434934831644, -122.383634554347) | 10 | 3 | 8 | 58 | 1 | ||
159580 | 14882 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017027.26925 | 2098565.83494 | 37.7432172671691 | -122.383747002247 | (37.7432172671691, -122.383747002247) | 10 | 3 | 8 | 58 | 1 | |||
170555 | 14881 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 50 Mendell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017041.97386 | 2098599.86831 | 37.7433115287015 | -122.383698526073 | (37.7433115287015, -122.383698526073) | 10 | 3 | 8 | 58 | 1 | ||
68533 | 14977 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 495X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016593.75941 | 2097492.39708 | 37.7402458525216 | -122.385171201108 | (37.7402458525216, -122.385171201108) | 10 | 3 | 8 | 58 | 1 | ||
170483 | 14981 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 495X Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2008 12:00:00 AM | 3 | 3X3 | 6016593.75941 | 2097492.39708 | 37.7402458525216 | -122.385171201108 | (37.7402458525216, -122.385171201108) | 10 | 3 | 8 | 58 | 1 | ||
72255 | 240350 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4746 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5998436.06596 | 2105691.7221 | 37.7617380052332 | -122.448543308522 | (37.7617380052332, -122.448543308522) | 15 | 5 | 11 | 29492 | 9 | |||
77040 | 240349 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4736 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 5998465.34509 | 2105692.76775 | 37.7617425503974 | -122.448442119502 | (37.7617425503974, -122.448442119502) | 15 | 5 | 11 | 29492 | 9 | |||
193294 | 98540 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 4736 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 5998512 | 2105692 | 37.7617431097225 | -122.448280704282 | (37.7617431097225, -122.448280704282) | 15 | 5 | 11 | 29492 | 9 | ||||
565 | 170476 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 46 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003788.04729 | 2094625.21712 | 37.7316565146416 | -122.429243816075 | (37.7316565146416, -122.429243816075) | 9 | 7 | 5 | 28861 | 25 | ||
14698 | 53201 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 428@ CLEMENT 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2006 12:00:00 AM | 8 | Permit Number 49135 | 5983471.70703 | 2112915.4813 | 37.7807053822414 | -122.50083241779 | (37.7807053822414, -122.50083241779) | 11 | 6 | 2 | 55 | 26 | ||
103279 | 113196 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4090X 20th St | 1 | Median : Yard | Tree | DPW 1 | 6003325.96697 | 2104184.75857 | 37.7578786248615 | -122.431523525971 | (37.7578786248615, -122.431523525971) | 2 | 4 | 5 | 28862 | 3 | |||||
95650 | 240351 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4090 20th St | 1 | : Yard | Tree | Private 2 | 22 | Width 3ft | 6003153.88022 | 2104182.56452 | 37.7578628454134 | -122.432118516979 | (37.7578628454134, -122.432118516979) | 2 | 4 | 5 | 28862 | 3 | |||
45458 | 136290 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006768.37866 | 2112062.50938 | 37.7797035719992 | -122.420177283766 | (37.7797035719992, -122.420177283766) | 7 | 9 | 9 | 28852 | 36 | |||
67441 | 136291 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006783.12153 | 2111963.42533 | 37.779432341874 | -122.420119247825 | (37.779432341874, -122.420119247825) | 7 | 9 | 9 | 28852 | 36 | |||
97907 | 136292 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006812.66695 | 2111768.16026 | 37.7788978558793 | -122.420003176823 | (37.7788978558793, -122.420003176823) | 7 | 9 | 9 | 28852 | 36 | |||
23991 | 197244 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Mendell St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016639.49339 | 2097549.35813 | 37.7404047858594 | -122.385017037417 | (37.7404047858594, -122.385017037417) | 10 | 3 | 8 | 58 | 1 | |||
75684 | 197245 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Mendell St | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6016656.39457 | 2097572.22784 | 37.7404685163083 | -122.38496019216 | (37.7404685163083, -122.38496019216) | 10 | 3 | 8 | 58 | 1 | |||
81664 | 197243 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Mendell St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6016629.41985 | 2097534.84725 | 37.7403643847096 | -122.385050857321 | (37.7403643847096, -122.385050857321) | 10 | 3 | 8 | 58 | 1 | |||
56405 | 201668 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 4 | Front Yard : Yard | Tree | Private 2 | 11 | 6010243.64351 | 2109736.80769 | 37.7735129403066 | -122.407990719097 | (37.7735129403066, -122.407990719097) | 14 | 2 | 9 | 28853 | 34 | ||||
70732 | 201670 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 6 | Front Yard : Yard | Tree | Private 2 | 10 | 6010207.48998 | 2109776.17317 | 37.7736190045563 | -122.408118556848 | (37.7736190045563, -122.408118556848) | 14 | 2 | 9 | 28853 | 34 | ||||
104712 | 201665 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6010317.6274 | 2109676.05195 | 37.7733502610444 | -122.407730511973 | (37.7733502610444, -122.407730511973) | 14 | 2 | 9 | 28853 | 34 | ||||
178580 | 201667 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 08th St | 3 | Front Yard : Yard | Tree | Private 2 | 5 | 6010257.0488 | 2109725.83328 | 37.7734835576458 | -122.407943573961 | (37.7734835576458, -122.407943573961) | 14 | 2 | 9 | 28853 | 34 | ||||
161719 | 14971 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 400X Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6016631.74011 | 2097650.02311 | 37.7406807626184 | -122.385050857322 | (37.7406807626184, -122.385050857322) | 10 | 3 | 8 | 58 | 1 | ||
19431 | 242096 | Planning Code 138.1 required 2 | Quercus suber :: Cork Oak 78 | 3721 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2019 12:00:00 AM | 3 | 4x4 | Permit Number 769571 | 6003563.92038 | 2103590.2718 | 37.756259789464 | -122.430658162741 | (37.756259789464, -122.430658162741) | 2 | 4 | 5 | 28862 | 22 | |
189970 | 1241 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3702X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X5 | 5992970.26911 | 2087627.91348 | 37.711825271896 | -122.466134417365 | (37.711825271896, -122.466134417365) | 9 | 8 | 4 | 64 | 24 | |||
46463 | 1243 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3700X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/2004 12:00:00 AM | 3 | 3X5 | 5993218.71389 | 2087629.40018 | 37.7118436847502 | -122.465275838287 | (37.7118436847502, -122.465275838287) | 9 | 8 | 4 | 64 | 24 | ||
19880 | 243367 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 3686 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782225 | 6005735.65581 | 2104339.74223 | 37.7584404565742 | -122.423200817986 | (37.7584404565742, -122.423200817986) | 2 | 4 | 5 | 28859 | 19 | |
189645 | 224739 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 3686 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782225 | 6005758.94029 | 2104340.80798 | 37.7584446968891 | -122.423120365536 | (37.7584446968891, -122.423120365536) | 2 | 4 | 5 | 28859 | 19 | |
69328 | 1227 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3600X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/2004 12:00:00 AM | 8 | 3X5 | 5993524.0546702 | 2087589.4711722 | 37.7117516532039 | -122.464217607089 | (37.7117516532039, -122.464217607089) | 9 | 8 | 4 | 64 | 24 | ||
541 | 225969 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3599 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6005840.01853 | 2101965.47506 | 37.7519271589233 | -122.422671163153 | (37.7519271589233, -122.422671163153) | 2 | 4 | 5 | 28859 | 19 | |||
69653 | 14961 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 355 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016837.91572 | 2097829.62207 | 37.7411853074635 | -122.384350479174 | (37.7411853074635, -122.384350479174) | 10 | 3 | 8 | 58 | 1 | |||
14449 | 260124 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 3195X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | 3x3 | ||||||||||||
68597 | 23583 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6005493.5455 | 2121226.72691 | 37.8047942964921 | -122.425239779807 | (37.8047942964921, -122.425239779807) | 5 | 1 | 1 | 28858 | 32 | |||
72754 | 23582 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005497.77155 | 2121198.52122 | 37.8047170896849 | -122.425223146826 | (37.8047170896849, -122.425223146826) | 5 | 1 | 1 | 28858 | 32 | ||
119078 | 23581 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005553.2513401 | 2120985.4040713 | 37.8041350589608 | -122.425015980687 | (37.8041350589608, -122.425015980687) | 5 | 1 | 1 | 28858 | 32 | ||
39591 | 197240 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 301 Mendell St | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6016921.73157 | 2097930.91265 | 37.7414680650873 | -122.384067722948 | (37.7414680650873, -122.384067722948) | 10 | 3 | 8 | 58 | 1 | |||
23481 | 29669 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 300X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 3 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | ||||
101457 | 23180 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 300X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 3 | 9 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | |||
178117 | 29670 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 300X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | ||||
13875 | 226227 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2955 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2020 12:00:00 AM | 3 | 6x6 | Permit Number 787786 | 6008507.27789 | 2103281.70589 | 37.755691354088 | -122.413540452526 | (37.755691354088, -122.413540452526) | 2 | 4 | 7 | 28859 | 19 | |
77807 | 13296 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2770 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2016 12:00:00 AM | 2 | 3X3 | Permit Number 770074 | 5999335.52143 | 2119120.50059 | 37.7986613518083 | -122.446398566642 | (37.7986613518083, -122.446398566642) | 13 | 9 | 1 | 57 | 17 | |
121021 | 14957 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 275 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2007 12:00:00 AM | 3 | 3X3 | 6016965.76785 | 2098027.33997 | 37.7417352694795 | -122.383922171933 | (37.7417352694795, -122.383922171933) | 10 | 3 | 8 | 58 | 1 | ||
97214 | 136295 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2600x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 16 | Width 8ft | 6005728.53037 | 2119520.31629 | 37.8001222024312 | -122.424305148569 | (37.8001222024312, -122.424305148569) | 13 | 9 | 1 | 28858 | 32 | |||
57758 | 23507 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2600X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 9 | 6005789.5650879 | 2119282.8766016 | 37.799473699725 | -122.424077049734 | (37.799473699725, -122.424077049734) | 13 | 9 | 1 | 28858 | 32 |
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) );