15 rows where DBH = 2 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)
2915 223666 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/16/2016 05:50:00 AM 2 Width 3ft   6002610.0457 2101075.27233 37.7493001124297 -122.433777236447 (37.7493001124297, -122.433777236447) 2 4 5 28862 22
16772 113034 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 251 06th Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5993975.1139 2113804.1265 37.7837564355183 -122.464560902617 (37.7837564355183, -122.464560902617) 11 6 2 54 11
23915 96577 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 401x Otsego Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM 2 3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
44433 94516 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1106X Wisconsin St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   08/27/2010 12:00:00 AM 2   Permit Number 53703 6012787.7377 2102360.94736 37.7534025731789 -122.398672553793 (37.7534025731789, -122.398672553793) 10 3 8 28856 29
104120 131002 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 937 Lombard St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/09/2014 12:00:00 AM 2 Width 3ft   6007919.06293 2120264.13988 37.8022880028424 -122.416777764577 (37.8022880028424, -122.416777764577) 5 1 10 308 32
124230 107423 DPW Maintained 1 Acer buergeranum :: Trident Maple 110 251 06th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5993968.46376 2113916.3836 37.7840642796834 -122.464592063385 (37.7840642796834, -122.464592063385) 11 6 2 54 11
134492 228663 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   06/23/2015 07:36:00 AM 2 Width 3ft   6001958.87793 2104675.64602 37.7591489038263 -122.436286615639 (37.7591489038263, -122.436286615639) 2 4 5 28862 3
178792 115969 DPW Maintained 1 Olea europaea :: Olive Tree 9 1599x 30th Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5986813.3885 2104627.15 37.7581435700771 -122.488662699732 (37.7581435700771, -122.488662699732) 1 8 3 56 35
5633 76756 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1501X 42nd Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x12   5983095.0741 2104639.3384 37.757959352781 -122.501522927406 (37.757959352781, -122.501522927406) 1 8 3 56 35
31112 96772 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1300X Lane St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x3   6015407.2 2095381.5 37.7343840488548 -122.389126529878 (37.7343840488548, -122.389126529878) 10 3 8 58 1
79109 116057 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2100x 19th St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x3   6011480.97635 2105135.37266 37.760947638753 -122.40338680266 (37.760947638753, -122.40338680266) 10 3 8 28856 29
112770 116059 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2100x 19th St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x3   6011431.5308 2105131.75607 37.7609349466036 -122.403557559651 (37.7609349466036, -122.403557559651) 10 3 8 28856 29
121110 98804 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x Clay St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010297.35863 2117215.00262 37.7940492982967 -122.408332474088 (37.7940492982967, -122.408332474088) 3 1 10 28857 4
130969 116857 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x Clay St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x3   6010080.35093 2117187.65635 37.793962057763 -122.409081415981 (37.793962057763, -122.409081415981) 3 1 10 28857 4
164578 116058 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2100x 19th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x3   6011458.59484 2105134.56728 37.760944177262 -122.403464154268 (37.760944177262, -122.403464154268) 10 3 8 28856 29

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