31 rows where qCaretaker_id = 19 sorted by PermitNotes

View and edit SQL

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);