superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where MNG_AGENCY = 326 sorted by ACRES
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7544 | 7544 | 7543 | {"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 | Oak Terrace Park | 23008 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 0.264 | Oak Terrace Park | ||
9854 | 9854 | 9853 | {"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 | Springbrook Park | 25744 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 0.301 | Springbrook Park | ||
7590 | 7590 | 7589 | {"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 | Oak Tree Park | 23012 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 0.328 | Oak Tree Park | ||
8998 | 8998 | 8997 | {"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 | Rosewood Park | 24671 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 0.413 | Rosewood Park | ||
4771 | 4771 | 4770 | {"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 | Grizzly Ridge Park | 19526 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 0.463 | Grizzly Ridge Park | ||
2644 | 2644 | 2643 | {"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 | Carson Park | 16922 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 0.697 | Carson Park | ||
7115 | 7115 | 7114 | {"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 | Montafino Park | 22380 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 0.765 | Montafino Park | ||
7137 | 7137 | 7136 | {"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 | Monte Vista Park | 22402 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1.07 | Monte Vista Park | ||
3363 | 3363 | 3362 | {"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 | Crystal Aire Park | 17842 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1.112 | Crystal Aire Park | ||
2042 | 2042 | 2041 | {"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 | Blackmore Ranch Park | 16145 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1.147 | Blackmore Ranch Park | ||
3812 | 3812 | 3811 | {"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.17372, 33.5745], [-117.17285, 33.57404], [-117.17274, 33.57404], [-117.17275, 33.57402], [-117.17286, 33.574], [-117.17444, 33.57477]]]} | Open Access 1 | Eastgate Park | 18394 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1.738 | Eastgate Park | ||
7888 | 7888 | 7887 | {"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 | Palomar Park | 23365 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1.76 | Palomar Park | ||
2541 | 2541 | 2540 | {"type": "MultiPolygon", "coordinates": [[[[-117.25209, 33.56761], [-117.25188, 33.5678], [-117.25188, 33.56775], [-117.25184, 33.56771], [-117.25161, 33.56761], [-117.25142, 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.25269, 33.56781], [-117.25288, 33.56784], [-117.25311, 33.56783], [-117.25313, 33.56791], [-117.25311, 33.56807], [-117.25315, 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 | Calle Cipres Park | 16735 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1.973 | Calle Cipres Park | ||
13876 | 13876 | 13875 | {"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 | Creekside Village Green Park | 33139 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 2.012 | Creekside Village Green Park | ||
25 | 25 | 24 | {"type": "Polygon", "coordinates": [[[-117.22514, 33.57752], [-117.22474, 33.57763], [-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.57756], [-117.22513, 33.57748], [-117.22514, 33.57752]]]} | Open Access 1 | Antigua Park | 15519 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 2.282 | Antigua Park | ||
9594 | 9594 | 9593 | {"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.1656, 33.56833], [-117.1654, 33.56817], [-117.16523, 33.56799], [-117.16515, 33.56771], [-117.16525, 33.5677], [-117.16538, 33.56755], [-117.16543, 33.56767], [-117.16557, 33.5679], [-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.56794], [-117.16694, 33.56779], [-117.16694, 33.56771], [-117.16712, 33.56775]]]} | Open Access 1 | Whitewood Park | 27471 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 2.359 | Whitewood Park | ||
10188 | 10188 | 10187 | {"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 | Sycamore Park | 26139 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 2.664 | Sycamore Park | ||
2542 | 2542 | 2541 | {"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 | Calle Estancia Park | 16736 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 2.844 | Calle Estancia Park | ||
10195 | 10195 | 10194 | {"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 | Sykes Ranch Park | 26147 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 3.07 | Sykes Ranch Park | ||
14101 | 14101 | 14100 | {"type": "Polygon", "coordinates": [[[-117.13775, 33.58611], [-117.13774, 33.5873], [-117.13671, 33.5873], [-117.13671, 33.58613], [-117.13721, 33.58613], [-117.13726, 33.58609], [-117.13739, 33.58614], [-117.13775, 33.58611]]]} | Open Access 1 | Northstar Park | 33151 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 3.082 | Northstar 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]);