254 rows where qSpecies_id = 78 sorted by qSiteInfo

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)
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
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
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
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
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
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
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
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
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
27937 240347 DPW Maintained 1 Quercus suber :: Cork Oak 78 1201 San Jose Ave 16 Front Yard : Yard Tree Private 2     1     6004297.07476 2095945.05367 37.7353092927844 -122.427578002737 (37.7353092927844, -122.427578002737) 2 7 5 28861 2
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
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
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
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
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
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
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
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
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
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
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
17228 29643 DPW Maintained 1 Quercus suber :: Cork Oak 78 1500X La Salle Ave 2 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015873.398 2095908.1157 37.7358558618741 -122.387551444245 (37.7358558618741, -122.387551444245) 10 3 8 58 1
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
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
38538 119910 DPW Maintained 1 Quercus suber :: Cork Oak 78 1500X La Salle Ave 15 Median : Cutout Tree DPW 1       12x31   6015992.6911276 2095862.2429535 37.735736511316 -122.38713579848 (37.735736511316, -122.38713579848) 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
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
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
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
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
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
80580 29655 DPW Maintained 1 Quercus suber :: Cork Oak 78 1500X La Salle Ave 15 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015616.5769 2096101.5164 37.7363726727082 -122.388452878787 (37.7363726727082, -122.388452878787) 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
96482 29653 DPW Maintained 1 Quercus suber :: Cork Oak 78 1500X La Salle Ave 12 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015651.7407 2096073.8877 37.7362987584373 -122.388329374012 (37.7362987584373, -122.388329374012) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1709 224383 Permitted Site 7 Quercus suber :: Cork Oak 78 125 Julian Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2019 12:00:00 AM 3 5x5 Permit Number 778492 6006444.85004 2107119.85754 37.7661139992865 -122.420945489154 (37.7661139992865, -122.420945489154) 8 4 7 28853 19
1983 197256 DPW Maintained 1 Quercus suber :: Cork Oak 78 1320 Hudson Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6018044.32152 2094632.22344 37.732472518087 -122.379956998329 (37.732472518087, -122.379956998329) 10 3 8 58 1
3206 83039 DPW Maintained 1 Quercus suber :: Cork Oak 78 100X Cargo Way 13 Sidewalk: Curb side : Cutout Tree Port 6     12     6018611.72965 2097767.00037 37.7411112833697 -122.378212851336 (37.7411112833697, -122.378212851336) 10 3 8 58 1
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
3911 197246 DPW Maintained 1 Quercus suber :: Cork Oak 78 1339 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017203.85974 2095339.70133 37.7343687116489 -122.382911921471 (37.7343687116489, -122.382911921471) 10 3 8 58 1
5519 251279 DPW Maintained 1 Quercus suber :: Cork Oak 78 1200x Hudson Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6017356 2095183 37.733946845802 -122.382375019073 (37.733946845802, -122.382375019073) 10 3 8 58 1
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
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
12987 27593 DPW Maintained 1 Quercus suber :: Cork Oak 78 2200X San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/21/2001 12:00:00 AM 12 3X3   6010149.0566544 2095763.2891254 37.7351394742744 -122.407332636882 (37.7351394742744, -122.407332636882) 10 7 7 309 28
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
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
13584 170477 DPW Maintained 1 Quercus suber :: Cork Oak 78 17 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6003910.26031 2094625.94541 37.7316654323041 -122.428821353234 (37.7316654323041, -122.428821353234) 9 7 5 28861 25
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
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                      
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
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
15199 778 DPW Maintained 1 Quercus suber :: Cork Oak 78 1800X 37th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/14/2006 12:00:00 AM 3 3X3   5984768.5556 2102340.232 37.7517447878795 -122.49556583439 (37.7517447878795, -122.49556583439) 1 8 3 56 35
15250 222585 DPW Maintained 1 Quercus suber :: Cork Oak 78 219 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6001765.70571 2104562.10445 37.7588261686132 -122.436946567843 (37.7588261686132, -122.436946567843) 2 4 5 28862 3
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
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
18244 222586 DPW Maintained 1 Quercus suber :: Cork Oak 78 219 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6001763.88203 2104576.51068 37.7588656209757 -122.436953906316 (37.7588656209757, -122.436953906316) 2 4 5 28862 3
18663 83040 DPW Maintained 1 Quercus suber :: Cork Oak 78 100X Cargo Way 12 Sidewalk: Curb side : Cutout Tree Port 6     6     6018704.22704 2097697.64106 37.740925933998 -122.377888212277 (37.740925933998, -122.377888212277) 10 3 8 58 1
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
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
19437 3542 DPW Maintained 1 Quercus suber :: Cork Oak 78 201X Cargo Way 52 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2006 12:00:00 AM 3 3X3   6018537.99972 2097717.76917 37.7409720404334 -122.378464368331 (37.7409720404334, -122.378464368331) 10 3 8 58 1
19687 10849 DPW Maintained 1 Quercus suber :: Cork Oak 78 1220X Hudson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 6 3X4   6017356.4574634 2095156.0177673 37.7338727832056 -122.382371560842 (37.7338727832056, -122.382371560842) 10 3 8 58 1
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

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