superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where MNG_AGENCY = 326 sorted by YR_EST
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
5918 | 5918 | 5917 | {"type": "Polygon", "coordinates": [[[-117.14668, 33.57411], [-117.14655, 33.57447], [-117.14648, 33.57484], [-117.14648, 33.57603], [-117.1453, 33.57604], [-117.14529, 33.57375], [-117.14558, 33.57377], [-117.14583, 33.57382], [-117.14668, 33.57411]]]} | Open Access 1 | Mira Mosa Park | 22275 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 6.763 | Mira Mosa 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 | ||
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 | ||
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 | ||
7573 | 7573 | 7572 | {"type": "Polygon", "coordinates": [[[-117.20672, 33.59726], [-117.20656, 33.59751], [-117.20573, 33.59841], [-117.20419, 33.59741], [-117.20482, 33.59637], [-117.20549, 33.59669], [-117.20516, 33.59719], [-117.20517, 33.59721], [-117.20564, 33.59742], [-117.20598, 33.59691], [-117.20672, 33.59726]]]} | Open Access 1 | Oak Mesa Park | 22991 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 5.992 | Oak Mesa 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 | ||
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 | ||
8295 | 8295 | 8294 | {"type": "Polygon", "coordinates": [[[-117.16604, 33.55441], [-117.16605, 33.55479], [-117.16604, 33.55495], [-117.16597, 33.55518], [-117.16588, 33.55536], [-117.16571, 33.55556], [-117.16533, 33.55609], [-117.16504, 33.55642], [-117.16406, 33.55733], [-117.1638, 33.55765], [-117.16349, 33.55798], [-117.16259, 33.5591], [-117.16238, 33.55941], [-117.16225, 33.55965], [-117.16212, 33.55998], [-117.16204, 33.56026], [-117.162, 33.56059], [-117.16199, 33.5609], [-117.16211, 33.56185], [-117.16201, 33.56266], [-117.16202, 33.56292], [-117.16209, 33.56322], [-117.1622, 33.56347], [-117.16235, 33.5637], [-117.16253, 33.5639], [-117.16143, 33.56391], [-117.16142, 33.56456], [-117.16169, 33.56664], [-117.16337, 33.56729], [-117.16367, 33.56785], [-117.16347, 33.56856], [-117.16282, 33.56928], [-117.16277, 33.5697], [-117.16226, 33.56931], [-117.16277, 33.56883], [-117.16301, 33.56874], [-117.16316, 33.56856], [-117.16319, 33.56833], [-117.16336, 33.5682], [-117.16321, 33.56804], [-117.16302, 33.56815], [-117.16274, 33.56795], [-117.16256, 33.56786], [-117.16223, 33.56773], [-117.16198, 33.56756], [-117.16198, 33.56753], [-117.16188, 33.56746], [-117.16186, 33.56746], [-117.16149, 33.56719], [-117.16138, 33.56709], [-117.16139, 33.56706], [-117.1613, 33.56699], [-117.16127, 33.56699], [-117.16106, 33.56677], [-117.16081, 33.56642], [-117.16025, 33.56558], [-117.16019, 33.56545], [-117.16014, 33.56532], [-117.15994, 33.5641], [-117.15997, 33.56395], [-117.16004, 33.56388], [-117.15993, 33.56355], [-117.16046, 33.56283], [-117.16052, 33.56269], [-117.16056, 33.56247], [-117.16054, 33.56228], [-117.16047, 33.5621], [-117.16036, 33.56193], [-117.16014, 33.56169], [-117.16014, 33.56164], [-117.16038, 33.56139], [-117.16049, 33.56122], [-117.16056, 33.56108], [-117.16061, 33.56091], [-117.16064, 33.56075], [-117.16063, 33.56037], [-117.16083, 33.56036], [-117.16106, 33.55994], [-117.16109, 33.55967], [-117.16106, 33.55893], [-117.16148, 33.55847], [-117.16151, 33.55834], [-117.16217, 33.55789], [-117.16209, 33.55733], [-117.16253, 33.55653], [-117.16358, 33.55595], [-117.16409, 33.55593], [-117.16523, 33.55503], [-117.16538, 33.5547], [-117.16534, 33.55452], [-117.16604, 33.55441]]]} | Open Access 1 | Pond Park | 23883 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 52.935 | Pond 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 | ||
9548 | 9548 | 9547 | {"type": "Polygon", "coordinates": [[[-117.1403, 33.57415], [-117.13924, 33.57416], [-117.13919, 33.57413], [-117.13916, 33.57248], [-117.14027, 33.57246], [-117.1403, 33.57415]]]} | Open Access 1 | Shady Maple Park | 25349 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 4.789 | Shady Maple 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 | ||
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 | ||
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 | ||
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 | ||
10425 | 10425 | 10424 | {"type": "Polygon", "coordinates": [[[-117.21183, 33.5585], [-117.2118, 33.55858], [-117.21182, 33.55867], [-117.21125, 33.5591], [-117.21106, 33.55919], [-117.21091, 33.55922], [-117.21077, 33.55923], [-117.21062, 33.5592], [-117.2105, 33.55916], [-117.21037, 33.5591], [-117.21028, 33.55903], [-117.21019, 33.55892], [-117.21014, 33.5588], [-117.21011, 33.55869], [-117.21011, 33.55857], [-117.21013, 33.55847], [-117.21023, 33.55829], [-117.21031, 33.55821], [-117.21087, 33.55779], [-117.21097, 33.55782], [-117.21106, 33.5578], [-117.21183, 33.5585]]]} | Open Access 1 | Town Square Park | 26494 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 4.206 | Town Square Park | ||
10644 | 10644 | 10643 | {"type": "Polygon", "coordinates": [[[-117.20489, 33.58643], [-117.20434, 33.58688], [-117.20406, 33.58724], [-117.20281, 33.58703], [-117.20154, 33.58694], [-117.20128, 33.58697], [-117.20118, 33.58654], [-117.20334, 33.58617], [-117.20373, 33.58607], [-117.20417, 33.58607], [-117.2046, 33.58619], [-117.20489, 33.58643]]]} | Open Access 1 | Valley Vista Park | 26812 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 6.792 | Valley Vista Park | ||
13843 | 13843 | 13842 | {"type": "Polygon", "coordinates": [[[-117.25095, 33.57544], [-117.25091, 33.57553], [-117.25006, 33.57583], [-117.24979, 33.57563], [-117.24893, 33.57585], [-117.2491, 33.57687], [-117.24818, 33.57745], [-117.24769, 33.57801], [-117.24486, 33.57631], [-117.24411, 33.57437], [-117.24437, 33.57438], [-117.24457, 33.57444], [-117.24472, 33.57458], [-117.2449, 33.57465], [-117.24508, 33.57471], [-117.24545, 33.5748], [-117.24553, 33.57447], [-117.24589, 33.57453], [-117.24573, 33.57521], [-117.24573, 33.57527], [-117.24601, 33.57533], [-117.24665, 33.57596], [-117.24663, 33.57627], [-117.24709, 33.57594], [-117.24715, 33.57544], [-117.24797, 33.5755], [-117.2479, 33.57561], [-117.24783, 33.57583], [-117.24784, 33.57603], [-117.24777, 33.57631], [-117.24778, 33.57646], [-117.24783, 33.5766], [-117.24791, 33.5767], [-117.24802, 33.57678], [-117.24816, 33.57681], [-117.24831, 33.57682], [-117.24845, 33.57678], [-117.2486, 33.57672], [-117.24868, 33.57663], [-117.24874, 33.57644], [-117.24873, 33.57638], [-117.24866, 33.57615], [-117.24866, 33.576], [-117.24867, 33.57587], [-117.24876, 33.57577], [-117.24956, 33.57531], [-117.24981, 33.57506], [-117.25006, 33.57518], [-117.25034, 33.57529], [-117.25063, 33.57538], [-117.25095, 33.57544]]]} | Open Access 1 | Copper Canyon Park | 33162 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 20.229 | Copper Canyon 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]);