trees
41 rows where Zip Codes = 309 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 57951 | 179814 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 522 Sunnydale Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | 6010066.66697 | 2086413.12079 | 37.7094612429124 | -122.406958677794 | (37.7094612429124, -122.406958677794) | 9 | 7 | 8 | 309 | 39 | ||||
| 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 | |||
| 79418 | 179867 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 985 Avalon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6005404.97601 | 2092232.73416 | 37.7251786880381 | -122.423483738408 | (37.7251786880381, -122.423483738408) | 9 | 7 | 6 | 309 | 5 | |||
| 80852 | 54662 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 353 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 18 | Permit Number 10486 | 6012290.80379 | 2086856.89359 | 37.7108039630942 | -122.39930277173 | (37.7108039630942, -122.39930277173) | 10 | 3 | 8 | 309 | 1 | ||
| 81457 | 179891 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 101 Dartmouth St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008528.33324 | 2093531.3526 | 37.7289202139869 | -122.41277834095 | (37.7289202139869, -122.41277834095) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 105096 | 179885 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007447.44417 | 2094010.42268 | 37.7301749085276 | -122.416548984266 | (37.7301749085276, -122.416548984266) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 106736 | 179905 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1216 Silver Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 3ft | 6008780.07198 | 2094033.26413 | 37.7303124823168 | -122.411943512893 | (37.7303124823168, -122.411943512893) | 9 | 3 | 7 | 309 | 28 | |||
| 107371 | 179874 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007111.06937 | 2091808.8773 | 37.7241110173924 | -122.4175559066 | (37.7241110173924, -122.4175559066) | 9 | 7 | 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 | |||
| 123638 | 179876 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007115.03067 | 2091796.72343 | 37.7240778683719 | -122.41754135197 | (37.7240778683719, -122.41754135197) | 9 | 7 | 7 | 309 | 28 | |||
| 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 | |||
| 133906 | 179882 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Pioche St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005924.81091 | 2093297.57145 | 37.7281318260086 | -122.421762319978 | (37.7281318260086, -122.421762319978) | 9 | 7 | 7 | 309 | 5 | |||
| 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 | |||
| 144877 | 179883 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 39 Amherst St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007323.05766 | 2093363.44581 | 37.7283914539998 | -122.416933184515 | (37.7283914539998, -122.416933184515) | 9 | 3 | 7 | 309 | 5 | |||
| 148428 | 179906 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 600 Somerset St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6010277.8918 | 2091719.16171 | 37.7240423622482 | -122.406602309775 | (37.7240423622482, -122.406602309775) | 10 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 161950 | 179870 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 743 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6005435.63394 | 2092350.08273 | 37.7255026319158 | -122.423386095411 | (37.7255026319158, -122.423386095411) | 9 | 7 | 7 | 309 | 5 | |||
| 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 | |||
| 175053 | 179875 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007112.5297 | 2091803.34556 | 37.7240959105931 | -122.417550466576 | (37.7240959105931, -122.417550466576) | 9 | 7 | 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 | |||
| 179861 | 179869 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 299 Madison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6005754.24665 | 2092349.7952 | 37.725519819773 | -122.422284657027 | (37.725519819773, -122.422284657027) | 9 | 7 | 7 | 309 | 5 | |||
| 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 |
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) );