superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where MNG_AGENCY = 360 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 9 ✖
MNG_AGENCY 1
- Jurupa Area Recreation and Park District · 9 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]);