trees
121 rows where qSpecies_id = 82 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188281 | 208877 | DPW Maintained 1 | Malus :: Crab Apple 82 | 136 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995442.32442 | 2097008.84044 | 37.7377253637243 | -122.458268913495 | (37.7377253637243, -122.458268913495) | 9 | 7 | 4 | 59 | 40 | |||
191249 | 208880 | DPW Maintained 1 | Malus :: Crab Apple 82 | 331 Kensington Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994249.09162 | 2099012.51392 | 37.7431583121036 | -122.462539760623 | (37.7431583121036, -122.462539760623) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
36521 | 231492 | DPW Maintained 1 | Malus :: Crab Apple 82 | 118 Saint Marys Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003928.90104 | 2095975.35964 | 37.7353716742659 | -122.428853075008 | (37.7353716742659, -122.428853075008) | 2 | 7 | 5 | 63 | 7 | |||
37326 | 231483 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1604 Diamond St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6002002.63462 | 2099363.53444 | 37.7445655982382 | -122.435755219736 | (37.7445655982382, -122.435755219736) | 2 | 7 | 5 | 63 | 22 | |||
38391 | 56772 | Permitted Site 7 | Malus :: Crab Apple 82 | 4147 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | Permit Number 777832 | 6002943.47271565 | 2100629.70644343 | 37.7480956077539 | -122.432592417618 | (37.7480956077539, -122.432592417618) | 2 | 4 | 5 | 63 | 22 | ||
47430 | 231469 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6004732.5768 | 2096627.96754 | 37.7372090440461 | -122.426120912148 | (37.7372090440461, -122.426120912148) | 2 | 7 | 5 | 63 | 7 | ||||
79973 | 208886 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100 Joost Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6001302.89972 | 2094970.3961 | 37.7324632946503 | -122.437860163028 | (37.7324632946503, -122.437860163028) | 9 | 7 | 5 | 63 | 40 | |||
108858 | 231491 | DPW Maintained 1 | Malus :: Crab Apple 82 | 231 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001952.57165 | 2096161.99375 | 37.7357720695123 | -122.435699318774 | (37.7357720695123, -122.435699318774) | 2 | 7 | 5 | 63 | 7 | |||
116776 | 231468 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6004726.49867 | 2096628.95996 | 37.7372114254688 | -122.426141997667 | (37.7372114254688, -122.426141997667) | 2 | 7 | 5 | 63 | 7 | ||||
119727 | 231493 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6002237.63018 | 2097698.28157 | 37.7400065480711 | -122.434823590441 | (37.7400065480711, -122.434823590441) | 2 | 7 | 5 | 63 | 7 | |||
141816 | 231495 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6002243.19948 | 2097700.16893 | 37.7400120465212 | -122.434804469057 | (37.7400120465212, -122.434804469057) | 2 | 7 | 5 | 63 | 7 | |||
142430 | 231470 | DPW Maintained 1 | Malus :: Crab Apple 82 | 200 Saint Marys Ave | 4 | Side Yard : Yard | Tree | Private 2 | 5 | Width 2ft | 6003936.80205 | 2095969.7041 | 37.7353565926307 | -122.42882535522 | (37.7353565926307, -122.42882535522) | 2 | 7 | 5 | 63 | 7 | |||
152179 | 231490 | DPW Maintained 1 | Malus :: Crab Apple 82 | 144 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004625.22033 | 2097267.44339 | 37.7389588315807 | -122.42653761393 | (37.7389588315807, -122.42653761393) | 2 | 7 | 5 | 63 | 7 | |||
173142 | 4977 | DPW Maintained 1 | Malus :: Crab Apple 82 | 5200X Diamond Heights Blvd | 13 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6000986.47805 | 2099376.03086 | 37.7445421376042 | -122.439269772981 | (37.7445421376042, -122.439269772981) | 2 | 7 | 5 | 63 | 7 | |||
190829 | 208889 | DPW Maintained 1 | Malus :: Crab Apple 82 | 714 Detroit St | 10 | Side Yard : Yard | Tree | Private 2 | 6 | 5999450.60571 | 2095416.85302 | 37.7335836565405 | -122.444296031762 | (37.7335836565405, -122.444296031762) | 9 | 7 | 4 | 63 | 40 | ||||
84907 | 208884 | DPW Maintained 1 | Malus :: Crab Apple 82 | 450 Bright St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 5993793.06593 | 2090164.68597 | 37.7188380799952 | -122.46347460498 | (37.7188380799952, -122.46347460498) | 9 | 8 | 6 | 64 | 24 |
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) );