trees

3,587 rows where qSpecies_id = 28 sorted by TreeID

✎ View and edit SQL

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)
63627 104944 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 532 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
86228 104945 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 532 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
66095 104946 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 532 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
123860 104948 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 535 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
177371 104949 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 535 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
125250 104950 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
74833 104951 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
149012 104952 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
166348 104956 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 759 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
12565 104957 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 759 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
64576 104958 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 759 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
81822 104959 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 759 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
80991 105000 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 280X SAN MARCOS AVE 1 Median : Cutout Tree DPW 1     65   Tree tag no. 416 5993063.2 2100277.9 37.7465643757171 -122.466732187112 (37.7465643757171, -122.466732187112) 1 8 4 29491 40
179978 105160 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1600X OAKDALE AVE 1 Front Yard : Yard Tree Arts Commission 19     13   Permit Number 770204 6015006 2095503 37.7346954145828 -122.390522107646 (37.7346954145828, -122.390522107646) 10 3 8 58 1
133384 105167 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 4755X 03RD ST 1 Front Yard : Cutout Tree Arts Commission 19     8 3x3   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
15723 105168 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 4755X 03RD ST 2 Front Yard : Cutout Tree Arts Commission 19     23 3x3 Permit Number 770204 6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
57045 105169 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 4755X 03RD ST 3 Front Yard : Cutout Tree Arts Commission 19     23 4x4   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
145448 105217 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2100 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   5999896.62594 2116125.07257 37.7904687293982 -122.44424160569 (37.7904687293982, -122.44424160569) 13 6 1 29490 27
124373 105289 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 528-530 NOE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 6x8   6002937.9 2105119.7 37.7604237469391 -122.432932416408 (37.7604237469391, -122.432932416408) 2 4 5 28862 3
137373 10569 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1627X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6001688.62119 2092532.05532 37.7257900940002 -122.436352188242 (37.7257900940002, -122.436352188242) 9 7 6 28861 25
84077 105690 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 701X DUBOCE AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     12 6x10   6002306 2108287 37.7690845180814 -122.435344429196 (37.7690845180814, -122.435344429196) 15 5 5 28862 3
157604 105712 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 901 Balboa St 3 Sidewalk: Curb side : Cutout Tree Private 2     26 5x5   5992769.34278 2111348.54699 37.7769444989414 -122.468553656228 (37.7769444989414, -122.468553656228) 11 6 2 54 11
165083 105749 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 200X NORIEGA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     40 4x4   5993413 2103282 37.7548330463317 -122.46574085189 (37.7548330463317, -122.46574085189) 1 8 4 56 12
45323 105766 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 280 RUTLEDGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3   6009844.3 2099431 37.7451931526373 -122.408644950144 (37.7451931526373, -122.408644950144) 2 7 7 28859 2
169013 105767 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 245 RUTLEDGE ST   Sidewalk: Curb side : Cutout Tree Private 2     26 3x3   6010031.3 2099465.2 37.7452975299559 -122.40800074457 (37.7452975299559, -122.40800074457) 2 7 7 28859 2
76185 105867 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 2 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
186539 105868 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 3 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
73380 105869 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 4 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
145596 105870 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 5 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
178545 105871 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 6 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
81248 105890 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1100 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5999444.5 2109060.1 37.7710443339737 -122.445297745357 (37.7710443339737, -122.445297745357) 15 5 11 29492 9
3865 105892 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1100 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5999444.5 2109060.1 37.7710443339737 -122.445297745357 (37.7710443339737, -122.445297745357) 15 5 11 29492 9
179036 105893 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1100 Masonic Ave 4 Sidewalk: Curb side : Cutout Tree Private 2           5999444.5 2109060.1 37.7710443339737 -122.445297745357 (37.7710443339737, -122.445297745357) 15 5 11 29492 9
79247 106168 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1052 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     18     6012164.74783 2103476.70855 37.7564314799541 -122.400905383382 (37.7564314799541, -122.400905383382) 10 3 8 28856 29
52000 106170 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 99X THOR AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     24 4x4   6002346 2095994 37.7353331366469 -122.434327078202 (37.7353331366469, -122.434327078202) 2 7 5 63 7
171336 106295 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 535 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   5991244.063 2111740.20386 37.7779316560453 -122.473858594256 (37.7779316560453, -122.473858594256) 11 6 2 54 26
62295 106457 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1x CHESTNUT ST 14 Sidewalk: Curb side : Cutout Tree Private 2           6011546 2121132 37.8048742648975 -122.404287845465 (37.8048742648975, -122.404287845465) 3 1 10 28860 6
98691 106500 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 420X Shrader St 3 Sidewalk: Curb side : Cutout Tree Private 2           5997462.73555 2109001.92463 37.7707712761397 -122.452148498658 (37.7707712761397, -122.452148498658) 15 5 11 29492 9
114681 106527 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2100 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2     15     5999890.20621 2116153.78918 37.7905472114236 -122.444265881958 (37.7905472114236, -122.444265881958) 13 6 1 29490 27
4413 106528 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2100 Baker St 4 Sidewalk: Curb side : Cutout Tree Private 2     23     5999888.51189 2116174.57366 37.7906041834903 -122.444273238422 (37.7906041834903, -122.444273238422) 13 6 1 29490 27
32026 106549 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2221 LARKIN ST 4 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6006757.8 2118838.2 37.7983073484274 -122.420695021037 (37.7983073484274, -122.420695021037) 13 9 10 28858 32
49434 10667 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1021 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3X3   6002954.21433 2110590.33753 37.7754457061984 -122.433266902977 (37.7754457061984, -122.433266902977) 15 5 11 29492 10
12051 106705 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 199X BRIGHTON AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     24     5996224 2090880 37.7209419254054 -122.455123542447 (37.7209419254054, -122.455123542447) 9 8 6 28861 24
74316 106886 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 580 Commercial St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2014 12:00:00 AM 3   Permit Number 772874 6011893.85928 2117261.69096 37.7942667642387 -122.402811670039 (37.7942667642387, -122.402811670039) 3 1 10 28860 4
132167 106904 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 20X MAYFAIR DR 12 Sidewalk: Curb side : Cutout Tree Private 2     20     5997868 2114773 37.7866403525015 -122.451162941103 (37.7866403525015, -122.451162941103) 11 6 1 54 31
173988 106905 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 20X MAYFAIR DR 13 Sidewalk: Curb side : Cutout Tree Private 2     16     5997868 2114773 37.7866403525015 -122.451162941103 (37.7866403525015, -122.451162941103) 11 6 1 54 31
126266 106906 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 20X MAYFAIR DR 14 Sidewalk: Curb side : Cutout Tree Private 2     18     5997868 2114773 37.7866403525015 -122.451162941103 (37.7866403525015, -122.451162941103) 11 6 1 54 31
178498 106907 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 20X MAYFAIR DR 11 Sidewalk: Curb side : Cutout Tree Private 2           5998146 2114573 37.7861071180483 -122.450186711437 (37.7861071180483, -122.450186711437) 11 6 1 54 31
192542 106951 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 156 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2014 12:00:00 AM 22 3x3 Permit Number 773389 5987431.57269 2114958.38797 37.7865463157209 -122.487283609867 (37.7865463157209, -122.487283609867) 11 6 1 55 33
157973 107051 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 450 Walnut St 2 Sidewalk: Curb side : Cutout Tree Private 2           5998625.9783 2115075.11894 37.7875132600186 -122.448562297399 (37.7875132600186, -122.448562297399) 13 6 1 54 31
53489 107162 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 798X 07TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2           5993812 2110401 37.7744029620428 -122.464877983618 (37.7744029620428, -122.464877983618) 11 6 2 54 11
69561 107165 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1298X HUDSON AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1     22 3x3   6017281 2095243 37.734107450868 -122.382638493216 (37.734107450868, -122.382638493216) 10 3 8 58 1
43481 107218 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 100 WINSTON DR 1 Sidewalk: Curb side : Cutout Tree Private 2     42     5990934.3 2093194.2 37.7269912477326 -122.473576991848 (37.7269912477326, -122.473576991848) 9 8 4 64 40
141196 107220 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 100 WINSTON DR 3 Sidewalk: Curb side : Cutout Tree Private 2           5990934.3 2093194.2 37.7269912477326 -122.473576991848 (37.7269912477326, -122.473576991848) 9 8 4 64 40
145056 107232 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2265 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6006749.11596 2119031.04722 37.7988363688534 -122.420738768293 (37.7988363688534, -122.420738768293) 5 9 10 28858 32
119385 107299 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 955 SOUTH VAN NESS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     18 7x6   6007636.8 2104105.7 37.7579049366557 -122.416609217837 (37.7579049366557, -122.416609217837) 2 4 7 28859 19
50840 107446 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 683 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 6x9   5992221.43699 2110812.70882 37.7754415677969 -122.470409979859 (37.7754415677969, -122.470409979859) 11 6 2 54 11
170537 107658 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 660 COLE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 7x9   5997954.3 2108255.2 37.768749107551 -122.450394337656 (37.768749107551, -122.450394337656) 15 5 11 29492 9
182528 107815 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 311 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   5986808.71714 2113837.73031 37.7834329707826 -122.489356078034 (37.7834329707826, -122.489356078034) 11 6 2 55 26
164005 107832 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 100X SUSSEX ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6002188 2096682 37.7372132564844 -122.434922529204 (37.7372132564844, -122.434922529204) 2 7 5 63 7
44180 107833 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 100X SUSSEX ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6002188 2096682 37.7372132564844 -122.434922529204 (37.7372132564844, -122.434922529204) 2 7 5 63 7
140859 107838 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1000x LEAVENWORTH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
85016 107866 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 300 ALEMANY BLVD 1 Sidewalk: Property side : Cutout Tree PUC 8     15 3x3   6008820.4 2095497.5 37.7343352217744 -122.411907523711 (37.7343352217744, -122.411907523711) 10 7 7 28859 2
111799 108018 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 109 ALPINE TER   Sidewalk: Curb side : Cutout Tree Private 2     20 4x7   6001716.4 2108199.1 37.7688096651516 -122.43737752181 (37.7688096651516, -122.43737752181) 15 5 5 29492 3
82550 108113 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 786 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2       7x7   5998636 2107697 37.7672554233108 -122.447996203185 (37.7672554233108, -122.447996203185) 15 5 11 29492 9
193169 108114 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 786 Clayton St 3 Sidewalk: Curb side : Cutout Tree Private 2       7x7   5998636 2107697 37.7672554233108 -122.447996203185 (37.7672554233108, -122.447996203185) 15 5 11 29492 9
156160 108314 Private 9 Corymbia ficifolia :: Red Flowering Gum 28 2501X DIAMOND ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002141 2097265 37.7388113707969 -122.435126715418 (37.7388113707969, -122.435126715418) 2 7 5 63 7
57823 108319 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1350X Keith St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   6016176.6854 2094790.4104 37.7328036614551 -122.386424944191 (37.7328036614551, -122.386424944191) 10 3 8 58 1
54922 108321 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1350X Keith St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   6016155.336 2094757.7583 37.7327128234907 -122.386496479231 (37.7327128234907, -122.386496479231) 10 3 8 58 1
193020 108614 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1847 GRANT AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6010358.9 2120872.9 37.8040964350925 -122.408377664827 (37.8040964350925, -122.408377664827) 3 1 10 308 23
111150 108755 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 200x Hester Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6012748.71102 2087691.71249 37.7131217210609 -122.397778647462 (37.7131217210609, -122.397778647462) 10 3 8 309 1
128876 108757 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 210x Hester Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6012680.34873 2087652.65908 37.7130106808854 -122.3980121942 (37.7130106808854, -122.3980121942) 10 3 8 309 1
7358 108758 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1449 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2           5999638.3 2109087.9 37.7711317264146 -122.444629385712 (37.7711317264146, -122.444629385712) 15 5 11 29492 9
131419 108759 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1443 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2           5999670.4 2109034 37.7709855623052 -122.444514476591 (37.7709855623052, -122.444514476591) 15 5 11 29492 9
159848 108960 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 399X ORTEGA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992998 2102542 37.7527772506572 -122.467122225509 (37.7527772506572, -122.467122225509) 1 8 4 29491 12
181309 108961 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 399X ORTEGA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992998 2102542 37.7527772506572 -122.467122225509 (37.7527772506572, -122.467122225509) 1 8 4 29491 12
133355 109015 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1800x FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007970.1 2107738.8 37.7678993280557 -122.415713764528 (37.7678993280557, -122.415713764528) 8 4 7 28853 19
70746 109021 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1800x FOLSOM ST 21 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007970.1 2107738.8 37.7678993280557 -122.415713764528 (37.7678993280557, -122.415713764528) 8 4 7 28853 19
87338 109022 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1800x FOLSOM ST 22 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007970.1 2107738.8 37.7678993280557 -122.415713764528 (37.7678993280557, -122.415713764528) 8 4 7 28853 19
78725 109023 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1800x FOLSOM ST 23 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007970.1 2107738.8 37.7678993280557 -122.415713764528 (37.7678993280557, -122.415713764528) 8 4 7 28853 19
144625 109024 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1800x FOLSOM ST 24 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007970.1 2107738.8 37.7678993280557 -122.415713764528 (37.7678993280557, -122.415713764528) 8 4 7 28853 19
163844 109025 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1800x FOLSOM ST 25 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007970.1 2107738.8 37.7678993280557 -122.415713764528 (37.7678993280557, -122.415713764528) 8 4 7 28853 19
156619 109026 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1800x FOLSOM ST 26 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007970.1 2107738.8 37.7678993280557 -122.415713764528 (37.7678993280557, -122.415713764528) 8 4 7 28853 19
191884 109027 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1800x FOLSOM ST 27 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007970.1 2107738.8 37.7678993280557 -122.415713764528 (37.7678993280557, -122.415713764528) 8 4 7 28853 19
163911 109028 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1800x FOLSOM ST 28 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007970.1 2107738.8 37.7678993280557 -122.415713764528 (37.7678993280557, -122.415713764528) 8 4 7 28853 19
86646 109112 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 432X FREDERICK ST 2 Sidewalk: Curb side : Cutout Tree Private 2     14 6x7   5997770.4 2107507.4 37.7666853128725 -122.450976500583 (37.7666853128725, -122.450976500583) 15 5 11 29492 9
39653 109179 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 301x 28TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6003894 2099493 37.7450283339929 -122.429224487562 (37.7450283339929, -122.429224487562) 2 7 5 63 22
53412 109180 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 301x 28TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003894 2099493 37.7450283339929 -122.429224487562 (37.7450283339929, -122.429224487562) 2 7 5 63 22
182086 109181 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 301x 28TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003894 2099493 37.7450283339929 -122.429224487562 (37.7450283339929, -122.429224487562) 2 7 5 63 22
173256 109240 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 737 Buena Vista Ave 5 Sidewalk: Curb side : Cutout Tree Private 2           5999798.5 2108081.7 37.7683780948237 -122.444002941237 (37.7683780948237, -122.444002941237) 15 5 11 29492 9
156324 109269 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 875x CHENERY ST 2 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6001242 2095902 37.7350178001347 -122.438137418666 (37.7350178001347, -122.438137418666) 2 7 5 63 7
68465 109270 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 875x CHENERY ST 3 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6001242 2095902 37.7350178001347 -122.438137418666 (37.7350178001347, -122.438137418666) 2 7 5 63 7
136392 109847 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 535 CLAY ST 4 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6012019 2117742 37.7955925645 -122.402412455116 (37.7955925645, -122.402412455116) 3 1 10 28860 4
113180 109880 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1520 PAGE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       6x8   5999172.7 2109108.7 37.7711622584795 -122.446241403234 (37.7711622584795, -122.446241403234) 15 5 11 29492 9
82434 109881 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1520 PAGE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       6x8   5999172.7 2109108.7 37.7711622584795 -122.446241403234 (37.7711622584795, -122.446241403234) 15 5 11 29492 9
142372 109883 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1520 PAGE ST 5 Sidewalk: Curb side : Cutout Tree Private 2       6x8   5999172.7 2109108.7 37.7711622584795 -122.446241403234 (37.7711622584795, -122.446241403234) 15 5 11 29492 9
60081 10996 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1516 Hudson Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 11x7   6016146.6437344 2097132.6899249 37.7392334258448 -122.386692084549 (37.7392334258448, -122.386692084549) 10 3 8 58 1
134088 110013 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 116 Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6006793.95878445 2098914.89332793 37.7436047263526 -122.419155928098 (37.7436047263526, -122.419155928098) 2 7 7 28859 2
12838 110205 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2113 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     26 6x6   6000355.27236 2115993.16696 37.7901327067156 -122.442645247897 (37.7901327067156, -122.442645247897) 13 6 1 29490 27
129569 110219 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600X QUINTARA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     25 6x20   5991588 2101192 37.7489890115011 -122.471899832047 (37.7489890115011, -122.471899832047) 1 8 4 29491 12

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