trees
21 rows where qSpecies_id = 272
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4021 | 218797 | DPW Maintained 1 | Fagus sylvatica :: European Beech 272 | 215 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 4ft | 5994944.25592 | 2100553.85526 | 37.7474304587646 | -122.460247733165 | (37.7474304587646, -122.460247733165) | 1 | 8 | 4 | 29491 | 40 | |||
| 8444 | 103091 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008424.20559 | 2117797.21945 | 37.7955428518875 | -122.414855023041 | (37.7955428518875, -122.414855023041) | 5 | 1 | 10 | 308 | 21 | |
| 9912 | 103092 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008422.05981 | 2117808.63756 | 37.7955740826282 | -122.414863256344 | (37.7955740826282, -122.414863256344) | 5 | 1 | 10 | 308 | 21 | |
| 10996 | 103096 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008414.12252 | 2117870.41106 | 37.7957432514055 | -122.414895095058 | (37.7957432514055, -122.414895095058) | 5 | 1 | 10 | 308 | 21 | |
| 14679 | 103093 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008420.39916 | 2117820.52002 | 37.7956066156178 | -122.414869843894 | (37.7956066156178, -122.414869843894) | 5 | 1 | 10 | 308 | 21 | |
| 17667 | 103095 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008416.42419 | 2117851.09099 | 37.7956903325975 | -122.414885762773 | (37.7956903325975, -122.414885762773) | 5 | 1 | 10 | 308 | 21 | |
| 18706 | 103094 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008418.50881 | 2117836.67229 | 37.7956508595435 | -122.414877528601 | (37.7956508595435, -122.414877528601) | 5 | 1 | 10 | 308 | 21 | |
| 19455 | 218798 | DPW Maintained 1 | Fagus sylvatica :: European Beech 272 | 215 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 4ft | 5994966.43153 | 2100574.6456 | 37.7474888193606 | -122.460172557931 | (37.7474888193606, -122.460172557931) | 1 | 8 | 4 | 29491 | 40 | |||
| 27211 | 126608 | DPW Maintained 1 | Fagus sylvatica :: European Beech 272 | 2770 Lombard St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5999116.02879 | 2119093.57703 | 37.7985748882819 | -122.447156139343 | (37.7985748882819, -122.447156139343) | 13 | 9 | 1 | 57 | 17 | ||||
| 50624 | 123542 | DPW Maintained 1 | Fagus sylvatica :: European Beech 272 | 37 05th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 5994230.38734 | 2115336.74336 | 37.7879792973558 | -122.463789037794 | (37.7879792973558, -122.463789037794) | 11 | 6 | 1 | 54 | 11 | |||
| 51138 | 102048 | Undocumented 4 | Fagus sylvatica :: European Beech 272 | 213 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994976.9 | 2100573.4 | 37.7474860013873 | -122.46013626866 | (37.7474860013873, -122.46013626866) | 1 | 8 | 4 | 29491 | 40 | |||||
| 61806 | 123541 | DPW Maintained 1 | Fagus sylvatica :: European Beech 272 | 33 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994226.49475 | 2115389.59393 | 37.7881241862842 | -122.463806342918 | (37.7881241862842, -122.463806342918) | 11 | 6 | 1 | 54 | 11 | |||
| 84750 | 218796 | DPW Maintained 1 | Fagus sylvatica :: European Beech 272 | 303 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5994310.29727 | 2099950.16252 | 37.7457363842197 | -122.462396123591 | (37.7457363842197, -122.462396123591) | 1 | 8 | 4 | 29491 | 40 | |||
| 99560 | 186354 | DPW Maintained 1 | Fagus sylvatica :: European Beech 272 | 1801 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984834.846 | 2102662.3098 | 37.7526330064509 | -122.495360347454 | (37.7526330064509, -122.495360347454) | 1 | 8 | 3 | 56 | 35 | |||
| 103546 | 113379 | Property Tree 8 | Fagus sylvatica :: European Beech 272 | 140 CASTENADA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 50 | 5994437 | 2101097 | 37.7488926059174 | -122.462041158848 | (37.7488926059174, -122.462041158848) | 1 | 8 | 4 | 29491 | 40 | ||||
| 120621 | 101625 | Property Tree 8 | Fagus sylvatica :: European Beech 272 | 64 Levant St | 1 | Front Yard : Cutout | Tree | Private 2 | Permit Number 769362 | 6000275.9 | 2106473.5 | 37.7639895997076 | -122.442236202383 | (37.7639895997076, -122.442236202383) | 15 | 5 | 5 | 28862 | 3 | ||||
| 141107 | 249656 | DPW Maintained 1 | Fagus sylvatica :: European Beech 272 | 2401 Lyon St | 8 | Front Yard : Yard | Tree | Private 2 | 3 | Width 10ft | 5999224.17872 | 2117231.23359 | 37.7934675682154 | -122.446647842529 | (37.7934675682154, -122.446647842529) | 11 | 1 | 57 | 30 | ||||
| 151146 | 102049 | Undocumented 4 | Fagus sylvatica :: European Beech 272 | 213 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994976.9 | 2100573.4 | 37.7474860013873 | -122.46013626866 | (37.7474860013873, -122.46013626866) | 1 | 8 | 4 | 29491 | 40 | |||||
| 156934 | 126607 | DPW Maintained 1 | Fagus sylvatica :: European Beech 272 | 2770 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 5999174.46407 | 2119100.33558 | 37.7985967840741 | -122.446954422315 | (37.7985967840741, -122.446954422315) | 13 | 9 | 1 | 57 | 17 | |||
| 186695 | 13297 | DPW Maintained 1 | Fagus sylvatica :: European Beech 272 | 2770 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | Permit Number 770074 | 5999236.74018 | 2119108.91044 | 37.798623886028 | -122.446739545491 | (37.798623886028, -122.446739545491) | 13 | 9 | 1 | 57 | 17 | ||
| 188439 | 126609 | DPW Maintained 1 | Fagus sylvatica :: European Beech 272 | 1183 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008435.25063 | 2117910.57891 | 37.7958547295674 | -122.414824831928 | (37.7958547295674, -122.414824831928) | 5 | 1 | 10 | 308 | 21 |
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) );