trees
12 rows where DBH = 13 and qSpecies_id = 123 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24305 | 31508 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2419 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 13 | Permit Number 35068 | 6011299.52328 | 2102275.53688 | 37.7530850270762 | -122.403813131691 | (37.7530850270762, -122.403813131691) | 10 | 4 | 8 | 28859 | 19 | |
57071 | 31514 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2537 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 13 | Permit Number 35072 | 6010934.2499 | 2102257.13766 | 37.7530140939364 | -122.405075029795 | (37.7530140939364, -122.405075029795) | 10 | 4 | 8 | 28859 | 19 | |
57267 | 241390 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004068.12547 | 2098354.29911 | 37.7419115792635 | -122.428541241382 | (37.7419115792635, -122.428541241382) | 2 | 7 | 5 | 63 | 7 | |||
60153 | 34963 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | 13 | Permit Number 38553 | 6014444.86373 | 2102867.97159 | 37.7548869402077 | -122.392977289379 | (37.7548869402077, -122.392977289379) | 10 | 3 | 8 | 28856 | 29 | ||
76553 | 123210 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993133.98431 | 2112655.94122 | 37.7805553064396 | -122.467387351051 | (37.7805553064396, -122.467387351051) | 11 | 6 | 2 | 54 | 11 | |||
82690 | 241362 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 610 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009794.30933 | 2105409.48411 | 37.7616059370772 | -122.409239613928 | (37.7616059370772, -122.409239613928) | 2 | 4 | 8 | 28859 | 19 | |||
86392 | 241360 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 600 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009793.68997 | 2105435.76266 | 37.7616780573116 | -122.409243610512 | (37.7616780573116, -122.409243610512) | 2 | 4 | 8 | 28859 | 19 | |||
87499 | 197007 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6015822.85417 | 2114091.9182 | 37.7857818882589 | -122.388995368366 | (37.7857818882589, -122.388995368366) | 6 | 2 | 9 | 28856 | 6 | |||
116652 | 123211 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993134.492 | 2112639.50466 | 37.7805102054167 | -122.467384399185 | (37.7805102054167, -122.467384399185) | 11 | 6 | 2 | 54 | 11 | |||
153220 | 241354 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6009719.71418 | 2105928.26145 | 37.7630262022081 | -122.409534224627 | (37.7630262022081, -122.409534224627) | 8 | 4 | 8 | 28859 | 19 | |||
184093 | 197003 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6015964.6605 | 2113962.87673 | 37.7854354289412 | -122.38849574371 | (37.7854354289412, -122.38849574371) | 6 | 2 | 9 | 28856 | 6 | |||
190579 | 241272 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 67 Webster St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6004275.92505 | 2108860.93687 | 37.7707720854826 | -122.428571490982 | (37.7707720854826, -122.428571490982) | 7 | 9 | 11 | 29492 | 10 |
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) );