trees
3,587 rows where qSpecies_id = 28 sorted by SiteOrder 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100 | 255131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 3325 | 11719 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 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 | ||
| 7215 | 140951 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2060 Ofarrell St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6001488 | 2113369 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | 15 | 5 | 11 | 29490 | 41 | |||
| 7374 | 48751 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
| 9847 | 248795 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 5175 Diamond Heights Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6000777.48804 | 2099988.6184 | 37.7462122622804 | -122.440036333505 | (37.7462122622804, -122.440036333505) | 2 | 4 | 5 | 63 | 22 | ||||
| 12920 | 175992 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Geneva Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 5ft | 5998869.40884 | 2090603.99979 | 37.7203355078481 | -122.445959349454 | (37.7203355078481, -122.445959349454) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 31250 | 212259 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991274.76967 | 2090780.48576 | 37.7203834983807 | -122.472224135259 | (37.7203834983807, -122.472224135259) | 9 | 8 | 6 | 64 | 24 | |||
| 33486 | 176038 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 9 | : | Tree | Private 2 | 6 | Width 0ft | 5991295.02694 | 2088957.62103 | 37.7153795311078 | -122.472021319244 | (37.7153795311078, -122.472021319244) | 1 | 8 | 4 | 64 | 24 | |||
| 37608 | 97493 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X Miramar Ave | 9 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.458022688068 | (37.7258701708071, -122.458022688068) | 9 | 7 | 4 | 28861 | 40 | |||
| 43941 | 46350 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2002 12:00:00 AM | 12 | Permit Number 44594 | 6011800.91872 | 2117592.16753 | 37.7951689839044 | -122.403156514164 | (37.7951689839044, -122.403156514164) | 3 | 1 | 10 | 28860 | 4 | ||
| 44022 | 17728 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300X Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/20/1992 12:00:00 AM | 70 | 3X3 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | ||
| 47231 | 99464 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 550X Miramar Ave | 9 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995413 | 2092983.7 | 37.7266716211667 | -122.458079078858 | (37.7266716211667, -122.458079078858) | 9 | 7 | 4 | 28861 | 40 | |||
| 51784 | 121350 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
| 54553 | 212136 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Miramar Ave | 9 | Median : Yard | Tree | DPW 1 | 4 | 5995379.948 | 2093237.13475 | 37.7273655928402 | -122.458211672546 | (37.7273655928402, -122.458211672546) | 9 | 7 | 4 | 28861 | 40 | ||||
| 57866 | 47600 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 57896 | 24322 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006352.81998 | 2112520.5015 | 37.7809376833117 | -122.421647422525 | (37.7809376833117, -122.421647422525) | 7 | 9 | 11 | 28852 | 41 | |||
| 60934 | 258521 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 66633 | 248788 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2002 Castro St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002634.42965 | 2099690.41843 | 37.745499012663 | -122.433593958215 | (37.745499012663, -122.433593958215) | 2 | 7 | 5 | 63 | 22 | |||
| 69293 | 100901 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 4x4 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
| 72619 | 100020 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 73622 | 24333 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 9 | 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 | ||||
| 78272 | 126292 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1198 Columbus Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6007576.38379 | 2121572.19977 | 37.8058603240585 | -122.418056390085 | (37.8058603240585, -122.418056390085) | 5 | 1 | 10 | 308 | 23 | |||
| 79421 | 29636 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | ||
| 80357 | 12129 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X La Salle Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6016454.92328 | 2095170.51744 | 37.7338627575466 | -122.385489476485 | (37.7338627575466, -122.385489476485) | 10 | 3 | 8 | 58 | 1 | |||
| 81682 | 212132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Miramar Ave | 9 | Median : Yard | Tree | DPW 1 | 33 | 5995375.30973 | 2092922.42776 | 37.7265012166564 | -122.458204939309 | (37.7265012166564, -122.458204939309) | 9 | 7 | 4 | 28861 | 40 | ||||
| 83353 | 24460 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 84107 | 248764 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3235 18th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008029.67653 | 2105592.50304 | 37.7620094440008 | -122.415355734976 | (37.7620094440008, -122.415355734976) | 2 | 4 | 7 | 28859 | 19 | |||
| 88145 | 1271 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3995X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992356.50735 | 2087300.81856 | 37.7108917180496 | -122.468231949349 | (37.7108917180496, -122.468231949349) | 9 | 8 | 4 | 64 | 24 | |||
| 91092 | 248722 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6007990.99054 | 2107654.48225 | 37.767668985552 | -122.415635535654 | (37.767668985552, -122.415635535654) | 8 | 4 | 7 | 28853 | 19 | |||
| 95131 | 176020 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 9 | Front Yard : Yard | Tree | Private 2 | 10 | 6009615.52074 | 2089232.9452 | 37.7171786482456 | -122.408716720218 | (37.7171786482456, -122.408716720218) | 9 | 7 | 8 | 309 | 18 | ||||
| 99797 | 251392 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Bosworth St | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 3ft | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 106868 | 6332 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1895X Ellis St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | 15 | 5 | 11 | 29490 | 41 | |||
| 109139 | 2062 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Bosworth St | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6001908.8431877 | 2095495.9697002 | 37.7339408370986 | -122.435802866841 | (37.7339408370986, -122.435802866841) | 9 | 7 | 5 | 63 | 7 | |||
| 113240 | 2054 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 701X Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002076.85589 | 2095385.40046 | 37.7336467817625 | -122.435214090464 | (37.7336467817625, -122.435214090464) | 9 | 7 | 5 | 63 | 40 | |||
| 117410 | 114174 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x SHRADER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997234 | 2110523 | 37.7749346499606 | -122.453049512511 | (37.7749346499606, -122.453049512511) | 15 | 5 | 2 | 29492 | 16 | ||||
| 123848 | 29965 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 20 | 3x3 | 5991402.31851 | 2093518.0307 | 37.7279074991302 | -122.471982668166 | (37.7279074991302, -122.471982668166) | 9 | 8 | 4 | 59 | 40 | ||
| 124262 | 22582 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006498.64773 | 2112839.17836 | 37.7818209142342 | -122.421165566743 | (37.7818209142342, -122.421165566743) | 7 | 9 | 11 | 28852 | 41 | |||
| 126641 | 102334 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 3201X 18th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008125.3 | 2105602.6 | 37.7620425418858 | -122.415025724241 | (37.7620425418858, -122.415025724241) | 2 | 4 | 7 | 28859 | 19 | |||
| 127875 | 12553 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280X Lake St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/1992 12:00:00 AM | 24 | 3X3 | 5994647.05266 | 2114915.6366 | 37.7868470540675 | -122.462316907107 | (37.7868470540675, -122.462316907107) | 11 | 6 | 1 | 54 | 11 | ||
| 129232 | 212093 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1485x Northwood Dr | 9 | Median : Yard | Tree | DPW 1 | 22 | 5995874.68785 | 2094051.50206 | 37.7296300659678 | -122.456560233969 | (37.7296300659678, -122.456560233969) | 9 | 7 | 4 | 28861 | 40 | ||||
| 133078 | 218282 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Woodacre Dr | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5991361.16684 | 2095634.83429 | 37.7337173290882 | -122.472279171949 | (37.7337173290882, -122.472279171949) | 1 | 8 | 4 | 64 | 40 | ||||
| 133620 | 14883 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Mendell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017019.70543 | 2098544.01606 | 37.7431569388511 | -122.383771637374 | (37.7431569388511, -122.383771637374) | 10 | 3 | 8 | 58 | 1 | ||
| 137977 | 222115 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4090 20th St | 9 | : Yard | Tree | Private 2 | 15 | Width 3ft | 6003100.58415 | 2104168.90978 | 37.757822330949 | -122.432301861758 | (37.757822330949, -122.432301861758) | 2 | 4 | 5 | 28862 | 3 | |||
| 138841 | 121112 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 Stanyan St | 9 | 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 | |||
| 138870 | 26461 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017579.0331604 | 2096478.0920021 | 37.7375152284127 | -122.381693959087 | (37.7375152284127, -122.381693959087) | 10 | 3 | 8 | 58 | 1 | |||
| 142597 | 189437 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 9 | : | Tree | Private 2 | 13 | Width 4ft | 6016936.32054 | 2097949.49231 | 37.7415198876289 | -122.384018572307 | (37.7415198876289, -122.384018572307) | 10 | 3 | 8 | 58 | 1 | |||
| 147605 | 126336 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 537 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011931.21803 | 2117719.21185 | 37.7955250929746 | -122.402714594497 | (37.7955250929746, -122.402714594497) | 3 | 1 | 10 | 28860 | 4 | |||
| 148382 | 217821 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x Junipero Serra Blvd | 9 | Median : Yard | Tree | DPW 1 | 65 | 5991615.01367 | 2095586.81694 | 37.7336001735084 | -122.471398059368 | (37.7336001735084, -122.471398059368) | 1 | 8 | 4 | 59 | 40 | ||||
| 159729 | 99173 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003311.25259 | 2116120.54401 | 37.790650512059 | -122.432426898975 | (37.790650512059, -122.432426898975) | 13 | 9 | 1 | 29490 | 27 | ||
| 163304 | 123257 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 735 07th Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 5993773.776 | 2110615.61504 | 37.7749900336609 | -122.465025796945 | (37.7749900336609, -122.465025796945) | 11 | 6 | 2 | 54 | 11 | |||
| 164538 | 24321 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006368.77272 | 2112521.86674 | 37.7809423314653 | -122.42159233104 | (37.7809423314653, -122.42159233104) | 7 | 9 | 11 | 28852 | 41 | |||
| 166038 | 212010 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 302 San Fernando Way | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 8ft | 5992076.0582 | 2094714.79512 | 37.7312324797943 | -122.46974064572 | (37.7312324797943, -122.46974064572) | 9 | 8 | 4 | 59 | 40 | |||
| 168400 | 111217 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 3100x 19TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
| 172958 | 137531 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300 Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 6002253.4953 | 2113234.369 | 37.7826657756616 | -122.435880078144 | (37.7826657756616, -122.435880078144) | 15 | 5 | 11 | 29490 | 41 | |||
| 174160 | 248870 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3101 19th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008540.54057 | 2105084.00095 | 37.7606419133052 | -122.413552882963 | (37.7606419133052, -122.413552882963) | 2 | 4 | 7 | 28859 | 19 | |||
| 176875 | 212201 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 820 Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6001684.04904 | 2095564.31513 | 37.7341157260662 | -122.436584937851 | (37.7341157260662, -122.436584937851) | 9 | 7 | 5 | 63 | 7 | |||
| 181411 | 26472 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
| 182262 | 212208 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001453.89018 | 2095626.12972 | 37.7342723726763 | -122.437385092546 | (37.7342723726763, -122.437385092546) | 9 | 7 | 5 | 63 | 7 | |||
| 183410 | 126310 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011567.70518 | 2121110.48267 | 37.804816396425 | -122.404211216594 | (37.804816396425, -122.404211216594) | 3 | 1 | 10 | 28860 | 6 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 63771 | 248654 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 San Jose Ave | 81 | Front Yard : Yard | Tree | Private 2 | 15 | 6005089.97805 | 2097022.6793 | 37.7383130275105 | -122.424913285419 | (37.7383130275105, -122.424913285419) | 2 | 7 | 5 | 28859 | 7 | ||||
| 10238 | 255130 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 14784 | 141149 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1934 O'Farrell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 0ft | 6001965.0616 | 2113298.9081 | 37.7828265946555 | -122.436882555626 | (37.7828265946555, -122.436882555626) | 13 | 5 | 11 | 29490 | 41 | |||
| 18540 | 48750 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
| 20880 | 99966 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
| 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 | |||
| 24690 | 6331 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1895X Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | 15 | 5 | 11 | 29490 | 41 | |||
| 25023 | 176021 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 8 | Front Yard : Yard | Tree | Private 2 | 5 | 6009620.69504 | 2089243.53702 | 37.7172080210075 | -122.408699581837 | (37.7172080210075, -122.408699581837) | 9 | 7 | 8 | 309 | 18 | ||||
| 31160 | 7815 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006205.55902 | 2112775.31728 | 37.781629040289 | -122.422174980189 | (37.781629040289, -122.422174980189) | 7 | 9 | 11 | 28852 | 41 | |||
| 33450 | 2077 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900X Bosworth St | 8 | 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 | |||
| 35794 | 12552 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280X Lake St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5994647.05266 | 2114915.6366 | 37.7868470540675 | -122.462316907107 | (37.7868470540675, -122.462316907107) | 11 | 6 | 1 | 54 | 11 | |||
| 36873 | 137530 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300 Pierce St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 0ft | 6002254.2482 | 2113206.1329 | 37.7825882892496 | -122.435875452468 | (37.7825882892496, -122.435875452468) | 15 | 5 | 11 | 29490 | 41 | |||
| 37787 | 2061 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Bosworth St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6001908.8431877 | 2095495.9697002 | 37.7339408370986 | -122.435802866841 | (37.7339408370986, -122.435802866841) | 9 | 7 | 5 | 63 | 7 | |||
| 37955 | 126239 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1047 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6005998.3015 | 2113461.40483 | 37.7835011760695 | -122.422940770919 | (37.7835011760695, -122.422940770919) | 7 | 9 | 11 | 28858 | 41 | |||
| 38501 | 99172 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003312.12208 | 2116110.60344 | 37.7906232670935 | -122.432423180296 | (37.7906232670935, -122.432423180296) | 13 | 9 | 1 | 29490 | 27 | ||
| 38626 | 206413 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Castenada Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5994394.18927 | 2101806.70961 | 37.7508388236662 | -122.462240662288 | (37.7508388236662, -122.462240662288) | 1 | 8 | 4 | 29491 | 40 | |||
| 42309 | 24332 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1999 12:00:00 AM | 9 | 6006393.27479 | 2112527.98365 | 37.7809605085733 | -122.421508000714 | (37.7809605085733, -122.421508000714) | 7 | 9 | 11 | 28852 | 41 | |||
| 43951 | 2040 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Bosworth St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | |||
| 50134 | 100004 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 51463 | 29599 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900X Junipero Serra Blvd | 8 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.65606 | 2091094.6598 | 37.7212404641514 | -122.472586172621 | (37.7212404641514, -122.472586172621) | 9 | 8 | 4 | 64 | 40 | ||
| 51500 | 126291 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1198 Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007589.25664 | 2121562.16822 | 37.8058335044831 | -122.418011129904 | (37.8058335044831, -122.418011129904) | 5 | 1 | 10 | 308 | 23 | |||
| 52010 | 212186 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 620 Bosworth St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002182.4808 | 2095438.09218 | 37.7337974586866 | -122.434852681701 | (37.7337974586866, -122.434852681701) | 2 | 7 | 5 | 63 | 7 | |||
| 53491 | 2119 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
| 53913 | 212160 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Marietta Dr | 8 | Median : Cutout | Tree | DPW 1 | 21 | Width 5ft | 5999181.20972 | 2097594.91111 | 37.7395487140123 | -122.44538396231 | (37.7395487140123, -122.44538396231) | 9 | 7 | 4 | 59 | 40 | |||
| 53974 | 11776 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Junipero Serra Blvd | 8 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991282.42505 | 2091712.43436 | 37.7229428421321 | -122.472265573297 | (37.7229428421321, -122.472265573297) | 9 | 8 | 4 | 59 | 40 | ||
| 57270 | 142393 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 0ft | 5997963.0546 | 2114567.8206 | 37.7860824259012 | -122.45081927712 | (37.7860824259012, -122.45081927712) | 11 | 6 | 1 | 54 | 31 | |||
| 57954 | 189478 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 149 Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6015975.4745 | 2113658.63609 | 37.7846006521455 | -122.388437087216 | (37.7846006521455, -122.388437087216) | 6 | 2 | 9 | 28856 | 6 | |||
| 61110 | 26471 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 8 | 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 | |||
| 64433 | 126309 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6011549.22604 | 2121109.21321 | 37.8048118782298 | -122.404275076545 | (37.8048118782298, -122.404275076545) | 3 | 1 | 10 | 28860 | 6 | |||
| 69323 | 212131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Miramar Ave | 8 | Median : Yard | Tree | DPW 1 | 34 | 5995375.28934 | 2092898.1948 | 37.7264346776031 | -122.458203256672 | (37.7264346776031, -122.458203256672) | 9 | 7 | 4 | 28861 | 40 | ||||
| 69678 | 212092 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1485x Northwood Dr | 8 | Median : Yard | Tree | DPW 1 | 31 | 5995863.34016 | 2094047.68745 | 37.7296189404529 | -122.456599188129 | (37.7296189404529, -122.456599188129) | 9 | 7 | 4 | 28861 | 40 |
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) );