trees
14 rows where Neighborhoods (old) = 22 and qLegalStatus_id = 8 sorted by YCoord descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34602 | 97033 | Property Tree 8 | Afrocarpus gracilior :: Fern Pine 89 | 61 Vicksburg St | Back Yard : Yard | Tree | Private 2 | Possible significant tree; Nellie RoW; rear yard | 6004120 | 2102703 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | 2 | 4 | 5 | 28862 | 22 | |||||
162706 | 94228 | Property Tree 8 | Acer palmatum :: Japanese Maple 216 | 1097 Church St | Front Yard : Yard | Tree | Private 2 | 06/25/2010 12:00:00 AM | Permit Number 53567 | 6004455 | 2102510 | 37.7533440588084 | -122.427499544702 | (37.7533440588084, -122.427499544702) | 2 | 4 | 5 | 28862 | 22 | ||||
90477 | 109091 | Property Tree 8 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 4235 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773805 | 6001611.4 | 2102294.1 | 37.7525900037408 | -122.43731782876 | (37.7525900037408, -122.43731782876) | 2 | 4 | 5 | 28862 | 22 |
26011 | 100148 | Property Tree 8 | Tree(s) :: 17 | 209 Vicksburg St | Back Yard : Yard | Tree | Private 2 | 6004141 | 2102142 | 37.7523158521071 | -122.428559192815 | (37.7523158521071, -122.428559192815) | 2 | 4 | 5 | 28862 | 22 | ||||||
42557 | 101977 | Property Tree 8 | Cedrus deodara :: Deodar Cedar 109 | 601 Grand View Ave | Front Yard : Yard | Tree | Private 2 | 6000076.2 | 2101609.9 | 37.7506239629918 | -122.442577679409 | (37.7506239629918, -122.442577679409) | 2 | 4 | 5 | 28862 | 22 | ||||||
2998 | 261600 | Property Tree 8 | Acer macrophyllum :: Big Leaf Maple 180 | 451X Jersey St | 1 | Back Yard : Yard | Tree | Public Library 12 | 3x3 | 6002237 | 2101405 | 37.7501842910814 | -122.435090813874 | (37.7501842910814, -122.435090813874) | 2 | 4 | 5 | 28862 | 22 | ||||
57789 | 121199 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 72 Fountain St | 1 | Back Yard : Yard | Tree | Private 2 | 6000322 | 2101283 | 37.7497403826665 | -122.441704227556 | (37.7497403826665, -122.441704227556) | 2 | 4 | 5 | 28862 | 22 | |||||
84644 | 118371 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 4808 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999981 | 2101110 | 37.7492459313263 | -122.442870994168 | (37.7492459313263, -122.442870994168) | 2 | 4 | 5 | 28862 | 22 | ||||
44517 | 251117 | Property Tree 8 | Sequoiadendron giganteum :: Sierra Redwood 240 | 2024 Castro St | 1 | Back Yard : Yard | Tree | Private 2 | 6002622 | 2099601 | 37.7452527853239 | -122.433630548541 | (37.7452527853239, -122.433630548541) | 2 | 7 | 5 | 63 | 22 | |||||
106981 | 109092 | Property Tree 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 237 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773766 | 6004335.1 | 2099509.2 | 37.7450977767532 | -122.427700396282 | (37.7450977767532, -122.427700396282) | 2 | 7 | 5 | 63 | 22 |
120627 | 100045 | Property Tree 8 | Acacia decurrens :: Acacia: Silver Wattle 111 | 556 28th St | Front Yard : Yard | Tree | Private 2 | Not sure which property tree is located on. | 6002301 | 2099461 | 37.7448501592716 | -122.434730501666 | (37.7448501592716, -122.434730501666) | 2 | 7 | 5 | 63 | 22 | |||||
58309 | 100046 | Property Tree 8 | Tree(s) :: 17 | 562 28th St | Front Yard : Yard | Tree | Private 2 | 11/28/2012 12:00:00 AM | 17 | Permit Number 769057 | 6002262 | 2099459 | 37.7448424535299 | -122.434865213189 | (37.7448424535299, -122.434865213189) | 2 | 7 | 5 | 63 | 22 | |||
68497 | 99961 | Property Tree 8 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 1 | Front Yard : Yard | Tree | Private 2 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459 | 2099152 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | 2 | 7 | 5 | 63 | 22 | |||
28785 | 122558 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1760 Diamond St | 1 | Back Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6001927 | 2098732 | 37.7428272563398 | -122.435971568238 | (37.7428272563398, -122.435971568238) | 2 | 7 | 5 | 63 | 22 |
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) );