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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189228 | 15460 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2415 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2X2 | 6007042.74684 | 2104311.74773 | 37.7584372681668 | -122.418678319777 | (37.7584372681668, -122.418678319777) | 2 | 4 | 7 | 28859 | 19 | |||
189205 | 248812 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 206 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5997173.25747 | 2106728.39239 | 37.7645121529379 | -122.452985666282 | (37.7645121529379, -122.452985666282) | 15 | 5 | 11 | 29492 | 12 | |||
189154 | 123050 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 556 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 4ft | 5991924.6758 | 2111674.30311 | 37.7777901083668 | -122.471499333549 | (37.7777901083668, -122.471499333549) | 11 | 6 | 2 | 54 | 11 | |||
189081 | 14949 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6016963.53103 | 2098247.48496 | 37.7423396193305 | -122.383945231762 | (37.7423396193305, -122.383945231762) | 10 | 3 | 8 | 58 | 1 | |||
189003 | 189416 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1106 Wisconsin St | 5 | : | Tree | Private 2 | 23 | Width 6ft | 6012793.60681 | 2102247.59908 | 37.7530916703562 | -122.3986443034 | (37.7530916703562, -122.3986443034) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
188983 | 126283 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1442 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6006684.03658 | 2118052.67265 | 37.796146330239 | -122.420894465221 | (37.796146330239, -122.420894465221) | 13 | 9 | 10 | 28858 | 32 | |||
188899 | 141293 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1835 ELLIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6001992.8122 | 2112904.6467 | 37.7817456300043 | -122.436758318598 | (37.7817456300043, -122.436758318598) | 15 | 5 | 11 | 29490 | 41 | |||
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 | |||
188736 | 98324 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1899X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6001966.9 | 2114999.4 | 37.7874958161075 | -122.4369979772 | (37.7874958161075, -122.4369979772) | 13 | 6 | 11 | 29490 | 27 | |||
188708 | 212032 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 77 San Leandro Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 8ft | 5992384.20886 | 2096144.36761 | 37.7351755348194 | -122.46877931002 | (37.7351755348194, -122.46877931002) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||
188654 | 121111 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 Stanyan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.454382576109 | (37.7738204478349, -122.454382576109) | 15 | 5 | 2 | 29492 | 16 | |||
188637 | 12519 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 25 Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5995405.42847 | 2114888.66064 | 37.7868166246721 | -122.459691166013 | (37.7868166246721, -122.459691166013) | 11 | 6 | 1 | 54 | 11 | |||
188566 | 99482 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Miramar Ave | 1 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | 9 | 7 | 4 | 28861 | 40 | |
188304 | 205102 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 36 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5991324.44766 | 2092411.88768 | 37.7248657994962 | -122.472171271311 | (37.7248657994962, -122.472171271311) | 9 | 8 | 4 | 59 | 40 | |||
188300 | 244174 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 506 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 5997996.8307 | 2108836.46 | 37.7703475329742 | -122.450289132747 | (37.7703475329742, -122.450289132747) | 15 | 5 | 11 | 29492 | 9 | |||
188284 | 4297 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4348 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6001630.45884 | 2100316.0332 | 37.7471597870885 | -122.437110309213 | (37.7471597870885, -122.437110309213) | 2 | 4 | 5 | 63 | 22 | |||
188256 | 6314 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1829 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002129.29202 | 2112924.84308 | 37.7818088396004 | -122.436287609101 | (37.7818088396004, -122.436287609101) | 15 | 5 | 11 | 29490 | 41 | |||
188255 | 248855 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 71 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007802.0343 | 2100013.97897 | 37.7466792892369 | -122.415748047148 | (37.7466792892369, -122.415748047148) | 2 | 7 | 7 | 28859 | 2 | |||
188250 | 212262 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5991291.08137 | 2091048.64317 | 37.7211207365178 | -122.472187288206 | (37.7211207365178, -122.472187288206) | 9 | 8 | 6 | 64 | 24 | |||
188239 | 2139 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 28 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 12 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
188226 | 29592 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Junipero Serra Blvd | 19 | Median : Cutout | Tree | DPW 1 | 12 | 3X3 | 5991300.07797 | 2091981.73158 | 37.723683287234 | -122.472224172111 | (37.723683287234, -122.472224172111) | 9 | 8 | 4 | 59 | 40 | |||
188153 | 248846 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 270 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6006500.53425 | 2098146.70088 | 37.7414789136283 | -122.420116013845 | (37.7414789136283, -122.420116013845) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
188102 | 16802 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2057X O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 5999018.33918 | 2112717.63042 | 37.7810626381631 | -122.447035094766 | (37.7810626381631, -122.447035094766) | 15 | 5 | 1 | 54 | 16 | |||
188084 | 13393 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 5999367.9101935 | 2097504.6578797 | 37.7393115562077 | -122.444731949771 | (37.7393115562077, -122.444731949771) | 9 | 7 | 4 | 59 | 40 | |||
188034 | 126181 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1451 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003742.08845 | 2120700.5958 | 37.8032505760096 | -122.431263297686 | (37.8032505760096, -122.431263297686) | 13 | 9 | 1 | 28858 | 17 | |||
188013 | 141153 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1970 O'Farrell St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 6001825.2934 | 2113278.2643 | 37.7827619672518 | -122.437364615403 | (37.7827619672518, -122.437364615403) | 13 | 5 | 11 | 29490 | 41 | |||
187936 | 32304 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 840 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | Permit Number 36881 | 5985844.77778671 | 2115067.5891122 | 37.7867534900239 | -122.49278149751 | (37.7867534900239, -122.49278149751) | 11 | 6 | 1 | 55 | 33 | |||
187848 | 111234 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2601X 15TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991704 | 2097685 | 37.7393664008113 | -122.471243228199 | (37.7393664008113, -122.471243228199) | 1 | 8 | 4 | 29491 | 40 | ||||
187840 | 248811 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 204 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5997187.93599 | 2106731.52185 | 37.7645215868244 | -122.452935123452 | (37.7645215868244, -122.452935123452) | 15 | 5 | 11 | 29492 | 12 | |||
187836 | 248714 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 195 Virginia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6006901.81168 | 2098013.32917 | 37.7411353060452 | -122.41871907534 | (37.7411353060452, -122.41871907534) | 2 | 7 | 7 | 28859 | 2 | |||
187771 | 116236 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2700X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | 3x3 | 5994997.34997 | 2110275.42624 | 37.774126441973 | -122.460768561348 | (37.774126441973, -122.460768561348) | 11 | 6 | 2 | 54 | 11 | |||
187723 | 115901 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1450 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6006662.38450486 | 2118054.63736364 | 37.7961505043806 | -122.420969525455 | (37.7961505043806, -122.420969525455) | 13 | 9 | 10 | 28858 | 32 | ||||
187676 | 246776 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 926 Esmeralda Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6009551.14862 | 2098756.05448 | 37.7433234771118 | -122.40961099258 | (37.7433234771118, -122.40961099258) | 2 | 7 | 7 | 28859 | 2 | |||
187549 | 189479 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 149 Brannan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6015989.35043 | 2113670.21229 | 37.7846332066892 | -122.388389888999 | (37.7846332066892, -122.388389888999) | 6 | 2 | 9 | 28856 | 6 | |||
187433 | 17959 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 12x4.7 | 6001865.5272 | 2115022.21433 | 37.7875526959794 | -122.437350340245 | (37.7875526959794, -122.437350340245) | 13 | 6 | 1 | 29490 | 27 | |||
187399 | 54132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 461 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1972 12:00:00 AM | 24 | Permit Number 9865 | 6012176.49549 | 2086499.28373 | 37.7098156657361 | -122.3996727573 | (37.7098156657361, -122.3996727573) | 10 | 3 | 8 | 309 | 1 | ||
187374 | 82865 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 614 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51572 | 5994112.63762 | 2111294.28874 | 37.7768730237535 | -122.463902883988 | (37.7768730237535, -122.463902883988) | 11 | 6 | 2 | 54 | 11 | |
187345 | 206415 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 82 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5994311.20143 | 2101804.36406 | 37.7508276046147 | -122.46252746957 | (37.7508276046147, -122.46252746957) | 1 | 8 | 4 | 29491 | 40 | |||
187312 | 176022 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6009662.72679 | 2089352.75305 | 37.7175102597674 | -122.408561997261 | (37.7175102597674, -122.408561997261) | 9 | 7 | 8 | 309 | 18 | ||||
187301 | 248909 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4011 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6003751.66746 | 2101264.8805 | 37.7498854469596 | -122.429843009147 | (37.7498854469596, -122.429843009147) | 2 | 4 | 5 | 28862 | 22 | |||
187159 | 126297 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009095.83841 | 2121864.72541 | 37.806748927978 | -122.412818759199 | (37.806748927978, -122.412818759199) | 3 | 1 | 10 | 308 | 23 | |||
187144 | 212116 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2001x Monterey Blvd | 1 | Median : Yard | Tree | DPW 1 | 26 | Width 10ft | 5992083.71687 | 2095423.23256 | 37.7331781144806 | -122.469765726035 | (37.7331781144806, -122.469765726035) | 9 | 8 | 4 | 59 | 40 | |||
187080 | 212264 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991294.251 | 2091109.76949 | 37.7212887577439 | -122.472180785219 | (37.7212887577439, -122.472180785219) | 9 | 8 | 6 | 64 | 24 | |||
187042 | 14964 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 385 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2000 12:00:00 AM | 3 | 3X3 | 6016787.68352 | 2097759.85667 | 37.7409909681193 | -122.384519307613 | (37.7409909681193, -122.384519307613) | 10 | 3 | 8 | 58 | 1 | ||
187011 | 258524 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
186994 | 189509 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 12 Ironwood Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6018048.65488 | 2096118.91081 | 37.7365549077878 | -122.380045286575 | (37.7365549077878, -122.380045286575) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |
186852 | 16355 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1500X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 18 | 4-HOA | 5993419.93647 | 2095261.019 | 37.73280986008 | -122.465134313705 | (37.73280986008, -122.465134313705) | 9 | 8 | 4 | 59 | 40 | |||
186793 | 124252 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Lake St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5994624.37615 | 2114925.10507 | 37.7868717461393 | -122.462396049004 | (37.7868717461393, -122.462396049004) | 11 | 6 | 1 | 54 | 11 | |||
186678 | 217819 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x Junipero Serra Blvd | 6 | Median : Yard | Tree | DPW 1 | 33 | 5991622.36581 | 2095679.35409 | 37.7338546825282 | -122.471379381376 | (37.7338546825282, -122.471379381376) | 1 | 8 | 4 | 59 | 40 | ||||
186646 | 111779 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 356 Marietta Dr | 4 | Median : Cutout | Tree | DPW 1 | 5 | 5999368 | 2097504 | 37.7393097549515 | -122.444731591986 | (37.7393097549515, -122.444731591986) | 9 | 7 | 4 | 59 | 40 | ||||
186575 | 126234 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2110 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003833.18876 | 2115854.95154 | 37.7899508449138 | -122.430602069337 | (37.7899508449138, -122.430602069337) | 13 | 9 | 1 | 29490 | 27 | |||
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 | |||||
186518 | 222934 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3550 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004770.13378 | 2105457.27236 | 37.7614543941178 | -122.426619602439 | (37.7614543941178, -122.426619602439) | 8 | 4 | 5 | 28862 | 3 | |||
186511 | 126259 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1202 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 5ft | 6008095.42077 | 2116655.37814 | 37.7923891578898 | -122.415911781323 | (37.7923891578898, -122.415911781323) | 5 | 1 | 10 | 28858 | 21 | |||
186367 | 2025 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | |||
186363 | 111667 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2201 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6004212.17015 | 2115977.48719 | 37.7903087592304 | -122.429299568375 | (37.7903087592304, -122.429299568375) | 13 | 9 | 1 | 29490 | 27 | ||||
186356 | 16174 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 431 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5999199.03492 | 2094645.60304 | 37.7314516292758 | -122.445110353454 | (37.7314516292758, -122.445110353454) | 9 | 7 | 4 | 59 | 40 | |||
186314 | 16180 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 460 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999056.2837 | 2094723.78661 | 37.7316581540937 | -122.44560948981 | (37.7316581540937, -122.44560948981) | 9 | 7 | 4 | 59 | 40 | |||
186239 | 139544 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2231 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 6000683.1198 | 2113070.8118 | 37.7821273575936 | -122.441301153154 | (37.7821273575936, -122.441301153154) | 15 | 5 | 1 | 29490 | 41 | |||
186228 | 200952 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4439 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6015291.0959 | 2096561.6867 | 37.7376181646855 | -122.389610341558 | (37.7376181646855, -122.389610341558) | 10 | 3 | 8 | 58 | 1 | |||
186174 | 205492 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1325 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5992991.20175 | 2106455.6763 | 37.7635227934684 | -122.467430302689 | (37.7635227934684, -122.467430302689) | 1 | 8 | 11 | 56 | 12 | |||
186173 | 126244 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 679 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6006310.63597 | 2112467.1291 | 37.7807887569329 | -122.421789565841 | (37.7807887569329, -122.421789565841) | 7 | 9 | 11 | 28852 | 41 | |||
186154 | 201462 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 221 Catalina St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6017931.88164 | 2096043.57688 | 37.736341612873 | -122.380443791448 | (37.736341612873, -122.380443791448) | 10 | 3 | 8 | 58 | 1 | |||
186150 | 126337 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 505 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012234.06302 | 2117586.04773 | 37.7951763601562 | -122.401657328144 | (37.7951763601562, -122.401657328144) | 3 | 1 | 10 | 28860 | 4 | |||
186040 | 19167 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 95 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003517.6175946 | 2107764.5447227 | 37.767718716857 | -122.431116222266 | (37.767718716857, -122.431116222266) | 7 | 9 | 5 | 28862 | 3 | |||
186024 | 189500 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Acacia Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017962.8634 | 2096182.15193 | 37.7367238220301 | -122.380346301344 | (37.7367238220301, -122.380346301344) | 10 | 3 | 8 | 58 | 1 | |||
186014 | 189438 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 10 | : | Tree | Private 2 | 16 | Width 4ft | 6016944.89383 | 2097963.47475 | 37.7415587545458 | -122.383989901933 | (37.7415587545458, -122.383989901933) | 10 | 3 | 8 | 58 | 1 | |||
185993 | 50311 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1055 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
185956 | 212223 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1120 Bosworth St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6000871.26708 | 2095862.20264 | 37.7348874342912 | -122.439416319315 | (37.7348874342912, -122.439416319315) | 2 | 7 | 5 | 63 | 7 | ||||
185763 | 206307 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5994456.80406 | 2089957.2483 | 37.7183067254442 | -122.461165314131 | (37.7183067254442, -122.461165314131) | 9 | 8 | 6 | 28861 | 24 | |||
185735 | 92211 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Miramar Ave | 5 | Median : Cutout | Tree | Private 2 | 12/29/2010 12:00:00 AM | 2x2 | Permit Number 54064 | 5995384.3 | 2092126.4 | 37.7243160320082 | -122.458116274775 | (37.7243160320082, -122.458116274775) | 9 | 8 | 4 | 28861 | 24 | ||
185658 | 205103 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 37 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5991326.97312 | 2092437.01185 | 37.7249349303792 | -122.472164371689 | (37.7249349303792, -122.472164371689) | 9 | 8 | 4 | 59 | 40 | |||
185635 | 24325 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | 3X3 | 6006278.38926 | 2112509.01094 | 37.7809019357225 | -122.42190409899 | (37.7809019357225, -122.42190409899) | 7 | 9 | 11 | 28852 | 41 | |||
185566 | 206382 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 6 San Pablo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5994455.43125 | 2097793.85045 | 37.7398240468482 | -122.461737955636 | (37.7398240468482, -122.461737955636) | 1 | 8 | 4 | 59 | 40 | |||
185541 | 222118 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4053 20th St | 5 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6003329.88306 | 2104158.35572 | 37.7578063508916 | -122.431508097635 | (37.7578063508916, -122.431508097635) | 2 | 4 | 5 | 28862 | 3 | |||
185515 | 189527 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 213 Acacia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017855.19484 | 2096232.11788 | 37.7368550771857 | -122.380722034501 | (37.7368550771857, -122.380722034501) | 10 | 3 | 8 | 58 | 1 | |||
185507 | 248680 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 303 28th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003887.25922 | 2099518.37438 | 37.7450976245676 | -122.429249604983 | (37.7450976245676, -122.429249604983) | 2 | 7 | 5 | 63 | 22 | |||
185414 | 97419 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 670 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 6x15 | 5991954.45921 | 2110876.39128 | 37.7756009824944 | -122.471338151535 | (37.7756009824944, -122.471338151535) | 11 | 6 | 2 | 54 | 11 | |||
185412 | 117356 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6005443.21862963 | 2111009.61442816 | 37.7767378239513 | -122.424686672119 | (37.7767378239513, -122.424686672119) | 7 | 9 | 11 | 28852 | 10 | |||
185411 | 205086 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 39 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5991226.90116 | 2090814.46771 | 37.7204740340313 | -122.472392075543 | (37.7204740340313, -122.472392075543) | 9 | 8 | 4 | 64 | 24 | |||
185309 | 24328 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
185288 | 64666 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2649 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1988 12:00:00 AM | 20 | Permit Number 25599 | 6000212.56039 | 2118841.15322 | 37.7979443906796 | -122.443343666786 | (37.7979443906796, -122.443343666786) | 13 | 9 | 1 | 57 | 17 | ||
185150 | 246623 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3300 Harrison St | 1 | Side Yard : Yard | Tree | Private 2 | 14 | 6009020.22785 | 2099406.68522 | 37.7450802011034 | -122.411492743901 | (37.7450802011034, -122.411492743901) | 2 | 7 | 7 | 28859 | 2 | ||||
185093 | 248885 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2250 Harrison St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6008756.13472 | 2105159.43583 | 37.7608611437375 | -122.412812570938 | (37.7608611437375, -122.412812570938) | 2 | 4 | 7 | 28859 | 19 | |||
185088 | 140329 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1435 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004580.7035 | 2113684.8903 | 37.7840347196488 | -122.427861041065 | (37.7840347196488, -122.427861041065) | 13 | 9 | 11 | 29490 | 41 | |||
185051 | 212042 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 45 San Leandro Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 8ft | 5992376.21526 | 2096435.9834 | 37.7359757767547 | -122.468828160298 | (37.7359757767547, -122.468828160298) | 1 | 8 | 4 | 59 | 40 | |||
185000 | 16356 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1500X Monterey Blvd | 6 | Median : Cutout | Tree | DPW 1 | 30 | 4-HOA | 5993377.89298 | 2095299.30224 | 37.7329125518562 | -122.46528244733 | (37.7329125518562, -122.46528244733) | 9 | 8 | 4 | 59 | 40 | |||
184985 | 16352 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1500X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 18 | 4-HOA | 5993475.48003 | 2095210.28877 | 37.7326737701714 | -122.464938604131 | (37.7326737701714, -122.464938604131) | 9 | 8 | 4 | 59 | 40 | |||
184917 | 78 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 97X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002876.5924018 | 2107716.5314312 | 37.7675505386543 | -122.433330016252 | (37.7675505386543, -122.433330016252) | 15 | 5 | 5 | 28862 | 3 | |||
184905 | 122726 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2199x Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008252 | 2105724 | 37.7623829973195 | -122.414596107789 | (37.7623829973195, -122.414596107789) | 8 | 4 | 7 | 28859 | 19 | ||||
184873 | 47012 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 190 Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45008 | 6004362.86360721 | 2108776.26099442 | 37.7705445057003 | -122.428264732992 | (37.7705445057003, -122.428264732992) | 7 | 9 | 11 | 28852 | 10 | |||
184861 | 11724 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 12 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
184835 | 222937 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 113 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003527.24433 | 2107670.09994 | 37.7674599399382 | -122.431076182918 | (37.7674599399382, -122.431076182918) | 7 | 9 | 5 | 28862 | 3 | |||
184730 | 248686 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 598 Belvedere St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 2ft | 5998666.57206 | 2105730.16088 | 37.7618567256266 | -122.447748851034 | (37.7618567256266, -122.447748851034) | 15 | 5 | 11 | 29492 | 9 | |||
184688 | 14958 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 325 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6016888.48059 | 2097899.84949 | 37.7413809335659 | -122.384180531751 | (37.7413809335659, -122.384180531751) | 10 | 3 | 8 | 58 | 1 |
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) );