units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 294, MNG_AG_TYP = 2 and UNIT_NAME = "El Dorado Park West"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7345 | 7345 | 7344 | {"type": "MultiPolygon", "coordinates": [[[[-118.09899, 33.80339], [-118.09898, 33.80692], [-118.09893, 33.8069], [-118.0986, 33.8069], [-118.09853, 33.80691], [-118.09848, 33.80693], [-118.09845, 33.807], [-118.09844, 33.80738], [-118.09845, 33.80743], [-118.09848, 33.80749], [-118.09857, 33.80755], [-118.09893, 33.80755], [-118.09897, 33.80753], [-118.09896, 33.81027], [-118.09889, 33.81033], [-118.09798, 33.81032], [-118.09751, 33.8103], [-118.09184, 33.81029], [-118.09183, 33.81024], [-118.09172, 33.81024], [-118.0917, 33.80987], [-118.09176, 33.80986], [-118.0925, 33.81009], [-118.09343, 33.81003], [-118.09439, 33.81005], [-118.09543, 33.80984], [-118.09547, 33.8085], [-118.0948, 33.80682], [-118.09427, 33.80608], [-118.09376, 33.80564], [-118.09295, 33.8052], [-118.09249, 33.80501], [-118.0921, 33.8049], [-118.09209, 33.80476], [-118.09184, 33.80467], [-118.09162, 33.80454], [-118.0916, 33.80443], [-118.09178, 33.80441], [-118.09247, 33.80438], [-118.0928, 33.80433], [-118.09295, 33.80427], [-118.09344, 33.80418], [-118.09389, 33.80408], [-118.09567, 33.80357], [-118.09606, 33.80348], [-118.09649, 33.80341], [-118.09702, 33.80335], [-118.09755, 33.80333], [-118.09892, 33.80333], [-118.09899, 33.80339]]], [[[-118.09903, 33.79594], [-118.09899, 33.803], [-118.09892, 33.80306], [-118.09731, 33.80306], [-118.09688, 33.80308], [-118.09646, 33.80313], [-118.09607, 33.80319], [-118.09561, 33.80329], [-118.09451, 33.80361], [-118.09458, 33.80348], [-118.09473, 33.80327], [-118.09538, 33.80256], [-118.09551, 33.80237], [-118.09561, 33.80217], [-118.09568, 33.80195], [-118.0958, 33.80124], [-118.09587, 33.80097], [-118.09597, 33.80071], [-118.09637, 33.80014], [-118.09656, 33.80001], [-118.09686, 33.79988], [-118.09713, 33.7998], [-118.09743, 33.7998], [-118.0977, 33.79976], [-118.09804, 33.79961], [-118.09829, 33.79944], [-118.09852, 33.7992], [-118.09877, 33.79898], [-118.09888, 33.79874], [-118.09886, 33.7985], [-118.09879, 33.7984], [-118.09869, 33.79802], [-118.09858, 33.79781], [-118.09818, 33.79721], [-118.09762, 33.79721], [-118.09753, 33.79691], [-118.09735, 33.79656], [-118.09718, 33.79627], [-118.09701, 33.79609], [-118.09679, 33.79593], [-118.09903, 33.79594]]]]} | Open Access 1 | 6666 | El Dorado Park West | 5429 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/parks_and_open_spaces/parks/el_dorado_park_west.asp | Los Angeles 6 | 116.595 | El Dorado Park West | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);