trees
15 rows where Police Districts = 8 and qSpecies_id = 53
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
261 | 119280 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995293 | 2090512 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | 9 | 8 | 6 | 28861 | 24 | ||||
35372 | 94058 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1401X 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5993648 | 2105942 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | 1 | 8 | 11 | 56 | 12 | |||
36005 | 111369 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 724 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993485 | 2106687 | 37.7641864431876 | -122.465739233402 | (37.7641864431876, -122.465739233402) | 11 | 8 | 11 | 56 | 12 | ||||
63919 | 20972 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2002X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
79632 | 20975 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2002X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
79839 | 20974 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2002X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
118732 | 117200 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1321 23RD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5988915 | 2106334 | 37.7629525336189 | -122.481519510385 | (37.7629525336189, -122.481519510385) | 1 | 8 | 3 | 56 | 35 | |||
130776 | 25271 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1800 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 5994503.82801 | 2092400.83619 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | 9 | 8 | 4 | 28861 | 40 | |||
137544 | 25272 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1800 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 5994503.82801 | 2092400.83619 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | 9 | 8 | 4 | 28861 | 40 | |||
140268 | 54410 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1248 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 10182 | 5993332.64911234 | 2106987.54521442 | 37.765002872173 | -122.46628801063 | (37.765002872173, -122.46628801063) | 11 | 8 | 11 | 56 | 12 | |||
146767 | 119279 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 95 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995293 | 2090512 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | 9 | 8 | 6 | 28861 | 24 | ||||
150275 | 28300 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Broad St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3X3 | 5995887 | 2088090 | 37.713261901345 | -122.456086835381 | (37.713261901345, -122.456086835381) | 9 | 8 | 6 | 28861 | 24 | |||
151589 | 25270 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1800 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 5994503.82801 | 2092400.83619 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | 9 | 8 | 4 | 28861 | 40 | |||
153860 | 94059 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1401X 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5993648 | 2105942 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | 1 | 8 | 11 | 56 | 12 | |||
168485 | 25273 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1800 Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 5994503.82801 | 2092400.83619 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | 9 | 8 | 4 | 28861 | 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) );