trees
22 rows where qSpecies_id = 275
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4121 | 140633 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 498 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5996881.0877 | 2109845.2546 | 37.7730535057546 | -122.454221341129 | (37.7730535057546, -122.454221341129) | 15 | 5 | 2 | 29492 | 16 | |||
| 12398 | 140653 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 117 Shrader St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5997311.6833 | 2109908.6845 | 37.7732523506079 | -122.452736443592 | (37.7732523506079, -122.452736443592) | 15 | 5 | 2 | 29492 | 16 | |||
| 19198 | 75086 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 450 Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5x5 | 5996845.061 | 2110107.7895 | 37.7737722923526 | -122.45436492894 | (37.7737722923526, -122.45436492894) | 15 | 5 | 2 | 29492 | 16 | ||
| 27969 | 185244 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 2559 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5986116.5072 | 2097821.4777 | 37.7394163458868 | -122.490572078711 | (37.7394163458868, -122.490572078711) | 1 | 8 | 3 | 29491 | 35 | |||
| 30068 | 1909 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 47 Beideman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001510.2227 | 2113085.0255 | 37.7822134660516 | -122.438440775498 | (37.7822134660516, -122.438440775498) | 15 | 5 | 11 | 29490 | 41 | |||
| 43026 | 140749 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 59 BEIDEMAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6001509.5459 | 2113123.2672 | 37.7823184295271 | -122.438445857643 | (37.7823184295271, -122.438445857643) | 15 | 5 | 11 | 29490 | 41 | |||
| 45773 | 139680 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 2200 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6000664.8886 | 2113151.5427 | 37.7823479853916 | -122.441370019276 | (37.7823479853916, -122.441370019276) | 15 | 5 | 1 | 29490 | 41 | |||
| 50193 | 80838 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 2210 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50737 | 5982367.3505 | 2100035.4874 | 37.7452757006878 | -122.503698716143 | (37.7452757006878, -122.503698716143) | 1 | 8 | 3 | 29491 | 35 | |
| 62351 | 140949 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 2060 Ofarrell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6001488 | 2113369 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | 15 | 5 | 11 | 29490 | 41 | |||
| 63438 | 140652 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 115 Shrader St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997309.3837 | 2109929.764 | 37.7733100976884 | -122.452745919872 | (37.7733100976884, -122.452745919872) | 15 | 5 | 2 | 29492 | 16 | |||
| 68159 | 244542 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 1520 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 5999085.4254 | 2109079.6963 | 37.7710776370382 | -122.446541201155 | (37.7710776370382, -122.446541201155) | 15 | 5 | 11 | 29492 | 9 | |||
| 77937 | 25239 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 1199X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5996283.2054 | 2091824.5737 | 37.7235388978416 | -122.454987105753 | (37.7235388978416, -122.454987105753) | 9 | 8 | 4 | 28861 | 24 | |||
| 88922 | 139679 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 2200 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000698.184 | 2113151.9086 | 37.7823508867449 | -122.441254858469 | (37.7823508867449, -122.441254858469) | 15 | 5 | 1 | 29490 | 41 | |||
| 113127 | 141297 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 1835 ELLIS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002096.3693 | 2112918.522 | 37.7817896128573 | -122.436401053619 | (37.7817896128573, -122.436401053619) | 15 | 5 | 11 | 29490 | 41 | |||
| 137058 | 199340 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 1130 Connecticut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | Width 8ft | 6013385.17771 | 2101675.07072 | 37.751552571505 | -122.396558390655 | (37.751552571505, -122.396558390655) | 10 | 3 | 8 | 28856 | 29 | |||
| 140095 | 245163 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 1310 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000215.6172 | 2109235.6996 | 37.77157047334 | -122.442643044641 | (37.77157047334, -122.442643044641) | 15 | 5 | 11 | 29492 | 9 | |||
| 145045 | 140289 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 143 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5998736.4414 | 2110178.4157 | 37.7740744999849 | -122.447827456218 | (37.7740744999849, -122.447827456218) | 15 | 5 | 11 | 29492 | 16 | |||
| 163475 | 139675 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 2130 O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000973.3282 | 2113158.8604 | 37.7823856440019 | -122.440303482082 | (37.7823856440019, -122.440303482082) | 15 | 5 | 11 | 29490 | 41 | |||
| 164215 | 140651 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 113 Shrader St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997307.4674 | 2109953.9095 | 37.7733762851731 | -122.452754291616 | (37.7733762851731, -122.452754291616) | 15 | 5 | 2 | 29492 | 16 | |||
| 174453 | 141148 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 1930 O'Farrell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6001986.0438 | 2113301.6154 | 37.7828352207239 | -122.436810160003 | (37.7828352207239, -122.436810160003) | 13 | 5 | 11 | 29490 | 41 | |||
| 175683 | 245002 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 1424 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5999732.5024 | 2109169.2235 | 37.7713603951949 | -122.444309382403 | (37.7713603951949, -122.444309382403) | 15 | 5 | 11 | 29492 | 9 | |||
| 184848 | 141151 | DPW Maintained 1 | Eucalyptus robusta :: Swamp mahogany 275 | 1950 O'Farrell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 6001871.3188 | 2113285.3712 | 37.78278409741 | -122.437205896264 | (37.78278409741, -122.437205896264) | 13 | 5 | 11 | 29490 | 41 |
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) );