units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AGENCY = 326
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7468 | 7468 | 7467 | {"type": "Polygon", "coordinates": [[[-117.17186, 33.58817], [-117.17183, 33.58826], [-117.17163, 33.58838], [-117.17032, 33.58931], [-117.17034, 33.58934], [-117.17035, 33.58943], [-117.17025, 33.58954], [-117.16981, 33.58985], [-117.16963, 33.59001], [-117.16933, 33.59032], [-117.16911, 33.59059], [-117.16721, 33.59059], [-117.1671, 33.58461], [-117.16875, 33.58397], [-117.16822, 33.58131], [-117.16898, 33.58084], [-117.16936, 33.58054], [-117.16969, 33.58023], [-117.1703, 33.57954], [-117.17055, 33.5793], [-117.17085, 33.57906], [-117.17128, 33.57943], [-117.17143, 33.5796], [-117.17156, 33.57979], [-117.17156, 33.58], [-117.17162, 33.5802], [-117.17165, 33.58037], [-117.17165, 33.58302], [-117.17156, 33.58303], [-117.17156, 33.58371], [-117.17161, 33.58392], [-117.17169, 33.58411], [-117.17178, 33.58427], [-117.17198, 33.58456], [-117.17208, 33.58477], [-117.17215, 33.58502], [-117.17218, 33.58522], [-117.17216, 33.58551], [-117.17209, 33.58576], [-117.17199, 33.58597], [-117.17178, 33.58631], [-117.17168, 33.58652], [-117.17162, 33.58668], [-117.17157, 33.58698], [-117.17157, 33.58729], [-117.17162, 33.58762], [-117.17172, 33.5879], [-117.17186, 33.58817]]]} | Open Access 1 | 48447 | Los Alamos Hills Sports Park | 33152 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 100.636 | Los Alamos Hills Sports Park | 0 | Local Recreation Area 3 | 4 | |
7597 | 7597 | 7596 | {"type": "MultiPolygon", "coordinates": [[[[-117.22221, 33.54749], [-117.22073, 33.54861], [-117.21897, 33.54699], [-117.21941, 33.54668], [-117.21955, 33.54662], [-117.21987, 33.54665], [-117.2202, 33.54656], [-117.22029, 33.54648], [-117.22065, 33.54637], [-117.22161, 33.54644], [-117.22161, 33.54667], [-117.2217, 33.54685], [-117.22176, 33.54708], [-117.22221, 33.54749]]], [[[-117.22279, 33.54811], [-117.22136, 33.5492], [-117.22085, 33.54874], [-117.22226, 33.54767], [-117.2223, 33.54766], [-117.22279, 33.54811]]], [[[-117.22382, 33.54626], [-117.22228, 33.54743], [-117.22191, 33.54709], [-117.22182, 33.54694], [-117.2218, 33.54683], [-117.22184, 33.54663], [-117.22178, 33.54645], [-117.22192, 33.54646], [-117.2223, 33.54634], [-117.22307, 33.54616], [-117.22355, 33.54601], [-117.22382, 33.54626]]], [[[-117.22344, 33.54591], [-117.22303, 33.54604], [-117.22264, 33.54612], [-117.22238, 33.54527], [-117.22242, 33.54525], [-117.2226, 33.54513], [-117.22344, 33.54591]]], [[[-117.22405, 33.54715], [-117.22295, 33.54799], [-117.22246, 33.54754], [-117.22248, 33.5475], [-117.22355, 33.54669], [-117.22405, 33.54715]]]]} | Open Access 1 | 48452 | Murrieta Equestrian Park | 33165 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 20.623 | Murrieta Equestrian Park | 0 | Local Recreation Area 3 | 4 | |
10729 | 10729 | 10728 | {"type": "Polygon", "coordinates": [[[-117.1804, 33.56326], [-117.18038, 33.5638], [-117.17812, 33.56374], [-117.17802, 33.5637], [-117.17809, 33.56352], [-117.17634, 33.56183], [-117.17657, 33.56166], [-117.17692, 33.56134], [-117.17717, 33.56151], [-117.17741, 33.56171], [-117.1775, 33.56165], [-117.17861, 33.56269], [-117.1804, 33.56326]]]} | Open Access 1 | 19946 | Alta Murrieta Sports Park | 15418 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 9.771 | Alta Murrieta Sports Park | 0 | Local Recreation Area 3 | 4 | |
10739 | 10739 | 10738 | {"type": "Polygon", "coordinates": [[[-117.20326, 33.57243], [-117.20225, 33.57341], [-117.20195, 33.57373], [-117.20174, 33.574], [-117.20157, 33.57426], [-117.20142, 33.57453], [-117.20127, 33.57485], [-117.20118, 33.5749], [-117.20045, 33.57472], [-117.20015, 33.57462], [-117.1999, 33.57452], [-117.1994, 33.57426], [-117.19906, 33.57404], [-117.19884, 33.57386], [-117.20118, 33.57207], [-117.20032, 33.57135], [-117.19978, 33.57111], [-117.1998, 33.57108], [-117.20135, 33.57177], [-117.20137, 33.57176], [-117.20142, 33.57136], [-117.20163, 33.57136], [-117.20326, 33.57243]]]} | Open Access 1 | 19960 | California Oaks Sports Park | 16720 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 18.707 | California Oaks Sports Park | 0 | Local Recreation Area 3 | 4 | |
16328 | 16328 | 16327 | {"type": "Polygon", "coordinates": [[[-117.21238, 33.55493], [-117.21088, 33.55607], [-117.21015, 33.55539], [-117.21164, 33.55425], [-117.21238, 33.55493]]]} | Open Access 1 | 24646 | Community Center/Hunt Field | 17567 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 4.726 | Community Ctr./Hunt Field | 0 | Local Recreation Area 3 | 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]);