254 rows where qSpecies_id = 78 sorted by Fire Prevention Districts

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1119 113031 DPW Maintained 1 Quercus suber :: Cork Oak 78 251 06th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     14 3x3   5993971.49407 2113867.66105 37.7839306754778 -122.464578040665 (37.7839306754778, -122.464578040665) 11 6 2 54 11
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
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
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
20823 23388 DPW Maintained 1 Quercus suber :: Cork Oak 78 1500X Van Ness Ave 1 Median : Cutout Tree DPW 1   06/09/2005 12:00:00 AM 6 G   6006302.3156668 2115604.1529311 37.789401783497 -122.42204126893 (37.789401783497, -122.42204126893) 13 9 10 28858 21
36962 249474 DPW Maintained 1 Quercus suber :: Cork Oak 78 1200x Van Ness Ave 1 Median : Yard Tree DPW 1     8     6006395.0323 2114736.35179 37.7870242450239 -122.421658817911 (37.7870242450239, -122.421658817911) 13 9 1 28858 21
38964 29684 DPW Maintained 1 Quercus suber :: Cork Oak 78 2000X Van Ness Ave 2 Median : Cutout Tree DPW 1     24     6006028.67336 2117355.72849 37.7941957348865 -122.423112593587 (37.7941957348865, -122.423112593587) 13 9 10 28858 32
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
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
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
70792 23332 DPW Maintained 1 Quercus suber :: Cork Oak 78 1142X Van Ness Ave 1 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
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
77034 23354 DPW Maintained 1 Quercus suber :: Cork Oak 78 1250X Van Ness Ave 1 Median : Cutout Tree DPW 1   12/01/2003 12:00:00 AM 3 9   6006448.1236467 2114767.6788933 37.7871132551315 -122.421477359088 (37.7871132551315, -122.421477359088) 13 9 10 28858 21
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
91055 249487 DPW Maintained 1 Quercus suber :: Cork Oak 78 1500x Van Ness Ave 1 Median : Yard Tree DPW 1     13     6006262.64335 2115713.01946 37.7896984663527 -122.422186268479 (37.7896984663527, -122.422186268479) 13 9 1 28858 21
92608 136294 DPW Maintained 1 Quercus suber :: Cork Oak 78 1500x Van Ness Ave 6 Median : Yard Tree DPW 1     14     6006242.09436 2115852.50489 37.7900802996014 -122.422267280337 (37.7900802996014, -122.422267280337) 13 9 1 28858 21
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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