trees
125 rows where Supervisor Districts = 8 and qSpecies_id = 53 sorted by rowid descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48959 | 112162 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1324 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013680.97327942 | 2105726.70860795 | 37.7626939483281 | -122.39581935837 | (37.7626939483281, -122.39581935837) | 14 | 3 | 8 | 28856 | 29 | ||||
| 47426 | 693 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1299X Potrero Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x3 | 6010664.7611959 | 2101498.8811325 | 37.7509170198962 | -122.405953567035 | (37.7509170198962, -122.405953567035) | 10 | 4 | 8 | 28859 | 19 | |||
| 47161 | 18304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.7683100673499 | -122.407895847634 | (37.7683100673499, -122.407895847634) | 8 | 4 | 8 | 28853 | 19 | |||
| 46216 | 6816 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
| 43596 | 112404 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 300x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011264 | 2107649 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | 8 | 2 | 8 | 28853 | 20 | ||||
| 43224 | 117205 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013468.70293325 | 2105662.80878203 | 37.762506682391 | -122.396549051509 | (37.762506682391, -122.396549051509) | 10 | 3 | 8 | 28856 | 29 | |||||
| 41806 | 6719 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 39117 | 14994 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016235.7427248 | 2097702.9858463 | 37.7408042749191 | -122.38642376985 | (37.7408042749191, -122.38642376985) | 10 | 3 | 8 | 58 | 1 | |||
| 37186 | 112411 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 300x 15TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011264 | 2107649 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | 8 | 2 | 8 | 28853 | 20 | ||||
| 37080 | 6828 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
| 35952 | 120884 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2140x 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011295 | 2105636 | 37.7623118602886 | -122.404065249735 | (37.7623118602886, -122.404065249735) | 8 | 3 | 8 | 28856 | 29 | ||||
| 34152 | 21980 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2575 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6015881.32806 | 2103602.42313 | 37.7569832760363 | -122.388060799634 | (37.7569832760363, -122.388060799634) | 10 | 3 | 8 | 28856 | 29 | |||
| 33185 | 18322 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 226 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010268.7839855 | 2107259.8540962 | 37.7667132034185 | -122.407729067657 | (37.7667132034185, -122.407729067657) | 8 | 4 | 8 | 28853 | 19 | |||
| 31123 | 18463 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1185X Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010590.6142382 | 2102338.4990144 | 37.7532182781408 | -122.406269126047 | (37.7532182781408, -122.406269126047) | 10 | 4 | 8 | 28859 | 19 | |||
| 30509 | 109858 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2455 03RD ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 5x8 | 6015836.2 | 2104173 | 37.7585474584562 | -122.388256691115 | (37.7585474584562, -122.388256691115) | 10 | 3 | 8 | 28856 | 29 | |||
| 29445 | 26153 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500 Oakdale Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
| 28577 | 18320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 206 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010262.2750436 | 2107350.6845554 | 37.7669622387245 | -122.40775798639 | (37.7669622387245, -122.40775798639) | 8 | 4 | 8 | 28853 | 19 | |||
| 28345 | 6727 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 27391 | 6825 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
| 23663 | 85059 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2435 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x9 | 6015831.18626 | 2104262.21936 | 37.7587921580004 | -122.388280257816 | (37.7587921580004, -122.388280257816) | 10 | 3 | 8 | 28856 | 29 | |||
| 20262 | 253597 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010453 | 2107072 | 37.7662077096315 | -122.407078650031 | (37.7662077096315, -122.407078650031) | 8 | 4 | 8 | 28853 | 19 | ||||
| 19076 | 99594 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | 10 | 3 | 8 | 58 | 1 | |||
| 18675 | 101715 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
| 14874 | 6756 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 769095 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
| 14802 | 11429 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016007.44377 | 2096780.42114 | 37.7382584597776 | -122.387148815626 | (37.7382584597776, -122.387148815626) | 10 | 3 | 8 | 58 | 1 |
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) );