trees
121 rows where qSpecies_id = 82 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 131950 | 11189 | DPW Maintained 1 | Malus :: Crab Apple 82 | 130 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 5995756.5668063 | 2099351.3416202 | 37.7441753471304 | -122.457351852348 | (37.7441753471304, -122.457351852348) | 1 | 8 | 4 | 59 | 40 | |||
| 155688 | 248559 | DPW Maintained 1 | Malus :: Crab Apple 82 | 776 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998007.1271 | 2107705.5553 | 37.7672429465083 | -122.450171990254 | (37.7672429465083, -122.450171990254) | 15 | 5 | 11 | 29492 | 9 | |||
| 187628 | 177483 | DPW Maintained 1 | Malus :: Crab Apple 82 | 37 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6005099.05752 | 2093268.21852 | 37.7280046286024 | -122.424614893969 | (37.7280046286024, -122.424614893969) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 166690 | 208878 | DPW Maintained 1 | Malus :: Crab Apple 82 | 430 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5995998.78542 | 2096380.30117 | 37.7360315086418 | -122.456299537593 | (37.7360315086418, -122.456299537593) | 9 | 7 | 4 | 59 | 40 | |||
| 188003 | 246802 | DPW Maintained 1 | Malus :: Crab Apple 82 | 369 Mullen Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6010622.51697 | 2099596.58355 | 37.7456913641809 | -122.405965658085 | (37.7456913641809, -122.405965658085) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 63848 | 231474 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2044 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009525.85119 | 2105200.14517 | 37.7610160960274 | -122.410153325135 | (37.7610160960274, -122.410153325135) | 2 | 4 | 7 | 28859 | 19 | |||
| 73687 | 231482 | DPW Maintained 1 | Malus :: Crab Apple 82 | 60 Murray St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6004917.71249 | 2095272.09944 | 37.7334965967716 | -122.425384353019 | (37.7334965967716, -122.425384353019) | 2 | 7 | 7 | 28861 | 2 | |||
| 129380 | 231473 | DPW Maintained 1 | Malus :: Crab Apple 82 | 400 Prospect Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6006235.9692 | 2097629.5715 | 37.7400440821557 | -122.420994082235 | (37.7400440821557, -122.420994082235) | 2 | 7 | 7 | 28859 | 2 | ||||
| 154390 | 208873 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1915 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5992820.79743 | 2102456.25278 | 37.7525315806908 | -122.46772878318 | (37.7525315806908, -122.46772878318) | 1 | 8 | 4 | 29491 | 12 | |||
| 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 | |||
| 115277 | 177471 | DPW Maintained 1 | Malus :: Crab Apple 82 | 184 Mount Vernon Ave | 3 | Side Yard : Yard | Tree | Private 2 | 9 | 5998983.26506 | 2089357.76175 | 37.7169201246297 | -122.445476221974 | (37.7169201246297, -122.445476221974) | 9 | 7 | 6 | 28861 | 25 | ||||
| 134041 | 177470 | DPW Maintained 1 | Malus :: Crab Apple 82 | 184 Mount Vernon Ave | 2 | Side Yard : Yard | Tree | Private 2 | 9 | 5998987.4843 | 2089354.3008 | 37.7169108625194 | -122.445461389446 | (37.7169108625194, -122.445461389446) | 9 | 7 | 6 | 28861 | 25 | ||||
| 181280 | 117508 | Undocumented 4 | Malus :: Crab Apple 82 | 21 MOUNTAIN SPRING AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 9 | 3x10 | Permit Number 778424 | 5997487 | 2104391 | 37.7581122388252 | -122.451731896555 | (37.7581122388252, -122.451731896555) | 15 | 5 | 4 | 28862 | 38 |
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) );