trees
117 rows where Police Districts = 6 and qLegalStatus_id = 6 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134012 | 117417 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2835 Washington St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x10 | Permit Number 778177 | 6001153.1 | 2116153.5 | 37.7906183870332 | -122.439896334555 | (37.7906183870332, -122.439896334555) | 13 | 6 | 1 | 29490 | 27 | |||
58472 | 104728 | Significant Tree 6 | Tree(s) :: 17 | 3212 Jackson St | 1 | Front Yard : Cutout | Tree | Private 2 | 11/06/2013 12:00:00 AM | Permit Number 770525 | 5998810.5 | 2116292.9 | 37.7908675143955 | -122.448011605492 | (37.7908675143955, -122.448011605492) | 13 | 6 | 1 | 54 | 31 | |||
14136 | 112391 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 2201X LYON ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | 5999307 | 2116423 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | 13 | 6 | 1 | 29490 | 31 | ||||
189234 | 112390 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 2201X LYON ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | 5999307 | 2116423 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | 13 | 6 | 1 | 29490 | 31 | ||||
147066 | 121377 | Significant Tree 6 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 2701 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001200 | 2116539 | 37.7916795394978 | -122.439761713662 | (37.7916795394978, -122.439761713662) | 13 | 6 | 1 | 29490 | 27 | ||||
72773 | 112366 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2224 Baker St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 775823 | 5999858.5 | 2116547.8 | 37.791627252722 | -122.444403911295 | (37.791627252722, -122.444403911295) | 13 | 6 | 1 | 29490 | 27 | |||
12411 | 260714 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2290 Lyon St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 784756 | 5999390 | 2116615 | 37.7917850243096 | -122.446029746387 | (37.7917850243096, -122.446029746387) | 13 | 6 | 1 | 29490 | 27 | |||
104499 | 107984 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2401x SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001096 | 2116670 | 37.7920333111805 | -122.440130949989 | (37.7920333111805, -122.440130949989) | 13 | 6 | 1 | 29490 | 27 | ||||
161834 | 107985 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2401x SCOTT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001096 | 2116670 | 37.7920333111805 | -122.440130949989 | (37.7920333111805, -122.440130949989) | 13 | 6 | 1 | 29490 | 27 | ||||
27860 | 107983 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 2405x Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6001231.00707 | 2116743.47753 | 37.7922427464694 | -122.439669095376 | (37.7922427464694, -122.439669095376) | 13 | 6 | 1 | 29490 | 27 | |||
82918 | 107986 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2401x SCOTT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001257 | 2116757 | 37.7922813550603 | -122.439580129378 | (37.7922813550603, -122.439580129378) | 13 | 6 | 1 | 29490 | 27 | ||||
6097 | 95161 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2721 Pacific Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | 13 | 6 | 1 | 29490 | 27 | |||||
98322 | 107720 | Significant Tree 6 | Tree(s) :: 17 | 2301x Baker St | 3 | Front Yard : Yard | Tree | Private 2 | 10/20/2014 12:00:00 AM | 3 | Permit Number 773397 | 5999765.63181 | 2116886.19958 | 37.7925511097437 | -122.44474956777 | (37.7925511097437, -122.44474956777) | 13 | 6 | 1 | 29490 | 27 | ||
24819 | 122688 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 2590 Pacific Ave | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 3x8 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |||
28531 | 173636 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 2 | Front Yard : Yard | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |
32335 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |
115527 | 122689 | Significant Tree 6 | Aesculus hippocastanum :: White Horsechestnut 190 | 2590 Pacific Ave | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 3x8 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 |
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) );