17 rows where DBH = 4 and qSpecies_id = 65 sorted by PlotSize

View and edit SQL

SiteOrder

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)
3392 70645 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 67 Lamartine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6002626.20323 2094469.32888 37.7311626384362 -122.433249403638 (37.7311626384362, -122.433249403638) 9 7 5 28861 25
151041 203576 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 404 Baden St 6 Side Yard : Yard Tree Private 2     4     6000769.77181 2095296.00897 37.7333270215234 -122.439726643888 (37.7333270215234, -122.439726643888) 9 7 5 63 40
165916 125541 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 65 Heather Ave 1 Sidewalk: Curb side : Pot Tree Private 2     4     5997339.5515 2114115.46943 37.7848046777406 -122.452943756065 (37.7848046777406, -122.452943756065) 15 6 1 54 31
31198 84402 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1852 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM 4 3x3 Permit Number 51006 6000688.3478 2111734.5053 37.778458498926 -122.441187160325 (37.778458498926, -122.441187160325) 15 5 11 29490 41
105607 95918 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 682 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2011 12:00:00 AM 4 3x3 Permit Number 767617 5991324.67511 2110779.55477 37.7752986449747 -122.473509641895 (37.7752986449747, -122.473509641895) 11 6 2 54 26
9355 43688 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 219 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM 4 4x6 Permit Number 43332 5993346.74324 2114008.67547 37.7842818271711 -122.466749684627 (37.7842818271711, -122.466749684627) 11 6 2 54 11
114225 185942 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2001 Sunset Blvd 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984826.9443 2101536.2304 37.7495406390981 -122.495304634302 (37.7495406390981, -122.495304634302) 1 8 3 29491 35
184312 183416 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2685 22nd Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 0ft   5989557.6977 2097079.8204 37.7375803497092 -122.478619864368 (37.7375803497092, -122.478619864368) 1 8 3 29491 35
44449 117949 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3851 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5983596.58663 2110338.47485 37.7736370016896 -122.500209835883 (37.7736370016896, -122.500209835883) 11 6 2 55 26
77660 175178 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 763 Morse St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5998593.8483 2087142.30255 37.7108147396853 -122.44666292955 (37.7108147396853, -122.44666292955) 9 7 6 28861 5
101270 125542 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 65 Heather Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5997338.84626 2114106.78779 37.78478079984 -122.452945569076 (37.78478079984, -122.452945569076) 15 6 1 54 31
106933 221895 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 47 Milton St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003758.63244 2095404.32352 37.7337940997194 -122.429401048121 (37.7337940997194, -122.429401048121) 2 7 5 28861 25
120305 221888 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 192 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006128.60788 2102045.32396 37.7521626832758 -122.421678849418 (37.7521626832758, -122.421678849418) 2 4 5 28859 19
135676 203502 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1277 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5990781.19981 2106711.00663 37.7640960267437 -122.475092558003 (37.7640960267437, -122.475092558003) 11 8 3 56 12
183922 221794 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 63 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009581.16571 2099887.27047 37.7464312301328 -122.409587024721 (37.7464312301328, -122.409587024721) 2 7 7 28859 2
72933 221807 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3720 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6004936.8002 2102544.12819 37.7534650059101 -122.425835807291 (37.7534650059101, -122.425835807291) 2 4 5 28862 22
20955 203536 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 347 Hearst Ave 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 6ft   5999101.32072 2094349.11818 37.7306319736778 -122.445426858158 (37.7306319736778, -122.445426858158) 9 7 4 28861 40

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