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, MNG_AG_TYP = 2 and YR_EST = 2018
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6186 | 6186 | 6185 | {"type": "Polygon", "coordinates": [[[-121.85783, 37.71464], [-121.85783, 37.71473], [-121.85752, 37.71497], [-121.85728, 37.71519], [-121.85684, 37.71563], [-121.85657, 37.71602], [-121.85649, 37.71603], [-121.85605, 37.71585], [-121.85602, 37.71588], [-121.85346, 37.71482], [-121.85305, 37.71458], [-121.8528, 37.71439], [-121.85265, 37.71425], [-121.85239, 37.71397], [-121.85226, 37.71378], [-121.85214, 37.71356], [-121.85206, 37.71337], [-121.85199, 37.71316], [-121.85194, 37.71283], [-121.85194, 37.71254], [-121.85207, 37.71144], [-121.85213, 37.71121], [-121.85217, 37.71065], [-121.85226, 37.71059], [-121.8536, 37.71047], [-121.85423, 37.71036], [-121.85473, 37.71025], [-121.85511, 37.71013], [-121.85563, 37.70992], [-121.85597, 37.70976], [-121.85643, 37.7095], [-121.85715, 37.70914], [-121.85726, 37.70917], [-121.85745, 37.70949], [-121.85759, 37.70985], [-121.85766, 37.71022], [-121.85766, 37.71057], [-121.85762, 37.71079], [-121.85756, 37.71101], [-121.85703, 37.71255], [-121.85698, 37.7128], [-121.85697, 37.71317], [-121.85701, 37.71341], [-121.85708, 37.71364], [-121.85725, 37.71398], [-121.85748, 37.71429], [-121.85783, 37.71464]]]} | Open Access 1 | 48347 | Fallon Sports Park | 32911 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Fallon-Sports-Park-22 | Alameda 17 | 65.297 | Fallon Sports Park | 2018 | Local Recreation Area 3 | 4 |
7402 | 7402 | 7401 | {"type": "Polygon", "coordinates": [[[-120.86774, 37.60385], [-120.86552, 37.60384], [-120.86554, 37.60217], [-120.8656, 37.60212], [-120.8669, 37.60212], [-120.86691, 37.60254], [-120.86681, 37.60254], [-120.86682, 37.60268], [-120.867, 37.60268], [-120.86701, 37.60262], [-120.86773, 37.60261], [-120.86774, 37.60385]]]} | Open Access 1 | 48438 | Lebright Fields | 33140 | 1140 | Hughson, City of 863 | City 2 | City Agency 2 | http://hughson.org/government/city-departments/parks-and-recreations/ | City 2 | 1140 | Hughson, City of 841 | City 2 | City Agency 2 | Stanislaus 2 | 8.156 | Lebright Fields | 2018 | Local Recreation Area 3 | 4 | |
14743 | 14743 | 14742 | {"type": "Polygon", "coordinates": [[[-118.2041, 33.77812], [-118.20413, 33.77876], [-118.20407, 33.77891], [-118.20398, 33.77907], [-118.20386, 33.77925], [-118.20372, 33.7794], [-118.2035, 33.77958], [-118.20334, 33.77968], [-118.20106, 33.78128], [-118.20102, 33.78137], [-118.2007, 33.78153], [-118.20044, 33.7817], [-118.20015, 33.78197], [-118.19976, 33.78248], [-118.19955, 33.78248], [-118.19977, 33.78213], [-118.20005, 33.78181], [-118.20033, 33.78157], [-118.20115, 33.78099], [-118.20119, 33.78077], [-118.20134, 33.7806], [-118.20151, 33.78056], [-118.20132, 33.78016], [-118.20165, 33.78003], [-118.20194, 33.77984], [-118.20211, 33.77969], [-118.20269, 33.7791], [-118.20278, 33.77899], [-118.20298, 33.77911], [-118.20318, 33.77899], [-118.20318, 33.77898], [-118.20309, 33.77895], [-118.20314, 33.77882], [-118.20323, 33.77885], [-118.20344, 33.77871], [-118.20348, 33.77853], [-118.2035, 33.77836], [-118.20347, 33.77806], [-118.20393, 33.778], [-118.20395, 33.77813], [-118.2041, 33.77812]]]} | Open Access 1 | 45117 | Drake/Chavez Soccer Fields and Parkway | 27996 | 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 | Los Angeles 6 | 7.964 | Drake/Chavez Soccer Fields and Parkway | 2018 | Local Recreation Area 3 | 4 | |
16778 | 16778 | 16777 | {"type": "MultiPolygon", "coordinates": [[[[-119.09596, 36.2106], [-119.09596, 36.21227], [-119.0953, 36.21229], [-119.09519, 36.2123], [-119.0951, 36.21234], [-119.09499, 36.21245], [-119.09479, 36.21291], [-119.09497, 36.21298], [-119.09512, 36.21301], [-119.09561, 36.21301], [-119.09561, 36.2131], [-119.095, 36.21312], [-119.095, 36.21356], [-119.09546, 36.21356], [-119.09546, 36.214], [-119.09346, 36.21401], [-119.09328, 36.21399], [-119.09302, 36.21392], [-119.09275, 36.2139], [-119.09247, 36.21394], [-119.09215, 36.21404], [-119.092, 36.21406], [-119.09176, 36.21407], [-119.09169, 36.21403], [-119.09169, 36.21351], [-119.09171, 36.2135], [-119.09172, 36.21339], [-119.09177, 36.21327], [-119.09185, 36.21316], [-119.09196, 36.21307], [-119.09223, 36.21293], [-119.09241, 36.2128], [-119.09254, 36.21263], [-119.0926, 36.21251], [-119.09262, 36.21238], [-119.09258, 36.21065], [-119.09596, 36.2106]]], [[[-119.09351, 36.21418], [-119.09314, 36.21419], [-119.09313, 36.21509], [-119.0917, 36.2151], [-119.09169, 36.21427], [-119.09176, 36.21423], [-119.09211, 36.21421], [-119.09255, 36.21409], [-119.0928, 36.21407], [-119.09296, 36.21408], [-119.09328, 36.21416], [-119.09351, 36.21418]]]]} | Open Access 1 | 1159 | Lindsay Sports and Recreation Complex | 33707 | 1176 | Lindsay, City of 137 | City 2 | City Agency 2 | http://www.lindsay.ca.us/citygov/works/parks.cfm | City 2 | 1176 | Lindsay, City of 134 | City 2 | City Agency 2 | Tulare 29 | 30.078 | Lindsay Sports and Rec. Complex | 2018 | Local Recreation Area 3 | 4 | |
16813 | 16813 | 16812 | {"type": "MultiPolygon", "coordinates": [[[[-121.24935, 38.79757], [-121.24887, 38.7976], [-121.24888, 38.79736], [-121.24862, 38.79729], [-121.2486, 38.79701], [-121.24788, 38.79639], [-121.24756, 38.79629], [-121.24638, 38.79603], [-121.24591, 38.79611], [-121.24558, 38.79621], [-121.24526, 38.79664], [-121.24512, 38.79694], [-121.24485, 38.79709], [-121.24378, 38.7975], [-121.24094, 38.79876], [-121.24094, 38.79877], [-121.24112, 38.79902], [-121.24073, 38.79922], [-121.24054, 38.79896], [-121.23974, 38.79931], [-121.23958, 38.79911], [-121.23981, 38.7985], [-121.23945, 38.79817], [-121.2406, 38.79786], [-121.24375, 38.79649], [-121.2443, 38.79581], [-121.24429, 38.7958], [-121.2442, 38.7958], [-121.24484, 38.79531], [-121.24604, 38.79445], [-121.24636, 38.79473], [-121.24652, 38.79518], [-121.24729, 38.79541], [-121.2479, 38.79543], [-121.24805, 38.79534], [-121.24878, 38.79605], [-121.24909, 38.79654], [-121.24928, 38.79708], [-121.24934, 38.79735], [-121.24935, 38.79757]]], [[[-121.25255, 38.7998], [-121.25223, 38.80002], [-121.25251, 38.80029], [-121.25098, 38.80127], [-121.24815, 38.80405], [-121.24782, 38.80431], [-121.24743, 38.80455], [-121.24494, 38.8056], [-121.24452, 38.80574], [-121.24407, 38.80574], [-121.24396, 38.80605], [-121.24361, 38.80596], [-121.2433, 38.80581], [-121.24304, 38.80562], [-121.24284, 38.80538], [-121.24271, 38.80511], [-121.24237, 38.80408], [-121.24228, 38.80386], [-121.24216, 38.80366], [-121.242, 38.80347], [-121.24184, 38.80331], [-121.24168, 38.80319], [-121.24194, 38.80296], [-121.24086, 38.80233], [-121.24045, 38.80189], [-121.24021, 38.80132], [-121.24015, 38.8003], [-121.24006, 38.80006], [-121.24075, 38.79973], [-121.24057, 38.79946], [-121.24109, 38.79923], [-121.24126, 38.79947], [-121.24142, 38.79983], [-121.24149, 38.80031], [-121.24174, 38.80044], [-121.24236, 38.80036], [-121.24253, 38.80015], [-121.2423, 38.79946], [-121.2421, 38.79913], [-121.24418, 38.79821], [-121.24535, 38.79776], [-121.24594, 38.79761], [-121.24654, 38.79765], [-121.2474, 38.79783], [-121.24743, 38.79896], [-121.24579, 38.79935], [-121.24484, 38.79916], [-121.24397, 38.7995], [-121.244, 38.80063], [-121.24357, 38.80114], [-121.24342, 38.80191], [-121.24445, 38.80209], [-121.24565, 38.80187], [-121.24573, 38.80237], [-121.24541, 38.80249], [-121.24543, 38.80279], [-121.24583, 38.80285], [-121.2465, 38.80259], [-121.24734, 38.80186], [-121.24764, 38.80162], [-121.24906, 38.80072], [-121.24952, 38.80026], [-121.25005, 38.79988], [-121.2504, 38.79967], [-121.25064, 38.79948], [-121.25112, 38.799], [-121.25148, 38.79878], [-121.25255, 38.7998]]], [[[-121.26336, 38.7949], [-121.26216, 38.79573], [-121.26081, 38.79691], [-121.25822, 38.79824], [-121.25393, 38.79935], [-121.25344, 38.79967], [-121.25314, 38.79939], [-121.25282, 38.7996], [-121.25177, 38.7986], [-121.2521, 38.7984], [-121.25393, 38.79763], [-121.25471, 38.79763], [-121.25541, 38.7972], [-121.25571, 38.79678], [-121.25665, 38.79627], [-121.25694, 38.7964], [-121.25724, 38.79647], [-121.25756, 38.79649], [-121.25786, 38.79645], [-121.25816, 38.79633], [-121.25931, 38.79573], [-121.25953, 38.79557], [-121.26037, 38.79477], [-121.26072, 38.7945], [-121.26198, 38.79366], [-121.26336, 38.7949]]]]} | Open Access 1 | 49034 | Sunset Whitney Recreation Area | 33741 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | https://www.rocklin.ca.us/news/west-trails-sunset-whitney-rec-area-now-open | Placer 35 | 178.722 | Sunset Whitney Rec. Area | 2018 | 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]);