trees
254 rows where qSpecies_id = 78 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60368 | 27594 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2200X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2001 12:00:00 AM | 16 | 3X3 | 6010149.05665 | 2095763.28912 | 37.7351394742594 | -122.407332636897 | (37.7351394742594, -122.407332636897) | 10 | 7 | 7 | 309 | 28 | ||
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 | ||||
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 | |||
74430 | 23333 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1142X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006495.0913449 | 2114431.1382441 | 37.7861918455124 | -122.42129095338 | (37.7861918455124, -122.42129095338) | 13 | 9 | 10 | 28858 | 36 | ||
76183 | 27589 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2100X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.949435 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | 10 | 7 | 7 | 309 | 2 | ||
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 | |||
98474 | 27536 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1300 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016135.46193 | 2102904.74697 | 37.7550816812001 | -122.387133239331 | (37.7550816812001, -122.387133239331) | 10 | 3 | 8 | 28856 | 29 | ||
108620 | 23339 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1202X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 6 | 9x5 | 6006445.1571238 | 2114583.3806769 | 37.7866070504124 | -122.42147452901 | (37.7866070504124, -122.42147452901) | 13 | 9 | 10 | 28858 | 36 | ||
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 | |||
137610 | 23355 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1250X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/10/2003 12:00:00 AM | 3 | 9 | 6006448.1236467 | 2114767.6788933 | 37.7871132551315 | -122.421477359088 | (37.7871132551315, -122.421477359088) | 13 | 9 | 10 | 28858 | 21 | ||
138232 | 27542 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1390 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2006 12:00:00 AM | 3 | 3X3 | 6016157.095863 | 2102619.361637 | 37.7542992711205 | -122.387038518734 | (37.7542992711205, -122.387038518734) | 10 | 3 | 8 | 28856 | 29 | ||
144179 | 249478 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1300x Van Ness Ave | 2 | Median : Yard | Tree | DPW 1 | 12 | 6006350.91475 | 2115079.54882 | 37.7879640914292 | -122.421835842261 | (37.7879640914292, -122.421835842261) | 13 | 9 | 1 | 28858 | 21 | ||||
153438 | 23389 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006261.55669 | 2115711.13882 | 37.7896932412903 | -122.422189894555 | (37.7896932412903, -122.422189894555) | 13 | 9 | 1 | 28858 | 21 | |||
154737 | 179363 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010218.26631 | 2095644.80145 | 37.7348180057356 | -122.407085003796 | (37.7348180057356, -122.407085003796) | 10 | 3 | 7 | 309 | 28 | |||
158904 | 23324 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1108X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 3x3 | 6006505.7907443 | 2114265.3196899 | 37.7857371517591 | -122.421242157065 | (37.7857371517591, -122.421242157065) | 13 | 9 | 9 | 28858 | 36 | ||
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 | ||
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 | |||
191304 | 23366 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1356X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 6 | 9 | 6006391.3825894 | 2115174.2493055 | 37.7882263975959 | -122.421702559542 | (37.7882263975959, -122.421702559542) | 13 | 9 | 10 | 28858 | 21 | ||
194279 | 249475 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Van Ness Ave | 2 | Median : Yard | Tree | DPW 1 | 18 | Permit Number 787880 | 6006389.52859 | 2114780.40651 | 37.7871448980627 | -122.421680989782 | (37.7871448980627, -122.421680989782) | 13 | 9 | 1 | 28858 | 21 | |||
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 | |||
167697 | 27569 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 10 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
61310 | 27570 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 21 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
47677 | 27571 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 22 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
87659 | 21043 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2101X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
160181 | 27573 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 24 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
247 | 240348 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1201 San Jose Ave | 26 | Front Yard : Yard | Tree | Private 2 | 1 | 6004340.86769 | 2095971.00866 | 37.7353830362869 | -122.427428442788 | (37.7353830362869, -122.427428442788) | 2 | 7 | 5 | 28861 | 2 | ||||
115457 | 197257 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017533.22144 | 2094905.154 | 37.733193723116 | -122.381742986272 | (37.733193723116, -122.381742986272) | 10 | 3 | 8 | 58 | 1 | |||
30084 | 3591 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 27 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018372.01456 | 2097944.0595 | 37.7415842377244 | -122.379054002545 | (37.7415842377244, -122.379054002545) | 10 | 3 | 8 | 58 | 1 | ||
91583 | 10820 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1139X Hudson Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 3 | 3x4 | 6017736.87901 | 2094664.32601 | 37.7325437003489 | -122.381022142119 | (37.7325437003489, -122.381022142119) | 10 | 3 | 8 | 58 | 1 | ||
131442 | 197258 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017525.05376 | 2094913.62104 | 37.7332165209287 | -122.381771813133 | (37.7332165209287, -122.381771813133) | 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 | |
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 | |||
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 | |||
38770 | 197242 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 151 Mendell St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6017080.03361 | 2098493.68243 | 37.7430220675307 | -122.383559533147 | (37.7430220675307, -122.383559533147) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
42162 | 10795 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1139X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 3 | 3x4 | 6017417.86801 | 2094975.52401 | 37.7333805749772 | -122.382146691971 | (37.7333805749772, -122.382146691971) | 10 | 3 | 8 | 58 | 1 | ||
48159 | 23340 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1202X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 8 | 9x5 | 6006445.1571238 | 2114583.3806769 | 37.7866070504124 | -122.42147452901 | (37.7866070504124, -122.42147452901) | 13 | 9 | 10 | 28858 | 36 | ||
50113 | 197251 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1333 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017752.42929 | 2094673.2277 | 37.7325690009549 | -122.380968999147 | (37.7325690009549, -122.380968999147) | 10 | 3 | 8 | 58 | 1 | |||
52600 | 179364 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010224.85869 | 2095626.21613 | 37.7347673433273 | -122.407060901965 | (37.7347673433273, -122.407060901965) | 10 | 3 | 7 | 309 | 28 | |||
56994 | 23390 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 12/09/2003 12:00:00 AM | 6 | 9 | 6006302.3156668 | 2115604.1529311 | 37.789401783497 | -122.42204126893 | (37.789401783497, -122.42204126893) | 13 | 9 | 10 | 28858 | 21 | ||
61724 | 104602 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1945 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770083 | 6007233.09491 | 2119016.60883 | 37.7988239906011 | -122.41906301476 | (37.7988239906011, -122.41906301476) | 5 | 1 | 10 | 28858 | 32 | |
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 | |||
70193 | 10851 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1220X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 3 | 3X4 | 6017356.4574634 | 2095156.0177673 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | 10 | 3 | 8 | 58 | 1 | ||
77492 | 197255 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1320 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6018070.99696 | 2094637.60558 | 37.7324887679223 | -122.379865147852 | (37.7324887679223, -122.379865147852) | 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 | ||
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 | ||||
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 | |||
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 | |||
110571 | 240362 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 138 Laidley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003721.38231 | 2097581.21775 | 37.7397692466514 | -122.429685041427 | (37.7397692466514, -122.429685041427) | 2 | 7 | 5 | 63 | 7 | |||
111813 | 249489 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 3 | Median : Yard | Tree | DPW 1 | 11 | 6006246.93776 | 2115807.86331 | 37.7899579981201 | -122.422247349544 | (37.7899579981201, -122.422247349544) | 13 | 9 | 1 | 28858 | 21 | ||||
112325 | 27595 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2200X San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2001 12:00:00 AM | 8 | 3X3 | 6010149.0566544 | 2095763.2891254 | 37.7351394742744 | -122.407332636882 | (37.7351394742744, -122.407332636882) | 10 | 7 | 7 | 309 | 28 | ||
118523 | 251277 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/26/2011 12:00:00 AM | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | ||
132053 | 179369 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010313.94209 | 2095431.38029 | 37.7342373503731 | -122.406739182082 | (37.7342373503731, -122.406739182082) | 10 | 3 | 7 | 309 | 28 | |||
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 | ||
155357 | 29644 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X La Salle Ave | 3 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015992.6911276 | 2095862.2429535 | 37.735736511316 | -122.38713579848 | (37.735736511316, -122.38713579848) | 10 | 3 | 8 | 58 | 1 | ||
158925 | 197241 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 201 Mendell St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016985.47526 | 2098058.34628 | 37.7418214959701 | -122.383856188014 | (37.7418214959701, -122.383856188014) | 10 | 3 | 8 | 58 | 1 | |||
159213 | 27590 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2100X San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.949435 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | 10 | 7 | 7 | 309 | 2 | ||
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 | ||||
179134 | 249476 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Van Ness Ave | 3 | Median : Yard | Tree | DPW 1 | 16 | 6006383.25331 | 2114827.68427 | 37.7872743572577 | -122.421706060208 | (37.7872743572577, -122.421706060208) | 13 | 9 | 1 | 28858 | 21 | ||||
93791 | 10823 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1139X Hudson Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 3 | 3X4 | 6017777.24301 | 2094650.00301 | 37.7325066000949 | -122.380881597251 | (37.7325066000949, -122.380881597251) | 10 | 3 | 8 | 58 | 1 | ||
171577 | 10760 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1120X Hudson Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | ||
51021 | 10824 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1139X Hudson Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2007 12:00:00 AM | 3 | 3X4 | 6017795.47201 | 2094639.58601 | 37.7324790031541 | -122.380817850696 | (37.7324790031541, -122.380817850696) | 10 | 3 | 8 | 58 | 1 | ||
51144 | 197259 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017468.44354 | 2094985.48685 | 37.7334107241212 | -122.381972529223 | (37.7334107241212, -122.381972529223) | 10 | 3 | 8 | 58 | 1 | |||
154283 | 3521 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 201X Cargo Way | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6018183.10085 | 2097983.12019 | 37.7416810722141 | -122.379709922198 | (37.7416810722141, -122.379709922198) | 10 | 3 | 8 | 58 | 1 | |||
99331 | 10749 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1120X Hudson Ave | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | ||
85764 | 98130 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1120X Hudson Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 4 | 3x4 | 6017903.8 | 2094987 | 37.733438911814 | -122.380467469044 | (37.733438911814, -122.380467469044) | 10 | 3 | 8 | 58 | 1 | ||
120167 | 10829 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1139X Hudson Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2006 12:00:00 AM | 3 | 3X4 | 6017900.94101 | 2094609.63801 | 37.7324025921986 | -122.380451134764 | (37.7324025921986, -122.380451134764) | 10 | 3 | 8 | 58 | 1 | ||
1244 | 27591 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2100X San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/21/2001 12:00:00 AM | 3 | 3x3 | 6009789.2811665 | 2096218.949435 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | 10 | 7 | 7 | 309 | 2 | ||
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 | ||||
33402 | 27596 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2200X San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/20/2003 12:00:00 AM | 6 | 3X3 | 6010149.0566544 | 2095763.2891254 | 37.7351394742744 | -122.407332636882 | (37.7351394742744, -122.407332636882) | 10 | 7 | 7 | 309 | 28 | ||
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 | ||||
71826 | 27553 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 1299X Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
92029 | 197235 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1101 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016151.23089 | 2103629.88261 | 37.7570736237573 | -122.387129280509 | (37.7570736237573, -122.387129280509) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
100005 | 179370 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010321.94566 | 2095411.61629 | 37.7341835304417 | -122.406710118682 | (37.7341835304417, -122.406710118682) | 10 | 3 | 7 | 309 | 28 | |||
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 | ||||
115113 | 10782 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2016 09:31:00 AM | 3 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 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 | ||
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 | ||
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 | ||
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 | ||
135367 | 251278 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 01/27/2016 09:31:00 AM | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 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 | |||
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 | |||
148351 | 179365 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010237.42069 | 2095603.49038 | 37.7347056462347 | -122.407015869312 | (37.7347056462347, -122.407015869312) | 10 | 3 | 7 | 309 | 28 | |||
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 | ||
165987 | 99962 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1202X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 8 | 9x5 | 6006588.9 | 2114703 | 37.7869435992692 | -122.420985708971 | (37.7869435992692, -122.420985708971) | 13 | 9 | 10 | 28858 | 21 | |||
171090 | 249490 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 12 | 6006241.6595 | 2115852.26392 | 37.7900796134287 | -122.422268767791 | (37.7900796134287, -122.422268767791) | 13 | 9 | 1 | 28858 | 21 | ||||
189367 | 10733 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1100 Hudson Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 01/28/2016 08:19:00 AM | 3 | 3x4 | 6018138.7903974 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | 10 | 3 | 8 | 58 | 1 | ||
147785 | 197260 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 40 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6017393.35703 | 2095090.62772 | 37.7336952732179 | -122.382239439017 | (37.7336952732179, -122.382239439017) | 10 | 3 | 8 | 58 | 1 | |||
71515 | 197261 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017380.57172 | 2095099.80246 | 37.7337197590624 | -122.382284280115 | (37.7337197590624, -122.382284280115) | 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 | |||
191501 | 197262 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 46 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017335.88738 | 2095181.6845 | 37.7339421227254 | -122.382444463752 | (37.7339421227254, -122.382444463752) | 10 | 3 | 8 | 58 | 1 | |||
110186 | 10775 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1120X Hudson Ave | 48 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | ||
74325 | 10777 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1120X Hudson Ave | 49 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/06/2014 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 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 | ||
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 |
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) );