trees
12 rows where qSpecies_id = 490 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
160799 | 108897 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 321 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772765 | 6000249.7942 | 2087141.74128 | 37.7109076522403 | -122.44093957482 | (37.7109076522403, -122.44093957482) | 9 | 7 | 6 | 28861 | 5 |
177433 | 223348 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 148 Highland Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 6005777.46751 | 2096628.97923 | 37.7372708238985 | -122.422508313901 | (37.7372708238985, -122.422508313901) | 2 | 7 | 7 | 28859 | 2 | |||
174315 | 223352 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 105 Fairmount St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004725.01914 | 2097238.37288 | 37.7388846519014 | -122.42619048641 | (37.7388846519014, -122.42619048641) | 2 | 7 | 5 | 63 | 7 | |||
187206 | 223343 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 49 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008235.12942 | 2099945.56148 | 37.7465157672901 | -122.414245603756 | (37.7465157672901, -122.414245603756) | 2 | 7 | 7 | 28859 | 2 | |||
144271 | 223344 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 49 Manchester St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008234.7233 | 2099956.9963 | 37.7465471419448 | -122.414247816977 | (37.7465471419448, -122.414247816977) | 2 | 7 | 7 | 28859 | 2 | |||
93501 | 223345 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 49 Manchester St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008233.66961 | 2099967.65698 | 37.7465763546083 | -122.414252214673 | (37.7465763546083, -122.414252214673) | 2 | 7 | 7 | 28859 | 2 | |||
89580 | 223346 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 49 Manchester St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008234.13105 | 2099977.77966 | 37.7466041751511 | -122.414251335138 | (37.7466041751511, -122.414251335138) | 2 | 7 | 7 | 28859 | 2 | |||
62926 | 256695 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 49 Manchester St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6008233.34715 | 2099989.19469 | 37.7466354742457 | -122.414254853292 | (37.7466354742457, -122.414254853292) | 2 | 7 | 7 | 28859 | 2 | ||||
111544 | 223347 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 49 Manchester St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008233.34715 | 2099989.19469 | 37.7466354742457 | -122.414254853292 | (37.7466354742457, -122.414254853292) | 2 | 7 | 7 | 28859 | 2 | |||
95189 | 223349 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 3141 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007332.11246 | 2103804.72913 | 37.7570613992842 | -122.417641626361 | (37.7570613992842, -122.417641626361) | 2 | 4 | 7 | 28859 | 19 | |||
168506 | 223350 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 3141 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007345.97081 | 2103804.71664 | 37.7570621448052 | -122.417593697901 | (37.7570621448052, -122.417593697901) | 2 | 4 | 7 | 28859 | 19 | |||
174957 | 223351 | DPW Maintained 1 | Dypsis cabadae :: Cabada palm 490 | 3141 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007355.43704 | 2103805.26091 | 37.7570641719034 | -122.417560998562 | (37.7570641719034, -122.417560998562) | 2 | 4 | 7 | 28859 | 19 |
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) );