trees
33 rows where qSiteInfo = "Back Yard : Yard" and qSpecies_id = 59 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155569 | 109374 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 1 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 161562 | 195955 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 1 | Back Yard : Yard | Tree | Private 2 | 10 | 6015700.85592 | 2100342.37267 | 37.7480218628289 | -122.388457404684 | (37.7480218628289, -122.388457404684) | 10 | 3 | 8 | 58 | 1 | ||||
| 155557 | 195964 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 10 | Back Yard : Yard | Tree | Private 2 | 8 | 6015516.57214 | 2100331.82177 | 37.7479826784534 | -122.38909391965 | (37.7479826784534, -122.38909391965) | 10 | 3 | 8 | 58 | 1 | ||||
| 63271 | 195965 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 11 | Back Yard : Yard | Tree | Private 2 | 8 | 6015497.16873 | 2100330.63483 | 37.7479783437428 | -122.389160933554 | (37.7479783437428, -122.389160933554) | 10 | 3 | 8 | 58 | 1 | ||||
| 103959 | 195966 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 12 | Back Yard : Yard | Tree | Private 2 | 6 | 6015475.98989 | 2100328.78152 | 37.7479720808553 | -122.389234040342 | (37.7479720808553, -122.389234040342) | 3 | 8 | 58 | 1 | |||||
| 138530 | 195967 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 13 | Back Yard : Yard | Tree | Private 2 | 5 | 6015456.78398 | 2100328.64296 | 37.747970635647 | -122.389300444473 | (37.747970635647, -122.389300444473) | 3 | 8 | 58 | 1 | |||||
| 79032 | 195968 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 14 | Back Yard : Yard | Tree | Private 2 | 7 | 6015437.03514 | 2100327.81381 | 37.7479672640843 | -122.389368677829 | (37.7479672640843, -122.389368677829) | 3 | 8 | 58 | 1 | |||||
| 64076 | 195969 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 15 | Back Yard : Yard | Tree | Private 2 | 8 | 6015417.97335 | 2100326.09336 | 37.7479614832509 | -122.389434473133 | (37.7479614832509, -122.389434473133) | 3 | 8 | 58 | 1 | |||||
| 29793 | 195970 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 16 | Back Yard : Yard | Tree | Private 2 | 8 | 6015399.1088 | 2100325.42161 | 37.7479585928282 | -122.389499659601 | (37.7479585928282, -122.389499659601) | 3 | 8 | 58 | 1 | |||||
| 144333 | 195971 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 17 | Back Yard : Yard | Tree | Private 2 | 10 | Width 4ft | 6015377.86647 | 2100320.41197 | 37.7479436595871 | -122.389572765484 | (37.7479436595871, -122.389572765484) | 3 | 8 | 58 | 1 | ||||
| 127355 | 195972 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 18 | Back Yard : Yard | Tree | Private 2 | 10 | Width 4ft | 6015355.8319 | 2100319.80426 | 37.7479407691514 | -122.389648918288 | (37.7479407691514, -122.389648918288) | 3 | 8 | 58 | 1 | ||||
| 98771 | 195973 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 19 | Back Yard : Yard | Tree | Private 2 | 10 | Width 4ft | 6015335.01264 | 2100318.29491 | 37.7479354703429 | -122.389720805596 | (37.7479354703429, -122.389720805596) | 3 | 8 | 58 | 1 | ||||
| 42007 | 195956 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 2 | Back Yard : Yard | Tree | Private 2 | 9 | 6015682.42479 | 2100340.57249 | 37.7480158985316 | -122.388521013727 | (37.7480158985316, -122.388521013727) | 10 | 3 | 8 | 58 | 1 | ||||
| 84676 | 109375 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 2 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 41514 | 195974 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 20 | Back Yard : Yard | Tree | Private 2 | 12 | Width 4ft | 6015315.44713 | 2100317.81293 | 37.7479330619596 | -122.389788429193 | (37.7479330619596, -122.389788429193) | 3 | 8 | 58 | 1 | ||||
| 81240 | 195975 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 21 | Back Yard : Yard | Tree | Private 2 | 9 | Width 4ft | 6015294.9834 | 2100316.47199 | 37.747928245201 | -122.389859098828 | (37.747928245201, -122.389859098828) | 3 | 8 | 58 | 1 | ||||
| 185019 | 195976 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 22 | Back Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6015275.57642 | 2100315.10939 | 37.7479234275315 | -122.389926112714 | (37.7479234275315, -122.389926112714) | 3 | 8 | 58 | 1 | ||||
| 145025 | 195977 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 23 | Back Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6015256.87723 | 2100313.90806 | 37.7479190918917 | -122.389990690329 | (37.7479190918917, -122.389990690329) | 3 | 8 | 58 | 1 | ||||
| 53808 | 195978 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 24 | Back Yard : Yard | Tree | Private 2 | 9 | Width 4ft | 6015236.23042 | 2100312.22008 | 37.7479133119586 | -122.390061968785 | (37.7479133119586, -122.390061968785) | 3 | 8 | 58 | 1 | ||||
| 77598 | 249893 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 230 Greenwich St | 29 | Back Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6011394.80053 | 2120441.53452 | 37.8029699659579 | -122.404762450627 | (37.8029699659579, -122.404762450627) | 3 | 1 | 10 | 28860 | 6 | |||
| 26017 | 109376 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 3 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 173532 | 195957 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 3 | Back Yard : Yard | Tree | Private 2 | 12 | 6015667.37966 | 2100340.53223 | 37.7480149542209 | -122.388573036834 | (37.7480149542209, -122.388573036834) | 10 | 3 | 8 | 58 | 1 | ||||
| 66019 | 249894 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 230 Greenwich St | 30 | Back Yard : Yard | Tree | Private 2 | 24 | Width 0ft | 6011403.76038 | 2120447.63681 | 37.8029872221404 | -122.404731874586 | (37.8029872221404, -122.404731874586) | 3 | 1 | 10 | 28860 | 6 | |||
| 98514 | 249895 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 230 Greenwich St | 31 | Back Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6011395.76102 | 2120447.38073 | 37.8029860719045 | -122.404759538639 | (37.8029860719045, -122.404759538639) | 3 | 1 | 10 | 28860 | 6 | |||
| 142161 | 249896 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 230 Greenwich St | 32 | Back Yard : Yard | Tree | Private 2 | 24 | Width 0ft | 6011386.30387 | 2120437.51769 | 37.8029584618196 | -122.404791570676 | (37.8029584618196, -122.404791570676) | 3 | 1 | 10 | 28860 | 6 | |||
| 64778 | 109377 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 4 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 176690 | 195958 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 4 | Back Yard : Yard | Tree | Private 2 | 10 | 6015649.24062 | 2100340.89834 | 37.7480149542299 | -122.388635787013 | (37.7480149542299, -122.388635787013) | 10 | 3 | 8 | 58 | 1 | ||||
| 61534 | 195959 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 5 | Back Yard : Yard | Tree | Private 2 | 10 | 6015616.60441 | 2100338.74984 | 37.7480072461368 | -122.388748492749 | (37.7480072461368, -122.388748492749) | 10 | 3 | 8 | 58 | 1 | ||||
| 137889 | 109378 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 5 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 192137 | 195960 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 6 | Back Yard : Yard | Tree | Private 2 | 8 | 6015597.7328 | 2100337.72732 | 37.7480033925609 | -122.388813679213 | (37.7480033925609, -122.388813679213) | 10 | 3 | 8 | 58 | 1 | ||||
| 137920 | 195961 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 7 | Back Yard : Yard | Tree | Private 2 | 10 | 6015577.60391 | 2100335.50195 | 37.7479961664858 | -122.388883129368 | (37.7479961664858, -122.388883129368) | 10 | 3 | 8 | 58 | 1 | ||||
| 90159 | 195962 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 8 | Back Yard : Yard | Tree | Private 2 | 9 | 6015556.60842 | 2100333.99599 | 37.7479908676843 | -122.388955626422 | (37.7479908676843, -122.388955626422) | 10 | 3 | 8 | 58 | 1 | ||||
| 167404 | 195963 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 9 | Back Yard : Yard | Tree | Private 2 | 8 | 6015537.22246 | 2100333.68578 | 37.7479889413373 | -122.389022641203 | (37.7479889413373, -122.389022641203) | 10 | 3 | 8 | 58 | 1 |
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) );