superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where MNG_AGENCY = 326 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1459 | 1459 | 1458 | {"type": "Polygon", "coordinates": [[[-117.1804, 33.56326], [-117.18038, 33.5638], [-117.17812, 33.56374], [-117.17802, 33.5637], [-117.17809, 33.56351], [-117.17634, 33.56183], [-117.17657, 33.56166], [-117.17692, 33.56134], [-117.17717, 33.56151], [-117.17741, 33.56171], [-117.1775, 33.56165], [-117.17861, 33.56269], [-117.1804, 33.56326]]]} | Open Access 1 | Alta Murrieta Sports Park | 15418 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 9.773 | Alta Murrieta Sports Park | ||
1513 | 1513 | 1512 | {"type": "Polygon", "coordinates": [[[-117.18446, 33.59404], [-117.18429, 33.59427], [-117.18425, 33.59451], [-117.18409, 33.59476], [-117.18403, 33.59496], [-117.18348, 33.59576], [-117.18336, 33.59601], [-117.18322, 33.59617], [-117.18308, 33.59647], [-117.18289, 33.59647], [-117.18283, 33.59639], [-117.18287, 33.59634], [-117.18274, 33.59604], [-117.18279, 33.59601], [-117.18268, 33.59574], [-117.1828, 33.59563], [-117.18306, 33.5955], [-117.18298, 33.59534], [-117.18308, 33.5952], [-117.18326, 33.59518], [-117.18333, 33.59499], [-117.18294, 33.59451], [-117.18328, 33.5943], [-117.18405, 33.59372], [-117.18433, 33.59394], [-117.18437, 33.59393], [-117.18446, 33.59404]]]} | Open Access 1 | Antelope Hills Park | 15510 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 5.062 | Antelope Hills 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 | ||
1871 | 1871 | 1870 | {"type": "Polygon", "coordinates": [[[-117.25647, 33.57277], [-117.25579, 33.5728], [-117.25577, 33.57282], [-117.25578, 33.57286], [-117.25545, 33.573], [-117.25437, 33.57366], [-117.25416, 33.57376], [-117.25393, 33.57377], [-117.25366, 33.5736], [-117.25295, 33.5734], [-117.2518, 33.57349], [-117.25149, 33.57386], [-117.25149, 33.57399], [-117.25101, 33.57526], [-117.2506, 33.57518], [-117.25062, 33.57511], [-117.25087, 33.57509], [-117.25102, 33.57493], [-117.25115, 33.57458], [-117.25131, 33.57423], [-117.25134, 33.57353], [-117.25125, 33.57303], [-117.25137, 33.57249], [-117.25131, 33.57229], [-117.25067, 33.57168], [-117.25048, 33.57153], [-117.25004, 33.57126], [-117.25006, 33.57118], [-117.25004, 33.57093], [-117.24993, 33.57058], [-117.2497, 33.57037], [-117.24961, 33.57025], [-117.24957, 33.57002], [-117.24948, 33.56988], [-117.24934, 33.56977], [-117.24915, 33.56972], [-117.24894, 33.5697], [-117.24845, 33.57008], [-117.24845, 33.57002], [-117.24869, 33.5698], [-117.24892, 33.56965], [-117.24924, 33.5695], [-117.24949, 33.56943], [-117.24958, 33.56948], [-117.24969, 33.56978], [-117.24979, 33.56998], [-117.24991, 33.57017], [-117.25008, 33.57039], [-117.25055, 33.57085], [-117.25073, 33.57098], [-117.25096, 33.57111], [-117.25117, 33.57119], [-117.25143, 33.57127], [-117.25362, 33.57158], [-117.25369, 33.57166], [-117.25365, 33.57184], [-117.25359, 33.572], [-117.25358, 33.57206], [-117.25363, 33.57216], [-117.25374, 33.57222], [-117.25399, 33.57223], [-117.2544, 33.57229], [-117.25482, 33.57231], [-117.25637, 33.57229], [-117.25646, 33.57236], [-117.25647, 33.57277]]]} | Open Access 1 | Bear Valley Park 1 | 15933 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 23.779 | Bear Valley Park 1 | ||
1872 | 1872 | 1871 | {"type": "Polygon", "coordinates": [[[-117.2535, 33.57043], [-117.25344, 33.57074], [-117.25163, 33.57048], [-117.2517, 33.57021], [-117.25135, 33.57003], [-117.2512, 33.5699], [-117.2511, 33.56975], [-117.25101, 33.56958], [-117.25077, 33.569], [-117.25099, 33.56884], [-117.25106, 33.56883], [-117.25157, 33.56922], [-117.25171, 33.56928], [-117.25212, 33.56943], [-117.25213, 33.56947], [-117.25212, 33.56952], [-117.25202, 33.56966], [-117.252, 33.56974], [-117.25202, 33.56982], [-117.25207, 33.56987], [-117.25213, 33.56991], [-117.25224, 33.56993], [-117.25212, 33.57016], [-117.25217, 33.57024], [-117.25265, 33.57044], [-117.25298, 33.57046], [-117.2535, 33.57043]]]} | Open Access 1 | Bear Valley Park 2 | 15934 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 3.951 | Bear Valley Park 2 | ||
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 | ||
2520 | 2520 | 2519 | {"type": "Polygon", "coordinates": [[[-117.20326, 33.57243], [-117.20225, 33.57341], [-117.20195, 33.57373], [-117.20174, 33.574], [-117.20157, 33.57426], [-117.20142, 33.57453], [-117.20127, 33.57485], [-117.20118, 33.5749], [-117.20045, 33.57472], [-117.20015, 33.57462], [-117.1999, 33.57452], [-117.1994, 33.57426], [-117.19906, 33.57404], [-117.19884, 33.57386], [-117.20117, 33.57207], [-117.20032, 33.57135], [-117.19978, 33.57111], [-117.1998, 33.57108], [-117.20135, 33.57177], [-117.20137, 33.57175], [-117.20142, 33.57136], [-117.20163, 33.57136], [-117.20326, 33.57243]]]} | Open Access 1 | California Oaks Sports Park | 16720 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 18.723 | California Oaks Sports 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 | ||
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 | ||
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 | ||
2799 | 2799 | 2798 | {"type": "Polygon", "coordinates": [[[-117.19207, 33.58147], [-117.19147, 33.58193], [-117.19075, 33.58111], [-117.19093, 33.58095], [-117.18947, 33.57961], [-117.1898, 33.57937], [-117.19207, 33.58147]]]} | Open Access 1 | Century Park | 17080 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 3.91 | Century Park | ||
3134 | 3134 | 3133 | {"type": "Polygon", "coordinates": [[[-117.21238, 33.55493], [-117.21088, 33.55607], [-117.21015, 33.55539], [-117.21164, 33.55425], [-117.21238, 33.55493]]]} | Open Access 1 | Community Center/Hunt Field | 17567 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 4.725 | Community Ctr./Hunt Field | ||
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 | ||
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 | ||
3829 | 3829 | 3828 | {"type": "Polygon", "coordinates": [[[-117.21501, 33.59236], [-117.21477, 33.5923], [-117.21456, 33.59232], [-117.21445, 33.59236], [-117.21437, 33.59241], [-117.21425, 33.59255], [-117.21422, 33.59264], [-117.21421, 33.59274], [-117.21423, 33.59284], [-117.21427, 33.59293], [-117.21434, 33.59301], [-117.21476, 33.59338], [-117.2143, 33.59375], [-117.21415, 33.59432], [-117.21381, 33.59458], [-117.21363, 33.5947], [-117.21353, 33.59459], [-117.21337, 33.59411], [-117.21338, 33.59388], [-117.21304, 33.59323], [-117.21289, 33.59312], [-117.21307, 33.59294], [-117.21312, 33.59286], [-117.21314, 33.59278], [-117.21314, 33.59268], [-117.21312, 33.5926], [-117.21307, 33.59251], [-117.21301, 33.59243], [-117.21288, 33.59235], [-117.21276, 33.59231], [-117.21258, 33.5923], [-117.21242, 33.59234], [-117.21232, 33.5924], [-117.21224, 33.59247], [-117.21177, 33.59307], [-117.21164, 33.593], [-117.21226, 33.59228], [-117.21262, 33.59195], [-117.21262, 33.59194], [-117.2124, 33.59195], [-117.21225, 33.59199], [-117.21211, 33.59207], [-117.21198, 33.59219], [-117.21173, 33.59249], [-117.21168, 33.59269], [-117.21153, 33.59293], [-117.21122, 33.59263], [-117.21105, 33.59242], [-117.21096, 33.59227], [-117.21126, 33.59214], [-117.21104, 33.59175], [-117.21118, 33.59169], [-117.21166, 33.59155], [-117.21187, 33.59139], [-117.21195, 33.59115], [-117.2119, 33.59097], [-117.21176, 33.59082], [-117.21148, 33.59073], [-117.21122, 33.59077], [-117.21055, 33.59105], [-117.21086, 33.59078], [-117.21124, 33.59055], [-117.21165, 33.59027], [-117.21299, 33.58924], [-117.2137, 33.58989], [-117.21337, 33.59015], [-117.21352, 33.5903], [-117.21363, 33.59033], [-117.21358, 33.59042], [-117.21359, 33.5905], [-117.21364, 33.59058], [-117.21374, 33.59065], [-117.21352, 33.59089], [-117.21364, 33.59101], [-117.2136, 33.59106], [-117.21501, 33.59236]]]} | Open Access 1 | Echo Canyon Park | 18419 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 23.421 | Echo Canyon Park | ||
4232 | 4232 | 4231 | {"type": "Polygon", "coordinates": [[[-117.17013, 33.55521], [-117.1701, 33.55528], [-117.16948, 33.55572], [-117.1693, 33.55567], [-117.16926, 33.55564], [-117.16919, 33.55565], [-117.16918, 33.55571], [-117.16913, 33.55574], [-117.16891, 33.55575], [-117.16846, 33.55557], [-117.16835, 33.55543], [-117.16784, 33.55546], [-117.16785, 33.55528], [-117.16788, 33.55504], [-117.16798, 33.55506], [-117.16799, 33.55509], [-117.16815, 33.55511], [-117.16819, 33.55492], [-117.16804, 33.55489], [-117.16799, 33.55501], [-117.1679, 33.55499], [-117.168, 33.55465], [-117.16809, 33.5546], [-117.16844, 33.55469], [-117.17013, 33.55521]]]} | Open Access 1 | Firefighters Park | 18911 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 3.859 | Firefighters Park | ||
4582 | 4582 | 4581 | {"type": "Polygon", "coordinates": [[[-117.21827, 33.58487], [-117.21607, 33.58653], [-117.21597, 33.58652], [-117.21589, 33.58644], [-117.21614, 33.58622], [-117.21518, 33.58535], [-117.21506, 33.58522], [-117.21497, 33.58509], [-117.21487, 33.58492], [-117.2148, 33.58475], [-117.21476, 33.58459], [-117.21475, 33.58429], [-117.21477, 33.58411], [-117.21481, 33.58398], [-117.21491, 33.58374], [-117.21526, 33.58316], [-117.21534, 33.58295], [-117.21536, 33.58281], [-117.21536, 33.58266], [-117.21534, 33.5825], [-117.21531, 33.58237], [-117.21551, 33.58233], [-117.21749, 33.58417], [-117.21822, 33.58477], [-117.21827, 33.58487]]]} | Open Access 1 | Glen Arbor Park | 19315 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 18.926 | Glen Arbor 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 | ||
6614 | 6614 | 6613 | {"type": "Polygon", "coordinates": [[[-117.16406, 33.62935], [-117.16365, 33.62962], [-117.16356, 33.62982], [-117.16344, 33.63023], [-117.16307, 33.63041], [-117.16275, 33.63041], [-117.16257, 33.63044], [-117.16217, 33.63045], [-117.1621, 33.63066], [-117.16183, 33.63056], [-117.16137, 33.63046], [-117.1615, 33.6302], [-117.16162, 33.63014], [-117.16177, 33.62999], [-117.16179, 33.62979], [-117.16197, 33.62953], [-117.16221, 33.62927], [-117.16246, 33.62916], [-117.16264, 33.62915], [-117.16291, 33.629], [-117.16319, 33.6287], [-117.1634, 33.62884], [-117.16406, 33.62935]]]} | Open Access 1 | Mapleton Park | 21784 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 6.682 | Mapleton Park | ||
6884 | 6884 | 6883 | {"type": "Polygon", "coordinates": [[[-117.18475, 33.56446], [-117.18474, 33.56447], [-117.18458, 33.56438], [-117.18435, 33.56431], [-117.18259, 33.56431], [-117.1826, 33.56367], [-117.18264, 33.56346], [-117.18269, 33.56326], [-117.18276, 33.56309], [-117.18294, 33.56278], [-117.18475, 33.56446]]]} | Open Access 1 | Meadowridge Park | 22094 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 4.287 | Meadowridge 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]);