trees
61 rows where qSpecies_id = 300 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | ||||
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 | |||
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 |
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) );