trees
14 rows where Neighborhoods (old) = 2 and qSpecies_id = 123 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20731 | 63489 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 319 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50934 | 6006645.5795298 | 2096080.30995427 | 37.7358132351331 | -122.419467931102 | (37.7358132351331, -122.419467931102) | 2 | 7 | 7 | 28859 | 2 | ||
39070 | 241380 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4050 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008348.5979 | 2096262.44881 | 37.7364091240834 | -122.413592786804 | (37.7364091240834, -122.413592786804) | 10 | 7 | 7 | 28859 | 2 | |||
42098 | 241379 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3702 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008438.87775 | 2097614.97452 | 37.7401279331501 | -122.413376271417 | (37.7401279331501, -122.413376271417) | 2 | 7 | 7 | 28859 | 2 | |||
67177 | 241335 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Coso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007049.61155 | 2099992.5386 | 37.7465780921238 | -122.418348334311 | (37.7465780921238, -122.418348334311) | 2 | 7 | 7 | 28859 | 2 | |||
72441 | 82759 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 49 Samoset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50251 | 6009929.1659667 | 2099164.47966506 | 37.744466098795 | -122.408332701789 | (37.744466098795, -122.408332701789) | 2 | 7 | 7 | 28859 | 2 | ||
73623 | 247601 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Tompkins Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6009211.63365 | 2096404.06359 | 37.7368463915456 | -122.410618895163 | (37.7368463915456, -122.410618895163) | 10 | 7 | 7 | 28859 | 2 | |||
109489 | 25585 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1997 12:00:00 AM | 30 | 3X3 | 6008661.2482385 | 2097297.4630516 | 37.7392685988549 | -122.412584962687 | (37.7392685988549, -122.412584962687) | 10 | 7 | 7 | 28859 | 2 | ||
131374 | 82729 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 49 Samoset St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50251 | 6009929.1659667 | 2099164.47966506 | 37.744466098795 | -122.408332701789 | (37.744466098795, -122.408332701789) | 2 | 7 | 7 | 28859 | 2 | ||
134611 | 241336 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 11 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007215.53058 | 2099620.48751 | 37.7455658619754 | -122.417748235597 | (37.7455658619754, -122.417748235597) | 2 | 7 | 7 | 28859 | 2 | |||
141436 | 247600 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Tompkins Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6009197.59612 | 2096407.47189 | 37.7368549629719 | -122.410667669902 | (37.7368549629719, -122.410667669902) | 10 | 7 | 7 | 28859 | 2 | |||
143795 | 247599 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Tompkins Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 6009183.00439 | 2096409.33052 | 37.7368592482464 | -122.410718251366 | (37.7368592482464, -122.410718251366) | 10 | 7 | 7 | 28859 | 2 | |||
144328 | 88018 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3926 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51046 | 6004957.7 | 2095821.3 | 37.7350068377073 | -122.425285172259 | (37.7350068377073, -122.425285172259) | 2 | 7 | 5 | 28861 | 2 | |||
169285 | 32320 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3337 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/1996 12:00:00 AM | 4 | Permit Number 36887 | 6009057.01923 | 2099240.26466 | 37.7446253105111 | -122.411353770753 | (37.7446253105111, -122.411353770753) | 2 | 7 | 7 | 28859 | 2 | ||
184282 | 25586 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1150X Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1997 12:00:00 AM | 30 | 3X3 | 6008754.8829591 | 2097365.1323636 | 37.7394596586207 | -122.412265995986 | (37.7394596586207, -122.412265995986) | 10 | 7 | 7 | 28859 | 2 |
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) );