trees
23 rows where qSpecies_id = 357
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13872 | 223985 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1000 San Jose Ave | 100 | Front Yard : Yard | Tree | Private 2 | 3 | 6005168.16195 | 2097235.94873 | 37.7389030331571 | -122.424658130684 | (37.7389030331571, -122.424658130684) | 2 | 7 | 5 | 28859 | 7 | ||||
| 28425 | 223978 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1001 San Jose Ave | 21 | Front Yard : Yard | Tree | Private 2 | 13 | 6005224.64241 | 2096990.32038 | 37.7382317827581 | -122.424445380762 | (37.7382317827581, -122.424445380762) | 2 | 7 | 5 | 28859 | 2 | ||||
| 33931 | 206262 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 389 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2005 12:00:00 AM | 17 | Width 3ft | Permit Number 48035 | 5992637.65541 | 2093989.35221 | 37.729273037804 | -122.467746379295 | (37.729273037804, -122.467746379295) | 9 | 8 | 4 | 59 | 40 | |
| 38754 | 223983 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1000 San Jose Ave | 72 | Front Yard : Yard | Tree | Private 2 | 4 | 6005068.86996 | 2097059.31242 | 37.7384124214878 | -122.424988872563 | (37.7384124214878, -122.424988872563) | 2 | 7 | 5 | 63 | 7 | ||||
| 50183 | 206263 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 900 Junipero Serra Blvd | 98 | : | Tree | Private 2 | 26 | Width 0ft | 5991142.47333 | 2090520.08752 | 37.7196608517337 | -122.4726624603 | (37.7196608517337, -122.4726624603) | 9 | 8 | 4 | 64 | 40 | |||
| 55278 | 223988 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 3770 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6004647.28322 | 2101937.78539 | 37.7517837647067 | -122.426793841569 | (37.7517837647067, -122.426793841569) | 2 | 4 | 5 | 28862 | 22 | |||
| 55817 | 223991 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1393 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6003295.67795 | 2100166.25248 | 37.7468430386775 | -122.431341427178 | (37.7468430386775, -122.431341427178) | 2 | 7 | 5 | 63 | 22 | |||
| 57770 | 199339 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1300x De Haro St | 27 | Median : Yard | Tree | DPW 1 | 16 | 6012269.24818 | 2102070.28333 | 37.7525755719142 | -122.4004451958 | (37.7525755719142, -122.4004451958) | 10 | 3 | 8 | 28856 | 29 | ||||
| 66997 | 24266 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 350X Winding Way | 4 | Median : Cutout | Tree | DPW 1 | 30 | 8 | 6001132.77174 | 2086585.13109 | 37.7094295741756 | -122.437847962815 | (37.7094295741756, -122.437847962815) | 9 | 7 | 6 | 28861 | 5 | |||
| 68636 | 223992 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1393 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6003299.26185 | 2100166.17851 | 37.7468430386836 | -122.431329029117 | (37.7468430386836, -122.431329029117) | 2 | 7 | 5 | 63 | 22 | |||
| 93538 | 100462 | Undocumented 4 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 236 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992450 | 2097712 | 37.7394836593705 | -122.468665877071 | (37.7394836593705, -122.468665877071) | 1 | 8 | 4 | 59 | 40 | |||||
| 103197 | 223987 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 733 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008547.47654 | 2104243.34455 | 37.7583340523817 | -122.41346943938 | (37.7583340523817, -122.41346943938) | 2 | 4 | 7 | 28859 | 19 | |||
| 121360 | 223981 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1001 San Jose Ave | 63 | Front Yard : Yard | Tree | Private 2 | 10 | Width 8ft | 6005335.62555 | 2097342.83204 | 37.739205967091 | -122.424086717622 | (37.739205967091, -122.424086717622) | 2 | 7 | 5 | 28859 | 2 | |||
| 122041 | 223989 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 3770 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6004597.66255 | 2101934.56635 | 37.7517721203085 | -122.426965207398 | (37.7517721203085, -122.426965207398) | 2 | 4 | 5 | 28862 | 22 | |||
| 148841 | 223980 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1001 San Jose Ave | 60 | Front Yard : Yard | Tree | Private 2 | 10 | 6005331.10363 | 2097321.45415 | 37.7391470129135 | -122.4241008325 | (37.7391470129135, -122.4241008325) | 2 | 7 | 5 | 28859 | 2 | ||||
| 156657 | 223986 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1000 San Jose Ave | 112 | Front Yard : Yard | Tree | Private 2 | 2 | 6005022.50641 | 2096918.98774 | 37.7380245025333 | -122.425139193343 | (37.7380245025333, -122.425139193343) | 2 | 7 | 5 | 63 | 7 | ||||
| 168932 | 101806 | Permitted Site 7 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 733 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 19463 | 6008567.7 | 2104253 | 37.7583616995478 | -122.413400180344 | (37.7583616995478, -122.413400180344) | 2 | 4 | 7 | 28859 | 19 | ||||
| 169203 | 223982 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1000 San Jose Ave | 25 | Front Yard : Yard | Tree | Private 2 | 6 | 6005159.47161 | 2097237.42875 | 37.7389066061482 | -122.424688283133 | (37.7389066061482, -122.424688283133) | 2 | 7 | 5 | 28859 | 7 | ||||
| 169490 | 223984 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1000 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 15 | 6005069.13037 | 2097045.62125 | 37.7383748433334 | -122.424986998352 | (37.7383748433334, -122.424986998352) | 2 | 7 | 5 | 63 | 7 | ||||
| 174240 | 223990 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 625 Douglass St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6001233.17503 | 2102831.20257 | 37.7540432493014 | -122.438664275631 | (37.7540432493014, -122.438664275631) | 2 | 4 | 5 | 28862 | 22 | |||
| 177653 | 223979 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 1001 San Jose Ave | 57 | Front Yard : Yard | Tree | Private 2 | 23 | 6005329.34305 | 2097309.20014 | 37.7391132667602 | -122.42410604857 | (37.7391132667602, -122.42410604857) | 2 | 7 | 5 | 28859 | 2 | ||||
| 184760 | 254498 | Undocumented 4 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 160 Oak Park Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5996144 | 2103482 | 37.7555393480762 | -122.456310814197 | (37.7555393480762, -122.456310814197) | 1 | 5 | 4 | 63 | 12 | ||||
| 191655 | 246805 | DPW Maintained 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 | 126 Brewster St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6010295.44868 | 2099195.49612 | 37.7445717675796 | -122.407068351029 | (37.7445717675796, -122.407068351029) | 2 | 7 | 7 | 28859 | 2 |
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) );