61 rows where qSpecies_id = 300 sorted by YCoord

View and edit SQL

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)
131731 214010 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 1282 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   5993646.42758 2106770.73569 37.7644256696191 -122.465186988782 (37.7644256696191, -122.465186988782) 11 8 11 56 12
99393 197274 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 1 Sidewalk: Property side : Yard Tree Private 2     12     6016132.08399 2107992.89152 37.7690524495297 -122.387499868632 (37.7690524495297, -122.387499868632) 14 3 9 310 20
152244 197275 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 6ft   6016114.88446 2108006.33732 37.7690884161304 -122.387560299479 (37.7690884161304, -122.387560299479) 14 3 9 310 20
8468 197330 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 14 Bridgeview Way 10 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016083.25197 2108007.00917 37.7690885087587 -122.38766976226 (37.7690885087587, -122.38766976226) 14 3 9 310 20
43477 197276 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 3 Sidewalk: Property side : Yard Tree Private 2     10     6016130.4022 2108018.99868 37.7691240409612 -122.387507507471 (37.7691240409612, -122.387507507471) 14 3 9 310 20
35754 197329 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 14 Bridgeview Way 9 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016083.65358 2108026.91709 37.7691431938187 -122.387669762259 (37.7691431938187, -122.387669762259) 14 3 9 310 20
66143 197277 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 4 Sidewalk: Curb side : Yard Tree Private 2     13 Width 6ft   6016113.56208 2108033.05397 37.7691617009916 -122.387566737717 (37.7691617009916, -122.387566737717) 14 3 9 310 20
97676 197278 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 5 Sidewalk: Property side : Yard Tree Private 2     8     6016127.49423 2108040.92806 37.769184093202 -122.387519096154 (37.769184093202, -122.387519096154) 14 3 9 310 20
20936 197328 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 14 Bridgeview Way 8 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016081.1788 2108055.10958 37.7692204671748 -122.38768028972 (37.7692204671748, -122.38768028972) 14 3 9 310 20
110898 197279 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 6 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   6016112.15748 2108055.69454 37.7692237892692 -122.387573175954 (37.7692237892692, -122.387573175954) 14 3 9 310 20
187435 197327 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 14 Bridgeview Way 7 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016081.45818 2108068.9584 37.769258508494 -122.387680289716 (37.769258508494, -122.387680289716) 14 3 9 310 20
150880 197280 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 7 Sidewalk: Property side : Yard Tree Private 2     8     6016126.2319 2108070.60894 37.7692655205206 -122.387525533474 (37.7692655205206, -122.387525533474) 14 3 9 310 20
36336 197281 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 8 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   6016110.38845 2108078.71323 37.7692868955955 -122.387580901141 (37.7692868955955, -122.387580901141) 14 3 9 310 20
127579 197282 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 9 Sidewalk: Property side : Yard Tree Private 2     8     6016126.62805 2108090.24775 37.769319466359 -122.387525533476 (37.769319466359, -122.387525533476) 14 3 9 310 20
52990 197283 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 10 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6016109.01375 2108102.83593 37.7693530551333 -122.387587339395 (37.7693530551333, -122.387587339395) 14 3 9 310 20
143510 197326 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 14 Bridgeview Way 6 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6016080.07973 2108108.38527 37.769366689736 -122.387687808951 (37.769366689736, -122.387687808951) 14 3 9 310 20
88847 197284 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 11 Sidewalk: Property side : Yard Tree Private 2     11     6016124.07114 2108114.80894 37.7693867644176 -122.387536091526 (37.7693867644176, -122.387536091526) 14 3 9 310 20
135704 197325 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 14 Bridgeview Way 5 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016079.09017 2108123.99167 37.7694094866965 -122.387692320842 (37.7694094866965, -122.387692320842) 14 3 9 310 20
184324 197285 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 12 Sidewalk: Curb side : Yard Tree Private 2     9 Width 6ft   6016108.43544 2108129.53724 37.769426339083 -122.387591202882 (37.769426339083, -122.387591202882) 14 3 9 310 20
193308 197286 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 13 Sidewalk: Property side : Yard Tree Private 2     5     6016122.10777 2108142.97702 37.7694639990838 -122.387544848216 (37.7694639990838, -122.387544848216) 14 3 9 310 20
112031 197324 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 14 Bridgeview Way 4 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016077.33631 2108144.80906 37.7694665495632 -122.387699840069 (37.7694665495632, -122.387699840069) 14 3 9 310 20
45569 197287 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 14 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6016106.644 2108151.44442 37.7694863922003 -122.387598928065 (37.7694863922003, -122.387598928065) 14 3 9 310 20
130838 197288 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 15 Sidewalk: Property side : Yard Tree Private 2     7     6016122.50392 2108162.61583 37.7695179449204 -122.387544848233 (37.7695179449204, -122.387544848233) 14 3 9 310 20
178783 197289 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 16 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   6016104.5103 2108174.84091 37.7695505156795 -122.387607941055 (37.7695505156795, -122.387607941055) 14 3 9 310 20
20842 197290 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 18 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016103.18046 2108201.18695 37.7696227825046 -122.387614379323 (37.7696227825046, -122.387614379323) 14 3 9 310 20
161879 197323 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 14 Bridgeview Way 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016072.52647 2108208.1178 37.7696401151345 -122.387720895025 (37.7696401151345, -122.387720895025) 14 3 9 310 20
33390 197291 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 19 Sidewalk: Property side : Yard Tree Private 2     5     6016119.81432 2108213.82546 37.7696584064353 -122.387557724709 (37.7696584064353, -122.387557724709) 14 3 9 310 20
192209 197292 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 20 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6016102.8622 2108222.32256 37.769680798655 -122.387616954977 (37.769680798655, -122.387616954977) 14 3 9 310 20
87899 197322 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 14 Bridgeview Way 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016075.02245 2108224.08687 37.7696841009794 -122.387713375778 (37.7696841009794, -122.387713375778) 14 3 9 310 20
168046 197293 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 21 Sidewalk: Property side : Yard Tree Private 2     7     6016120.55273 2108231.97432 37.7697082801492 -122.387556436894 (37.7697082801492, -122.387556436894) 14 3 9 310 20
149236 197321 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 14 Bridgeview Way 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016071.10439 2108245.38059 37.7697423518581 -122.387728414261 (37.7697423518581, -122.387728414261) 14 3 9 310 20
150016 197294 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 22 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   6016100.76588 2108247.57178 37.7697500113938 -122.387625967988 (37.7697500113938, -122.387625967988) 14 3 9 310 20
78612 197295 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 23 Sidewalk: Property side : Yard Tree Private 2     6     6016116.71545 2108263.18986 37.769793778677 -122.387571888147 (37.769793778677, -122.387571888147) 14 3 9 310 20
162288 197320 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 16 Bridgeview Way 10 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016068.99433 2108270.10145 37.7698101130652 -122.38773743804 (37.7698101130652, -122.38773743804) 14 3 9 310 20
122269 197296 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 11 Bridgeview Way 24 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   6016097.57551 2108273.95502 37.7698222773026 -122.387638844473 (37.7698222773026, -122.387638844473) 14 3 9 310 20
177288 197319 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 16 Bridgeview Way 9 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016066.8339 2108313.87338 37.7699301815631 -122.387747965502 (37.7699301815631, -122.387747965502) 14 3 9 310 20
39043 197318 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 16 Bridgeview Way 8 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016065.97558 2108335.97136 37.7699908102494 -122.387752476503 (37.7699908102494, -122.387752476503) 14 3 9 310 20
136962 197297 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 2 Sidewalk: Property side : Yard Tree Private 2     5     6016111.05999 2108351.89846 37.7700370398988 -122.387597640241 (37.7700370398988, -122.387597640241) 14 3 9 310 20
63910 197317 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 16 Bridgeview Way 7 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016063.89172 2108361.99068 37.7700621381908 -122.387761500319 (37.7700621381908, -122.387761500319) 14 3 9 310 20
149438 197298 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016094.16751 2108363.36014 37.7700675754904 -122.387656871394 (37.7700675754904, -122.387656871394) 14 3 9 310 20
21375 197299 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 4 Sidewalk: Property side : Yard Tree Private 2     5     6016109.97525 2108371.93758 37.7700920028679 -122.387602790654 (37.7700920028679, -122.387602790654) 14 3 9 310 20
104837 197316 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 16 Bridgeview Way 6 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016062.19028 2108385.40465 37.7701263335922 -122.387769019543 (37.7701263335922, -122.387769019543) 14 3 9 310 20
45781 197300 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 6 Sidewalk: Property side : Yard Tree Private 2     5     6016108.28074 2108398.66141 37.7701652868163 -122.387610516728 (37.7701652868163, -122.387610516728) 14 3 9 310 20
90766 197315 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 16 Bridgeview Way 5 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   6016060.47111 2108407.95267 37.7701881503006 -122.387776539678 (37.7701881503006, -122.387776539678) 14 3 9 310 20
88484 197301 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 7 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6016091.41098 2108411.23459 37.7701988755957 -122.387669746961 (37.7701988755957, -122.387669746961) 14 3 9 310 20
112110 197302 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 8 Sidewalk: Property side : Yard Tree Private 2     6     6016108.37202 2108421.64225 37.7702283922446 -122.387611804545 (37.7702283922446, -122.387611804545) 14 3 9 310 20
6433 197303 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 9 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016090.04379 2108435.72758 37.7702660522696 -122.387676185234 (37.7702660522696, -122.387676185234) 14 3 9 310 20
158854 197314 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 16 Bridgeview Way 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6016057.14011 2108479.8898 37.7703854894316 -122.387793081795 (37.7703854894316, -122.387793081795) 14 3 9 310 20
59312 197304 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 10 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016087.22721 2108480.63748 37.7703892090349 -122.387689061714 (37.7703892090349, -122.387689061714) 14 3 9 310 20
91345 197305 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 11 Sidewalk: Property side : Yard Tree Private 2     3     6016103.90601 2108495.49899 37.7704309393585 -122.38763240622 (37.7704309393585, -122.38763240622) 14 3 9 310 20
130407 197313 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 16 Bridgeview Way 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016056.29901 2108502.85342 37.7704484959236 -122.387797593705 (37.7704484959236, -122.387797593705) 14 3 9 310 20
62943 197306 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 12 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016086.21724 2108504.38173 37.7704543496162 -122.387694212136 (37.7704543496162, -122.387694212136) 14 3 9 310 20
21217 197312 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 16 Bridgeview Way 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016054.19772 2108528.00678 37.7705174451533 -122.38780661748 (37.7705174451533, -122.38780661748) 14 3 9 310 20
55427 197307 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 13 Sidewalk: Property side : Yard Tree Private 2     4     6016099.30364 2108544.15188 37.7705642746414 -122.387651720961 (37.7705642746414, -122.387651720961) 14 3 9 310 20
182391 197308 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 14 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016082.38164 2108554.13112 37.7705907381114 -122.387710951221 (37.7705907381114, -122.387710951221) 14 3 9 310 20
80898 197309 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 15 Sidewalk: Property side : Yard Tree Private 2     5     6016098.96323 2108564.17566 37.7706192367121 -122.387654295711 (37.7706192367121, -122.387654295711) 14 3 9 310 20
59650 197311 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 16 Bridgeview Way 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   6016051.68139 2108575.68217 37.7706482119628 -122.387818648634 (37.7706482119628, -122.387818648634) 14 3 9 310 20
32974 197310 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 13 Bridgeview Way 16 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6016082.19822 2108581.9361 37.7706670743519 -122.387713525969 (37.7706670743519, -122.387713525969) 14 3 9 310 20
37596 123490 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 600 Arguello Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 10:38:00 AM 3     5995673.90504 2111757.95548 37.7782359793629 -122.458535593893 (37.7782359793629, -122.458535593893) 11 6 2 54 16
19094 34470 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 1725 Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/15/1997 12:00:00 AM 4   Permit Number 38203 6008690.7518 2118960.18601 37.7987510438941 -122.414015036487 (37.7987510438941, -122.414015036487) 5 1 10 308 21
11226 33101 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 450X Chestnut St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 11/05/1996 12:00:00 AM 14   Permit Number 37341 6009682.3141 2120901.0273 37.804135754367 -122.410721035819 (37.804135754367, -122.410721035819) 3 1 10 308 23

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