trees
3,587 rows where qSpecies_id = 28 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
194366 | 265027 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2623 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5997622 | 2089116 | 37.7161784966097 | -122.450164015076 | (37.7161784966097, -122.450164015076) | 9 | 8 | 6 | 28861 | 24 | |||
194329 | 54859 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1830 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1972 12:00:00 AM | 25 | Permit Number 10718 | 5999038.10946992 | 2110464.35352985 | 37.7748768498196 | -122.446804517086 | (37.7748768498196, -122.446804517086) | 15 | 5 | 11 | 29492 | 16 | ||
194242 | 142394 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 0ft | 5997948.164 | 2114566.1285 | 37.7860769274284 | -122.450870672307 | (37.7860769274284, -122.450870672307) | 11 | 6 | 1 | 54 | 31 | |||
194205 | 212248 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 183 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 5996208.17588 | 2091165.73956 | 37.7217255908538 | -122.45519887983 | (37.7217255908538, -122.45519887983) | 9 | 8 | 6 | 28861 | 24 | |||
194154 | 205505 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2088 15th Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 6ft | 5991647.26153 | 2101306.76233 | 37.7493075480059 | -122.471703269501 | (37.7493075480059, -122.471703269501) | 1 | 8 | 4 | 29491 | 12 | |||
194064 | 212268 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 851 Junipero Serra Blvd | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5991336.52605 | 2091747.02554 | 37.7230409518531 | -122.472081079192 | (37.7230409518531, -122.472081079192) | 9 | 8 | 4 | 59 | 40 | |||
194033 | 212143 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 650x Miramar Ave | 1 | Median : Yard | Tree | DPW 1 | 3 | 5995395.28868 | 2093711.39383 | 37.7286686754144 | -122.458192950462 | (37.7286686754144, -122.458192950462) | 9 | 7 | 4 | 28861 | 40 | ||||
193990 | 206325 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1544 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5992470.15883 | 2104948.68777 | 37.7593549052146 | -122.469122723329 | (37.7593549052146, -122.469122723329) | 1 | 8 | 4 | 56 | 12 | |||
193984 | 212040 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 51 San Leandro Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 8ft | 5992378.18286 | 2096369.61273 | 37.7357936532423 | -122.468816529385 | (37.7357936532423, -122.468816529385) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||
193920 | 248641 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 69 Fair Oaks St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | Width 7ft | 6005403.80316 | 2103339.90036 | 37.7556763911732 | -122.424277402685 | (37.7556763911732, -122.424277402685) | 2 | 4 | 5 | 28859 | 19 | |||
193893 | 248841 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 155 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006565.55672 | 2098798.9675 | 37.7432735548255 | -122.419937463369 | (37.7432735548255, -122.419937463369) | 2 | 7 | 7 | 28859 | 2 | |||
193865 | 26172 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
193754 | 126302 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 150 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6011734.76105 | 2120835.8555 | 37.8040716705345 | -122.403613764588 | (37.8040716705345, -122.403613764588) | 3 | 1 | 10 | 28860 | 6 | |||
193739 | 142088 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 635 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6002077.8659 | 2110711.1599 | 37.7757277005143 | -122.436307043771 | (37.7757277005143, -122.436307043771) | 15 | 5 | 11 | 29492 | 10 | |||
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 | |||||
193668 | 189470 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 155 Brannan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015742.103 | 2113440.86493 | 37.7839897669485 | -122.389229269432 | (37.7839897669485, -122.389229269432) | 6 | 2 | 9 | 28856 | 6 | |||
193663 | 248697 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 139 Belgrave Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 1ft | 5997836.70415 | 2104878.71976 | 37.7594714168791 | -122.45055763612 | (37.7594714168791, -122.45055763612) | 15 | 5 | 11 | 28862 | 12 | |||
193623 | 248689 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 598 Belvedere St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 2ft | 5998658.65328 | 2105780.97893 | 37.7619958066699 | -122.44777989743 | (37.7619958066699, -122.44777989743) | 15 | 5 | 11 | 29492 | 9 | |||
193520 | 124434 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996180.98022 | 2115014.21197 | 37.7872059221875 | -122.457017039515 | (37.7872059221875, -122.457017039515) | 11 | 6 | 1 | 54 | 31 | |||
193326 | 189482 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 21 Commer Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6016460.65782 | 2094701.27931 | 37.7325746405951 | -122.38543696147 | (37.7325746405951, -122.38543696147) | 10 | 3 | 8 | 58 | 1 | |||
193181 | 113186 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2400 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 43 | 6x6 | 6002287.42061 | 2116502.02806 | 37.7916398598304 | -122.435996604952 | (37.7916398598304, -122.435996604952) | 13 | 9 | 1 | 29490 | 27 | |||
193176 | 212200 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 820 Bosworth St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6001696.91365 | 2095566.3144 | 37.7341219466514 | -122.436540603989 | (37.7341219466514, -122.436540603989) | 2 | 7 | 5 | 63 | 7 | ||||
193171 | 189480 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 21 Commer Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6016438.6726 | 2094774.74464 | 37.7327751453509 | -122.385518088395 | (37.7327751453509, -122.385518088395) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
193029 | 32037 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2575 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1995 12:00:00 AM | Permit Number 35420 | 6002281.60668482 | 2096845.31902787 | 37.7376670072008 | -122.434610563073 | (37.7376670072008, -122.434610563073) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
192988 | 97637 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008163 | 2117572 | 37.7949097746331 | -122.415742887246 | (37.7949097746331, -122.415742887246) | 5 | 1 | 10 | 28858 | 21 | |||||
192949 | 17730 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1301 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 24 | 3X3 | 6002241.0395679 | 2112976.4425925 | 37.7819568674508 | -122.435904708519 | (37.7819568674508, -122.435904708519) | 15 | 5 | 11 | 29490 | 41 | |||
192758 | 11837 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
192711 | 248655 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 San Jose Ave | 107 | Front Yard : Yard | Tree | Private 2 | 16 | 6005056.20315 | 2096946.76695 | 37.7381026814961 | -122.425024662861 | (37.7381026814961, -122.425024662861) | 2 | 7 | 5 | 63 | 7 | ||||
192638 | 248170 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 314 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010107.59926 | 2099260.73689 | 37.7447403904632 | -122.407722499021 | (37.7447403904632, -122.407722499021) | 2 | 7 | 7 | 28859 | 2 | |||
192607 | 126193 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2329 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6000793.47304 | 2116382.12167 | 37.7912256446929 | -122.441157029971 | (37.7912256446929, -122.441157029971) | 13 | 6 | 1 | 29490 | 27 | |||
192602 | 12661 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1045 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 100 | 4X4 | 5992178.70595 | 2114775.57253 | 37.786320036254 | -122.47084652786 | (37.786320036254, -122.47084652786) | 11 | 6 | 2 | 54 | 11 | |||
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 | ||
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 | |
192525 | 222113 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3965 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6003922.60018 | 2104195.09683 | 37.7579408094489 | -122.429460855761 | (37.7579408094489, -122.429460855761) | 2 | 4 | 5 | 28862 | 3 | |||
192493 | 123990 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 21 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 5993916.42634 | 2115397.19508 | 37.7881271842978 | -122.464879669796 | (37.7881271842978, -122.464879669796) | 11 | 6 | 1 | 54 | 11 | |||
192486 | 112185 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301x CORBETT AVE | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5999677 | 2105220 | 37.760513648973 | -122.444217531177 | (37.760513648973, -122.444217531177) | 15 | 5 | 5 | 28862 | 3 | ||||
192448 | 248860 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 11 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007702.84177 | 2107906.06122 | 37.7683435607327 | -122.416650032975 | (37.7683435607327, -122.416650032975) | 8 | 4 | 7 | 28853 | 19 | |||
192429 | 248703 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 137 Clifford Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5999474.6898 | 2106505.74152 | 37.7640324311778 | -122.445009659077 | (37.7640324311778, -122.445009659077) | 15 | 5 | 5 | 29492 | 9 | |||
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 | ||
192313 | 222094 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3945 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003487.80235 | 2102419.13873 | 37.7530398226367 | -122.430837830198 | (37.7530398226367, -122.430837830198) | 2 | 4 | 5 | 28862 | 22 | |||
192177 | 248647 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2x Lyell St | 1 | Median : Yard | Tree | DPW 1 | 23 | 6002988.02096 | 2095088.45779 | 37.7328831449407 | -122.432042732011 | (37.7328831449407, -122.432042732011) | 9 | 7 | 5 | 28861 | 25 | ||||
192160 | 126134 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2829 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | Permit Number 779774 | 6000559.90395 | 2118036.87537 | 37.7957558571972 | -122.442084000781 | (37.7957558571972, -122.442084000781) | 13 | 9 | 1 | 57 | 17 | ||
192086 | 139536 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2139 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6000977.3529 | 2113113.8568 | 37.7822623047738 | -122.440286330016 | (37.7822623047738, -122.440286330016) | 15 | 5 | 11 | 29490 | 41 | |||
192084 | 2099 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000X Bosworth St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6001184.3961353 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | 9 | 7 | 5 | 63 | 7 | |||
192077 | 2068 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 825 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6001750.47291 | 2095477.80199 | 37.7338819553801 | -122.43634910054 | (37.7338819553801, -122.43634910054) | 9 | 7 | 5 | 63 | 40 | |||
192058 | 1301 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4000X Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 32 | 10 | 5991772.09471 | 2087046.42932 | 37.7101594558675 | -122.470233284447 | (37.7101594558675, -122.470233284447) | 9 | 8 | 4 | 64 | 24 | |||
191931 | 212215 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1120 Bosworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6001146.22542 | 2095720.44544 | 37.7345138460282 | -122.438455541186 | (37.7345138460282, -122.438455541186) | 9 | 7 | 5 | 63 | 7 | ||||
191895 | 212106 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1602x Monterey Blvd | 4 | Median : Yard | Tree | DPW 1 | 33 | Width 10ft | 5993007.60376 | 2095365.54091 | 37.733073065562 | -122.466567434662 | (37.733073065562, -122.466567434662) | 9 | 8 | 4 | 59 | 40 | |||
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 | ||||
191782 | 16767 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1900X O'Farrell St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002203.1786904 | 2113328.4738156 | 37.7829213052255 | -122.43606088796 | (37.7829213052255, -122.43606088796) | 13 | 5 | 11 | 29490 | 41 | |||
191777 | 110220 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X QUINTARA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x20 | 5991588 | 2101192 | 37.7489890115011 | -122.471899832047 | (37.7489890115011, -122.471899832047) | 1 | 8 | 4 | 29491 | 12 | ||||
191731 | 17984 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2590 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6001555.7749733 | 2114978.4545091 | 37.7874149287591 | -122.43841888265 | (37.7874149287591, -122.43841888265) | 13 | 6 | 1 | 29490 | 27 | |||
191691 | 5126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2750 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002442.8157587 | 2095988.0085916 | 37.7353221804907 | -122.433991922534 | (37.7353221804907, -122.433991922534) | 2 | 7 | 5 | 63 | 7 | |||
191643 | 205493 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1327 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 4ft | 5992991.47949 | 2106428.83003 | 37.7634490967118 | -122.467427389781 | (37.7634490967118, -122.467427389781) | 1 | 8 | 11 | 56 | 12 | |||
191549 | 212272 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 851 Junipero Serra Blvd | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5991349.46561 | 2091914.71653 | 37.7235021385885 | -122.4720485669 | (37.7235021385885, -122.4720485669) | 9 | 8 | 4 | 59 | 40 | |||
191535 | 126222 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2155 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 5ft | 6003779.18403 | 2115900.43409 | 37.7900726688789 | -122.430792168042 | (37.7900726688789, -122.430792168042) | 13 | 9 | 1 | 29490 | 27 | |||
191483 | 222962 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 36 McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6006457.75464 | 2109180.19954 | 37.7717719364536 | -122.421047159316 | (37.7717719364536, -122.421047159316) | 8 | 2 | 9 | 28853 | 19 | |||
191474 | 16196 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 487 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 5998881.11246 | 2094651.6641 | 37.7314501202298 | -122.446209903265 | (37.7314501202298, -122.446209903265) | 9 | 7 | 4 | 59 | 40 | |||
191420 | 57393 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1236 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 17 | Permit Number 16232 | 6008083.47781 | 2116740.22221 | 37.7926214473861 | -122.415959115337 | (37.7926214473861, -122.415959115337) | 5 | 1 | 10 | 28858 | 21 | ||
191368 | 222131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 885 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004385.29448 | 2103730.85005 | 37.756692283336 | -122.427827584396 | (37.756692283336, -122.427827584396) | 2 | 4 | 5 | 28862 | 3 | |||
191334 | 244551 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1544 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999025.8241 | 2109069.656 | 37.771046664384 | -122.446746640696 | (37.771046664384, -122.446746640696) | 15 | 5 | 11 | 29492 | 9 | |||
191246 | 212028 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 80 San Leandro Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 8ft | 5992353.68763 | 2096100.78997 | 37.7350541182422 | -122.468881661879 | (37.7350541182422, -122.468881661879) | 1 | 8 | 4 | 59 | 40 | |||
191142 | 248771 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Cuesta Ct | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 8ft | 5999742.36883 | 2101773.9828 | 37.7510554595584 | -122.4437438777 | (37.7510554595584, -122.4437438777) | 2 | 5 | 5 | 63 | 38 | |||
190941 | 248745 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2179 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008160.24503 | 2105677.60418 | 37.762250449719 | -122.414910171272 | (37.762250449719, -122.414910171272) | 8 | 4 | 7 | 28859 | 19 | |||
190921 | 248749 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2179 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008154.49878 | 2105752.80936 | 37.7624566229027 | -122.414935368492 | (37.7624566229027, -122.414935368492) | 8 | 4 | 7 | 28859 | 19 | |||
190902 | 12554 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280X Lake St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994647.05266 | 2114915.6366 | 37.7868470540675 | -122.462316907107 | (37.7868470540675, -122.462316907107) | 11 | 6 | 1 | 54 | 11 | |||
190803 | 126205 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2475 Broderick St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6000219.22077 | 2116962.27003 | 37.7927858533464 | -122.443185605545 | (37.7927858533464, -122.443185605545) | 13 | 6 | 1 | 29490 | 27 | |||
190762 | 126260 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1045 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008127.58003 | 2116092.75233 | 37.7908461335032 | -122.415760652943 | (37.7908461335032, -122.415760652943) | 13 | 1 | 10 | 28858 | 21 | |||
190726 | 212146 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 650x Miramar Ave | 4 | Median : Yard | Tree | DPW 1 | 4 | 5995392.59413 | 2093841.41892 | 37.7290255380777 | -122.458211672548 | (37.7290255380777, -122.458211672548) | 9 | 7 | 4 | 28861 | 40 | ||||
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 | |
190681 | 12574 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 352 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 5994320.89991 | 2114924.89711 | 37.7868536951076 | -122.463445983594 | (37.7868536951076, -122.463445983594) | 11 | 6 | 1 | 54 | 11 | |||
190670 | 16602 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 81 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6002869.47017 | 2107840.01946 | 37.7678892025435 | -122.433363476353 | (37.7678892025435, -122.433363476353) | 15 | 5 | 5 | 28862 | 3 | |||
190610 | 248776 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10x Lyell St | 3 | Median : Yard | Tree | DPW 1 | 18 | Width 10ft | 6002998.16884 | 2095083.85117 | 37.7328710715272 | -122.43200731938 | (37.7328710715272, -122.43200731938) | 9 | 7 | 5 | 28861 | 25 | |||
190444 | 124435 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349 Cherry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5996182.91783 | 2115003.73991 | 37.7871772799902 | -122.45700957809 | (37.7871772799902, -122.45700957809) | 11 | 6 | 1 | 54 | 31 | |||
190439 | 212005 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 302 San Fernando Way | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 49 | Width 8ft | 5991983.8699 | 2094464.42627 | 37.73053970054 | -122.470041130814 | (37.73053970054, -122.470041130814) | 9 | 8 | 4 | 59 | 40 | |||
190422 | 247282 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1135 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999372.323 | 2108928.6638 | 37.7706793231619 | -122.445537954126 | (37.7706793231619, -122.445537954126) | 15 | 5 | 11 | 29492 | 9 | |||
190189 | 11836 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
190171 | 98321 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1899X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 48 | 3x3 | 6001966.9 | 2114999.4 | 37.7874958161075 | -122.4369979772 | (37.7874958161075, -122.4369979772) | 13 | 6 | 11 | 29490 | 27 | |||
190150 | 205519 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 185 San Leandro Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 6ft | 5992407.88276 | 2095504.69979 | 37.7334205348154 | -122.468650932689 | (37.7334205348154, -122.468650932689) | 9 | 8 | 4 | 59 | 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 | |||
190081 | 16130 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 339 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 5999827.96036 | 2094635.22598 | 37.7314590136127 | -122.442935300848 | (37.7314590136127, -122.442935300848) | 9 | 7 | 4 | 63 | 40 | |||
190002 | 33685 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.4247810873 | (37.7772038638652, -122.4247810873) | 7 | 9 | 11 | 28852 | 10 | |||
189935 | 99989 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Permit Number 44594 | 6011816.52839 | 2117490.26365 | 37.7948900519939 | -122.403095330591 | (37.7948900519939, -122.403095330591) | 3 | 1 | 10 | 28860 | 4 | |||
189817 | 126197 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3108 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5999278.07426 | 2116343.74093 | 37.7910338264984 | -122.446397484758 | (37.7910338264984, -122.446397484758) | 13 | 6 | 1 | 29490 | 31 | |||
189737 | 212086 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 161 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 6ft | 5994321.92466 | 2096778.98632 | 37.7370297956816 | -122.462125981643 | (37.7370297956816, -122.462125981643) | 9 | 8 | 4 | 59 | 40 | |||
189706 | 222122 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3732 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003486.42496 | 2103629.72034 | 37.7563637151278 | -122.430928983698 | (37.7563637151278, -122.430928983698) | 2 | 4 | 5 | 28862 | 3 | |||
189608 | 13391 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 294 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 5999337.3143931 | 2097513.8503676 | 37.739335050559 | -122.444838396667 | (37.739335050559, -122.444838396667) | 9 | 7 | 4 | 59 | 40 | |||
189578 | 206367 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 315 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 3ft | 5995329.15273 | 2092207.95882 | 37.7245368041267 | -122.458312810287 | (37.7245368041267, -122.458312810287) | 9 | 7 | 4 | 28861 | 40 | |||
189542 | 27431 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4X4 | 6007595.97622 | 2121559.89845 | 37.8058276504572 | -122.41798771471 | (37.8058276504572, -122.41798771471) | 5 | 1 | 10 | 308 | 23 | |||
189522 | 249736 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Broderick St | 20 | : | Tree | Private 2 | 27 | Width 3ft | 6000189.43372 | 2117210.10698 | 37.793464649935 | -122.443306478906 | (37.793464649935, -122.443306478906) | 13 | 9 | 1 | 57 | 27 | |||
189469 | 99171 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003316.34975 | 2116092.54276 | 37.7905739167998 | -122.432407262311 | (37.7905739167998, -122.432407262311) | 13 | 9 | 1 | 29490 | 27 | ||
189447 | 248683 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4810 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5998171.46832 | 2105674.11321 | 37.7616745229951 | -122.449457172615 | (37.7616745229951, -122.449457172615) | 15 | 5 | 11 | 29492 | 9 | |||
189402 | 11845 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 17 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
189363 | 126321 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6013275.05108 | 2116971.76517 | 37.7935477194132 | -122.398012208604 | (37.7935477194132, -122.398012208604) | 4 | 1 | 10 | 28860 | 6 | |||
189344 | 11777 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991284.18794 | 2091732.93739 | 37.7229992404026 | -122.472260973267 | (37.7229992404026, -122.472260973267) | 9 | 8 | 4 | 59 | 40 | ||
189260 | 138841 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 451 IVY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005188.6254 | 2111110.5576 | 37.7770006071382 | -122.425574572293 | (37.7770006071382, -122.425574572293) | 7 | 9 | 11 | 28852 | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );