trees

3,587 rows where qSpecies_id = 28 sorted by XCoord

✎ 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)
103454 250661 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 620 El Camino Del Mar 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5986629.19669 2115016.79506 37.7866598622128 -122.490063893129 (37.7866598622128, -122.490063893129) 11 6 1 55 33
52470 250742 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2840 Lake St 1 Sidewalk: Curb side : Yard Tree Private 2     20 Width 4ft   5986642.93068 2114467.77379 37.7851532099925 -122.489975981713 (37.7851532099925, -122.489975981713) 11 6 1 55 33
62793 250741 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2820 Lake St 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5986676.6053 2114467.05765 37.7851532099869 -122.489859426897 (37.7851532099869, -122.489859426897) 11 6 1 55 33
36389 120124 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 620 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5986678 2115081 37.7868390002377 -122.489899771602 (37.7868390002377, -122.489899771602) 11 6 1 55 33
69204 120126 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 620 El Camino Del Mar 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5986678 2115081 37.7868390002377 -122.489899771602 (37.7868390002377, -122.489899771602) 11 6 1 55 33
114695 120127 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 620 El Camino Del Mar 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5986678 2115081 37.7868390002377 -122.489899771602 (37.7868390002377, -122.489899771602) 11 6 1 55 33
175508 120125 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 620 El Camino Del Mar 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5986678 2115081 37.7868390002377 -122.489899771602 (37.7868390002377, -122.489899771602) 11 6 1 55 33
175673 250740 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2820 Lake St 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5986687.60002 2114465.60377 37.785149860023 -122.489821282139 (37.785149860023, -122.489821282139) 11 6 1 55 33
41557 115704 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2820 LAKE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x15   5986689 2114483 37.7851977068092 -122.489817718558 (37.7851977068092, -122.489817718558) 11 6 1 55 33
126422 250739 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2820 Lake St 1 Sidewalk: Curb side : Yard Tree Private 2     22 Width 4ft   5986710.27993 2114466.34156 37.785153210004 -122.48974287205 (37.785153210004, -122.48974287205) 11 6 1 55 33
157099 250879 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 123 29th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   5986776.16352 2114759.61772 37.7859623084516 -122.489536511807 (37.7859623084516, -122.489536511807) 11 6 1 55 33
183180 250880 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 123 29th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   5986777.36802 2114746.25153 37.7859256790604 -122.489531361397 (37.7859256790604, -122.489531361397) 11 6 1 55 33
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
87638 120018 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 333 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5986813.06354 2113669.74125 37.7829719746526 -122.489328685687 (37.7829719746526, -122.489328685687) 11 6 2 55 26
65120 120017 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 343 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5986815.03872 2113631.20342 37.7828662761015 -122.48931901802 (37.7828662761015, -122.48931901802) 11 6 2 55 26
186926 250622 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 122 28th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   5987113.07989 2115137.65362 37.7870199498697 -122.48839868145 (37.7870199498697, -122.48839868145) 11 6 1 55 33
110328 250621 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 122 28th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     18 Width 4ft   5987113.38286 2115127.17746 37.7869912030255 -122.48839686305 (37.7869912030255, -122.48839686305) 11 6 1 55 33
174602 119961 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 450 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   5987197.92043 2112907.45085 37.7809014005793 -122.487941229653 (37.7809014005793, -122.487941229653) 11 6 2 55 26
27213 87671 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 450 El Camino Del Mar 1 Sidewalk: Property side : Cutout Tree Private 2   05/22/2008 12:00:00 AM   3x3 Permit Number 50395 5987244 2115292 37.7874513785554 -122.487957078163 (37.7874513785554, -122.487957078163) 11 6 1 55 33
89523 43346 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 5200 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2000 12:00:00 AM     Permit Number 43101 5987278.98724374 2109843.31804433 37.7724928847849 -122.487435636536 (37.7724928847849, -122.487435636536) 11 6 2 55 26
114643 43348 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 5200 Fulton St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2000 12:00:00 AM     Permit Number 43101 5987278.98724374 2109843.31804433 37.7724928847849 -122.487435636536 (37.7724928847849, -122.487435636536) 11 6 2 55 26
177436 43347 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 5200 Fulton St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2000 12:00:00 AM     Permit Number 43101 5987278.98724374 2109843.31804433 37.7724928847849 -122.487435636536 (37.7724928847849, -122.487435636536) 11 6 2 55 26
124744 250333 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 135 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5987387.37303 2115049.79038 37.7867947029504 -122.487443244435 (37.7867947029504, -122.487443244435) 11 6 1 55 33
143890 250325 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 165 27th Ave 1 : Tree Private 2     13 Width 3ft   5987394.93306 2114848.62147 37.7862427917124 -122.487402306398 (37.7862427917124, -122.487402306398) 11 6 1 55 33
65460 68443 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1274 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/26/1993 12:00:00 AM 26 7.5x7.5 Permit Number 32300 5987418.73686806 2106612.65804585 37.7636305377833 -122.486714964872 (37.7636305377833, -122.486714964872) 1 8 3 56 35
186867 65689 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3601 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/17/1990 12:00:00 AM 15 4x3 Permit Number 28615 5987420.04323 2111837.39532 37.7779762857803 -122.487094195586 (37.7779762857803, -122.487094195586) 11 6 2 55 26
17574 120058 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 132 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     37 Width 4ft   5987428.81431 2115064.18199 37.7868366349011 -122.487300926674 (37.7868366349011, -122.487300926674) 11 6 1 55 33
143505 120056 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 142 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5987429.57525 2114999.01583 37.7866577516935 -122.487293505702 (37.7866577516935, -122.487293505702) 11 6 1 55 33
154915 120057 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 142 27th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     31 Width 4ft   5987429.90023 2115014.31734 37.7866997842021 -122.487293505698 (37.7866997842021, -122.487293505698) 11 6 1 55 33
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
99973 120055 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 146 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 5ft   5987431.73679 2114982.94917 37.7866137633018 -122.487284846841 (37.7866137633018, -122.487284846841) 11 6 1 55 33
158172 120053 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 158 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   5987432.11782 2114926.05688 37.7864575756069 -122.487279348253 (37.7864575756069, -122.487279348253) 11 6 1 55 33
75671 120054 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 158 27th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5987432.2307 2114943.781 37.786506247541 -122.487280260053 (37.786506247541, -122.487280260053) 11 6 1 55 33
188890 119976 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 790 27th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 6ft   5987592.78191 2110583.46178 37.7745434075019 -122.486404553553 (37.7745434075019, -122.486404553553) 11 6 2 55 26
124530 121412 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2548 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   5987616 2110573 37.7745160357052 -122.486323470467 (37.7745160357052, -122.486323470467) 11 6 2 55 26
19739 119985 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2512 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 5ft   5987666.80033 2110540.30319 37.7744292202448 -122.486145343797 (37.7744292202448, -122.486145343797) 11 6 2 55 26
66897 120074 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 135 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 4ft   5987695.47672 2115079.1685 37.7868933302758 -122.486379449256 (37.7868933302758, -122.486379449256) 11 6 1 55 33
24858 120075 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 135 26th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5987696.45298 2115057.78701 37.7868346797306 -122.486374501304 (37.7868346797306, -122.486374501304) 11 6 1 55 33
129237 102733 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 227 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2     19 6x12   5987865.55593 2115301.49013 37.7875136738907 -122.485807345479 (37.7875136738907, -122.485807345479) 11 6 1 55 33
37527 120384 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 221 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5987878.79334 2115302.0322 37.7875159336053 -122.485761587082 (37.7875159336053, -122.485761587082) 11 6 1 55 33
145949 120382 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 209 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5987947.25387 2115304.74454 37.7875273698347 -122.485524929516 (37.7875273698347, -122.485524929516) 11 6 1 55 33
104513 19428 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1200X Sloat Blvd 1 Median : Cutout Tree DPW 1   11/13/2007 12:00:00 AM 3 20   5987947.5018995 2095985.7700738 37.7344827526385 -122.484106799366 (37.7344827526385, -122.484106799366) 1 8 3 64 35
79713 120222 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 250 25th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 3ft   5988081.00935 2114311.02027 37.7848066783881 -122.484989234462 (37.7848066783881, -122.484989234462) 11 6 2 55 26
20479 120223 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 250 25th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5988081.34041 2114326.62635 37.7848495475274 -122.484989234472 (37.7848495475274, -122.484989234472) 11 6 2 55 26
136082 120221 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 250 25th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   5988083.13088 2114289.30079 37.7847471664462 -122.484980300734 (37.7847471664462, -122.484980300734) 11 6 2 55 26
78543 182811 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1808 26th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 0ft   5988164.7245 2103004.1689 37.7537660663924 -122.483870250853 (37.7537660663924, -122.483870250853) 1 8 3 56 35
89318 182809 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1812 26th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5988165.2943 2102980.2378 37.7537003911945 -122.483866525764 (37.7537003911945, -122.483866525764) 1 8 3 56 35
47003 182810 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1810 26th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   5988165.8641 2102992.2034 37.7537332786865 -122.483865432602 (37.7537332786865, -122.483865432602) 1 8 3 56 35
92563 182808 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1814 26th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5988165.8641 2102960.2953 37.7536456676195 -122.483863093122 (37.7536456676195, -122.483863093122) 1 8 3 56 35
182506 30320 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 867 25th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/13/1955 12:00:00 AM     Permit Number 14 5988182.28713273 2110079.61323567 37.77319432354 -122.484328404455 (37.77319432354, -122.484328404455) 11 6 2 55 26
75357 251054 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 6000x Geary Blvd 5 Median : Yard Tree DPW 1     1 Width 10ft   5988209.3153 2112595.4218 37.7801036030677 -122.484419468966 (37.7801036030677, -122.484419468966) 11 6 2 55 26
101477 182806 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1851 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5988216.5752 2103026.3907 37.7538300998005 -122.483692570666 (37.7538300998005, -122.483692570666) 1 8 3 56 35
164520 182805 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1835 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   5988270.1353 2103027.5303 37.7538363463756 -122.483507433283 (37.7538363463756, -122.483507433283) 1 8 3 56 35
90328 96835 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 6001 Geary Blvd 1 Front Yard : Cutout Tree Private 2           5988352.4 2112527.1 37.779924341439 -122.483919468894 (37.779924341439, -122.483919468894) 11 6 2 55 26
25454 96949 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 798X 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5988521.18817 2110597.78203 37.7746367985505 -122.483194104095 (37.7746367985505, -122.483194104095) 11 6 2 55 26
152035 251051 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5900x Geary Blvd 5 Median : Yard Tree DPW 1     1 Width 10ft   5988530.6021 2112606.8245 37.7801536150187 -122.483308841687 (37.7801536150187, -122.483308841687) 11 6 2 55 26
140857 54249 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1274 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/31/1972 12:00:00 AM 20   Permit Number 9991 5988659.40013717 2106655.34316867 37.7638199891792 -122.482427078169 (37.7638199891792, -122.482427078169) 1 8 3 56 35
78513 95971 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5900 Geary Blvd 5 Median : Tree DPW 1   03/12/2011 12:00:00 AM 2     5988665.62185 2112680.21656 37.7803629858967 -122.482847132605 (37.7803629858967, -122.482847132605) 11 6 2 55 26
70073 120405 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 557 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 4ft   5988754.07512 2111518.78349 37.7771791619936 -122.482456009616 (37.7771791619936, -122.482456009616) 11 6 2 55 26
35363 51559 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 29 West Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47854 5988768.43262818 2115023.56671426 37.7868031451511 -122.48266323691 (37.7868031451511, -122.48266323691) 11 6 1 55 33
123608 51557 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 29 West Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/03/2005 12:00:00 AM     Permit Number 47854 5988768.43262818 2115023.56671426 37.7868031451511 -122.48266323691 (37.7868031451511, -122.48266323691) 11 6 1 55 33
171368 51558 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 29 West Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/03/2005 12:00:00 AM     Permit Number 47854 5988768.43262818 2115023.56671426 37.7868031451511 -122.48266323691 (37.7868031451511, -122.48266323691) 11 6 1 55 33
147246 12815 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2139 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5988780.51636 2114651.15635 37.7857813149586 -122.482594130976 (37.7857813149586, -122.482594130976) 11 6 2 55 26
95114 12813 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2122 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2008 12:00:00 AM 3 5   5988829.56201 2114710.83275 37.7859480226252 -122.482428823022 (37.7859480226252, -122.482428823022) 11 6 1 55 33
68726 176047 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard Tree Private 2     24     5988958.7133 2089588.42281 37.7169760831658 -122.480142699133 (37.7169760831658, -122.480142699133) 1 8 4 64 14
133551 19423 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 880X Sloat Blvd 1 Median : Cutout Tree DPW 1   11/13/2007 12:00:00 AM 3 20   5988998.1028282 2096024.0271709 37.7346489082814 -122.480477366023 (37.7346489082814, -122.480477366023) 1 8 3 64 35
21900 176048 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2     18     5989010.93647 2089619.81285 37.7170653066825 -122.479964486788 (37.7170653066825, -122.479964486788) 1 8 4 64 14
182033 176049 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard Tree Private 2     18     5989054.79394 2089564.29309 37.716915411303 -122.479808833919 (37.716915411303, -122.479808833919) 1 8 4 64 14
39739 176040 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     25     5989182.35151 2090508.47222 37.7195153009692 -122.479436972335 (37.7195153009692, -122.479436972335) 1 8 4 64 14
54735 176050 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2     13     5989206.75613 2089405.10082 37.7164871361381 -122.47927194137 (37.7164871361381, -122.47927194137) 1 8 4 64 14
106648 176051 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     25     5989218.52603 2089406.15184 37.7164907055632 -122.479231336085 (37.7164907055632, -122.479231336085) 1 8 4 64 14
179912 176053 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2     19     5989219.15665 2089312.55172 37.7162337395604 -122.479222313162 (37.7162337395604, -122.479222313162) 1 8 4 64 14
37254 176052 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2     17     5989234.20998 2089407.11974 37.7164942740645 -122.47917719598 (37.7164942740645, -122.47917719598) 1 8 4 64 14
113662 176042 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     19     5989234.3289 2090278.89103 37.7188879474116 -122.479240521736 (37.7188879474116, -122.479240521736) 1 8 4 64 14
58195 176054 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     16     5989245.31981 2089315.24778 37.7162426617475 -122.479132078791 (37.7162426617475, -122.479132078791) 1 8 4 64 14
163419 176043 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     19     5989267.95492 2090414.23117 37.7192615104927 -122.479134185915 (37.7192615104927, -122.479134185915) 1 8 4 64 14
58160 97331 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 139 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     25 9x6   5989269.62959 2114411.1007 37.7851506326758 -122.480884374701 (37.7851506326758, -122.480884374701) 11 6 2 55 26
155266 176055 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 7 Sidewalk: Curb side : Yard Tree Private 2     24     5989270.85841 2089380.99818 37.7164246791237 -122.479048612712 (37.7164246791237, -122.479048612712) 1 8 4 64 14
147050 176056 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard Tree Private 2     24     5989277.71826 2089365.90518 37.7163836358725 -122.479023798614 (37.7163836358725, -122.479023798614) 1 8 4 64 14
155164 176057 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard Tree Private 2     18     5989281.98257 2089351.51723 37.7163443777799 -122.479008007435 (37.7163443777799, -122.479008007435) 1 8 4 64 14
94149 115334 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 58 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     28 21x4   5989295.28706 2114885.33628 37.786454241014 -122.480830341017 (37.786454241014, -122.480830341017) 11 6 1 55 33
67263 120717 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 154 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 4ft   5989318.46035 2114318.61366 37.7848995275722 -122.480708664243 (37.7848995275722, -122.480708664243) 11 6 2 55 26
15588 120716 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 154 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   5989318.46493 2114336.78774 37.7849494287395 -122.480709979349 (37.7849494287395, -122.480709979349) 11 6 2 55 26
12047 176041 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 420 Font Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     20     5989405 2090258 37.7188404967574 -122.478649058693 (37.7188404967574, -122.478649058693) 1 8 4 64 14
125618 251082 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5600x Geary Blvd 4 Median : Yard Tree DPW 1     2 Width 10ft   5989477.5192 2112643.2957 37.7803088175248 -122.480035730601 (37.7803088175248, -122.480035730601) 11 6 2 55 26
68577 251044 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5600x Geary Blvd 2 Median : Yard Tree DPW 1   03/12/2011 12:00:00 AM 2 Width 10ft   5989568.3861 2112643.8334 37.7803155729867 -122.479721422798 (37.7803155729867, -122.479721422798) 11 6 2 55 26
68870 95969 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5600 Geary Blvd 4 Median : Tree DPW 1   03/12/2011 12:00:00 AM 2     5989606.68558 2112715.06065 37.7805133679778 -122.479594141591 (37.7805133679778, -122.479594141591) 11 6 2 55 26
155854 95968 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5600 Geary Blvd 2 Median : Tree DPW 1   03/12/2011 12:00:00 AM 2     5989606.68558 2112715.06065 37.7805133679778 -122.479594141591 (37.7805133679778, -122.479594141591) 11 6 2 55 26
170384 120745 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 310 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5989667.04936 2113254.10273 37.7819969332671 -122.47942476507 (37.7819969332671, -122.47942476507) 11 6 2 55 26
190713 43780 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 318 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2000 12:00:00 AM 15   Permit Number 43410 5989670.6824 2113208.17204 37.7818710314531 -122.479408835232 (37.7818710314531, -122.479408835232) 11 6 2 55 26
62723 9050 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5500 Geary Blvd 4 Median : Cutout Tree DPW 1     3 8M   5989756.3032 2112653.5115 37.7803530611008 -122.479072045798 (37.7803530611008, -122.479072045798) 11 6 2 55 26
9809 120740 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 682 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   5989760.03773 2110677.58416 37.7749279292467 -122.478914562404 (37.7749279292467, -122.478914562404) 11 6 2 55 26
110440 176058 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Crespi Dr 2 Sidewalk: Curb side : Yard Tree Private 2     25     5989854.78687 2090110.33741 37.7184611570226 -122.477083556286 (37.7184611570226, -122.477083556286) 1 8 4 64 14
121085 95967 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5500 Geary Blvd 10 Median : Cutout Tree DPW 1   03/12/2011 12:00:00 AM 5     5989915.47138 2112737.13311 37.7805919048991 -122.478527531838 (37.7805919048991, -122.478527531838) 11 6 2 55 26
179611 113697 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 418 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     23 3x3   5990008.80232 2112457.58426 37.7798297595647 -122.478184214126 (37.7798297595647, -122.478184214126) 11 6 2 55 26
101312 176046 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     24     5990073.98867 2089647.08481 37.7172018948419 -122.47629205486 (37.7172018948419, -122.47629205486) 1 8 4 64 14
88918 176045 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     20     5990157.58815 2089581.85402 37.7170276349961 -122.475998332672 (37.7170276349961, -122.475998332672) 1 8 4 64 14
61380 251039 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5400 Geary Blvd 1 Median : Tree DPW 1   03/12/2011 12:00:00 AM 2 Width 6ft   5990159.2899 2112663.7273 37.780404505362 -122.477678689302 (37.780404505362, -122.477678689302) 11 6 2 55 26
105092 95965 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5400 Geary Blvd 1 Median : Tree DPW 1   03/12/2011 12:00:00 AM 2     5990210.87302 2112736.64328 37.7806077057511 -122.477505572017 (37.7806077057511, -122.477505572017) 11 6 2 55 26
56181 110400 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 419X 18th Ave 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 MTA   28 3x3   5990269.5497 2112500.03817 37.7799614584413 -122.477285287094 (37.7799614584413, -122.477285287094) 11 6 2 55 26

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