superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where ACCESS_TYP = 1, LAYER = 4, MNG_AGENCY = 360 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
731 | 731 | 730 | {"type": "Polygon", "coordinates": [[[-117.47515, 34.00095], [-117.47513, 34.00167], [-117.47122, 34.00165], [-117.47122, 34.00115], [-117.4713, 34.00113], [-117.4713, 34.00095], [-117.47178, 34.00095], [-117.4718, 34.00091], [-117.47183, 34.0009], [-117.47184, 34.00053], [-117.47179, 34.00051], [-117.47179, 34.00047], [-117.47226, 34.00036], [-117.4723, 34.00042], [-117.47259, 34.00035], [-117.47259, 34.00028], [-117.47323, 34.00012], [-117.47323, 34.00094], [-117.47515, 34.00095]]]} | Open Access 1 | Agate Park | 15285 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 9.361 | Agate Park | ||
1679 | 1679 | 1678 | {"type": "Polygon", "coordinates": [[[-117.39388, 34.01558], [-117.39303, 34.01723], [-117.39281, 34.01754], [-117.39105, 34.01644], [-117.39205, 34.01531], [-117.39226, 34.01542], [-117.39256, 34.01509], [-117.39254, 34.01505], [-117.39262, 34.0148], [-117.39388, 34.01558]]]} | Open Access 1 | Avalon Park | http://www.ssf.net/377/Parks-Recreation | 15722 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 10.01 | Avalon Park | |
2165 | 2165 | 2164 | {"type": "Polygon", "coordinates": [[[-117.47044, 34.01823], [-117.46999, 34.0192], [-117.46848, 34.01888], [-117.46878, 34.0179], [-117.47044, 34.01823]]]} | Open Access 1 | Boulder Hill Park | 16296 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 4.194 | Boulder Hill Park | ||
2546 | 2546 | 2545 | {"type": "Polygon", "coordinates": [[[-117.55619, 33.9885], [-117.55587, 33.98861], [-117.55562, 33.9881], [-117.55595, 33.98799], [-117.55619, 33.9885]]]} | Open Access 1 | Cambria Park | 16750 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 0.49 | Cambria Park | ||
2754 | 2754 | 2753 | {"type": "Polygon", "coordinates": [[[-117.44667, 34.00615], [-117.44289, 34.00706], [-117.44289, 34.00515], [-117.44331, 34.00483], [-117.44348, 34.00473], [-117.44506, 34.00402], [-117.44583, 34.0036], [-117.44659, 34.00317], [-117.44661, 34.00468], [-117.44667, 34.00615]]]} | Open Access 1 | Centennial Park | 17032 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 23.348 | Centennial Park | ||
3018 | 3018 | 3017 | {"type": "Polygon", "coordinates": [[[-117.4594, 33.9728], [-117.45935, 33.97284], [-117.45884, 33.97285], [-117.45848, 33.97292], [-117.45815, 33.97306], [-117.45777, 33.97331], [-117.45771, 33.97331], [-117.45756, 33.97315], [-117.45746, 33.97301], [-117.45737, 33.97282], [-117.45733, 33.97265], [-117.45732, 33.97245], [-117.45742, 33.97147], [-117.45748, 33.97143], [-117.45793, 33.97147], [-117.45815, 33.97145], [-117.45844, 33.9714], [-117.45849, 33.97143], [-117.45857, 33.97166], [-117.45867, 33.97183], [-117.4588, 33.97196], [-117.45905, 33.97217], [-117.45924, 33.97239], [-117.45934, 33.9726], [-117.4594, 33.9728]]]} | Open Access 1 | Clay Park | 17399 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 6.49 | Clay Park | ||
3545 | 3545 | 3544 | {"type": "Polygon", "coordinates": [[[-117.55346, 33.96127], [-117.55339, 33.96134], [-117.5529, 33.96113], [-117.55289, 33.96099], [-117.55294, 33.96096], [-117.55314, 33.96096], [-117.55346, 33.96127]]]} | Open Access 1 | Delaware Greenbelt | 18064 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 0.28 | Delaware Greenbelt | ||
4586 | 4586 | 4585 | {"type": "Polygon", "coordinates": [[[-117.45683, 34.01367], [-117.4567, 34.01359], [-117.45557, 34.0128], [-117.45533, 34.01269], [-117.45514, 34.01254], [-117.45458, 34.01233], [-117.45448, 34.01222], [-117.45472, 34.01209], [-117.45472, 34.01191], [-117.45682, 34.01188], [-117.45683, 34.01367]]]} | Open Access 1 | Glen Avon Heritage Park | 19316 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 5.837 | Glen Avon Heritage Park | ||
4910 | 4910 | 4909 | {"type": "Polygon", "coordinates": [[[-117.55666, 33.98578], [-117.55602, 33.98578], [-117.556, 33.98574], [-117.55595, 33.98567], [-117.55624, 33.98538], [-117.55664, 33.98538], [-117.55666, 33.98578]]]} | Open Access 1 | Harmony Park | 19683 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 0.593 | Harmony Park | ||
5256 | 5256 | 5255 | {"type": "Polygon", "coordinates": [[[-117.4779, 33.9693], [-117.47779, 33.96978], [-117.47717, 33.97108], [-117.4763, 33.97159], [-117.47615, 33.97159], [-117.47602, 33.97156], [-117.47589, 33.97151], [-117.47578, 33.97144], [-117.47449, 33.9704], [-117.4762, 33.96892], [-117.47663, 33.96912], [-117.477, 33.96923], [-117.47746, 33.9693], [-117.4779, 33.9693]]]} | Open Access 1 | Horseshoe Lake Park | 20097 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 13.504 | Horseshoe Lake Park | ||
5767 | 5767 | 5766 | {"type": "Polygon", "coordinates": [[[-117.49518, 33.99641], [-117.49517, 33.99777], [-117.49321, 33.99778], [-117.49322, 33.99691], [-117.49518, 33.99641]]]} | Open Access 1 | Knowles Park | 20707 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 5.533 | Knowles Park | ||
5995 | 5995 | 5994 | {"type": "Polygon", "coordinates": [[[-117.53199, 33.98073], [-117.53199, 33.98121], [-117.53198, 33.98135], [-117.53184, 33.98166], [-117.53179, 33.9817], [-117.53155, 33.98164], [-117.53138, 33.98163], [-117.53008, 33.98163], [-117.52977, 33.98166], [-117.52952, 33.98093], [-117.52983, 33.98083], [-117.53023, 33.98075], [-117.53199, 33.98073]]]} | Open Access 1 | Laramore Park | 21020 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 5.181 | Laramore Park | ||
6178 | 6178 | 6177 | {"type": "Polygon", "coordinates": [[[-117.54599, 33.96936], [-117.54599, 33.96937], [-117.54528, 33.96931], [-117.54507, 33.96926], [-117.54462, 33.96911], [-117.54474, 33.96885], [-117.54481, 33.96863], [-117.54481, 33.96817], [-117.54598, 33.96816], [-117.54599, 33.96936]]]} | Open Access 1 | Limonite Meadows Park | 21244 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 3.529 | Limonite Meadows Park | ||
7179 | 7179 | 7178 | {"type": "Polygon", "coordinates": [[[-117.55563, 33.96321], [-117.55525, 33.9634], [-117.55503, 33.96318], [-117.55544, 33.96296], [-117.55563, 33.96321]]]} | Open Access 1 | Moon River Tot Lot | 22450 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 0.347 | Moon River Tot Lot | ||
8529 | 8529 | 8528 | {"type": "Polygon", "coordinates": [[[-117.51253, 34.02959], [-117.5125, 34.02964], [-117.51201, 34.02981], [-117.51161, 34.03001], [-117.51127, 34.03026], [-117.51099, 34.03052], [-117.51092, 34.03052], [-117.51078, 34.03043], [-117.5107, 34.03035], [-117.51062, 34.03024], [-117.51057, 34.03013], [-117.51055, 34.03002], [-117.51055, 34.02877], [-117.51059, 34.02873], [-117.51222, 34.02874], [-117.51228, 34.02879], [-117.51229, 34.02894], [-117.51253, 34.02959]]]} | Open Access 1 | Rancho Mira Loma Park | 24155 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 6.398 | Rancho Mira Loma Park | ||
10791 | 10791 | 10790 | {"type": "Polygon", "coordinates": [[[-117.54454, 33.99253], [-117.54449, 33.99264], [-117.54314, 33.99308], [-117.54219, 33.99336], [-117.54158, 33.99356], [-117.54145, 33.99351], [-117.54133, 33.99325], [-117.54118, 33.99285], [-117.54101, 33.99223], [-117.54091, 33.99161], [-117.54088, 33.99075], [-117.54071, 33.99074], [-117.54371, 33.99035], [-117.54378, 33.99069], [-117.54394, 33.9912], [-117.544, 33.99136], [-117.54454, 33.99253]]]} | Open Access 1 | Vernola Park | 27002 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 21.07 | Vernola Park | ||
10820 | 10820 | 10819 | {"type": "Polygon", "coordinates": [[[-117.42436, 33.99419], [-117.42407, 33.99506], [-117.42342, 33.99491], [-117.42281, 33.9956], [-117.42176, 33.99536], [-117.42393, 33.99294], [-117.42433, 33.99303], [-117.42437, 33.9934], [-117.42434, 33.99363], [-117.42427, 33.99386], [-117.42426, 33.99403], [-117.42436, 33.99419]]]} | Open Access 1 | Veterans Memorial Park | 27035 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 8.126 | Veterans Memorial Park | ||
11335 | 11335 | 11334 | {"type": "Polygon", "coordinates": [[[-117.5345, 33.98645], [-117.5334, 33.98645], [-117.53326, 33.98678], [-117.53299, 33.98668], [-117.5328, 33.98657], [-117.53267, 33.9865], [-117.53237, 33.98641], [-117.53234, 33.98636], [-117.53244, 33.98618], [-117.53265, 33.98593], [-117.53291, 33.98572], [-117.53312, 33.98561], [-117.53332, 33.98554], [-117.5336, 33.98547], [-117.53388, 33.98544], [-117.53446, 33.98543], [-117.5345, 33.98547], [-117.5345, 33.98645]]]} | Open Access 1 | Wineville Park | 27645 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 4.844 | Wineville Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);