trees
37 rows where Zip Codes = 57 and qSpecies_id = 86
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11189 | 136665 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 65 Normandie Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000886.70084 | 2117510.54537 | 37.7943293112096 | -122.4409154505 | (37.7943293112096, -122.4409154505) | 13 | 9 | 1 | 57 | 27 | |||
| 12939 | 136649 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002175.88564 | 2121598.89549 | 37.8056281874435 | -122.436747525379 | (37.8056281874435, -122.436747525379) | 13 | 9 | 1 | 57 | 17 | |||
| 15056 | 136668 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2640 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000716.04305 | 2117375.36701 | 37.793948425839 | -122.44149623986 | (37.793948425839, -122.44149623986) | 13 | 9 | 1 | 57 | 27 | |||
| 17039 | 136666 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 45 Normandie Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000890.78199 | 2117450.16174 | 37.7941637460202 | -122.440896995501 | (37.7941637460202, -122.440896995501) | 13 | 9 | 1 | 57 | 27 | |||
| 22753 | 136655 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002095.53828 | 2121587.56307 | 37.80559250506 | -122.437024766584 | (37.80559250506, -122.437024766584) | 13 | 9 | 1 | 57 | 17 | |||
| 31608 | 136644 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3801 Webster St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002496.13752 | 2121660.90327 | 37.8058166394946 | -122.435643688532 | (37.8058166394946, -122.435643688532) | 13 | 9 | 1 | 57 | 17 | |||
| 36884 | 136634 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3600 Baker St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5999197.43818 | 2121197.11006 | 37.8043552744421 | -122.447025895951 | (37.8043552744421, -122.447025895951) | 13 | 9 | 1 | 57 | 17 | ||||
| 40704 | 136716 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 14 | Side Yard : Yard | Tree | Private 2 | 15 | Width 7ft | 6003215.33658 | 2120983.87446 | 37.8039985196804 | -122.43310638985 | (37.8039985196804, -122.43310638985) | 13 | 9 | 1 | 57 | 17 | |||
| 44452 | 136673 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2650 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000708.53208 | 2117436.75891 | 37.7941165639844 | -122.441526636039 | (37.7941165639844, -122.441526636039) | 13 | 9 | 1 | 57 | 27 | |||
| 50876 | 39476 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1425 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 14 | Permit Number 40937 | 6002367.56738 | 2121559.91338 | 37.8055320445375 | -122.436081393069 | (37.8055320445375, -122.436081393069) | 13 | 9 | 1 | 57 | 17 | ||
| 51654 | 136654 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6002110.79049 | 2121588.87191 | 37.8055969657012 | -122.436972078008 | (37.8055969657012, -122.436972078008) | 13 | 9 | 1 | 57 | 17 | |||
| 54469 | 136659 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 11 | Side Yard : Yard | Tree | Private 2 | 13 | Width 7ft | 6003202.74777 | 2120982.34817 | 37.8039936147875 | -122.433149845112 | (37.8039936147875, -122.433149845112) | 13 | 9 | 1 | 57 | 17 | |||
| 55052 | 136641 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2901 Steiner St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002004.16197 | 2118138.13487 | 37.796116088744 | -122.437093866005 | (37.796116088744, -122.437093866005) | 13 | 9 | 1 | 57 | 17 | |||
| 57882 | 136670 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2640 Divisadero St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000713.73895 | 2117400.40925 | 37.7940170539955 | -122.441506010108 | (37.7940170539955, -122.441506010108) | 13 | 9 | 1 | 57 | 27 | |||
| 58420 | 136671 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2650 Divisadero St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6000711.13679 | 2117411.08582 | 37.7940462208083 | -122.441515780329 | (37.7940462208083, -122.441515780329) | 13 | 9 | 1 | 57 | 27 | |||
| 61991 | 136635 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3600 Baker St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5999192.08373 | 2121248.84261 | 37.804497012091 | -122.447048150554 | (37.804497012091, -122.447048150554) | 13 | 9 | 1 | 57 | 17 | ||||
| 62547 | 136657 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1725 North Point St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 9ft | 6002469.52976 | 2120880.32815 | 37.8036718751301 | -122.435679888015 | (37.8036718751301, -122.435679888015) | 13 | 9 | 1 | 57 | 17 | |||
| 62558 | 136653 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6002117.3275 | 2121589.45847 | 37.8055989477865 | -122.436949497817 | (37.8055989477865, -122.436949497817) | 13 | 9 | 1 | 57 | 17 | |||
| 85899 | 136715 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 9 | Side Yard : Yard | Tree | Private 2 | 9 | Width 7ft | 6003190.85748 | 2120979.91426 | 37.803986257417 | -122.433190818205 | (37.803986257417, -122.433190818205) | 13 | 9 | 1 | 57 | 17 | |||
| 93918 | 136660 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 17 | Side Yard : Yard | Tree | Private 2 | 14 | Width 7ft | 6003228.45993 | 2120985.21121 | 37.8040029344509 | -122.433061071222 | (37.8040029344509, -122.433061071222) | 13 | 9 | 1 | 57 | 17 | |||
| 102034 | 136652 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002131.53394 | 2121592.77416 | 37.8056088592346 | -122.43690057202 | (37.8056088592346, -122.43690057202) | 13 | 9 | 1 | 57 | 17 | |||
| 103768 | 136642 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3035 Divisadero St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6000450.1684 | 2118732.62208 | 37.7976599396021 | -122.442513681577 | (37.7976599396021, -122.442513681577) | 13 | 9 | 1 | 57 | 17 | |||
| 105124 | 136656 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1425 Jefferson St | 4 | : | Tree | Private 2 | 18 | Width 3ft | 6002391.37561 | 2121563.03053 | 37.8055419559627 | -122.435999224706 | (37.8055419559627, -122.435999224706) | 13 | 9 | 1 | 57 | 17 | |||
| 111535 | 136714 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 3 | Side Yard : Yard | Tree | Private 2 | 18 | Width 7ft | 6003161.03368 | 2120976.61805 | 37.8039755150326 | -122.433293789677 | (37.8039755150326, -122.433293789677) | 13 | 9 | 1 | 57 | 17 | |||
| 112794 | 136639 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2901 Steiner St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001999.29002 | 2118169.89644 | 37.7962030208048 | -122.437112999059 | (37.7962030208048, -122.437112999059) | 13 | 9 | 1 | 57 | 17 | |||
| 117200 | 136669 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2640 Divisadero St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000715.68155 | 2117388.18403 | 37.7939835974195 | -122.44149841085 | (37.7939835974195, -122.44149841085) | 13 | 9 | 1 | 57 | 27 | |||
| 124320 | 136672 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2650 Divisadero St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000710.42284 | 2117422.03568 | 37.7940762455768 | -122.441519036792 | (37.7940762455768, -122.441519036792) | 13 | 9 | 1 | 57 | 27 | |||
| 134209 | 136658 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 6 | Side Yard : Yard | Tree | Private 2 | 15 | Width 7ft | 6003175.48548 | 2120978.26665 | 37.8039808614944 | -122.433243896185 | (37.8039808614944, -122.433243896185) | 13 | 9 | 1 | 57 | 17 | |||
| 144301 | 136647 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6002197.32767 | 2121601.52004 | 37.8056366123151 | -122.436673510277 | (37.8056366123151, -122.436673510277) | 13 | 9 | 1 | 57 | 17 | |||
| 144491 | 136651 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002148.06177 | 2121594.41755 | 37.8056143109046 | -122.436843492933 | (37.8056143109046, -122.436843492933) | 13 | 9 | 1 | 57 | 17 | |||
| 145031 | 136646 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3801 Webster St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002496.98739 | 2121653.01832 | 37.8057950377808 | -122.435640182969 | (37.8057950377808, -122.435640182969) | 13 | 9 | 1 | 57 | 17 | |||
| 146617 | 136645 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3801 Webster St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002496.65751 | 2121656.65619 | 37.8058050076721 | -122.435641584993 | (37.8058050076721, -122.435641584993) | 13 | 9 | 1 | 57 | 17 | |||
| 152355 | 136667 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 45 Normandie Ter | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000893.50994 | 2117430.42201 | 37.7941097012578 | -122.440886139797 | (37.7941097012578, -122.440886139797) | 13 | 9 | 1 | 57 | 27 | |||
| 156393 | 136650 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002164.97809 | 2121597.31622 | 37.8056232312917 | -122.436785159329 | (37.8056232312917, -122.436785159329) | 13 | 9 | 1 | 57 | 17 | |||
| 166932 | 136648 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002184.59684 | 2121599.43708 | 37.8056301695703 | -122.436717417869 | (37.8056301695703, -122.436717417869) | 13 | 9 | 1 | 57 | 17 | |||
| 167364 | 136640 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2901 Steiner St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6002002.26446 | 2118153.31636 | 37.7961576653005 | -122.43710151924 | (37.7961576653005, -122.43710151924) | 13 | 9 | 1 | 57 | 17 | |||
| 189701 | 136643 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2781 Filbert St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 5999657.45024 | 2118405.07114 | 37.7967153546854 | -122.445233129815 | (37.7967153546854, -122.445233129815) | 13 | 9 | 1 | 57 | 17 |
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) );