trees
35 rows where qSpecies_id = 180 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1242 | 125338 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 943 Green St | 13 | Side Yard : Yard | Tree | Private 2 | 7 | 6008681.05502 | 2118993.3413 | 37.7988415354762 | -122.414050937395 | (37.7988415354762, -122.414050937395) | 5 | 1 | 10 | 308 | 21 | ||||
7911 | 221663 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 355 Masonic Ave | 15 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6000243.57338 | 2106889.96572 | 37.7651312687056 | -122.442377910911 | (37.7651312687056, -122.442377910911) | 15 | 5 | 5 | 28862 | 3 | |||
9386 | 221661 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 332 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6006177.94117 | 2101108.79634 | 37.7495939748898 | -122.421441743156 | (37.7495939748898, -122.421441743156) | 2 | 4 | 5 | 28859 | 19 | |||
32822 | 221658 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 619 28th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 2ft | 6001870.44358 | 2099404.83716 | 37.7446714960931 | -122.436215264321 | (37.7446714960931, -122.436215264321) | 2 | 7 | 5 | 63 | 22 | |||
42868 | 221654 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 2 Trainor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008310.98632 | 2108259.27286 | 37.7693475818501 | -122.414571509075 | (37.7693475818501, -122.414571509075) | 8 | 4 | 7 | 28853 | 19 | |||
44309 | 125336 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 943 Green St | 8 | Side Yard : Yard | Tree | Private 2 | 13 | 6008636.03175 | 2118982.55728 | 37.7988093963818 | -122.414205969747 | (37.7988093963818, -122.414205969747) | 5 | 1 | 10 | 308 | 21 | ||||
58922 | 221659 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 619 28th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 2ft | 6001877.83925 | 2099406.20223 | 37.7446756644454 | -122.43618978925 | (37.7446756644454, -122.43618978925) | 2 | 7 | 5 | 63 | 22 | |||
60583 | 203310 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 711 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5997341.17783 | 2094972.11297 | 37.7322419310188 | -122.45155682788 | (37.7322419310188, -122.45155682788) | 9 | 7 | 4 | 59 | 40 | ||||
64555 | 221657 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 119 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006195.39377 | 2102302.17548 | 37.7528717042805 | -122.421466132763 | (37.7528717042805, -122.421466132763) | 2 | 4 | 5 | 28859 | 19 | |||
75788 | 203309 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 300x Marietta Dr | 44 | Median : Cutout | Tree | DPW 1 | 12 | Width 5ft | 5999493.35383 | 2097506.12856 | 37.7393227521334 | -122.444298328617 | (37.7393227521334, -122.444298328617) | 9 | 7 | 4 | 59 | 40 | |||
78163 | 199803 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 1330 Donner Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 0ft | 6015357.8938 | 2090741.5774 | 37.72164101353 | -122.388973157072 | (37.72164101353, -122.388973157072) | 10 | 3 | 8 | 58 | 1 | |||
80276 | 221660 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 1106 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008028.11056 | 2101448.31178 | 37.7506303518144 | -122.415067804458 | (37.7506303518144, -122.415067804458) | 2 | 4 | 7 | 28859 | 19 | |||
81497 | 221655 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 1801 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6009351.71824 | 2099059.68883 | 37.7441460132414 | -122.410322008262 | (37.7441460132414, -122.410322008262) | 2 | 7 | 7 | 28859 | 2 | |||
85937 | 125346 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 37 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 6008495.12972 | 2119144.49563 | 37.799246123364 | -122.414705004452 | (37.799246123364, -122.414705004452) | 5 | 1 | 10 | 308 | 32 | ||||
94026 | 203311 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 197 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992432.99188 | 2089152.6134 | 37.7159807180098 | -122.46810221944 | (37.7159807180098, -122.46810221944) | 9 | 8 | 6 | 64 | 24 | |||
108501 | 125340 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 943 Green St | 15 | Side Yard : Yard | Tree | Private 2 | 20 | 6008683.32426 | 2118993.96894 | 37.7988433862724 | -122.414043129483 | (37.7988433862724, -122.414043129483) | 5 | 1 | 10 | 308 | 21 | ||||
110595 | 125344 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 900 Green St | 36 | Front Yard : Yard | Tree | Private 2 | 10 | 6008567.57414 | 2119009.84956 | 37.7988804887064 | -122.414444788317 | (37.7988804887064, -122.414444788317) | 5 | 1 | 10 | 308 | 32 | ||||
113478 | 120550 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 298x Corbett Ave | 1 | Side Yard : Yard | Tree | DPW 1 | 10 | Permit Number 778898 | 5999572 | 2105342 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | 15 | 5 | 5 | 28862 | 3 | |||
117525 | 125342 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 900 Green St | 34 | Front Yard : Yard | Tree | Private 2 | 44 | 6008569.92711 | 2119005.57592 | 37.7988688865349 | -122.414436343681 | (37.7988688865349, -122.414436343681) | 5 | 1 | 10 | 308 | 32 | ||||
123492 | 181835 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 1201 Santiago St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989284.9043 | 2099668.4623 | 37.7446722442303 | -122.479752392917 | (37.7446722442303, -122.479752392917) | 1 | 8 | 3 | 29491 | 35 | |||
138972 | 125343 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 900 Green St | 35 | Front Yard : Yard | Tree | Private 2 | 49 | 6008565.48376 | 2119003.63515 | 37.7988633080488 | -122.414451581778 | (37.7988633080488, -122.414451581778) | 5 | 1 | 10 | 308 | 32 | ||||
145854 | 125339 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 943 Green St | 14 | Side Yard : Yard | Tree | Private 2 | 10 | 6008681.4461 | 2118995.91753 | 37.7988486311296 | -122.414049766478 | (37.7988486311296, -122.414049766478) | 5 | 1 | 10 | 308 | 21 | ||||
153252 | 251819 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 298X Corbett Ave | 1 | Side Yard : Yard | Tree | DPW 1 | 3x3 | Permit Number 778898 | 5999572 | 2105342 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | 15 | 5 | 5 | 28862 | 3 | |||
156604 | 139572 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 2101 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000749.1121 | 2112733.0668 | 37.7812037552799 | -122.441048612085 | (37.7812037552799, -122.441048612085) | 15 | 5 | 1 | 29490 | 41 | |||
158875 | 221662 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 332 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6006179.18858 | 2101087.67748 | 37.7495360576606 | -122.421435929945 | (37.7495360576606, -122.421435929945) | 2 | 4 | 5 | 28859 | 19 | |||
165651 | 125345 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 37 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6008486.65637 | 2119146.05481 | 37.7992499284092 | -122.414734435667 | (37.7992499284092, -122.414734435667) | 5 | 1 | 10 | 308 | 32 | ||||
172215 | 125341 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 900 Green St | 18 | Front Yard : Yard | Tree | Private 2 | 18 | 6008614.63085 | 2119005.8231 | 37.7988720764367 | -122.414281671073 | (37.7988720764367, -122.414281671073) | 5 | 1 | 10 | 308 | 32 | ||||
184290 | 192452 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 2009 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 1 | Width 3ft | 6011358.82025 | 2106481.94376 | 37.7646381974302 | -122.403904049543 | (37.7646381974302, -122.403904049543) | 8 | 3 | 8 | 28856 | 29 | ||
190070 | 125337 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 943 Green St | 10 | Side Yard : Yard | Tree | Private 2 | 35 | 6008660.27555 | 2118990.50152 | 37.7988325710362 | -122.414122640373 | (37.7988325710362, -122.414122640373) | 5 | 1 | 10 | 308 | 21 | ||||
192774 | 221656 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 123 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006192.45721 | 2102280.00009 | 37.7528106501898 | -122.421474713209 | (37.7528106501898, -122.421474713209) | 2 | 4 | 5 | 28859 | 19 | |||
194202 | 125335 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 945 Green St | 2 | Front Yard : Yard | Tree | Private 2 | 19 | 6008588.90325 | 2118969.76345 | 37.7987716203837 | -122.414368144483 | (37.7987716203837, -122.414368144483) | 5 | 1 | 10 | 308 | 21 | ||||
14314 | 101224 | Undocumented 4 | Acer macrophyllum :: Big Leaf Maple 180 | 1X Trainor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008353.8 | 2108315.6 | 37.7695046482274 | -122.414427404273 | (37.7695046482274, -122.414427404273) | 8 | 4 | 7 | 28853 | 19 | ||||
72319 | 40311 | Permitted Site 7 | Acer macrophyllum :: Big Leaf Maple 180 | 121 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2004 12:00:00 AM | Permit Number 41453 | 6006197.56884078 | 2102286.11075476 | 37.7528277168801 | -122.421457470156 | (37.7528277168801, -122.421457470156) | 2 | 4 | 5 | 28859 | 19 | ||
86745 | 40312 | Permitted Site 7 | Acer macrophyllum :: Big Leaf Maple 180 | 123 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | 6 | 3x3 | Permit Number 41454 | 6006197.01673983 | 2102279.01915111 | 37.7528082138393 | -122.421458875834 | (37.7528082138393, -122.421458875834) | 2 | 4 | 5 | 28859 | 19 |
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 |
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) );