trees
121 rows where Zip Codes = 55 and qSpecies_id = 6
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 162045 | 24747 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1999 12:00:00 AM | 3 | 3X3 | 5982215.35166 | 2112638.47493 | 37.7798709615679 | -122.505158146759 | (37.7798709615679, -122.505158146759) | 11 | 6 | 2 | 55 | 26 | ||
| 162564 | 118108 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3585 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2017 12:00:00 AM | 3 | Width 3ft | 5984519.42575 | 2111051.46948 | 37.7756488017479 | -122.497070281467 | (37.7756488017479, -122.497070281467) | 11 | 6 | 2 | 55 | 26 | ||
| 166220 | 90719 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4616 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981255.79709 | 2110310.22456 | 37.7734217675099 | -122.508304742671 | (37.7734217675099, -122.508304742671) | 11 | 6 | 2 | 55 | 26 | ||
| 168020 | 118692 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4549 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5981428.28301 | 2110941.30275 | 37.7751646862289 | -122.507754939589 | (37.7751646862289, -122.507754939589) | 11 | 6 | 2 | 55 | 26 | |||
| 168229 | 90283 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4508 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981566.01243 | 2111001.75609 | 37.7753387866897 | -122.507282997083 | (37.7753387866897, -122.507282997083) | 11 | 6 | 2 | 55 | 26 | ||
| 169302 | 118589 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 150 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982275.32502 | 2112634.79146 | 37.779864376411 | -122.50495040284 | (37.779864376411, -122.50495040284) | 11 | 6 | 2 | 55 | 26 | |||
| 170818 | 120009 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 746 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5986962.57059 | 2110820.51914 | 37.775157546008 | -122.488601975561 | (37.775157546008, -122.488601975561) | 11 | 6 | 2 | 55 | 26 | |||
| 171990 | 90740 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4451X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981760.6962 | 2110270.81896 | 37.7733433125278 | -122.506555332031 | (37.7733433125278, -122.506555332031) | 11 | 6 | 2 | 55 | 26 | ||
| 177874 | 42963 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 560 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42852 | 5981647.94996 | 2111905.75128 | 37.7778257173711 | -122.507066636025 | (37.7778257173711, -122.507066636025) | 11 | 6 | 2 | 55 | 26 | ||
| 178384 | 120804 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 689 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989715.19561 | 2110680.27165 | 37.774932704327 | -122.479069875733 | (37.774932704327, -122.479069875733) | 11 | 6 | 2 | 55 | 26 | |||
| 183256 | 88394 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 139 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51373 | 5988000.05712 | 2115038.19323 | 37.7867985724398 | -122.485322676521 | (37.7867985724398, -122.485322676521) | 11 | 6 | 1 | 55 | 33 | ||
| 183672 | 250554 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 El Camino Del Mar | 2 | : | Tree | Private 2 | 5 | Width 4ft | 5988163.80572 | 2115366.95271 | 37.7877107901693 | -122.484780278081 | (37.7877107901693, -122.484780278081) | 11 | 6 | 1 | 55 | 33 | |||
| 184601 | 119241 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981435.03386 | 2111334.77238 | 37.776245435782 | -122.5077607921 | (37.776245435782, -122.5077607921) | 11 | 6 | 2 | 55 | 26 | |||
| 186887 | 119083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5981985.30992 | 2109867.54201 | 37.7722492542332 | -122.505748473333 | (37.7722492542332, -122.505748473333) | 11 | 6 | 2 | 55 | 26 | |||
| 186958 | 120000 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 818 30th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5986676.70436 | 2110336.54693 | 37.7738120096448 | -122.489555240793 | (37.7738120096448, -122.489555240793) | 11 | 6 | 2 | 55 | 26 | |||
| 188623 | 90746 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4345 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982095.14058 | 2110285.66939 | 37.7734037737787 | -122.505399563205 | (37.7734037737787, -122.505399563205) | 11 | 6 | 2 | 55 | 26 | ||
| 188853 | 90742 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4435 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981815.15401 | 2110273.6149 | 37.7733541956697 | -122.506367165545 | (37.7733541956697, -122.506367165545) | 11 | 6 | 2 | 55 | 26 | ||
| 192805 | 115237 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775536 | 5982900.6 | 2109891.1 | 37.7723677654738 | -122.502584200594 | (37.7723677654738, -122.502584200594) | 11 | 6 | 2 | 55 | 26 | |||
| 192907 | 255098 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 585 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x9 | 5987788 | 2112008 | 37.7784661663567 | -122.485833843864 | (37.7784661663567, -122.485833843864) | 11 | 6 | 2 | 55 | 26 | ||||
| 193198 | 111714 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051 | 2113265 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | 11 | 6 | 2 | 55 | 26 | |
| 194199 | 118595 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5982415.15882 | 2112561.71552 | 37.7796719571588 | -122.504461248614 | (37.7796719571588, -122.504461248614) | 11 | 6 | 2 | 55 | 26 |
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) );