trees
28 rows where DBH = 7 and qSpecies_id = 133
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 701 | 52560 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1742 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 7 | Permit Number 48656 | 5984113.6499 | 2103302.6049 | 37.7543488257224 | -122.497901608629 | (37.7543488257224, -122.497901608629) | 1 | 8 | 3 | 56 | 35 | |
| 4563 | 223021 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006234.71683 | 2099501.18451 | 37.7451830394575 | -122.421131274692 | (37.7451830394575, -122.421131274692) | 2 | 7 | 7 | 28859 | 2 | |||
| 8188 | 126379 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1136 Havens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6007507.74968 | 2119357.27743 | 37.7997748437807 | -122.418136782297 | (37.7997748437807, -122.418136782297) | 5 | 1 | 1 | 28858 | 32 | |||
| 28527 | 206648 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994513.85188 | 2100887.12446 | 37.748320765087 | -122.461760191398 | (37.748320765087, -122.461760191398) | 1 | 8 | 4 | 29491 | 40 | |||
| 38300 | 206652 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994516.45103 | 2100943.31749 | 37.7484752065739 | -122.4617552775 | (37.7484752065739, -122.4617552775) | 1 | 8 | 4 | 29491 | 40 | |||
| 45592 | 206647 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994503.49405 | 2100867.53113 | 37.748266370491 | -122.461794587759 | (37.748266370491, -122.461794587759) | 1 | 8 | 4 | 29491 | 40 | |||
| 54746 | 143086 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 459 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010641.4481 | 2120294.7479 | 37.8025247902186 | -122.407359099343 | (37.8025247902186, -122.407359099343) | 3 | 1 | 10 | 308 | 23 | |||
| 56805 | 206593 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 187 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995062.08104 | 2100706.46988 | 37.7478562769412 | -122.459851357851 | (37.7478562769412, -122.459851357851) | 1 | 8 | 4 | 29491 | 40 | |||
| 70335 | 206597 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995049.66416 | 2100868.50319 | 37.7483004655893 | -122.459906030335 | (37.7483004655893, -122.459906030335) | 1 | 8 | 4 | 29491 | 40 | |||
| 89550 | 65967 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2562 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 7 | Permit Number 28991 | 5989886.449 | 2097917.9756 | 37.7399007896882 | -122.477544471364 | (37.7399007896882, -122.477544471364) | 1 | 8 | 3 | 29491 | 35 | |
| 91882 | 121558 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 400X Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6003675 | 2102779 | 37.7540385213778 | -122.430216135756 | (37.7540385213778, -122.430216135756) | 2 | 4 | 5 | 28862 | 22 | |||
| 95037 | 206600 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995054.43703 | 2100813.29817 | 37.7481491609747 | -122.459885527604 | (37.7481491609747, -122.459885527604) | 1 | 8 | 4 | 29491 | 40 | |||
| 101256 | 206522 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991046.63721 | 2100321.91518 | 37.7465686447317 | -122.473708385358 | (37.7465686447317, -122.473708385358) | 1 | 8 | 4 | 29491 | 40 | |||
| 103424 | 206620 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2105 09th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993657.15968 | 2101227.85905 | 37.7492069822304 | -122.464747327347 | (37.7492069822304, -122.464747327347) | 1 | 8 | 4 | 29491 | 40 | |||
| 110640 | 206559 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995306.63453 | 2095221.10602 | 37.7328088843117 | -122.458608676455 | (37.7328088843117, -122.458608676455) | 9 | 7 | 4 | 59 | 40 | |||
| 110892 | 31752 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2642 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 7 | Permit Number 35239 | 5989905.4007 | 2097381.577 | 37.7384290772799 | -122.477439751256 | (37.7384290772799, -122.477439751256) | 1 | 8 | 3 | 29491 | 35 | |
| 114209 | 206572 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | 1 | 8 | 4 | 29491 | 40 | |||
| 114823 | 223042 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006921.22556 | 2096271.82147 | 37.7363546053902 | -122.418528488295 | (37.7363546053902, -122.418528488295) | 2 | 7 | 7 | 28859 | 2 | |||
| 117769 | 126378 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1976 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003585.79025 | 2118315.11213 | 37.7966917978451 | -122.431633760802 | (37.7966917978451, -122.431633760802) | 13 | 9 | 1 | 57 | 17 | |||
| 148811 | 206520 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2290 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991725.72943 | 2099875.90905 | 37.7453833337792 | -122.471327688331 | (37.7453833337792, -122.471327688331) | 1 | 8 | 4 | 29491 | 40 | |||
| 157023 | 206592 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Montalvo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993721.8716 | 2099672.65516 | 37.744940517497 | -122.464410652624 | (37.744940517497, -122.464410652624) | 1 | 8 | 4 | 29491 | 40 | |||
| 160622 | 206650 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994518.14401 | 2100922.4103 | 37.748417898169 | -122.461747907542 | (37.748417898169, -122.461747907542) | 1 | 8 | 4 | 29491 | 40 | |||
| 160913 | 206649 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994518.46873 | 2100904.00828 | 37.7483673895631 | -122.461745450587 | (37.7483673895631, -122.461745450587) | 1 | 8 | 4 | 29491 | 40 | |||
| 164255 | 126380 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1136 Havens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6007510.81799 | 2119357.46903 | 37.7997755425663 | -122.418126178374 | (37.7997755425663, -122.418126178374) | 5 | 1 | 1 | 28858 | 32 | |||
| 169106 | 206621 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1912 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993175.25671 | 2102431.10448 | 37.7524829903015 | -122.466501185193 | (37.7524829903015, -122.466501185193) | 1 | 8 | 4 | 29491 | 12 | |||
| 177885 | 223020 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6006199.74889 | 2099432.38497 | 37.7449921601655 | -122.421247303447 | (37.7449921601655, -122.421247303447) | 2 | 7 | 7 | 28859 | 2 | |||
| 190674 | 206519 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991734.05463 | 2099933.45812 | 37.7455418303067 | -122.471303093689 | (37.7455418303067, -122.471303093689) | 1 | 8 | 4 | 29491 | 40 | |||
| 194061 | 206612 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Sola Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994889.66342 | 2100721.49656 | 37.7478876192364 | -122.460448654307 | (37.7478876192364, -122.460448654307) | 1 | 8 | 4 | 29491 | 40 |
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) );