trees
29 rows where DBH = 5 and qSpecies_id = 86
This data as json, CSV (advanced)
These facets timed out: DBH
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20460 | 100528 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1728 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4.5x6 | 6008351.1313 | 2118382.01094 | 37.7971444383282 | -122.415149288427 | (37.7971444383282, -122.415149288427) | 5 | 1 | 10 | 308 | 21 | |||
| 21329 | 136680 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1369 Hyde St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007505.03866 | 2117018.90394 | 37.7933541007707 | -122.417980305661 | (37.7933541007707, -122.417980305661) | 5 | 1 | 10 | 28858 | 32 | |||
| 24655 | 215338 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998226.11251 | 2096380.78786 | 37.7361604543418 | -122.448598839867 | (37.7361604543418, -122.448598839867) | 9 | 7 | 4 | 59 | 40 | |||
| 33262 | 116307 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | |||
| 34996 | 31114 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Edna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 5 | Permit Number 34839 | 5998792.19171 | 2094330.53052 | 37.7305632843566 | -122.44649422303 | (37.7305632843566, -122.44649422303) | 9 | 7 | 4 | 28861 | 40 | |
| 37032 | 215337 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998231.9169 | 2096387.51631 | 37.7361792609492 | -122.448579256245 | (37.7361792609492, -122.448579256245) | 9 | 7 | 4 | 59 | 40 | |||
| 46559 | 179844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 19 Camellia Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6003286.16791 | 2094080.48748 | 37.7301323849801 | -122.430940049855 | (37.7301323849801, -122.430940049855) | 9 | 7 | 6 | 28861 | 25 | |||
| 46837 | 179803 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1481 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5998958.13876 | 2089448.31197 | 37.7171673203931 | -122.445569578776 | (37.7171673203931, -122.445569578776) | 9 | 7 | 6 | 28861 | 25 | |||
| 49054 | 179903 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6008647.44016 | 2091243.13146 | 37.7226439290591 | -122.412204920617 | (37.7226439290591, -122.412204920617) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 59813 | 136702 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1728 Jones St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6008349.70738 | 2118393.07464 | 37.7971747364841 | -122.415154999108 | (37.7971747364841, -122.415154999108) | 5 | 1 | 10 | 308 | 21 | |||
| 63554 | 241060 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005928.78547 | 2095826.36488 | 37.7350755589952 | -122.421928139697 | (37.7350755589952, -122.421928139697) | 2 | 7 | 7 | 28859 | 2 | |||
| 69558 | 84155 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 770 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52704 | 5981697.89996 | 2110507.76717 | 37.7739902053501 | -122.506790127416 | (37.7739902053501, -122.506790127416) | 11 | 6 | 2 | 55 | 26 | |
| 71160 | 136681 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1369 Hyde St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007511.08374 | 2116974.21798 | 37.7932317444123 | -122.41795622 | (37.7932317444123, -122.41795622) | 5 | 1 | 10 | 28858 | 32 | |||
| 71235 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | 5 | 1 | 1 | 28858 | 32 | ||||
| 82501 | 136685 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 929 Bay St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6006311.09024 | 2121067.4414 | 37.8044030913911 | -122.422399252223 | (37.8044030913911, -122.422399252223) | 5 | 1 | 1 | 28858 | 32 | |||
| 88955 | 215335 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998237.40059 | 2096398.28008 | 37.7362091292407 | -122.448561071933 | (37.7362091292407, -122.448561071933) | 9 | 7 | 4 | 59 | 40 | |||
| 91516 | 179860 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 243 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6004522.90502 | 2091823.63198 | 37.7240055575044 | -122.426503852472 | (37.7240055575044, -122.426503852472) | 9 | 7 | 6 | 28861 | 5 | |||
| 92456 | 215336 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998234.84844 | 2096392.28962 | 37.7361925349403 | -122.448569464424 | (37.7361925349403, -122.448569464424) | 9 | 7 | 4 | 59 | 40 | |||
| 126944 | 241063 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005947.85615 | 2095824.2566 | 37.73507084564 | -122.421862055716 | (37.73507084564, -122.421862055716) | 2 | 7 | 7 | 28859 | 2 | |||
| 128394 | 241062 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005944.68012 | 2095825.54843 | 37.7350742136048 | -122.421873128139 | (37.7350742136048, -122.421873128139) | 2 | 7 | 7 | 28859 | 2 | |||
| 135830 | 179804 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1481 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5998957.13313 | 2089446.35886 | 37.717161900187 | -122.44557291438 | (37.717161900187, -122.44557291438) | 9 | 7 | 6 | 28861 | 25 | |||
| 161620 | 179873 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007108.9711 | 2091815.95561 | 37.7241303348443 | -122.417563661454 | (37.7241303348443, -122.417563661454) | 9 | 7 | 7 | 309 | 28 | |||
| 168686 | 136707 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1155 Greenwich St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007381.61519 | 2119835.37419 | 37.8010804768418 | -122.418607177199 | (37.8010804768418, -122.418607177199) | 5 | 1 | 1 | 28858 | 32 | |||
| 169155 | 136706 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1155 Greenwich St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007368.03811 | 2119831.84665 | 37.8010700267201 | -122.418653909561 | (37.8010700267201, -122.418653909561) | 5 | 1 | 1 | 28858 | 32 | |||
| 181025 | 179862 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 274 Moscow St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6004589.52556 | 2091551.8255 | 37.7232630025659 | -122.426254213277 | (37.7232630025659, -122.426254213277) | 9 | 7 | 6 | 28861 | 5 | |||
| 183336 | 136701 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1728 Jones St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6008350.35689 | 2118390.24391 | 37.7971670005024 | -122.415152551158 | (37.7971670005024, -122.415152551158) | 5 | 1 | 10 | 308 | 21 | |||
| 185017 | 136688 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 777 Bay St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6007087.93893 | 2121181.13167 | 37.8047590475447 | -122.419718966771 | (37.8047590475447, -122.419718966771) | 5 | 1 | 1 | 28858 | 32 | |||
| 190798 | 136683 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 874 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008833.05028 | 2119058.08121 | 37.7990278309217 | -122.413529563544 | (37.7990278309217, -122.413529563544) | 3 | 1 | 10 | 308 | 32 |
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) );