units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where MNG_AGENCY = 326 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16914 | 16914 | 16913 | {"type": "Polygon", "coordinates": [[[-117.22054, 33.57636], [-117.22038, 33.57652], [-117.2202, 33.57676], [-117.21927, 33.57767], [-117.21907, 33.57793], [-117.21895, 33.57815], [-117.21873, 33.5787], [-117.21862, 33.57891], [-117.21892, 33.57907], [-117.21878, 33.57924], [-117.21862, 33.5794], [-117.21847, 33.57951], [-117.21831, 33.5796], [-117.21797, 33.57919], [-117.21772, 33.57901], [-117.21742, 33.57893], [-117.21756, 33.57831], [-117.21773, 33.57794], [-117.21814, 33.57745], [-117.21919, 33.57682], [-117.21996, 33.5759], [-117.22054, 33.57636]]]} | Open Access 1 | 19954 | Mountain Pride Park | 22545 | 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 | 9.651 | Mtn. Pride Park | 0 | Local Park 2 | 4 | |
16328 | 16328 | 16327 | {"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 | 24646 | Community Center/Hunt Field | 17567 | 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 | 4.726 | Community Ctr./Hunt Field | 0 | Local Recreation Area 3 | 4 | |
15016 | 15016 | 15015 | {"type": "Polygon", "coordinates": [[[-117.16241, 33.61242], [-117.1624, 33.61284], [-117.16228, 33.61379], [-117.16221, 33.61385], [-117.16188, 33.6139], [-117.1617, 33.61363], [-117.16145, 33.61359], [-117.1611, 33.61345], [-117.16091, 33.61348], [-117.16081, 33.61344], [-117.16072, 33.61329], [-117.16046, 33.61319], [-117.16035, 33.61333], [-117.1599, 33.61332], [-117.15984, 33.61328], [-117.15979, 33.61327], [-117.15972, 33.61328], [-117.15966, 33.61332], [-117.15918, 33.61331], [-117.15918, 33.61311], [-117.15856, 33.61278], [-117.15849, 33.61233], [-117.16234, 33.61236], [-117.16241, 33.61242]]]} | Open Access 1 | 48460 | Alderwood Park (West) | 33166 | 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 | 10.096 | Alderwood Park (West) | 2017 | None 1296 | ||
14230 | 14230 | 14229 | {"type": "Polygon", "coordinates": [[[-117.21517, 33.55612], [-117.21408, 33.55696], [-117.21341, 33.55748], [-117.21339, 33.55643], [-117.21366, 33.55642], [-117.21366, 33.55608], [-117.2134, 33.55607], [-117.2134, 33.55585], [-117.2142, 33.55523], [-117.21517, 33.55612]]]} | Restricted Access 2 | 44109 | Murrieta Elementary School Park | 31631 | 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 | 5.132 | Murrieta Elementary School 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
14100 | 14100 | 14099 | {"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.5972], [-117.20517, 33.59721], [-117.20564, 33.59743], [-117.20598, 33.59691], [-117.20672, 33.59726]]]} | Open Access 1 | 39181 | Oak Mesa Park | 22991 | 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 | 5.989 | Oak Mesa 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 | |
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 | |
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 | |
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 | |
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 | |
14094 | 14094 | 14093 | {"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.59577], [-117.18336, 33.59602], [-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.59602], [-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.59395], [-117.18437, 33.59393], [-117.18446, 33.59404]]]} | Open Access 1 | 39169 | Antelope Hills Park | 15510 | 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 | 5.057 | Antelope Hills Park | 0 | Local Park 2 | 4 | |
14093 | 14093 | 14092 | {"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.16216, 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 | 39166 | Mapleton Park | 21784 | 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 | 6.68 | Mapleton 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 | |
14091 | 14091 | 14090 | {"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.21013, 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 | 39164 | Town Square Park | 26494 | 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 | 4.206 | Town Square 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]);