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)
149432 53401 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 730 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/1969 12:00:00 AM 19   Permit Number 6300 5990392.09793 2110392.49513 37.7741818356132 -122.476707321825 (37.7741818356132, -122.476707321825) 11 6 2 55 26
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
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
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
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
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
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
193712 104914 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 614 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
109661 205500 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1138 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 4ft   5990418.09905 2103165.28215 37.7543393618736 -122.476089416911 (37.7543393618736, -122.476089416911) 1 8 4 56 12
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
104508 104915 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 701 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
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
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
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
30603 9013 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5317 Geary Blvd 2 Median : Cutout Tree DPW 1   03/12/2011 12:00:00 AM 2 8M   5990485.6581 2112681.4706 37.7804721580667 -122.476550937565 (37.7804721580667, -122.476550937565) 11 6 2 55 26
81116 206314 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3698 19th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     18 Width 3ft   5990493.86406 2091288.56287 37.721733327719 -122.474960512337 (37.721733327719, -122.474960512337) 9 8 4 64 40
135840 205501 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1118 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 4ft   5990494.6785 2103168.06118 37.7543514325961 -122.475824791393 (37.7543514325961, -122.475824791393) 1 8 4 56 12
114268 96150 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 129 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     32 9x5   5990508.47141 2114517.58396 37.7855149374501 -122.476606194857 (37.7855149374501, -122.476606194857) 11 6 2 55 26
177610 205502 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1112 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   5990518.96382 2103168.28108 37.7543534443741 -122.475740823499 (37.7543534443741, -122.475740823499) 1 8 4 56 12
8634 176044 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     21     5990534.22824 2089263.30634 37.7161748133009 -122.474673246391 (37.7161748133009, -122.474673246391) 1 8 4 64 14
161532 353 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3590X 19th Ave 22 Sidewalk: Curb side : Cutout Tree DPW 1     18 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219) 9 8 4 64 40
52644 205503 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1106 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   5990538.13175 2103170.07444 37.7543594797245 -122.475674667545 (37.7543594797245, -122.475674667545) 1 8 4 56 12
151029 206315 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3646 19th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   5990563.4574 2092379.20957 37.7247320046732 -122.474799514783 (37.7247320046732, -122.474799514783) 9 8 4 64 40
2496 331 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3402X 19th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/24/2008 12:00:00 AM 50 2X3   5990579.05408 2092494.42491 37.7250492609916 -122.474754004974 (37.7250492609916, -122.474754004974) 9 8 4 64 40
44670 332 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3402X 19th Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/24/2008 12:00:00 AM 80 2X3   5990579.05408 2092494.42491 37.7250492609916 -122.474754004974 (37.7250492609916, -122.474754004974) 9 8 4 64 40
55413 122082 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 431 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5990582.93071 2112432.87879 37.7797952350064 -122.476196266646 (37.7797952350064, -122.476196266646) 11 6 2 55 26
188670 206316 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3578 19th Ave 1 Sidewalk: Curb side : Yard Tree DPW 1   02/24/2008 12:00:00 AM 16 Width 3ft   5990600.84966 2093024.2495 37.7265052896682 -122.474717313166 (37.7265052896682, -122.474717313166) 9 8 4 64 40
31845 206317 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3578 19th Ave 2 Sidewalk: Curb side : Yard Tree DPW 1   02/24/2008 12:00:00 AM 25 Width 3ft   5990608.28598 2093089.7399 37.7266855407931 -122.474696384147 (37.7266855407931, -122.474696384147) 9 8 4 64 40
112456 251072 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5200x Geary Blvd 6 Median : Yard Tree DPW 1     3 Width 10ft   5990697.77 2112688.192 37.7805029132293 -122.475817641236 (37.7805029132293, -122.475817641236) 11 6 2 54 26
69083 95961 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5200 Geary Blvd 1 Median : Cutout Tree DPW 1   03/12/2011 12:00:00 AM       5990756.89162 2112756.21837 37.7806931223902 -122.475618082454 (37.7806931223902, -122.475618082454) 11 6 2 54 26
131804 95964 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5200 Geary Blvd 6 Median : Tree DPW 1   03/12/2011 12:00:00 AM       5990756.89162 2112756.21837 37.7806931223902 -122.475618082454 (37.7806931223902, -122.475618082454) 11 6 2 54 26
159549 95963 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5200 Geary Blvd 4 Median : Cutout Tree DPW 1   03/12/2011 12:00:00 AM 5     5990756.89162 2112756.21837 37.7806931223902 -122.475618082454 (37.7806931223902, -122.475618082454) 11 6 2 54 26
23933 251069 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5200x Geary Blvd 1 Median : Yard Tree DPW 1     2 Width 10ft   5990794.5513 2112690.3427 37.7805144291466 -122.475482989541 (37.7805144291466, -122.475482989541) 11 6 2 54 26
10661 114250 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 131 FONT BLVD 1 Front Yard : Yard Tree Private 2     36     5990844 2088883 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248) 1 8 4 64 14
164291 253651 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 131 Font Blvd 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990844 2088883 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248) 1 8 4 64 14
116962 205489 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1430 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 3ft   5990863.69165 2105623.89692 37.7611158947076 -122.474727895479 (37.7611158947076, -122.474727895479) 1 8 4 56 12
194483 265134 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 Winston Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6   5990934 2093194 37.7269906812088 -122.47357801435 (37.7269906812088, -122.47357801435) 9 8 4 64 40
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
44052 114240 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 99x FONT BLVD 16 Sidewalk: Curb side : Yard Tree Private 2           5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
126287 114225 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 99x FONT BLVD 1 Sidewalk: Curb side : Yard Tree Private 2     48     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
90372 121244 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 701 16th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     27     5990956.24309491 2110611.72775368 37.7748164950302 -122.474771867875 (37.7748164950302, -122.474771867875) 11 6 2 54 26
33553 122092 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 701 16th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 6ft   5990960.29001 2110539.25119 37.7746177286903 -122.474752577866 (37.7746177286903, -122.474752577866) 11 6 2 54 26
192579 16692 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 950X Noriega St 3 Median : Cutout Tree DPW 1   02/25/2016 08:08:00 AM 3 8   5990985.78631 2103156.72144 37.7543487579916 -122.474125605135 (37.7543487579916, -122.474125605135) 1 8 4 56 12
39778 251075 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5100x Geary Blvd 3 Median : Yard Tree DPW 1     1 Width 10ft   5990994.9145 2112700.954 37.7805551774565 -122.474790620269 (37.7805551774565, -122.474790620269) 11 6 2 54 26
90480 217785 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 124 Sloat Blvd 2 Sidewalk: Property side : Yard Tree Private 2     33     5991003.2864 2096055.68839 37.7348521691816 -122.473547145886 (37.7348521691816, -122.473547145886) 1 8 4 29491 40
61941 54995 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 692 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/1972 12:00:00 AM 13   Permit Number 10873 5991003.86193 2110730.86063 37.7751463606227 -122.474615842608 (37.7751463606227, -122.474615842608) 11 6 2 54 26
77824 16690 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 950X Noriega St 1 Median : Cutout Tree DPW 1   11/07/2014 11:22:00 AM 3 8   5991053.49575 2103158.03284 37.7543562808184 -122.473891546652 (37.7543562808184, -122.473891546652) 1 8 4 56 12
49495 16378 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000X Moraga St 1 Median : Cutout Tree DPW 1     18 12   5991088.16435 2103840.65792 37.7562325975726 -122.473821451692 (37.7562325975726, -122.473821451692) 1 8 4 56 12
79421 29636 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1110X Junipero Serra Blvd 9 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
95248 29632 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1110X Junipero Serra Blvd 5 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
106333 29635 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1110X Junipero Serra Blvd 8 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
106785 29629 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1110X Junipero Serra Blvd 2 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
106813 29637 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1110X Junipero Serra Blvd 10 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
115965 29628 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1110X Junipero Serra Blvd 1 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
123602 29638 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1110X Junipero Serra Blvd 11 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
180304 29634 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1110X Junipero Serra Blvd 7 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
188989 29630 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1110X Junipero Serra Blvd 3 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
192410 29633 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1110X Junipero Serra Blvd 6 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
72747 68295 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 25 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/1993 12:00:00 AM 17   Permit Number 32104 5991131.60478 2114879.69838 37.7865453253482 -122.47447679418 (37.7865453253482, -122.47447679418) 11 6 1 54 33
173667 122144 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 25 15th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     16 Width 8ft   5991132.25176 2114855.87276 37.7864799443229 -122.474472816433 (37.7864799443229, -122.474472816433) 11 6 1 54 33
135188 122145 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 31 15th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     18 Width 8ft   5991133.61704 2114833.40571 37.7864183351682 -122.474466452762 (37.7864183351682, -122.474466452762) 11 6 1 54 33
156525 122146 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 31 15th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     22 Width 8ft   5991133.99272 2114818.51521 37.7863774717716 -122.47446406595 (37.7863774717716, -122.47446406595) 11 6 1 54 33
48458 16693 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 900X NORIEGA ST 4 Median : Cutout Tree DPW 1   11/07/2014 11:22:00 AM 3 8   5991142.4 2103205.1 37.7544906639436 -122.473587529216 (37.7544906639436, -122.473587529216) 1 8 4 56 12
11685 122149 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 159 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   5991148.17044 2114368.07321 37.7851415048457 -122.47438213241 (37.7851415048457, -122.47438213241) 11 6 2 54 26
65602 212292 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 2 Median : Cutout Tree DPW 1     6 Width 0ft   5991164.37326 2089829.54432 37.7177660575462 -122.472536442798 (37.7177660575462, -122.472536442798) 9 8 4 64 24
162570 212293 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 3 Median : Cutout Tree DPW 1     9 Width 0ft   5991165.05081 2089858.71083 37.7178461808423 -122.472536226064 (37.7178461808423, -122.472536226064) 9 8 4 64 24
136840 212294 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 4 Median : Cutout Tree DPW 1     9 Width 0ft   5991166.95703 2089883.01903 37.7179130355286 -122.472531408396 (37.7179130355286, -122.472531408396) 9 8 4 64 24
107716 58220 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 40 Winston Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   06/27/1978 12:00:00 AM 32 3x80 Permit Number 17215 5991168.5767018 2093158.16680643 37.7269058743608 -122.472764483204 (37.7269058743608, -122.472764483204) 9 8 4 64 40
190136 212295 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 6 Median : Cutout Tree DPW 1     9 Width 0ft   5991170.53267 2089939.68134 37.7180688232854 -122.472523177809 (37.7180688232854, -122.472523177809) 9 8 4 64 24
31724 24412 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 15 Sidewalk: Curb side : Cutout Tree PUC 8   06/23/1995 12:00:00 AM 12 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
34452 11772 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 16 Sidewalk: Curb side : Cutout Tree PUC 8   06/23/1995 12:00:00 AM 12 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
57719 11785 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8     30 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
83353 24460 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout Tree PUC 8   06/22/1995 12:00:00 AM 6 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
134137 24414 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 17 Sidewalk: Curb side : Cutout Tree PUC 8   06/23/1995 12:00:00 AM 12 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
176383 11790 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 12 Sidewalk: Curb side : Cutout Tree PUC 8     24 3x4   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
193977 24413 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 13 Sidewalk: Curb side : Cutout Tree PUC 8   06/22/1995 12:00:00 AM 6 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
114571 29626 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 900X Junipero Serra Blvd 35 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991174.60245 2090776.13532 37.7203657556648 -122.472570060379 (37.7203657556648, -122.472570060379) 9 8 4 64 40
167231 122264 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1400 Balboa St 3 Sidewalk: Curb side : Pot Tree Private 2     16 Width 4ft   5991175.02195 2111348.8824 37.7768531954343 -122.474068870116 (37.7768531954343, -122.474068870116) 11 6 2 54 26
151461 212296 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 10 Median : Cutout Tree DPW 1     10 Width 0ft   5991176.06439 2090044.25898 37.7183562879852 -122.472511677268 (37.7183562879852, -122.472511677268) 9 8 4 64 24
51463 29599 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 900X Junipero Serra Blvd 8 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991176.65606 2091094.6598 37.7212404641514 -122.472586172621 (37.7212404641514, -122.472586172621) 9 8 4 64 40
79244 212297 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 11 Median : Cutout Tree DPW 1     5 Width 0ft   5991177.82743 2090064.76298 37.7184126889791 -122.47250707726 (37.7184126889791, -122.47250707726) 9 8 4 64 24
26505 212298 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 12 Median : Cutout Tree DPW 1     5 Width 0ft   5991179.12071 2090094.55389 37.7184945623549 -122.472504777687 (37.7184945623549, -122.472504777687) 9 8 4 64 24
130632 95960 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5100 Geary Blvd 3 Median : Cutout Tree DPW 1   03/12/2011 12:00:00 AM 2     5991179.18244 2112771.35122 37.780759144985 -122.474158294453 (37.780759144985, -122.474158294453) 11 6 2 54 26
126423 212299 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 14 Median : Cutout Tree DPW 1     5 Width 0ft   5991184.2984 2090150.76712 37.7186492097602 -122.472490976674 (37.7186492097602, -122.472490976674) 9 8 4 64 24
158682 212300 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 16 Median : Cutout Tree DPW 1     7 Width 0ft   5991186.31185 2090192.49351 37.7187638967107 -122.472487057435 (37.7187638967107, -122.472487057435) 9 8 4 64 24
35454 29603 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 910X Junipero Serra Blvd 12 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991188.7321263 2091104.0152467 37.7212668508959 -122.472545111236 (37.7212668508959, -122.472545111236) 9 8 4 64 40
59681 29605 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 910X Junipero Serra Blvd 14 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991188.7321263 2091104.0152467 37.7212668508959 -122.472545111236 (37.7212668508959, -122.472545111236) 9 8 4 64 40
149794 29604 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 910X Junipero Serra Blvd 13 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991188.7321263 2091104.0152467 37.7212668508959 -122.472545111236 (37.7212668508959, -122.472545111236) 9 8 4 64 40
188138 212301 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 17 Median : Cutout Tree DPW 1     5 Width 0ft   5991188.84719 2090215.08791 37.7188260821255 -122.472479940192 (37.7188260821255, -122.472479940192) 9 8 4 64 24
134716 212302 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 18 Median : Cutout Tree DPW 1     3 Width 0ft   5991190.15994 2090239.43451 37.7188930078858 -122.47247717658 (37.7188930078858, -122.47247717658) 9 8 4 64 24
75104 212303 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 19 Median : Cutout Tree DPW 1     10 Width 0ft   5991192.11842 2090269.21075 37.7189748794765 -122.472472576576 (37.7189748794765, -122.472472576576) 9 8 4 64 24
138333 212304 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 20 Median : Cutout Tree DPW 1     5 Width 0ft   5991192.55124 2090289.74279 37.7190312804608 -122.472472576553 (37.7190312804608, -122.472472576553) 9 8 4 64 24
63500 212305 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 21 Median : Cutout Tree DPW 1     3 Width 0ft   5991194.3003 2090309.58448 37.7190858620976 -122.472467976539 (37.7190858620976, -122.472467976539) 9 8 4 64 24
40099 212306 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 22 Median : Cutout Tree DPW 1     7 Width 0ft   5991196.13313 2090333.39999 37.7191513597144 -122.472463376508 (37.7191513597144, -122.472463376508) 9 8 4 64 24
148936 68216 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 371 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/1993 12:00:00 AM 13 4x4 Permit Number 32003 5991199.85508 2112923.89297 37.7811791800837 -122.474097911754 (37.7811791800837, -122.474097911754) 11 6 2 54 26
45103 122263 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1400 Balboa St 2 Sidewalk: Curb side : Pot Tree Private 2     17 Width 4ft   5991199.98338 2111351.52204 37.7768618890602 -122.473982714477 (37.7768618890602, -122.473982714477) 11 6 2 54 26
80166 212307 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000x Junipero Serra Blvd 23 Median : Cutout Tree DPW 1     12 Width 0ft   5991200.21272 2090369.09522 37.7192496061609 -122.47245187595 (37.7192496061609, -122.47245187595) 9 8 4 64 24

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