trees
32 rows where DBH = 7 and qSpecies_id = 86 sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5435 | 70223 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2011 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989310.46344 | 2111227.07993 | 37.776410575875 | -122.480509949706 | (37.776410575875, -122.480509949706) | 11 | 6 | 2 | 55 | 26 | |||
22753 | 136655 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002095.53828 | 2121587.56307 | 37.80559250506 | -122.437024766584 | (37.80559250506, -122.437024766584) | 13 | 9 | 1 | 57 | 17 | |||
23410 | 215313 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997655.06789 | 2090049.20462 | 37.7187427527624 | -122.450116941352 | (37.7187427527624, -122.450116941352) | 9 | 8 | 6 | 28861 | 24 | |||
24370 | 215317 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997677.83985 | 2090093.68651 | 37.7188661927949 | -122.450041432477 | (37.7188661927949, -122.450041432477) | 9 | 8 | 6 | 28861 | 24 | |||
27119 | 215314 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997659.25231 | 2090057.81858 | 37.7187666441474 | -122.450103098091 | (37.7187666441474, -122.450103098091) | 9 | 8 | 6 | 28861 | 24 | |||
38031 | 215288 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Pacheco St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5991477.1073 | 2101838.1015 | 37.7507566211347 | -122.472330389247 | (37.7507566211347, -122.472330389247) | 1 | 8 | 4 | 29491 | 12 | |||
42831 | 215318 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997681.5922 | 2090099.04662 | 37.7188811251298 | -122.450028848265 | (37.7188811251298, -122.450028848265) | 9 | 8 | 6 | 28861 | 24 | |||
44291 | 215312 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997649.01848 | 2090038.45407 | 37.7187128880716 | -122.450137077175 | (37.7187128880716, -122.450137077175) | 9 | 8 | 6 | 28861 | 24 | |||
49688 | 136713 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 290 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6011569.99478 | 2119432.50864 | 37.8002092172264 | -122.404085130728 | (37.8002092172264, -122.404085130728) | 3 | 1 | 10 | 308 | 23 | |||
51532 | 179818 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998665.00636 | 2087845.19043 | 37.7127487749191 | -122.446467526652 | (37.7127487749191, -122.446467526652) | 9 | 7 | 6 | 28861 | 25 | |||
53129 | 136663 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3109 Franklin St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6005049.76701 | 2120690.58566 | 37.8032971105329 | -122.426737318298 | (37.8032971105329, -122.426737318298) | 13 | 9 | 1 | 28858 | 17 | |||
56759 | 215319 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997686.11778 | 2090106.56575 | 37.7189020298764 | -122.450013746835 | (37.7189020298764, -122.450013746835) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
68300 | 241061 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 6005940.184 | 2095824.54912 | 37.7350712161596 | -122.421888601897 | (37.7350712161596, -122.421888601897) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
90245 | 136682 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 874 Green St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6008846.30156 | 2119059.10202 | 37.7990313778645 | -122.413483781748 | (37.7990313778645, -122.413483781748) | 3 | 1 | 10 | 308 | 32 | |||
93014 | 136664 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3109 Franklin St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6005052.80958 | 2120674.99367 | 37.8032544709705 | -122.42672567836 | (37.8032544709705, -122.42672567836) | 13 | 9 | 1 | 28858 | 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 | |||
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 | |||
118052 | 52756 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 176@ GEARY Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2006 12:00:00 AM | 7 | Permit Number 48800 | 5995950.25747 | 2113100.83881 | 37.7819390591214 | -122.457676787394 | (37.7819390591214, -122.457676787394) | 11 | 6 | 1 | 54 | 31 | ||
122775 | 215315 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997671.74515 | 2090080.76177 | 37.7188303557048 | -122.450061568292 | (37.7188303557048, -122.450061568292) | 9 | 8 | 6 | 28861 | 24 | |||
123804 | 179868 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 345 Congdon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6004732.69466 | 2093569.91681 | 37.7288123277178 | -122.425902888604 | (37.7288123277178, -122.425902888604) | 9 | 7 | 6 | 28861 | 5 | |||
144491 | 136651 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002148.06177 | 2121594.41755 | 37.8056143109046 | -122.436843492933 | (37.8056143109046, -122.436843492933) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
147312 | 215316 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Tara St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5997674.77739 | 2090086.49914 | 37.7188462827039 | -122.45005150039 | (37.7188462827039, -122.45005150039) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
156393 | 136650 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1490 Jefferson St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002164.97809 | 2121597.31622 | 37.8056232312917 | -122.436785159329 | (37.8056232312917, -122.436785159329) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
159941 | 136686 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 915 Bay St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6006372.4804 | 2121073.97355 | 37.8044244898475 | -122.42218727034 | (37.8044244898475, -122.42218727034) | 5 | 1 | 1 | 28858 | 32 | |||
162049 | 179857 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2344 Alemany Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 5999361.46611 | 2089227.95328 | 37.7165852836723 | -122.444159646863 | (37.7165852836723, -122.444159646863) | 9 | 7 | 6 | 28861 | 25 | |||
177939 | 179858 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2344 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 5999350.65317 | 2089217.81228 | 37.7165568219137 | -122.444196293341 | (37.7165568219137, -122.444196293341) | 9 | 7 | 6 | 28861 | 25 | |||
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 |
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) );