trees
3,587 rows where qSpecies_id = 28 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79 | 121399 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
100 | 255131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
1723 | 19755 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
1845 | 20002 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
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 | ||
2868 | 255125 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3319 | 255128 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3449 | 19754 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
3464 | 26465 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
3974 | 2063 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Bosworth St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001908.8431877 | 2095495.9697002 | 37.7339408370986 | -122.435802866841 | (37.7339408370986, -122.435802866841) | 9 | 7 | 5 | 63 | 7 | |||
4083 | 19998 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY46 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
4977 | 11672 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 710X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991310.6193982 | 2092985.752428 | 37.7264406890913 | -122.472260886614 | (37.7264406890913, -122.472260886614) | 9 | 8 | 4 | 64 | 40 | ||
5016 | 29966 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991400.88182 | 2093544.5626 | 37.7279802659702 | -122.471989567778 | (37.7279802659702, -122.471989567778) | 9 | 8 | 4 | 59 | 40 | ||
5059 | 255129 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5129 | 255126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5305 | 5766 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 414 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6003770.1384677 | 2108392.97573 | 37.769458541933 | -122.430287624255 | (37.769458541933, -122.430287624255) | 15 | 9 | 5 | 29492 | 10 | |||
6508 | 14990 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Mendell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016422.44289 | 2097376.45794 | 37.7399180286864 | -122.385755471644 | (37.7399180286864, -122.385755471644) | 10 | 3 | 8 | 58 | 1 | |||
6726 | 2033 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | |||
6987 | 249466 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 25 | 6006522.49711 | 2113836.87509 | 37.7845616899264 | -122.421153924138 | (37.7845616899264, -122.421153924138) | 7 | 9 | 11 | 28858 | 36 | ||||
7147 | 260402 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Arch St | 1 | Median : Yard | Tree | DPW 1 | 3X5 | 5992587 | 2087523 | 37.7115150847083 | -122.467451465905 | (37.7115150847083, -122.467451465905) | 9 | 8 | 4 | 64 | 24 | ||||
7199 | 5759 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6003976.63728 | 2108405.62354 | 37.7695049641016 | -122.42957425574 | (37.7695049641016, -122.42957425574) | 7 | 9 | 5 | 29492 | 10 | |||
7991 | 16770 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1900X O'Farrell St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6002203.1786904 | 2113328.4738156 | 37.7829213052255 | -122.43606088796 | (37.7829213052255, -122.43606088796) | 13 | 5 | 11 | 29490 | 41 | |||
8612 | 255133 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 11 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
9867 | 18856 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2201 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004191.66186 | 2115995.22985 | 37.79035631503 | -122.429371791378 | (37.79035631503, -122.429371791378) | 13 | 9 | 1 | 29490 | 27 | |||
10052 | 14948 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016767.4558 | 2097838.85848 | 37.7412067724716 | -122.384594749942 | (37.7412067724716, -122.384594749942) | 10 | 3 | 8 | 58 | 1 | |||
10114 | 12679 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1302 Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4x4 | 5991386.80092 | 2114799.39324 | 37.7863396121206 | -122.473588027094 | (37.7863396121206, -122.473588027094) | 11 | 6 | 1 | 54 | 33 | |||
10238 | 255130 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10635 | 255127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10799 | 212114 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1902x Monterey Blvd | 2 | Median : Yard | Tree | DPW 1 | 36 | Width 10ft | 5992265.63325 | 2095412.19532 | 37.7331583221951 | -122.469135994644 | (37.7331583221951, -122.469135994644) | 9 | 8 | 4 | 59 | 40 | |||
11020 | 261566 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 26th St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
11079 | 6325 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1895X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | 15 | 5 | 11 | 29490 | 41 | |||
11833 | 16835 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2200 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x14 | 6000775.7711116 | 2113134.575359 | 37.7823077134494 | -122.440985198149 | (37.7823077134494, -122.440985198149) | 15 | 5 | 1 | 29490 | 41 | |||
11876 | 5083 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2566 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 3X3 | 6002238.2938951 | 2096914.6597978 | 37.7378549419938 | -122.434765273064 | (37.7378549419938, -122.434765273064) | 2 | 7 | 5 | 63 | 7 | |||
12883 | 255123 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
13040 | 261562 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1801 25th St | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
15052 | 1279 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
15264 | 2135 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 24 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 24 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
15569 | 4741 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1120 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/29/1992 12:00:00 AM | 12 | 3X3 | 6008069.3023022 | 2121114.6784448 | 37.8046318166674 | -122.416318139035 | (37.8046318166674, -122.416318139035) | 5 | 1 | 10 | 308 | 23 | ||
15721 | 126288 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500x Van Ness Ave | 7 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 6005772.33142 | 2119211.18315 | 37.7992758747311 | -122.424131583019 | (37.7992758747311, -122.424131583019) | 13 | 9 | 1 | 28858 | 32 | |||
15888 | 16825 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2139X OFARRELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6001076 | 2113135 | 37.7823259746064 | -122.439946572306 | (37.7823259746064, -122.439946572306) | 15 | 5 | 11 | 29490 | 41 | |||
16008 | 212124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 5 | 5995365.62659 | 2092320.18392 | 37.7248470432517 | -122.45819484442 | (37.7248470432517, -122.45819484442) | 9 | 7 | 4 | 28861 | 40 | ||||
16677 | 12369 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1335 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004408.00965 | 2113459.2839 | 37.7834054897746 | -122.428442413333 | (37.7834054897746, -122.428442413333) | 7 | 9 | 11 | 29490 | 41 | |||
17347 | 12370 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1335 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004408.00965 | 2113459.2839 | 37.7834054897746 | -122.428442413333 | (37.7834054897746, -122.428442413333) | 7 | 9 | 11 | 29490 | 41 | |||
17411 | 12539 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/01/2019 12:00:00 AM | 3 | 3x3 | 5994802.33005 | 2114932.67469 | 37.7869027759417 | -122.461780923147 | (37.7869027759417, -122.461780923147) | 11 | 6 | 1 | 54 | 11 | ||
17595 | 255124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
19147 | 255132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
19587 | 260401 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3900 Alemany Blvd | 2 | Median : Yard | Tree | DPW 1 | 3X5 | 5992602.03225 | 2087509.49597 | 37.7114788737215 | -122.467398529617 | (37.7114788737215, -122.467398529617) | 9 | 8 | 4 | 64 | 24 | ||||
19926 | 1838 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2201X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011226.77764 | 2087216.18178 | 37.7117311371657 | -122.403005565662 | (37.7117311371657, -122.403005565662) | 10 | 3 | 8 | 309 | 1 | |||
20178 | 6025 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1791 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001894.3231 | 2112551.24042 | 37.7807696680583 | -122.437073734016 | (37.7807696680583, -122.437073734016) | 15 | 5 | 11 | 29490 | 41 | |||
20216 | 121344 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
20259 | 26515 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2886 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6008938.68629 | 2101687.00134 | 37.7513368683627 | -122.411935812817 | (37.7513368683627, -122.411935812817) | 2 | 4 | 7 | 28859 | 19 | ||||
20704 | 2136 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
20866 | 212161 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Marietta Dr | 11 | Median : Cutout | Tree | DPW 1 | 24 | Width 5ft | 5999206.26812 | 2097588.84406 | 37.7395334857736 | -122.445296885446 | (37.7395334857736, -122.445296885446) | 9 | 7 | 4 | 59 | 40 | |||
20912 | 24331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 7 | 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 | ||||
20983 | 26458 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017771.22225 | 2096841.34416 | 37.7385232566369 | -122.381054711725 | (37.7385232566369, -122.381054711725) | 10 | 3 | 8 | 58 | 1 | |||
21189 | 14933 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016941.57525 | 2098184.84614 | 37.7421664120423 | -122.384016788063 | (37.7421664120423, -122.384016788063) | 10 | 3 | 8 | 58 | 1 | |||
21752 | 29977 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 610X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991336.00972369 | 2093444.32433125 | 37.7277012826104 | -122.47220652658 | (37.7277012826104, -122.47220652658) | 9 | 8 | 4 | 64 | 40 | ||
21890 | 205097 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 27 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991311.65126 | 2092183.57203 | 37.7242381608387 | -122.472198871475 | (37.7242381608387, -122.472198871475) | 9 | 8 | 4 | 59 | 40 | |||
21966 | 14887 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2006 12:00:00 AM | 3 | 3x3 | 6017068.53164 | 2098456.8281 | 37.7429202372855 | -122.383596739007 | (37.7429202372855, -122.383596739007) | 10 | 3 | 8 | 58 | 1 | ||
22098 | 205111 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 49 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991346.44389 | 2092729.45294 | 37.7257390277172 | -122.472118370494 | (37.7257390277172, -122.472118370494) | 9 | 8 | 4 | 59 | 40 | |||
22317 | 30044 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
22384 | 14951 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 225 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017001.18429 | 2098171.14482 | 37.7421320862857 | -122.383809722815 | (37.7421320862857, -122.383809722815) | 10 | 3 | 8 | 58 | 1 | |||
22615 | 212111 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1802x Monterey Blvd | 2 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 5992507.56631 | 2095396.95389 | 37.7331304494932 | -122.468298465918 | (37.7331304494932, -122.468298465918) | 9 | 8 | 4 | 59 | 40 | |||
22731 | 11780 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Junipero Serra Blvd | 12 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991289.71415 | 2091805.70466 | 37.7231993611319 | -122.472247172286 | (37.7231993611319, -122.472247172286) | 9 | 8 | 4 | 59 | 40 | ||
22935 | 12652 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5992352.41288 | 2114839.20557 | 37.7865047992766 | -122.470250187524 | (37.7865047992766, -122.470250187524) | 11 | 6 | 1 | 54 | 11 | |||
23052 | 3754 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1020 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 36 | 18 | 6012443.0515847 | 2103208.5839527 | 37.755710788358 | -122.399924077269 | (37.755710788358, -122.399924077269) | 10 | 3 | 8 | 28856 | 29 | |||
23077 | 16168 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 425 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 28 | 3X3 | 5999268.01839 | 2094645.05904 | 37.7314540727301 | -122.444871826278 | (37.7314540727301, -122.444871826278) | 9 | 7 | 4 | 59 | 40 | ||
23280 | 22237 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4445 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6015309.22014 | 2096468.43632 | 37.7373631231169 | -122.389541166269 | (37.7373631231169, -122.389541166269) | 10 | 3 | 8 | 58 | 1 | |||
23438 | 5987 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1640 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x6 | 6002592.39189 | 2112708.53671 | 37.7812412183178 | -122.434670029614 | (37.7812412183178, -122.434670029614) | 15 | 5 | 11 | 29490 | 41 | |||
23442 | 1196 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3080 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 28 | 3X3 | 5996438.01379 | 2087205.1874 | 37.7108640234246 | -122.454118486498 | (37.7108640234246, -122.454118486498) | 9 | 7 | 6 | 28861 | 25 | ||
23470 | 16820 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2130 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001107.6476595 | 2113179.9385941 | 37.782451166007 | -122.439840308676 | (37.782451166007, -122.439840308676) | 15 | 5 | 11 | 29490 | 41 | |||
23585 | 2101 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000X Bosworth St | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 14 | 6001184.3961353 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | 9 | 7 | 5 | 63 | 7 | |||
23645 | 16758 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1900X O'Farrell St | 1 | 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 | |||
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 | |||
24017 | 14992 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Mendell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016399.93011 | 2097341.84893 | 37.7398217535785 | -122.385830900501 | (37.7398217535785, -122.385830900501) | 10 | 3 | 8 | 58 | 1 | |||
24111 | 2116 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
24244 | 139815 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1652 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | Width 0ft | 6002517 | 2112708 | 37.7812354643217 | -122.434930809638 | (37.7812354643217, -122.434930809638) | 15 | 5 | 11 | 29490 | 41 | |||
24318 | 12678 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1302 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 4X4 | 5991402.06133 | 2114800.45081 | 37.7863433996674 | -122.473535307672 | (37.7863433996674, -122.473535307672) | 11 | 6 | 1 | 54 | 33 | |||
24372 | 212187 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 720 Bosworth St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 16 | 6002096.28779 | 2095466.30888 | 37.733870041163 | -122.435152693763 | (37.733870041163, -122.435152693763) | 2 | 7 | 5 | 63 | 7 | ||||
24635 | 251248 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 829 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001839 | 2095802 | 37.7347771581377 | -122.436066227259 | (37.7347771581377, -122.436066227259) | 2 | 7 | 5 | 63 | 7 | ||||
25028 | 23944 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2334X Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003622.99851 | 2115966.72014 | 37.7902458233354 | -122.431337290596 | (37.7902458233354, -122.431337290596) | 13 | 9 | 1 | 29490 | 27 | |||
25334 | 205114 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991407.36099 | 2093694.15878 | 37.7283913946494 | -122.471978068129 | (37.7283913946494, -122.471978068129) | 9 | 8 | 4 | 59 | 40 | |||
25445 | 1280 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5992520.10718 | 2087379.1823 | 37.7111163336128 | -122.467672210425 | (37.7111163336128, -122.467672210425) | 9 | 8 | 4 | 64 | 24 | |||
25471 | 2132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 21 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 0 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
25658 | 7812 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006212.78826 | 2112695.72596 | 37.7814109097272 | -122.422144314234 | (37.7814109097272, -122.422144314234) | 7 | 9 | 11 | 28852 | 41 | |||
25688 | 4330 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 831 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001821.43184 | 2095823.4199 | 37.7348349741444 | -122.436128498656 | (37.7348349741444, -122.436128498656) | 2 | 7 | 5 | 63 | 7 | |||
25779 | 205107 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 41 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 5991336.964 | 2092532.2101 | 37.7251968993055 | -122.472136770613 | (37.7251968993055, -122.472136770613) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
26634 | 212204 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 3ft | 6001555.51112 | 2095599.51711 | 37.7342050772889 | -122.437031852331 | (37.7342050772889, -122.437031852331) | 9 | 7 | 5 | 63 | 7 | |||
26716 | 26466 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
27332 | 14938 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016907.69513 | 2098053.92414 | 37.741805053675 | -122.384124820925 | (37.741805053675, -122.384124820925) | 10 | 3 | 8 | 58 | 1 | |||
27547 | 2079 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900X Bosworth St | 10 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001652.8683328 | 2095576.0345147 | 37.7341461328318 | -122.436693577752 | (37.7341461328318, -122.436693577752) | 2 | 7 | 5 | 63 | 7 | |||
28361 | 5082 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2563 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002286.6614 | 2096942.37452 | 37.7379337860994 | -122.434600024386 | (37.7379337860994, -122.434600024386) | 2 | 7 | 5 | 63 | 7 | |||
28594 | 2069 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 843 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001701.03191 | 2095490.91331 | 37.7339151466682 | -122.436520970873 | (37.7339151466682, -122.436520970873) | 9 | 7 | 5 | 63 | 40 | |||
28643 | 2608 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1760 Bush St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005030.51103 | 2115130.79368 | 37.7880302457848 | -122.426407854199 | (37.7880302457848, -122.426407854199) | 13 | 9 | 11 | 28858 | 27 | |||
28914 | 24330 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 6 | 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 | ||||
28991 | 2078 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900X Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6001652.8683328 | 2095576.0345147 | 37.7341461328318 | -122.436693577752 | (37.7341461328318, -122.436693577752) | 2 | 7 | 5 | 63 | 7 | |||
29128 | 16829 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2185 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6000864.446233 | 2113095.7481361 | 37.7822061539958 | -122.440675636453 | (37.7822061539958, -122.440675636453) | 15 | 5 | 11 | 29490 | 41 | |||
29605 | 217817 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x Junipero Serra Blvd | 4 | Median : Yard | Tree | DPW 1 | 27 | 5991627.99201 | 2095776.79312 | 37.7341225510202 | -122.47136702736 | (37.7341225510202, -122.47136702736) | 1 | 8 | 4 | 59 | 40 | ||||
29710 | 205081 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 32 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 5991210.7499 | 2090584.88401 | 37.7198427189488 | -122.472431176281 | (37.7198427189488, -122.472431176281) | 9 | 8 | 4 | 64 | 24 |
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) );