trees
17 rows where PlantType = "Landscaping" and qSpecies_id = 66 sorted by Fire Prevention Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3309 | 120871 | DPW Maintained 1 | Shrub :: Shrub 66 | 1387 08th Ave | 1 | Sidewalk: Curb side : Pot | Landscaping | Private 2 | 5993606 | 2106068 | 37.7624938100726 | -122.465275766733 | (37.7624938100726, -122.465275766733) | 1 | 8 | 11 | 56 | 12 | |||||
| 94878 | 117511 | DPW Maintained 1 | Shrub :: Shrub 66 | 2634 37TH AVE | 1 | Median : Yard | Landscaping | DPW 1 | 20 | 3x3 | 5984921 | 2097163 | 37.7375384395308 | -122.494657023299 | (37.7375384395308, -122.494657023299) | 1 | 8 | 3 | 29491 | 35 | |||
| 123486 | 99732 | DPW Maintained 1 | Shrub :: Shrub 66 | 4150 Ocean Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 5986619.2 | 2095203.6 | 37.7322576937009 | -122.488641645288 | (37.7322576937009, -122.488641645288) | 1 | 8 | 4 | 64 | 35 | |||||
| 161563 | 116580 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 3 | Sidewalk: Property side : Cutout | Landscaping | MTA 3 | DPW | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | |||
| 43687 | 117610 | DPW Maintained 1 | Shrub :: Shrub 66 | 391 NEVADA ST | 1 | Unaccepted Street : Yard | Landscaping | Private 2 | 3x3 | 6008958 | 2096497 | 37.7370873514658 | -122.411502385785 | (37.7370873514658, -122.411502385785) | 10 | 7 | 7 | 28859 | 2 | ||||
| 112926 | 251642 | DPW Maintained 1 | Shrub :: Shrub 66 | 2253 Broderick St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3x3 | 6000298.51737 | 2116393.24113 | 37.7912279703404 | -122.442870356286 | (37.7912279703404, -122.442870356286) | 13 | 6 | 1 | 29490 | 27 | ||||
| 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 | |||
| 36468 | 140265 | DPW Maintained 1 | Shrub :: Shrub 66 | 2100X Grove St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 0 | Width 0ft | 5997671.17 | 2110272.3417 | 37.7742714515841 | -122.45151917218 | (37.7742714515841, -122.45151917218) | 15 | 5 | 2 | 29492 | 16 | |||
| 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 | |||
| 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 | |||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 22629 | 106932 | DPW Maintained 1 | Shrub :: Shrub 66 | 358 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 8x10 | 6007793.2 | 2105846.4 | 37.7626932925098 | -122.416191600332 | (37.7626932925098, -122.416191600332) | 8 | 4 | 7 | 28859 | 19 | ||||
| 1437 | 109607 | DPW Maintained 1 | Shrub :: Shrub 66 | 775 Congo St | 1 | Front Yard : Yard | Landscaping | Private 2 | 6000381.8 | 2095947.7 | 37.7350943222142 | -122.441114705419 | (37.7350943222142, -122.441114705419) | 9 | 7 | 4 | 63 | 40 | |||||
| 155364 | 105003 | DPW Maintained 1 | Shrub :: Shrub 66 | 607 CONGO ST | Sidewalk: Property side : Yard | Landscaping | Private 2 | 6000094.1 | 2095817 | 37.7347190590407 | -122.44210000591 | (37.7347190590407, -122.44210000591) | 9 | 7 | 4 | 63 | 40 |
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) );