trees
35 rows where Zip Codes = 58 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 52126 | 22281 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4755X 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 18 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | |||
| 52462 | 116125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 63265 | 6801 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1385 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016634.4993322 | 2097405.4643513 | 37.7400094064471 | -122.385024282227 | (37.7400094064471, -122.385024282227) | 10 | 3 | 8 | 58 | 1 | |||
| 66362 | 6799 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1375 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x9 | 6016685.6205969 | 2097367.3215875 | 37.7399075017412 | -122.384844867735 | (37.7399075017412, -122.384844867735) | 10 | 3 | 8 | 58 | 1 | |||
| 72329 | 6726 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 23 | 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 | |||
| 74408 | 6773 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1355 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016787.8631263 | 2097291.0360599 | 37.7397036915046 | -122.384486040227 | (37.7397036915046, -122.384486040227) | 10 | 3 | 8 | 58 | 1 | |||
| 78348 | 6705 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 2 | 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 | |||
| 89965 | 116128 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 101295 | 29407 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2801X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6014804.18454 | 2090650.03815 | 37.7213589569903 | -122.390880803843 | (37.7213589569903, -122.390880803843) | 10 | 3 | 8 | 58 | 1 | |||
| 102193 | 6752 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017539.76894 | 2096719.16796 | 37.738175006759 | -122.381846478456 | (37.738175006759, -122.381846478456) | 10 | 3 | 8 | 58 | 1 | |||
| 110376 | 25995 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1781 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6014085.16035 | 2096167.03762 | 37.7364675981514 | -122.39375225191 | (37.7364675981514, -122.39375225191) | 10 | 3 | 8 | 58 | 1 | |||
| 115268 | 6817 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 9 | 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 | |||
| 122922 | 99595 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1855X Evans Ave | 10 | 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 | |||
| 122954 | 6709 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 129171 | 27857 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 7 | 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 | |||
| 142509 | 6722 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 19 | 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 | |||
| 149060 | 6808 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1395 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | 10 | 3 | 8 | 58 | 1 | |||
| 150567 | 25558 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 50X Industrial St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2001 12:00:00 AM | 8 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | 10 | 3 | 8 | 58 | 1 | ||
| 158152 | 6829 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 11 | 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 | |||
| 163580 | 116126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 169622 | 6721 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 18 | 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 | |||
| 174144 | 116127 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 188021 | 6788 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1390 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | |||
| 188909 | 6818 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 10 | 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 | |||
| 190734 | 6815 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 7 | 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 |
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) );