trees
31 rows where Fire Prevention Districts = 12 and qSpecies_id = 160 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
160332 | 194298 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6014390.53553 | 2117381.11551 | 37.7947337632981 | -122.394181185735 | (37.7947337632981, -122.394181185735) | 12 | 2 | 10 | 28855 | 6 | |||
37098 | 194299 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6014410.76303 | 2117359.45162 | 37.794675403602 | -122.394109677946 | (37.794675403602, -122.394109677946) | 12 | 2 | 10 | 28855 | 6 | |||
113439 | 194300 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 6014431.69544 | 2117339.12323 | 37.7946207500099 | -122.394035824707 | (37.7946207500099, -122.394035824707) | 12 | 2 | 10 | 28855 | 6 | |||
29479 | 194301 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6014450.94814 | 2117319.50323 | 37.7945679480926 | -122.393967833244 | (37.7945679480926, -122.393967833244) | 12 | 2 | 10 | 28855 | 6 | |||
159980 | 194302 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 5ft | 6014474.29881 | 2117301.48742 | 37.7945197786065 | -122.393885774627 | (37.7945197786065, -122.393885774627) | 12 | 2 | 10 | 28855 | 6 | |||
156774 | 194303 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6014498.26565 | 2117280.42263 | 37.7944632715183 | -122.393801370556 | (37.7944632715183, -122.393801370556) | 12 | 2 | 10 | 28855 | 6 | |||
54880 | 194304 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6014519.25252 | 2117262.79206 | 37.7944160283404 | -122.393727518235 | (37.7944160283404, -122.393727518235) | 12 | 2 | 10 | 28855 | 6 | |||
103535 | 194305 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 5ft | 6014543.5989 | 2117243.74376 | 37.7943650790379 | -122.393641942341 | (37.7943650790379, -122.393641942341) | 12 | 2 | 10 | 28855 | 6 | |||
27236 | 194306 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6014568.03404 | 2117229.07965 | 37.7943261725661 | -122.393556366426 | (37.7943261725661, -122.393556366426) | 12 | 2 | 10 | 28855 | 6 | |||
43024 | 194324 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 18 | Width 7ft | 6014719.87282 | 2117222.06559 | 37.7943153492131 | -122.393030491457 | (37.7943153492131, -122.393030491457) | 12 | 2 | 10 | 28855 | 6 | |||
155937 | 194323 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 15 | Width 7ft | 6014746.37404 | 2117187.87081 | 37.7942229303951 | -122.392936399892 | (37.7942229303951, -122.392936399892) | 12 | 2 | 10 | 28855 | 6 | |||
178595 | 194322 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 22 | Width 7ft | 6014773.34204 | 2117151.64182 | 37.7941249519603 | -122.392840551058 | (37.7941249519603, -122.392840551058) | 12 | 2 | 10 | 28855 | 6 | |||
77982 | 194321 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 22 | Width 7ft | 6014800.62587 | 2117118.44333 | 37.7940353120341 | -122.392743821769 | (37.7940353120341, -122.392743821769) | 12 | 2 | 10 | 28855 | 6 | |||
103858 | 194320 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 23 | Width 7ft | 6014831.89764 | 2117081.36813 | 37.7939352489635 | -122.392633022622 | (37.7939352489635, -122.392633022622) | 12 | 2 | 10 | 28855 | 6 | |||
38999 | 103927 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 13 | Median : Cutout | Tree | DPW 1 | 02/05/2001 12:00:00 AM | 4x4 | 6014859 | 2117030 | 37.793795709184 | -122.392535650186 | (37.793795709184, -122.392535650186) | 12 | 2 | 10 | 28855 | 6 | |||
120757 | 194318 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 24 | Width 7ft | 6014918.37663 | 2116934.10067 | 37.7935356891802 | -122.392323489462 | (37.7935356891802, -122.392323489462) | 12 | 2 | 9 | 28855 | 6 | |||
116516 | 27866 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014921.77607 | 2116935.19701 | 37.7935388882384 | -122.39231180375 | (37.7935388882384, -122.39231180375) | 12 | 2 | 9 | 28855 | 6 | ||
154415 | 194319 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 11 | Median : Yard | Tree | DPW 1 | 19 | Width 7ft | 6014937.91263 | 2116957.6212 | 37.7936013558627 | -122.392257538577 | (37.7936013558627, -122.392257538577) | 12 | 2 | 9 | 28855 | 6 | |||
193134 | 194316 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 26 | Width 7ft | 6014969.23068 | 2116866.26037 | 37.7933522391693 | -122.392142782374 | (37.7933522391693, -122.392142782374) | 12 | 2 | 9 | 28855 | 6 | |||
28000 | 27867 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014979.71901 | 2116870.00001 | 37.7933630896865 | -122.392106753362 | (37.7933630896865, -122.392106753362) | 12 | 2 | 9 | 28855 | 6 | ||
135984 | 194317 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 22 | Width 7ft | 6014996.79198 | 2116890.75749 | 37.7934210328094 | -122.392049131461 | (37.7934210328094, -122.392049131461) | 12 | 2 | 9 | 28855 | 6 | |||
124081 | 194314 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 20 | Width 7ft | 6015030.09218 | 2116803.1524 | 37.7931823383373 | -122.391927780566 | (37.7931823383373, -122.391927780566) | 12 | 2 | 9 | 28855 | 6 | |||
139826 | 27868 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015038.31301 | 2116806.19801 | 37.7931911572627 | -122.39189954881 | (37.7931911572627, -122.39189954881) | 12 | 2 | 9 | 28855 | 6 | ||
146729 | 194315 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 20 | Width 7ft | 6015053.74343 | 2116822.79374 | 37.7932375819021 | -122.391847319118 | (37.7932375819021, -122.391847319118) | 12 | 2 | 9 | 28855 | 6 | |||
80832 | 194312 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 25 | Width 7ft | 6015090.90053 | 2116737.38808 | 37.7930051404365 | -122.391712777831 | (37.7930051404365, -122.391712777831) | 12 | 2 | 9 | 28855 | 6 | |||
159054 | 27869 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015100.81301 | 2116738.49001 | 37.7930087163181 | -122.391678556907 | (37.7930087163181, -122.391678556907) | 12 | 2 | 9 | 28855 | 6 | ||
193297 | 194313 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 12 | Width 7ft | 6015116.8381 | 2116756.98357 | 37.793060384871 | -122.391624402345 | (37.793060384871, -122.391624402345) | 12 | 2 | 9 | 28855 | 6 | |||
101879 | 194310 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 20 | Width 7ft | 6015149.43028 | 2116672.04989 | 37.7928289857212 | -122.391505690053 | (37.7928289857212, -122.391505690053) | 12 | 2 | 9 | 28855 | 6 | |||
88902 | 27870 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015155.50001 | 2116672.08301 | 37.7928294135533 | -122.391484690649 | (37.7928294135533, -122.391484690649) | 12 | 2 | 9 | 28855 | 6 | ||
16115 | 194311 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 21 | Width 7ft | 6015171.22981 | 2116694.38601 | 37.7928915254696 | -122.391431824244 | (37.7928915254696, -122.391431824244) | 12 | 2 | 9 | 28855 | 6 | |||
51227 | 194309 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 The Embarcadero | 1 | : | Tree | Private 2 | 24 | Width 7ft | 6015233.93882 | 2116624.33128 | 37.7927026516602 | -122.39120994708 | (37.7927026516602, -122.39120994708) | 12 | 2 | 9 | 28855 | 6 |
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) );