trees
18 rows where DBH = 11 and qSpecies_id = 123
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16583 | 241346 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6009581.66758 | 2105919.15522 | 37.7629934624139 | -122.410011039795 | (37.7629934624139, -122.410011039795) | 8 | 4 | 8 | 28859 | 19 | |||
| 21100 | 241341 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2701 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009762.27519 | 2105459.58065 | 37.7617416960496 | -122.409353942929 | (37.7617416960496, -122.409353942929) | 2 | 4 | 8 | 28859 | 19 | |||
| 25076 | 241291 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1225 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011156.6405 | 2102469.67171 | 37.7536100953402 | -122.404320914102 | (37.7536100953402, -122.404320914102) | 10 | 4 | 8 | 28859 | 19 | |||
| 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 | |||
| 51900 | 40680 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 227 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 11 | Permit Number 41663 | 6004891.01488 | 2093810.36977 | 37.7294815042584 | -122.425372669006 | (37.7294815042584, -122.425372669006) | 9 | 7 | 6 | 28861 | 5 | |
| 53461 | 196972 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6014458.90845 | 2102627.41024 | 37.7542271903342 | -122.392911888877 | (37.7542271903342, -122.392911888877) | 10 | 3 | 8 | 28856 | 29 | |||
| 54649 | 241274 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2616 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010311.63301 | 2104008.02665 | 37.7577868194278 | -122.407351591615 | (37.7577868194278, -122.407351591615) | 10 | 4 | 7 | 28859 | 19 | |||
| 55713 | 136180 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3134 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999407.16472 | 2119635.33058 | 37.8000790286731 | -122.446187711617 | (37.8000790286731, -122.446187711617) | 13 | 9 | 1 | 57 | 17 | |||
| 64123 | 123208 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993131.19371 | 2112699.04699 | 37.7806735020779 | -122.467400140372 | (37.7806735020779, -122.467400140372) | 11 | 6 | 2 | 54 | 11 | |||
| 67242 | 241290 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1227 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011160.10458 | 2102427.21865 | 37.753493722159 | -122.404305946667 | (37.753493722159, -122.404305946667) | 10 | 4 | 8 | 28859 | 19 | |||
| 91402 | 241353 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6009702.25291 | 2105928.94008 | 37.7630270871447 | -122.409594665358 | (37.7630270871447, -122.409594665358) | 8 | 4 | 8 | 28859 | 19 | |||
| 103864 | 32350 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2180 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 11 | Permit Number 36907 | 6009568.01706 | 2104596.56642 | 37.7593611689943 | -122.40996488119 | (37.7593611689943, -122.40996488119) | 2 | 4 | 7 | 28859 | 19 | |
| 111775 | 241385 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2169 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6008146.20784 | 2105935.07496 | 37.7629566162671 | -122.41497694503 | (37.7629566162671, -122.41497694503) | 8 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 157891 | 241292 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1223 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011155.71596 | 2102482.72814 | 37.7536458937577 | -122.404325030294 | (37.7536458937577, -122.404325030294) | 10 | 4 | 8 | 28859 | 19 | |||
| 159489 | 241280 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1334 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010312.03054 | 2101467.09279 | 37.7508100021879 | -122.40717110848 | (37.7508100021879, -122.40717110848) | 2 | 4 | 7 | 28859 | 19 | |||
| 160657 | 37985 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 570 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 11 | Permit Number 40207 | 6013793.63158 | 2104435.25023 | 37.7591541522658 | -122.395339235527 | (37.7591541522658, -122.395339235527) | 10 | 3 | 8 | 28856 | 29 | |
| 180734 | 241381 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2169 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6008153.50864 | 2105811.23118 | 37.7626169800981 | -122.414942928177 | (37.7626169800981, -122.414942928177) | 8 | 4 | 7 | 28859 | 19 |
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) );