trees
121 rows where qSpecies_id = 82 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124211 | 114679 | DPW Maintained 1 | Malus :: Crab Apple 82 | 836 Brussels St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774714 | 6011176.24092 | 2090873.36995 | 37.7217702116011 | -122.403437363447 | (37.7217702116011, -122.403437363447) | 10 | 3 | 7 | 309 | 28 | ||
| 76311 | 108272 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | ||||
| 90573 | 108273 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | ||||
| 126435 | 108271 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | |||
| 192547 | 108274 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | ||||
| 90212 | 193450 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2000 18th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011681.52321 | 2105621.1617 | 37.7622927061762 | -122.40272735948 | (37.7622927061762, -122.40272735948) | 8 | 3 | 8 | 28856 | 29 | ||||
| 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 | ||||
| 80759 | 193451 | DPW Maintained 1 | Malus :: Crab Apple 82 | 760 De Haro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 9ft | 6012093.60455 | 2104911.13829 | 37.7603661389049 | -122.401252219518 | (37.7603661389049, -122.401252219518) | 10 | 3 | 8 | 28856 | 29 | |||
| 148705 | 193448 | DPW Maintained 1 | Malus :: Crab Apple 82 | 763 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6012158.68635 | 2104851.39826 | 37.7602057367258 | -122.40102293287 | (37.7602057367258, -122.40102293287) | 10 | 3 | 8 | 28856 | 29 | |||
| 145597 | 193447 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2 Coral Rd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012664.55802 | 2102543.04273 | 37.7538957038432 | -122.399111318627 | (37.7538957038432, -122.399111318627) | 10 | 3 | 8 | 28856 | 29 | ||||
| 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 | ||||
| 122356 | 193445 | DPW Maintained 1 | Malus :: Crab Apple 82 | 545 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6012707.67421 | 2104954.65178 | 37.7605198573339 | -122.399131478736 | (37.7605198573339, -122.399131478736) | 10 | 3 | 8 | 28856 | 29 | |||
| 69983 | 193454 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1751 22nd St | 4 | Side Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6012836.35508 | 2103764.61447 | 37.7572594461968 | -122.398602916587 | (37.7572594461968, -122.398602916587) | 10 | 3 | 8 | 28856 | 29 | |||
| 156246 | 193455 | DPW Maintained 1 | Malus :: Crab Apple 82 | 801 Arkansas St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6013064.65639 | 2103684.54152 | 37.7570522999402 | -122.397807739653 | (37.7570522999402, -122.397807739653) | 10 | 3 | 8 | 28856 | 29 | ||||
| 78883 | 202162 | DPW Maintained 1 | Malus :: Crab Apple 82 | 10 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6013172.6175 | 2093312.6442 | 37.7285792692962 | -122.396707277937 | (37.7285792692962, -122.396707277937) | 10 | 3 | 8 | 58 | 1 | |||
| 114857 | 193457 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 4 | Front Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 6013271.29091 | 2096357.05994 | 37.7369440992788 | -122.396579478874 | (37.7369440992788, -122.396579478874) | 10 | 3 | 8 | 58 | 1 | |||
| 104038 | 193458 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | Width 4ft | 6013271.57889 | 2096363.22177 | 37.7369610344099 | -122.396578915001 | (37.7369610344099, -122.396578915001) | 10 | 3 | 8 | 58 | 1 | |||
| 152545 | 193459 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 6 | Front Yard : Yard | Tree | Private 2 | 3 | Width 4ft | 6013276.74454 | 2096368.79771 | 37.7369766322662 | -122.396561445667 | (37.7369766322662, -122.396561445667) | 10 | 3 | 8 | 58 | 1 | |||
| 36495 | 193460 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 7 | Front Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6013283.26948 | 2096377.10518 | 37.736999805981 | -122.396539468037 | (37.736999805981, -122.396539468037) | 10 | 3 | 8 | 58 | 1 | |||
| 163573 | 193444 | DPW Maintained 1 | Malus :: Crab Apple 82 | 800 19th St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6014945.20165 | 2105329.27451 | 37.7616729293835 | -122.391419022363 | (37.7616729293835, -122.391419022363) | 10 | 3 | 8 | 28856 | 29 | |||
| 175413 | 96996 | Significant Tree 6 | Malus :: Crab Apple 82 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 |
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) );