13 rows where DBH = 16 and qCaretaker_id = 4 sorted by qCareAssistant

View and edit SQL

DBH

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)
12520 228662 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     16 Width 3ft   6001863.4982 2104671.44362 37.7591319452903 -122.436616182999 (37.7591319452903, -122.436616182999) 2 4 5 28862 3
102614 127905 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 937 Lombard St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     16 Width 6ft   6007996.96181 2120271.7748 37.8023133475557 -122.416508736883 (37.8023133475557, -122.416508736883) 5 1 10 308 32
152683 98649 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   16 5x5   6002707.76445 2119233.0203 37.7991623281478 -122.434737597267 (37.7991623281478, -122.434737597267) 13 9 1 57 17
8962 116061 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2100x 19th St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16 3x3   6011385.89017 2105128.48272 37.7609234092204 -122.403715181115 (37.7609234092204, -122.403715181115) 10 3 8 28856 29
15390 60892 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/11/1983 12:00:00 AM 16 5x5 Permit Number 20677 6008514.66964 2119698.45237 37.8007682484075 -122.414676612845 (37.8007682484075, -122.414676612845) 5 1 10 308 32
35970 122754 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 693 Vermont St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16     6011277.36342 2105334.1858 37.7614821606899 -122.404105006665 (37.7614821606899, -122.404105006665) 10 3 8 28856 29
44529 97900 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 375X Precita Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16 3x4   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
47950 97078 DPW Maintained 1 Tree(s) :: 17 1551 Newcomb Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16 4x4   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 10 3 8 58 1
56802 99677 DPW Maintained 1 Tree(s) :: 17 1250X Shrader St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/04/2013 12:00:00 AM 16 3x3 Permit Number 770537 5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
69692 97082 DPW Maintained 1 Tree(s) :: 17 1551 Newcomb Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16 3x3   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 10 3 8 58 1
111890 95155 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 250 23rd Ave 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16     5988718.09873 2113738.33114 37.7832713237769 -122.482743157022 (37.7832713237769, -122.482743157022) 11 6 2 55 26
163496 77992 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 163X London St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/01/2000 12:00:00 AM 16 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
175510 97079 DPW Maintained 1 Tree(s) :: 17 1551 Newcomb Ave 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16 4x4   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 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)
);