trees
121 rows where qSpecies_id = 82 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32566 | 208882 | DPW Maintained 1 | Malus :: Crab Apple 82 | 322 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994766.71833 | 2090736.01345 | 37.7204628590582 | -122.460150467892 | (37.7204628590582, -122.460150467892) | 9 | 8 | 6 | 28861 | 24 | |||
| 32185 | 208893 | DPW Maintained 1 | Malus :: Crab Apple 82 | 326 Detroit St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 5999451.44674 | 2094281.11232 | 37.7304652267742 | -122.444211538625 | (37.7304652267742, -122.444211538625) | 9 | 7 | 4 | 63 | 40 | |||
| 31702 | 193449 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2000 18th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011690.74691 | 2105621.1854 | 37.7622932862384 | -122.402695459648 | (37.7622932862384, -122.402695459648) | 8 | 3 | 8 | 28856 | 29 | ||||
| 31426 | 244062 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1666 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998622.1807 | 2109013.5796 | 37.7708696265101 | -122.448138811863 | (37.7708696265101, -122.448138811863) | 15 | 5 | 11 | 29492 | 9 | |||
| 30178 | 231494 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6002235.98479 | 2097691.64052 | 37.7399882198726 | -122.434828804717 | (37.7399882198726, -122.434828804717) | 2 | 7 | 5 | 63 | 7 | |||
| 24034 | 231489 | DPW Maintained 1 | Malus :: Crab Apple 82 | 3931 21st St | 5 | Front Yard : Yard | Tree | Private 2 | 10 | 6002270.32487 | 2103522.49736 | 37.7560003260644 | -122.435127007321 | (37.7560003260644, -122.435127007321) | 2 | 4 | 5 | 28862 | 22 | ||||
| 22243 | 231467 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6004723.8665 | 2096633.35194 | 37.7372233360818 | -122.426151410869 | (37.7372233360818, -122.426151410869) | 2 | 7 | 5 | 63 | 7 | ||||
| 21017 | 111270 | DPW Maintained 1 | Malus :: Crab Apple 82 | 700X BOSWORTH ST | 8 | Front Yard : Yard | Tree | DPW 1 | 10 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 20999 | 231487 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2119 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 8ft | 6002708.75912 | 2099359.82748 | 37.7445955042953 | -122.433313320275 | (37.7445955042953, -122.433313320275) | 2 | 7 | 5 | 63 | 22 | |||
| 17783 | 19925 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100 STAIRWAY37 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 17133 | 183310 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1278 42nd Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983073.0612 | 2106470.9099 | 37.762987036737 | -122.501734562858 | (37.762987036737, -122.501734562858) | 1 | 8 | 3 | 56 | 35 | |||
| 15570 | 208891 | DPW Maintained 1 | Malus :: Crab Apple 82 | 843 Detroit St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5999418.11372 | 2095604.85507 | 37.7340980120977 | -122.444421872075 | (37.7340980120977, -122.444421872075) | 9 | 7 | 4 | 59 | 40 | |||
| 14757 | 208879 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100x Idora Ave | 19 | Median : Yard | Tree | DPW 1 | 7 | Width 9ft | 5995727.40355 | 2099320.34097 | 37.7440885519582 | -122.457450449475 | (37.7440885519582, -122.457450449475) | 1 | 8 | 4 | 59 | 40 | |||
| 14342 | 185383 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2611 45th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5982402.2599 | 2097319.6826 | 37.7378209010805 | -122.503376950994 | (37.7378209010805, -122.503376950994) | 1 | 8 | 3 | 29491 | 35 | |||
| 13342 | 19760 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100 STAIRWAY15 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 12683 | 30939 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1106 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 2 | 3x32l | Permit Number 34749 | 5995956.73481 | 2091308.07941 | 37.7221019930946 | -122.456078325968 | (37.7221019930946, -122.456078325968) | 9 | 8 | 4 | 28861 | 24 | |
| 11647 | 19855 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100 STAIRWAY29 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
| 10841 | 177480 | DPW Maintained 1 | Malus :: Crab Apple 82 | 289 Flournoy St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | 5993810.32054 | 2086750.18301 | 37.7094636621006 | -122.463167341725 | (37.7094636621006, -122.463167341725) | 9 | 8 | 6 | 28861 | 25 | ||||
| 4797 | 19759 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100 STAIRWAY15 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 1678 | 193446 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2 Coral Rd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6012678.27331 | 2102537.38996 | 37.7538809468742 | -122.399063490894 | (37.7538809468742, -122.399063490894) | 10 | 3 | 8 | 28856 | 29 | ||||
| 275 | 193456 | DPW Maintained 1 | Malus :: Crab Apple 82 | 185 Hampshire St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 5ft | 6010023.67884 | 2107445.71101 | 37.76720979983 | -122.40858996078 | (37.76720979983, -122.40858996078) | 8 | 4 | 8 | 28853 | 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) );