trees
15 rows where Zip Codes = 56 and qSpecies_id = 53 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
170119 | 103480 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1247 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x5 | Permit Number 31998 | 5994182.5 | 2107061.8 | 37.765255754741 | -122.463353999562 | (37.765255754741, -122.463353999562) | 11 | 5 | 11 | 56 | 12 | ||
135459 | 106967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1225 02ND AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995419.1 | 2107212.6 | 37.7657409782079 | -122.459087842629 | (37.7657409782079, -122.459087842629) | 15 | 5 | 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 | ||||
156343 | 113279 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5995790.34429445 | 2107089.36315796 | 37.7654239364323 | -122.457794878244 | (37.7654239364323, -122.457794878244) | 15 | 5 | 11 | 56 | 12 | ||||
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 | |||
70103 | 121337 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 44 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5995656.55399656 | 2107084.69972772 | 37.7654034448102 | -122.458257287589 | (37.7654034448102, -122.458257287589) | 15 | 5 | 11 | 56 | 12 | ||||
79333 | 33008 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1311 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | 6x4 | Permit Number 37302 | 5994224.05093468 | 2106581.50911401 | 37.7639393951455 | -122.463175433011 | (37.7639393951455, -122.463175433011) | 1 | 5 | 11 | 56 | 12 | ||
155542 | 54199 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 44 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | 4x4 | Permit Number 9937 | 5995656.55399656 | 2107084.69972772 | 37.7654034448102 | -122.458257287589 | (37.7654034448102, -122.458257287589) | 15 | 5 | 11 | 56 | 12 | ||
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 | |||
124630 | 54736 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1247 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1993 12:00:00 AM | 12 | 5x5 | Permit Number 31998 | 5994208.55249488 | 2107032.01090972 | 37.7651754625969 | -122.463261729084 | (37.7651754625969, -122.463261729084) | 11 | 5 | 11 | 56 | 12 | |
140944 | 54742 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1374 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | 3x3 | Permit Number 10588 | 5993980.75543943 | 2106156.09216002 | 37.7627572927027 | -122.463986029849 | (37.7627572927027, -122.463986029849) | 1 | 5 | 11 | 56 | 12 | ||
49452 | 86740 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1275 02nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | 15 | 5 | 11 | 56 | 12 | |||||
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 | |||
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 | |||
27991 | 97561 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1251X 04th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5994791.4 | 2106981 | 37.7650689602603 | -122.461242116604 | (37.7650689602603, -122.461242116604) | 15 | 5 | 11 | 56 | 12 |
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) );