trees
24 rows where DBH = 9 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4496 | 74361 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 299 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6005755.65434 | 2092345.08491 | 37.7255069657486 | -122.422279456248 | (37.7255069657486, -122.422279456248) | 9 | 7 | 7 | 309 | 5 | |||
| 8931 | 215339 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 637 Detroit St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5999420.83111 | 2095184.41503 | 37.7329437376643 | -122.444382272244 | (37.7329437376643, -122.444382272244) | 9 | 7 | 4 | 59 | 40 | |||
| 23212 | 179853 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5998760.78346 | 2089904.78247 | 37.7184094145512 | -122.446284557804 | (37.7184094145512, -122.446284557804) | 9 | 7 | 6 | 28861 | 25 | |||
| 47539 | 31120 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Edna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 9 | Permit Number 34839 | 5998792.22814 | 2094324.02861 | 37.7305454337211 | -122.446493629496 | (37.7305454337211, -122.446493629496) | 9 | 7 | 4 | 28861 | 40 | |
| 54391 | 179886 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6007455.79909 | 2094011.3835 | 37.7301780166028 | -122.416520168176 | (37.7301780166028, -122.416520168176) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 81813 | 241070 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 415 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6002148.82258 | 2103426.21289 | 37.7557290518693 | -122.43554031414 | (37.7557290518693, -122.43554031414) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 86661 | 197902 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 578 San Bruno Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6010935.09599 | 2105618.63993 | 37.7622440780325 | -122.405308806777 | (37.7622440780325, -122.405308806777) | 8 | 3 | 8 | 28856 | 29 | |||
| 101151 | 179820 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998698.87726 | 2087810.60096 | 37.712655734647 | -122.446347971688 | (37.712655734647, -122.446347971688) | 9 | 7 | 6 | 28861 | 25 | |||
| 105099 | 179861 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 243 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6004531.11595 | 2091836.46353 | 37.7240412542901 | -122.426476381783 | (37.7240412542901, -122.426476381783) | 9 | 7 | 6 | 28861 | 5 | |||
| 121616 | 136698 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1047 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6007369.77523 | 2120178.57084 | 37.802022141674 | -122.418672500363 | (37.802022141674, -122.418672500363) | 5 | 1 | 1 | 28858 | 32 | |||
| 126177 | 179892 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 101 Dartmouth St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008521.95318 | 2093544.04536 | 37.728954707483 | -122.412801294348 | (37.728954707483, -122.412801294348) | 9 | 3 | 7 | 309 | 28 | |||
| 129935 | 215324 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1288 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5993647.63812 | 2106753.81902 | 37.764379290687 | -122.465181573075 | (37.764379290687, -122.465181573075) | 11 | 8 | 11 | 56 | 12 | |||
| 133462 | 179834 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 134 Cotter St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6001971.52486 | 2093519.43437 | 37.7285172835473 | -122.435444813332 | (37.7285172835473, -122.435444813332) | 9 | 7 | 6 | 28861 | 25 | |||
| 136982 | 215322 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1546 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993091.78936 | 2104948.86266 | 37.7593912846005 | -122.466972852608 | (37.7593912846005, -122.466972852608) | 1 | 8 | 4 | 56 | 12 | |||
| 137739 | 241056 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 4864 17th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5997871.31028 | 2105665.38567 | 37.7616333843862 | -122.450494663794 | (37.7616333843862, -122.450494663794) | 15 | 5 | 11 | 29492 | 9 | |||
| 147511 | 136710 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6007938.82451 | 2120606.36693 | 37.8032287836485 | -122.41673363846 | (37.8032287836485, -122.41673363846) | 5 | 1 | 1 | 308 | 32 | |||
| 149332 | 179850 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5998778.24395 | 2089941.01946 | 37.7185099101936 | -122.446226809638 | (37.7185099101936, -122.446226809638) | 9 | 7 | 6 | 28861 | 25 | |||
| 161074 | 41928 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 524 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 9 | Permit Number 42287 | 5994708.51972 | 2111929.51477 | 37.7786515066402 | -122.461887634901 | (37.7786515066402, -122.461887634901) | 11 | 6 | 2 | 54 | 11 | |
| 178178 | 197908 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Arkansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012886.87762 | 2106673.42615 | 37.7652492165901 | -122.398632309145 | (37.7652492165901, -122.398632309145) | 14 | 3 | 8 | 28856 | 20 | |||
| 179893 | 179877 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1516 Bacon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6007105.23827 | 2091790.85239 | 37.7240611967477 | -122.417574786965 | (37.7240611967477, -122.417574786965) | 9 | 7 | 7 | 309 | 28 | |||
| 189980 | 179878 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1516 Bacon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6007090.65933 | 2091786.11509 | 37.7240473687785 | -122.417624848631 | (37.7240473687785, -122.417624848631) | 9 | 7 | 7 | 309 | 28 | |||
| 192763 | 215327 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992028.3413 | 2098343.65136 | 37.7411936459769 | -122.470169759049 | (37.7411936459769, -122.470169759049) | 1 | 8 | 4 | 59 | 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) );