trees
121 rows where qSpecies_id = 82 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14757 | 208879 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100x Idora Ave | 19 | Median : Yard | Tree | DPW 1 | 7 | Width 9ft | 5995727.40355 | 2099320.34097 | 37.7440885519582 | -122.457450449475 | (37.7440885519582, -122.457450449475) | 1 | 8 | 4 | 59 | 40 | |||
| 144029 | 11192 | DPW Maintained 1 | Malus :: Crab Apple 82 | 156 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 5995565.7362355 | 2099396.4910429 | 37.7442883537687 | -122.458014965266 | (37.7442883537687, -122.458014965266) | 1 | 8 | 4 | 59 | 40 | |||
| 188281 | 208877 | DPW Maintained 1 | Malus :: Crab Apple 82 | 136 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995442.32442 | 2097008.84044 | 37.7377253637243 | -122.458268913495 | (37.7377253637243, -122.458268913495) | 9 | 7 | 4 | 59 | 40 | |||
| 180403 | 208883 | DPW Maintained 1 | Malus :: Crab Apple 82 | 350 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994771.01328 | 2090927.26714 | 37.7209882430054 | -122.460149470526 | (37.7209882430054, -122.460149470526) | 9 | 8 | 6 | 28861 | 24 | |||
| 32566 | 208882 | DPW Maintained 1 | Malus :: Crab Apple 82 | 322 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994766.71833 | 2090736.01345 | 37.7204628590582 | -122.460150467892 | (37.7204628590582, -122.460150467892) | 9 | 8 | 6 | 28861 | 24 | |||
| 35497 | 208885 | DPW Maintained 1 | Malus :: Crab Apple 82 | 175 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994860.83688 | 2099398.63743 | 37.7442537214346 | -122.460452495288 | (37.7442537214346, -122.460452495288) | 1 | 8 | 4 | 59 | 40 | |||
| 191249 | 208880 | DPW Maintained 1 | Malus :: Crab Apple 82 | 331 Kensington Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994249.09162 | 2099012.51392 | 37.7431583121036 | -122.462539760623 | (37.7431583121036, -122.462539760623) | 1 | 8 | 4 | 59 | 40 | |||
| 10841 | 177480 | DPW Maintained 1 | Malus :: Crab Apple 82 | 289 Flournoy St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | 5993810.32054 | 2086750.18301 | 37.7094636621006 | -122.463167341725 | (37.7094636621006, -122.463167341725) | 9 | 8 | 6 | 28861 | 25 | ||||
| 84907 | 208884 | DPW Maintained 1 | Malus :: Crab Apple 82 | 450 Bright St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 5993793.06593 | 2090164.68597 | 37.7188380799952 | -122.46347460498 | (37.7188380799952, -122.46347460498) | 9 | 8 | 6 | 64 | 24 | |||
| 37159 | 177479 | DPW Maintained 1 | Malus :: Crab Apple 82 | 275 De Long St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 5993713.98854 | 2086795.12422 | 37.7095815101473 | -122.463503537957 | (37.7095815101473, -122.463503537957) | 9 | 8 | 6 | 28861 | 25 | |||
| 122425 | 208876 | DPW Maintained 1 | Malus :: Crab Apple 82 | 24 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993960.68043 | 2101012.29566 | 37.7486325942246 | -122.463682112736 | (37.7486325942246, -122.463682112736) | 1 | 8 | 4 | 29491 | 40 | |||
| 61035 | 208875 | DPW Maintained 1 | Malus :: Crab Apple 82 | 24 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993958.96858 | 2101016.35827 | 37.7486436504797 | -122.463688327067 | (37.7486436504797, -122.463688327067) | 1 | 8 | 4 | 29491 | 40 | |||
| 170388 | 208874 | DPW Maintained 1 | Malus :: Crab Apple 82 | 88 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993686.48009 | 2101413.58216 | 37.7497186209261 | -122.464659422191 | (37.7497186209261, -122.464659422191) | 1 | 8 | 4 | 29491 | 40 | |||
| 154390 | 208873 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1915 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5992820.79743 | 2102456.25278 | 37.7525315806908 | -122.46772878318 | (37.7525315806908, -122.46772878318) | 1 | 8 | 4 | 29491 | 12 | |||
| 150502 | 97162 | Property Tree 8 | Malus :: Crab Apple 82 | 478 10th Ave | Back Yard : Yard | Tree | Private 2 | Tree in backyard on private property; not significant. | 5992861.5 | 2112216.7 | 37.7793335349967 | -122.468298031686 | (37.7793335349967, -122.468298031686) | 11 | 6 | 2 | 54 | 11 | |||||
| 93944 | 183470 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2535 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5988285.2504 | 2098036.7141 | 37.7401337687504 | -122.483089381496 | (37.7401337687504, -122.483089381496) | 1 | 8 | 3 | 29491 | 35 | |||
| 73376 | 181939 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2435 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5986090.3717 | 2098658.104 | 37.7417119717507 | -122.490723983614 | (37.7417119717507, -122.490723983614) | 1 | 8 | 3 | 29491 | 35 | |||
| 53601 | 184211 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1483 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984010.2855 | 2105077.6933 | 37.7592166624085 | -122.498390165683 | (37.7592166624085, -122.498390165683) | 1 | 8 | 3 | 56 | 35 | |||
| 68050 | 183309 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1278 42nd Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983073.9761 | 2106459.9318 | 37.7629569477354 | -122.501730586329 | (37.7629569477354, -122.501730586329) | 1 | 8 | 3 | 56 | 35 | |||
| 17133 | 183310 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1278 42nd Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983073.0612 | 2106470.9099 | 37.762987036737 | -122.501734562858 | (37.762987036737, -122.501734562858) | 1 | 8 | 3 | 56 | 35 | |||
| 14342 | 185383 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2611 45th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5982402.2599 | 2097319.6826 | 37.7378209010805 | -122.503376950994 | (37.7378209010805, -122.503376950994) | 1 | 8 | 3 | 29491 | 35 |
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) );