trees
31 rows where qCaretaker_id = 19 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
191133 | 26012 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1618X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/02/1998 12:00:00 AM | 3 | 3X3 | 6015044.019 | 2095518.8416 | 37.7347410214535 | -122.390391768412 | (37.7347410214535, -122.390391768412) | 10 | 3 | 8 | 58 | 1 | ||
185160 | 8091 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 762 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004317.1512 | 2111553.1108 | 37.7781664691559 | -122.428620825565 | (37.7781664691559, -122.428620825565) | 7 | 9 | 11 | 28852 | 41 | ||
179978 | 105160 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1600X OAKDALE AVE | 1 | Front Yard : Yard | Tree | Arts Commission 19 | 13 | Permit Number 770204 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
174039 | 22279 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | |||
170027 | 22282 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 4 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | |||
168475 | 8092 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 762 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004291.3267 | 2111546.8391 | 37.778147787093 | -122.428709714706 | (37.778147787093, -122.428709714706) | 7 | 9 | 11 | 28852 | 41 | ||
164164 | 105170 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 4755X 03RD ST | 4 | Front Yard : Cutout | Tree | Arts Commission 19 | 2 | 3x3 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | |||
151905 | 22278 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
149518 | 109194 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 4705 03rd St | Back Yard : Yard | Tree | Arts Commission 19 | 45 | 6015121.6 | 2095617 | 37.7350148477359 | -122.390130397219 | (37.7350148477359, -122.390130397219) | 10 | 3 | 8 | 58 | 1 | |||||
149337 | 8095 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 762 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 04/14/1998 12:00:00 AM | 24 | 3X3 | 6004129.5547 | 2111522.3059 | 37.77807126806 | -122.429267592872 | (37.77807126806, -122.429267592872) | 7 | 9 | 11 | 28852 | 41 | ||
146144 | 105171 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 4755X 03RD ST | 5 | Front Yard : Yard | Tree | Arts Commission 19 | 14 | 4x4 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | |||
142553 | 8096 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 762 Fulton St | 7 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 04/14/1998 12:00:00 AM | 18 | 3X3 | 6004110.3708 | 2111520.4613 | 37.7780651171853 | -122.429333825297 | (37.7780651171853, -122.429333825297) | 7 | 9 | 11 | 28852 | 41 | ||
133384 | 105167 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 1 | Front Yard : Cutout | Tree | Arts Commission 19 | 8 | 3x3 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | |||
130535 | 105165 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1600X OAKDALE AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 16 | 3x3 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
122917 | 22284 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 4755X 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 6 | 3x3 | Permit Number 770204 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
103033 | 105163 | Undocumented 4 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1600X OAKDALE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 17 | 4x4 | Permit Number 770204 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | ||
101451 | 105175 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1601X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 10 | 3x3 | 6015153.3918 | 2095715.6028 | 37.7352873542424 | -122.390027366589 | (37.7352873542424, -122.390027366589) | 10 | 3 | 8 | 58 | 1 | |||
93143 | 22280 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
91890 | 22277 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
89603 | 26011 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1618X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/02/1998 12:00:00 AM | 6 | 3X3 | 6014975.06835 | 2095558.90554 | 37.7348472038217 | -122.390632955135 | (37.7348472038217, -122.390632955135) | 10 | 3 | 8 | 58 | 1 | ||
88357 | 8090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 762 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004349.2473 | 2111557.1689 | 37.7781794280627 | -122.428510082803 | (37.7781794280627, -122.428510082803) | 7 | 9 | 11 | 28852 | 41 | ||
87319 | 22283 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 4755X 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 6 | 3X3 | Permit Number 770204 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
84098 | 105172 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 1601X NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
75443 | 105174 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
60470 | 8094 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 762 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 100 | 3X3 | 6004211.6397 | 2111535.7715 | 37.7781128879326 | -122.428984591665 | (37.7781128879326, -122.428984591665) | 7 | 9 | 11 | 28852 | 41 | |||
57045 | 105169 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 3 | Front Yard : Cutout | Tree | Arts Commission 19 | 23 | 4x4 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 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 | |||
48629 | 105164 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 15 | 5x5 | 6014842.39521 | 2095664.68421 | 37.735130289038 | -122.391099047201 | (37.735130289038, -122.391099047201) | 10 | 3 | 8 | 58 | 1 | |||
29803 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600X Oakdale Ave | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.83637 | 37.735069048787 | -122.391004288315 | (37.735069048787, -122.391004288315) | 10 | 3 | 8 | 58 | 1 | |||
24698 | 8097 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 762 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004143.8911021 | 2111521.3201229 | 37.7780693729621 | -122.4292179278 | (37.7780693729621, -122.4292179278) | 7 | 9 | 11 | 28852 | 41 | ||
15723 | 105168 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 23 | 3x3 | Permit Number 770204 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 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) );