trees
16 rows where Supervisor Districts = 5 and qSpecies_id = 66
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187 | 112917 | DPW Maintained 1 | Shrub :: Shrub 66 | 480X BEACON ST | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6002571 | 2098077 | 37.7410653426557 | -122.433697996676 | (37.7410653426557, -122.433697996676) | 2 | 7 | 5 | 63 | 7 | |||||
| 7615 | 258945 | DPW Maintained 1 | Shrub :: Shrub 66 | 500x 27th St | 33 | Median : Cutout | Tree | DPW 1 | Width 4ft | 6003013.92094 | 2100069.89733 | 37.7465624978683 | -122.432308835085 | (37.7465624978683, -122.432308835085) | 2 | 7 | 5 | 63 | 22 | ||||
| 8510 | 259163 | Private 9 | Shrub :: Shrub 66 | 1 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001019 | 2105729 | 37.7619877090771 | -122.439612669611 | (37.7619877090771, -122.439612669611) | 15 | 5 | 5 | 28862 | 3 | ||||
| 9208 | 259164 | Private 9 | Shrub :: Shrub 66 | 1 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001019 | 2105729 | 37.7619877090771 | -122.439612669611 | (37.7619877090771, -122.439612669611) | 15 | 5 | 5 | 28862 | 3 | ||||
| 9604 | 56991 | Permitted Site 7 | Shrub :: Shrub 66 | 4160 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | Permit Number 767882 | 6002854.60493399 | 2100676.90172362 | 37.7482201548247 | -122.432903090117 | (37.7482201548247, -122.432903090117) | 2 | 4 | 5 | 28862 | 22 | |||
| 16349 | 259165 | Private 9 | Shrub :: Shrub 66 | 1 Corbett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001019 | 2105729 | 37.7619877090771 | -122.439612669611 | (37.7619877090771, -122.439612669611) | 15 | 5 | 5 | 28862 | 3 | ||||
| 25702 | 89015 | DPW Maintained 1 | Shrub :: Shrub 66 | 4437 20th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 09/30/2008 12:00:00 AM | 3x1 | Permit Number 51764 | 6001659 | 2104076 | 37.7574853780776 | -122.437280798466 | (37.7574853780776, -122.437280798466) | 2 | 4 | 5 | 28862 | 3 | |||
| 34209 | 107409 | DPW Maintained 1 | Shrub :: Shrub 66 | 125 VILLA TER | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5999028.2 | 2104385.8 | 37.7581861070008 | -122.446401410764 | (37.7581861070008, -122.446401410764) | 2 | 5 | 5 | 28862 | 3 | |||||
| 35821 | 93164 | DPW Maintained 1 | Shrub :: Shrub 66 | 201 Upper Ter | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2009 12:00:00 AM | 1x2 | 5999670.5 | 2106448.3 | 37.7638858848202 | -122.444328283325 | (37.7638858848202, -122.444328283325) | 15 | 5 | 5 | 29492 | 3 | |||
| 67643 | 92611 | DPW Maintained 1 | Shrub :: Shrub 66 | 3856 23rd St | Sidewalk: Property side : Pot | Landscaping | Private 2 | 08/31/2009 12:00:00 AM | Permit Number 52924 | 6004067 | 2102488 | 37.7532616988935 | -122.428839761175 | (37.7532616988935, -122.428839761175) | 2 | 4 | 5 | 28862 | 22 | ||||
| 94409 | 9382 | DPW Maintained 1 | Shrub :: Shrub 66 | 337 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3X3 | 6001129.4629101 | 2097791.8544146 | 37.7402004981777 | -122.438661870607 | (37.7402004981777, -122.438661870607) | 2 | 7 | 5 | 63 | 7 | |||
| 101202 | 88829 | DPW Maintained 1 | Shrub :: Shrub 66 | 4437 20th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 09/30/2008 12:00:00 AM | 8x1 | Permit Number 51764 | 6001659 | 2104076 | 37.7574853780776 | -122.437280798466 | (37.7574853780776, -122.437280798466) | 2 | 4 | 5 | 28862 | 3 | |||
| 124791 | 22545 | DPW Maintained 1 | Shrub :: Shrub 66 | 7 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X3 | 6001395.6747593 | 2098711.0868843 | 37.7427396354232 | -122.437807240323 | (37.7427396354232, -122.437807240323) | 2 | 7 | 5 | 63 | 7 | |||
| 133338 | 93163 | DPW Maintained 1 | Shrub :: Shrub 66 | 201 Upper Ter | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2009 12:00:00 AM | 1x15 | 5999670.5 | 2106448.3 | 37.7638858848202 | -122.444328283325 | (37.7638858848202, -122.444328283325) | 15 | 5 | 5 | 29492 | 3 | |||
| 143620 | 106469 | Undocumented 4 | Shrub :: Shrub 66 | 100X HENRY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6002548 | 2107375 | 37.7665941299684 | -122.434442151396 | (37.7665941299684, -122.434442151396) | 15 | 5 | 5 | 28862 | 3 | |||
| 161681 | 4313 | DPW Maintained 1 | Shrub :: Shrub 66 | 727 Chenery St | 1 | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | 08/17/2013 12:00:00 AM | 3X3 | 6002321.25178 | 2095689.19659 | 37.7344948117373 | -122.434390856497 | (37.7344948117373, -122.434390856497) | 2 | 7 | 5 | 63 | 7 |
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) );