trees
41 rows where PlotSize = "Width 4ft" 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3399 | 197903 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 578 San Bruno Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6010927.90334 | 2105602.38731 | 37.762199049855 | -122.405332538967 | (37.762199049855, -122.405332538967) | 8 | 3 | 8 | 28856 | 29 | |||
13058 | 260903 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 51 Shore View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 5984536 | 2112849 | 37.7805852728313 | -122.497145662996 | (37.7805852728313, -122.497145662996) | 11 | 6 | 2 | 55 | 26 | ||||
14557 | 179896 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008623.46871 | 2091235.83896 | 37.7226225602776 | -122.412287269767 | (37.7226225602776, -122.412287269767) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
27327 | 179900 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008639.8841 | 2091240.95748 | 37.7226375357801 | -122.412230886773 | (37.7226375357801, -122.412230886773) | 9 | 3 | 7 | 309 | 28 | |||
32212 | 179898 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008631.84124 | 2091237.77549 | 37.7226283473964 | -122.412258464481 | (37.7226283473964, -122.412258464481) | 9 | 3 | 7 | 309 | 28 | |||
42109 | 215292 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 4ft | 5994414.45382 | 2100572.16969 | 37.747450256423 | -122.462081067713 | (37.747450256423, -122.462081067713) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
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 | |||
49209 | 179799 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5998244.59243 | 2088714.20474 | 37.7151108676608 | -122.447983134341 | (37.7151108676608, -122.447983134341) | 9 | 7 | 6 | 28861 | 25 | |||
49273 | 136676 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2121 Broadway | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6003331.47965 | 2117519.24553 | 37.7944921352492 | -122.432456859008 | (37.7944921352492, -122.432456859008) | 13 | 9 | 1 | 29490 | 27 | |||
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 | |||
61794 | 215293 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 4ft | 5994427.84018 | 2100560.89209 | 37.747420061691 | -122.462033961208 | (37.747420061691, -122.462033961208) | 1 | 8 | 4 | 29491 | 40 | |||
64911 | 179899 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008635.8472 | 2091239.23923 | 37.7226325913056 | -122.412244720114 | (37.7226325913056, -122.412244720114) | 9 | 3 | 7 | 309 | 28 | |||
70544 | 179889 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008314.8677 | 2094310.92324 | 37.7310487635727 | -122.41357142338 | (37.7310487635727, -122.41357142338) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
94276 | 179895 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008618.46635 | 2091234.88491 | 37.7226196599519 | -122.412304494484 | (37.7226196599519, -122.412304494484) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
104409 | 179798 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Foote Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5998239.51925 | 2088721.51535 | 37.7151306509273 | -122.448001195404 | (37.7151306509273, -122.448001195404) | 9 | 7 | 6 | 28861 | 25 | |||
104877 | 179837 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 285 Santa Rosa Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6000743.66321 | 2093585.989 | 37.728630215899 | -122.439694355537 | (37.728630215899, -122.439694355537) | 9 | 7 | 6 | 28861 | 25 | |||
105223 | 179902 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008644.61497 | 2091242.09558 | 37.7226409262237 | -122.412214613536 | (37.7226409262237, -122.412214613536) | 9 | 3 | 7 | 309 | 28 | |||
112107 | 179897 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008627.84918 | 2091236.6223 | 37.7226249569704 | -122.412272182734 | (37.7226249569704, -122.412272182734) | 9 | 3 | 7 | 309 | 28 | |||
115107 | 123109 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 534 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992552.3957 | 2111792.37608 | 37.7781505989958 | -122.469336449069 | (37.7781505989958, -122.469336449069) | 11 | 6 | 2 | 54 | 11 | |||
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 | |||
127245 | 123108 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 534 11th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992553.53653 | 2111802.27469 | 37.7781778438173 | -122.469333223241 | (37.7781778438173, -122.469333223241) | 11 | 6 | 2 | 54 | 11 | |||
141080 | 179879 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 463 Amherst St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6007835.00514 | 2091691.6908 | 37.7238299567678 | -122.415045072275 | (37.7238299567678, -122.415045072275) | 9 | 3 | 7 | 309 | 28 | |||
142951 | 197900 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 578 San Bruno Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 6010959.66368 | 2105665.96946 | 37.7623754078088 | -122.405227168994 | (37.7623754078088, -122.405227168994) | 8 | 3 | 8 | 28856 | 29 | |||
146018 | 136674 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2127 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003286.01413 | 2117511.22224 | 37.7944675271099 | -122.432613601844 | (37.7944675271099, -122.432613601844) | 13 | 9 | 1 | 29490 | 27 | |||
149317 | 179894 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008613.89309 | 2091233.32436 | 37.7226151183816 | -122.412320193042 | (37.7226151183816, -122.412320193042) | 9 | 3 | 7 | 309 | 28 | |||
150798 | 136677 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2121 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6003353.41971 | 2117521.18244 | 37.7944986976029 | -122.432381082137 | (37.7944986976029, -122.432381082137) | 13 | 9 | 1 | 29490 | 27 | |||
155425 | 197901 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 578 San Bruno Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6010946.53736 | 2105641.36513 | 37.7623071159928 | -122.405270835575 | (37.7623071159928, -122.405270835575) | 8 | 3 | 8 | 28856 | 29 | |||
155887 | 179901 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008641.95014 | 2091241.02596 | 37.7226378397427 | -122.412223749739 | (37.7226378397427, -122.412223749739) | 9 | 3 | 7 | 309 | 28 | |||
157954 | 179904 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1039 Woolsey St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008652.42423 | 2091244.38754 | 37.7226476576547 | -122.412187780452 | (37.7226476576547, -122.412187780452) | 9 | 3 | 7 | 309 | 28 | |||
166505 | 215294 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 4ft | 5994441.43842 | 2100548.35757 | 37.7473864279531 | -122.461986030947 | (37.7473864279531, -122.461986030947) | 1 | 8 | 4 | 29491 | 40 | |||
173401 | 179888 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6008315.20524 | 2094307.45797 | 37.7310392676412 | -122.413570011448 | (37.7310392676412, -122.413570011448) | 9 | 3 | 7 | 309 | 28 | |||
175071 | 179890 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008311.43296 | 2094322.79302 | 37.7310811625636 | -122.413584137105 | (37.7310811625636, -122.413584137105) | 9 | 3 | 7 | 309 | 28 | |||
181270 | 136675 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2127 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003298.06459 | 2117513.66207 | 37.7944749096307 | -122.432572080161 | (37.7944749096307, -122.432572080161) | 13 | 9 | 1 | 29490 | 27 | |||
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 | |||
190200 | 215291 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 4ft | 5994404.07408 | 2100583.57652 | 37.7474809790792 | -122.462117787007 | (37.7474809790792, -122.462117787007) | 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) );