trees
17 rows where DBH = 4 and qSpecies_id = 65 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
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) );