trees
22 rows where Zip Codes = 55 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1950 | 71713 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 782 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983564.60428 | 2110493.72832 | 37.7740614056929 | -122.500331946576 | (37.7740614056929, -122.500331946576) | 11 | 6 | 2 | 55 | 26 | |||
| 5035 | 103624 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/04/2013 12:00:00 AM | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | |||
| 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 | |||
| 5717 | 72392 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2220 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988673.5466 | 2110578.22329 | 37.7745919608967 | -122.48266563867 | (37.7745919608967, -122.48266563867) | 11 | 6 | 2 | 55 | 26 | |||
| 6392 | 70172 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3027 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989237.11171 | 2111905.73167 | 37.7782697016213 | -122.480813388031 | (37.7782697016213, -122.480813388031) | 11 | 6 | 2 | 55 | 26 | |||
| 7366 | 444 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 700X 23rd Ave | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8-HOA | 5988817.90932 | 2110395.27546 | 37.774098034723 | -122.482152859676 | (37.774098034723, -122.482152859676) | 11 | 6 | 2 | 55 | 26 | |||
| 7835 | 258799 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 566 29th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5986943 | 2112080 | 37.7786145821325 | -122.488762272653 | (37.7786145821325, -122.488762272653) | 11 | 6 | 2 | 55 | 26 | ||||
| 11629 | 47454 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 5135 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 6 | Permit Number 45360 | 5982684.34734 | 2111666.51211 | 37.7772298203102 | -122.50346371712 | (37.7772298203102, -122.50346371712) | 11 | 6 | 2 | 55 | 26 | |
| 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 | ||||
| 21064 | 45165 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 227 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | 3 | Permit Number 44015 | 5987719.09382 | 2114404.67144 | 37.7850427307042 | -122.486248205367 | (37.7850427307042, -122.486248205367) | 11 | 6 | 1 | 55 | 26 | ||
| 22738 | 120295 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 191 24th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5988321.26869 | 2114707.42753 | 37.7859090914651 | -122.484187107183 | (37.7859090914651, -122.484187107183) | 11 | 6 | 1 | 55 | 33 | |||
| 60405 | 120082 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 261 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5987725.3967 | 2114231.06843 | 37.7845664337094 | -122.486213650773 | (37.7845664337094, -122.486213650773) | 11 | 6 | 1 | 55 | 26 | |||
| 69558 | 84155 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 770 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52704 | 5981697.89996 | 2110507.76717 | 37.7739902053501 | -122.506790127416 | (37.7739902053501, -122.506790127416) | 11 | 6 | 2 | 55 | 26 | |
| 72527 | 120265 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 24th Ave | 3 | Side Yard : Yard | Tree | Private 2 | 20 | 5988361.48129 | 2115164.47421 | 37.7871663527314 | -122.484081512932 | (37.7871663527314, -122.484081512932) | 11 | 6 | 1 | 55 | 33 | ||||
| 73016 | 120230 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 154 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5988064.78369 | 2114963.42937 | 37.7865970627596 | -122.485093253087 | (37.7865970627596, -122.485093253087) | 11 | 6 | 1 | 55 | 33 | |||
| 106864 | 103625 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/04/2013 12:00:00 AM | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | |||
| 133639 | 121844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 518 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5990041.13259 | 2111807.14387 | 37.7780457072257 | -122.478024804476 | (37.7780457072257, -122.478024804476) | 11 | 6 | 2 | 55 | 26 | |||
| 135535 | 120845 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.85655 | 2113416.78862 | 37.7824580717728 | -122.478575916409 | (37.7824580717728, -122.478575916409) | 11 | 6 | 2 | 55 | 26 | |||
| 150071 | 67960 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 819 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 12 | Permit Number 31680 | 5987243.89988 | 2110346.29905 | 37.7738718832899 | -122.487593962509 | (37.7738718832899, -122.487593962509) | 11 | 6 | 2 | 55 | 26 | |
| 175109 | 120844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.94097 | 2113420.78105 | 37.7824690387717 | -122.478575916411 | (37.7824690387717, -122.478575916411) | 11 | 6 | 2 | 55 | 26 | |||
| 191808 | 103623 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/04/2013 12:00:00 AM | 13x2 | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | ||
| 193341 | 120231 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 154 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5988063.88277 | 2114955.73403 | 37.7865758810738 | -122.485095805195 | (37.7865758810738, -122.485095805195) | 11 | 6 | 1 | 55 | 33 |
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) );