254 rows where qSpecies_id = 78 sorted by rowid descending

View and edit SQL

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)
194494 264749 Section 806 (d) 5 Quercus suber :: Cork Oak 78 1339 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2021 12:00:00 AM 3 3x3 Permit Number 785207 5991088 2106284 37.7629413570223 -122.474000279679 (37.7629413570223, -122.474000279679) 1 8 11 56 12
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
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
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
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
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
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
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
187789 23323 DPW Maintained 1 Quercus suber :: Cork Oak 78 1108X Van Ness Ave 1 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
186305 136293 DPW Maintained 1 Quercus suber :: Cork Oak 78 1500x Van Ness Ave 5 Median : Yard Tree DPW 1     11     6006248.16207 2115803.32411 37.7899456036636 -122.422242790899 (37.7899456036636, -122.422242790899) 13 9 1 28858 21
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
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
184011 27550 Permitted Site 7 Quercus suber :: Cork Oak 78 1299X Illinois St 1 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
181525 197254 DPW Maintained 1 Quercus suber :: Cork Oak 78 1333 Hudson Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017901.24331 2094608.61235 37.7323997926186 -122.380450018371 (37.7323997926186, -122.380450018371) 10 3 8 58 1
179909 14923 DPW Maintained 1 Quercus suber :: Cork Oak 78 190 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/23/2015 08:59:00 AM 3 3x3   6016976.73758 2098306.80908 37.7425032414108 -122.383903696919 (37.7425032414108, -122.383903696919) 10 3 8 58 1
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
178961 27547 Permitted Site 7 Quercus suber :: Cork Oak 78 1301X Illinois St 5 Sidewalk: Curb side : Cutout Tree Port 6   04/06/2006 12:00:00 AM 3 3X3   6016173.411126 2103023.95301 37.7554110972717 -122.387010312465 (37.7554110972717, -122.387010312465) 10 3 8 28856 29
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
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
172963 10876 DPW Maintained 1 Quercus suber :: Cork Oak 78 1175X Hudson Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1   12/17/2007 12:00:00 AM 3 3X4   6017544.4990408 2094830.7506973 37.7329900490522 -122.381698823278 (37.7329900490522, -122.381698823278) 10 3 8 58 1
172174 214009 DPW Maintained 1 Quercus suber :: Cork Oak 78 1298x Plymouth Ave 1 Median : Cutout Tree DPW 1     7 Width 3ft   5995820.98998 2092615.99547 37.7256854263362 -122.456642099278 (37.7256854263362, -122.456642099278) 9 7 4 28861 40
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
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
170929 14896 DPW Maintained 1 Quercus suber :: Cork Oak 78 151 Mendell St 10 Sidewalk: Curb side : Cutout Tree DPW 1   09/15/2016 12:00:00 AM 3 3x3   6017148.9857 2098654.51037 37.7434674792458 -122.383332305946 (37.7434674792458, -122.383332305946) 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
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
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
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
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
166337 240360 DPW Maintained 1 Quercus suber :: Cork Oak 78 138 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6003696.80727 2097599.26117 37.7398173981643 -122.429771298113 (37.7398173981643, -122.429771298113) 2 7 5 63 7
166245 27592 Permitted Site 7 Quercus suber :: Cork Oak 78 2100X San Bruno Ave 5 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
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
164558 249473 DPW Maintained 1 Quercus suber :: Cork Oak 78 1100x Van Ness Ave 1 Median : Yard Tree DPW 1     14     6006432.64407 2114489.3949 37.7863482830936 -122.421511143829 (37.7863482830936, -122.421511143829) 13 9 11 28858 41
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
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
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
161102 240346 DPW Maintained 1 Quercus suber :: Cork Oak 78 1201 San Jose Ave 14 Front Yard : Yard Tree Private 2     1     6004285.4248 2095936.19817 37.7352843186184 -122.427617650241 (37.7352843186184, -122.427617650241) 2 7 5 28861 2
160784 197265 DPW Maintained 1 Quercus suber :: Cork Oak 78 1328 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017187.84442 2095472.38417 37.7347321474566 -122.382976523354 (37.7347321474566, -122.382976523354) 10 3 8 58 1
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
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
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
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
158965 197249 DPW Maintained 1 Quercus suber :: Cork Oak 78 1339 Hudson Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017286.5777 2095179.92105 37.733934556716 -122.382614821425 (37.733934556716, -122.382614821425) 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
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
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
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
154453 197238 DPW Maintained 1 Quercus suber :: Cork Oak 78 1101 Illinois St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6016145.70434 2103719.54836 37.7573195208837 -122.387154647679 (37.7573195208837, -122.387154647679) 10 3 8 28856 29
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
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
151505 29785 DPW Maintained 1 Quercus suber :: Cork Oak 78 2000x Van Ness Ave 1 Median : Cutout Tree DPW 1   03/12/2006 12:00:00 AM 4 5x5   6006071.7874482 2117255.4874462 37.7939229310388 -122.422956286012 (37.7939229310388, -122.422956286012) 13 9 10 28858 32
149866 240363 DPW Maintained 1 Quercus suber :: Cork Oak 78 19 Ohlone Way 1 Back Yard : Yard Tree Private 2     3 Width 2ft   6002113.49716 2096265.44164 37.7360652530044 -122.435150333941 (37.7360652530044, -122.435150333941) 2 7 5 63 7
148755 197250 DPW Maintained 1 Quercus suber :: Cork Oak 78 1337 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017426.32364 2094968.1062 37.7333606741381 -122.382116942362 (37.7333606741381, -122.382116942362) 10 3 8 58 1
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
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
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
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
144852 179366 DPW Maintained 1 Quercus suber :: Cork Oak 78 2300 San Bruno Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010245.15068 2095586.70884 37.7346600002662 -122.406987961537 (37.7346600002662, -122.406987961537) 10 3 7 309 28
144344 29654 DPW Maintained 1 Quercus suber :: Cork Oak 78 1500X La Salle Ave 13 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015636.0426 2096086.4462 37.7363323716667 -122.388384525603 (37.7363323716667, -122.388384525603) 10 3 8 58 1
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
141560 197253 DPW Maintained 1 Quercus suber :: Cork Oak 78 1333 Hudson Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017800.41079 2094649.24699 37.7325058028811 -122.380801447334 (37.7325058028811, -122.380801447334) 10 3 8 58 1
139403 100171 Significant Tree 6 Quercus suber :: Cork Oak 78 109 Edgewood Ave 1 Front Yard : Yard Tree Private 2           5996563.8 2106359.1 37.763463224844 -122.455066914463 (37.763463224844, -122.455066914463) 15 5 11 29492 12
139219 15047 DPW Maintained 1 Quercus suber :: Cork Oak 78 1115 Mendell St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2008 12:00:00 AM 3 3x3   6015512.6554 2096045.3172 37.7362126017611 -122.388808259867 (37.7362126017611, -122.388808259867) 10 3 8 58 1
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
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
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
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
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
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
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
131145 197237 DPW Maintained 1 Quercus suber :: Cork Oak 78 1101 Illinois St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6016149.20682 2103671.84274 37.7571887253073 -122.387139207224 (37.7571887253073, -122.387139207224) 10 3 8 28856 29
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
127393 3578 Permitted Site 7 Quercus suber :: Cork Oak 78 100X Cargo Way 13 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 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
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
122943 14893 DPW Maintained 1 Quercus suber :: Cork Oak 78 151 Mendell St 7 Sidewalk: Curb side : Cutout Tree DPW 1   12/21/2008 12:00:00 AM 3 3x3   6017107.5762 2098575.41356 37.7432480069006 -122.38346998587 (37.7432480069006, -122.38346998587) 10 3 8 58 1
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
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
119990 179367 DPW Maintained 1 Quercus suber :: Cork Oak 78 2302 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010293.44641 2095472.02067 37.7343477934225 -122.406812905791 (37.7343477934225, -122.406812905791) 10 3 7 309 28
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
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
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
116226 3658 DPW Maintained 1 Quercus suber :: Cork Oak 78 100X Cargo Way 94 Sidewalk: Curb side : Cutout Tree Port 6     6 3x3   6017265.72601 2098814.03291 37.7439119466908 -122.382939742901 (37.7439119466908, -122.382939742901) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
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
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
103538 197252 DPW Maintained 1 Quercus suber :: Cork Oak 78 1333 Hudson Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017782.90663 2094656.28102 37.7325241508658 -122.38086245284 (37.7325241508658, -122.38086245284) 10 3 8 58 1
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
102906 29780 DPW Maintained 1 Quercus suber :: Cork Oak 78 2000X Van Ness Ave 1 Median : Cutout Tree DPW 1   03/12/2006 12:00:00 AM 4 5x5   6006071.7874482 2117255.4874462 37.7939229310388 -122.422956286012 (37.7939229310388, -122.422956286012) 13 9 10 28858 32
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);