units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where MNG_AGENCY = 326 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
DES_TP 6
- Local Park 41
- Local Recreation Area 5
- Local Conservation Area 2
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 51 ✖
MNG_AGENCY 1
- Murrieta, City of · 51 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14101 | 14101 | 14100 | {"type": "Polygon", "coordinates": [[[-117.18463, 33.58711], [-117.18445, 33.58732], [-117.18413, 33.58714], [-117.18429, 33.58691], [-117.18463, 33.58711]]]} | Open Access 1 | 39182 | Oak Terrace Park | 23008 | 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 | 0.264 | Oak Terrace Park | 0 | Local Park 2 | 4 | |
14104 | 14104 | 14103 | {"type": "Polygon", "coordinates": [[[-117.16326, 33.62641], [-117.16277, 33.62657], [-117.16277, 33.62623], [-117.16317, 33.62622], [-117.16318, 33.62633], [-117.16326, 33.62641]]]} | Open Access 1 | 39185 | Springbrook Park | 25744 | 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 | 0.301 | Springbrook Park | 0 | Local Park 2 | 4 | |
3057 | 3057 | 3056 | {"type": "Polygon", "coordinates": [[[-117.24916, 33.57327], [-117.24874, 33.57336], [-117.24866, 33.57308], [-117.24907, 33.57298], [-117.24916, 33.57327]]]} | Open Access 1 | 24649 | Oak Tree Park | 23012 | 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 | 0.328 | Oak Tree Park | 0 | Local Park 2 | 4 | |
14103 | 14103 | 14102 | {"type": "Polygon", "coordinates": [[[-117.24407, 33.57359], [-117.24386, 33.5737], [-117.24355, 33.57288], [-117.24372, 33.57286], [-117.24377, 33.5729], [-117.2438, 33.57304], [-117.24388, 33.57326], [-117.24399, 33.57347], [-117.24407, 33.57359]]]} | Open Access 1 | 39184 | Rosewood Park | 24671 | 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 | 0.414 | Rosewood Park | 0 | Local Park 2 | 4 | |
14099 | 14099 | 14098 | {"type": "Polygon", "coordinates": [[[-117.2356, 33.58014], [-117.23556, 33.58019], [-117.23548, 33.58019], [-117.23534, 33.58019], [-117.2353, 33.58014], [-117.2352, 33.57957], [-117.23557, 33.57969], [-117.2356, 33.58014]]]} | Open Access 1 | 39177 | Grizzly Ridge Park | 19526 | 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 | 0.463 | Grizzly Ridge Park | 0 | Local Park 2 | 4 | |
14097 | 14097 | 14096 | {"type": "Polygon", "coordinates": [[[-117.14419, 33.57242], [-117.14358, 33.57242], [-117.14362, 33.57225], [-117.14376, 33.57201], [-117.14381, 33.57188], [-117.14419, 33.57187], [-117.14419, 33.57242]]]} | Open Access 1 | 39172 | Carson Park | 16922 | 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 | 0.697 | Carson Park | 0 | Local Park 2 | 4 | |
10734 | 10734 | 10733 | {"type": "Polygon", "coordinates": [[[-117.22023, 33.56942], [-117.21987, 33.56969], [-117.21948, 33.56933], [-117.21996, 33.56895], [-117.2202, 33.56917], [-117.22017, 33.56923], [-117.22017, 33.56931], [-117.22018, 33.56936], [-117.22023, 33.56942]]]} | Open Access 1 | 19953 | Montafino Park | 22380 | 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 | 0.765 | Montafino Park | 0 | Local Park 2 | 4 | |
14106 | 14106 | 14105 | {"type": "Polygon", "coordinates": [[[-117.14445, 33.5767], [-117.14419, 33.57685], [-117.14401, 33.57669], [-117.1438, 33.57655], [-117.14382, 33.57651], [-117.14382, 33.57606], [-117.14444, 33.57605], [-117.14445, 33.5767]]]} | Open Access 1 | 39187 | Monte Vista Park | 22402 | 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 | 1.07 | Monte Vista Park | 0 | Local Park 2 | 4 | |
10736 | 10736 | 10735 | {"type": "Polygon", "coordinates": [[[-117.21754, 33.58942], [-117.21704, 33.5898], [-117.2169, 33.58988], [-117.21649, 33.58952], [-117.21708, 33.58907], [-117.21716, 33.58907], [-117.21754, 33.58942]]]} | Open Access 1 | 19956 | Crystal Aire Park | 17842 | 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 | 1.112 | Crystal Aire Park | 0 | Local Park 2 | 4 | |
14092 | 14092 | 14091 | {"type": "Polygon", "coordinates": [[[-117.20329, 33.59684], [-117.20273, 33.59736], [-117.20247, 33.5977], [-117.202, 33.59748], [-117.20304, 33.59668], [-117.20329, 33.59684]]]} | Open Access 1 | 39165 | Blackmore Ranch Park | 16145 | 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 | 1.147 | Blackmore Ranch Park | 0 | Local Park 2 | 4 | |
14098 | 14098 | 14097 | {"type": "Polygon", "coordinates": [[[-117.17444, 33.57477], [-117.17414, 33.57486], [-117.17389, 33.57499], [-117.1736, 33.57558], [-117.17327, 33.57575], [-117.17301, 33.5756], [-117.17314, 33.57544], [-117.17334, 33.57514], [-117.17356, 33.57486], [-117.17373, 33.5745], [-117.17284, 33.57404], [-117.17276, 33.57405], [-117.17274, 33.57404], [-117.17275, 33.57402], [-117.17286, 33.574], [-117.17444, 33.57477]]]} | Open Access 1 | 39175 | Eastgate Park | 18394 | 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 | 1.734 | Eastgate Park | 0 | Local Park 2 | 4 | |
14102 | 14102 | 14101 | {"type": "Polygon", "coordinates": [[[-117.13919, 33.58038], [-117.13886, 33.58069], [-117.13861, 33.58095], [-117.13815, 33.5814], [-117.13771, 33.58192], [-117.13754, 33.58192], [-117.13752, 33.5819], [-117.1381, 33.58121], [-117.13824, 33.58101], [-117.13836, 33.58076], [-117.1385, 33.58029], [-117.13859, 33.58011], [-117.13869, 33.57996], [-117.13909, 33.58022], [-117.13911, 33.58031], [-117.13919, 33.58038]]]} | Open Access 1 | 39183 | Palomar Park | 23365 | 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 | 1.76 | Palomar Park | 0 | Local Park 2 | 4 | |
14095 | 14095 | 14094 | {"type": "MultiPolygon", "coordinates": [[[[-117.25209, 33.56761], [-117.25188, 33.5678], [-117.25188, 33.56775], [-117.25184, 33.56771], [-117.25161, 33.56761], [-117.25141, 33.56758], [-117.25135, 33.56755], [-117.25147, 33.56732], [-117.25153, 33.5673], [-117.25172, 33.56736], [-117.25183, 33.56741], [-117.25208, 33.56755], [-117.25209, 33.56761]]], [[[-117.25372, 33.56809], [-117.25343, 33.56852], [-117.252, 33.56793], [-117.25225, 33.56767], [-117.25231, 33.56766], [-117.2525, 33.56775], [-117.25268, 33.56781], [-117.25288, 33.56784], [-117.25311, 33.56783], [-117.25313, 33.56791], [-117.25311, 33.56807], [-117.25314, 33.56811], [-117.25322, 33.56812], [-117.25342, 33.56812], [-117.25347, 33.56805], [-117.25347, 33.56802], [-117.25363, 33.56804], [-117.25372, 33.56809]]]]} | Open Access 1 | 39170 | Calle Cipres Park | 16735 | 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 | 1.973 | Calle Cipres Park | 0 | Local Park 2 | 4 | |
14087 | 14087 | 14086 | {"type": "Polygon", "coordinates": [[[-117.1709, 33.55086], [-117.17086, 33.55094], [-117.17084, 33.55101], [-117.17078, 33.55104], [-117.17074, 33.55109], [-117.17073, 33.55115], [-117.17074, 33.5512], [-117.16988, 33.5518], [-117.16938, 33.55133], [-117.16996, 33.55106], [-117.17052, 33.55061], [-117.17066, 33.55075], [-117.1709, 33.55086]]]} | Open Access 1 | 39163 | Creekside Village Green Park | 33139 | 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 | 2.012 | Creekside Village Green Park | 0 | Local Park 2 | 4 | |
10733 | 10733 | 10732 | {"type": "Polygon", "coordinates": [[[-117.22514, 33.57752], [-117.22473, 33.57762], [-117.22503, 33.57866], [-117.22368, 33.57761], [-117.22385, 33.57746], [-117.22408, 33.5773], [-117.22431, 33.57718], [-117.22457, 33.57707], [-117.22472, 33.57757], [-117.22513, 33.57748], [-117.22514, 33.57752]]]} | Open Access 1 | 19952 | Antigua Park | 15519 | 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 | 2.274 | Antigua Park | 0 | Local Park 2 | 4 | |
11348 | 11348 | 11347 | {"type": "Polygon", "coordinates": [[[-117.16712, 33.56775], [-117.16704, 33.56803], [-117.16702, 33.56819], [-117.16702, 33.5685], [-117.16629, 33.56851], [-117.16591, 33.56846], [-117.16561, 33.56833], [-117.1654, 33.56817], [-117.16523, 33.56799], [-117.16515, 33.56771], [-117.16525, 33.56771], [-117.16538, 33.56755], [-117.16542, 33.56767], [-117.16557, 33.56791], [-117.16588, 33.56801], [-117.16615, 33.56807], [-117.1663, 33.56806], [-117.16651, 33.56799], [-117.1666, 33.5679], [-117.1666, 33.56782], [-117.16673, 33.56788], [-117.16684, 33.56797], [-117.16689, 33.56795], [-117.16694, 33.56779], [-117.16694, 33.56771], [-117.16712, 33.56775]]]} | Open Access 1 | 22130 | Whitewood Park | 27471 | 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 | 2.357 | Whitewood Park | 0 | Local Park 2 | 4 | |
5360 | 5360 | 5359 | {"type": "Polygon", "coordinates": [[[-117.232, 33.58521], [-117.23159, 33.58549], [-117.23057, 33.58454], [-117.23045, 33.58446], [-117.23025, 33.58435], [-117.23005, 33.58418], [-117.2305, 33.58383], [-117.23135, 33.58462], [-117.23141, 33.58463], [-117.23189, 33.585], [-117.232, 33.58521]]]} | Open Access 1 | 24651 | Sycamore Park | 26139 | 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 | 2.664 | Sycamore Park | 0 | Local Park 2 | 4 | |
14096 | 14096 | 14095 | {"type": "Polygon", "coordinates": [[[-117.22667, 33.55422], [-117.2261, 33.55465], [-117.22554, 33.55414], [-117.22526, 33.55393], [-117.22493, 33.55377], [-117.2244, 33.55358], [-117.22422, 33.55349], [-117.22404, 33.55336], [-117.22286, 33.55229], [-117.22287, 33.5522], [-117.22289, 33.55218], [-117.22442, 33.55328], [-117.22485, 33.55354], [-117.22524, 33.55373], [-117.22565, 33.55389], [-117.22607, 33.55402], [-117.22656, 33.55413], [-117.22667, 33.55422]]]} | Open Access 1 | 39171 | Calle Estancia Park | 16736 | 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 | 2.844 | Calle Estancia Park | 0 | Local Park 2 | 4 | |
14105 | 14105 | 14104 | {"type": "Polygon", "coordinates": [[[-117.23553, 33.55982], [-117.23482, 33.56036], [-117.23459, 33.56016], [-117.23427, 33.56041], [-117.23417, 33.56045], [-117.23405, 33.56057], [-117.2339, 33.56069], [-117.23383, 33.56068], [-117.23337, 33.56026], [-117.23371, 33.56], [-117.23387, 33.55992], [-117.23468, 33.5597], [-117.23481, 33.55941], [-117.23493, 33.55928], [-117.23553, 33.55982]]]} | Open Access 1 | 39186 | Sykes Ranch Park | 26147 | 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 | 3.067 | Sykes Ranch Park | 0 | Local Park 2 | 4 | |
7458 | 7458 | 7457 | {"type": "Polygon", "coordinates": [[[-117.13775, 33.58611], [-117.13774, 33.5873], [-117.13671, 33.5873], [-117.13671, 33.58613], [-117.13722, 33.58613], [-117.13726, 33.58609], [-117.13739, 33.58614], [-117.13775, 33.58611]]]} | Open Access 1 | 48446 | Northstar Park | 33151 | 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 | 3.082 | Northstar Park | 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]);