units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows where MNG_AG_ID = 308, MNG_AG_LEV = 3 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2076 | 2076 | 2075 | {"type": "MultiPolygon", "coordinates": [[[[-120.48446, 37.30559], [-120.48421, 37.306], [-120.48402, 37.30604], [-120.48391, 37.30609], [-120.48365, 37.30627], [-120.4836, 37.30627], [-120.48269, 37.30595], [-120.48317, 37.30512], [-120.48446, 37.30559]]], [[[-120.48598, 37.30615], [-120.48564, 37.30673], [-120.48546, 37.30672], [-120.48514, 37.30663], [-120.48487, 37.3065], [-120.48464, 37.30635], [-120.48448, 37.30608], [-120.4847, 37.30568], [-120.48598, 37.30615]]]]} | Open Access 1 | 17232 | Courthouse Square | 17719 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 5.112 | Courthouse Square | 0 | Local Park 2 | 4 | |
2080 | 2080 | 2079 | {"type": "Polygon", "coordinates": [[[-120.77651, 37.43633], [-120.77555, 37.43632], [-120.77574, 37.43492], [-120.77646, 37.43492], [-120.77651, 37.43633]]]} | Open Access 1 | 17257 | Shattuck Park | 25374 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 2.867 | Shattuck Park | 0 | Local Park 2 | 4 | |
2081 | 2081 | 2080 | {"type": "Polygon", "coordinates": [[[-120.61865, 37.39656], [-120.61343, 37.39659], [-120.61347, 37.39483], [-120.61787, 37.39482], [-120.61845, 37.39525], [-120.61865, 37.39656]]]} | Open Access 1 | 17262 | Winton Community Park | 27658 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 21.353 | Winton Community Park | 0 | Local Park 2 | 4 | |
2401 | 2401 | 2400 | {"type": "Polygon", "coordinates": [[[-120.85021, 37.36216], [-120.85028, 37.36322], [-120.85027, 37.36355], [-120.85022, 37.36388], [-120.84999, 37.36461], [-120.84979, 37.36492], [-120.84954, 37.36516], [-120.8486, 37.36601], [-120.84795, 37.36657], [-120.8466, 37.36468], [-120.84724, 37.36441], [-120.84898, 37.36307], [-120.85007, 37.36208], [-120.85021, 37.36216]]]} | Open Access 1 | 17235 | Hagaman Park | 19591 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 18.547 | Hagaman Park | 0 | Local Park 2 | 4 | |
2402 | 2402 | 2401 | {"type": "Polygon", "coordinates": [[[-120.42737, 37.52324], [-120.42138, 37.52317], [-120.42067, 37.52302], [-120.41617, 37.52235], [-120.41517, 37.52225], [-120.41177, 37.52149], [-120.41158, 37.52152], [-120.41169, 37.51747], [-120.41333, 37.51657], [-120.41629, 37.51759], [-120.41646, 37.5177], [-120.41822, 37.51781], [-120.41983, 37.51827], [-120.41982, 37.51942], [-120.41953, 37.51929], [-120.41951, 37.51931], [-120.41983, 37.5197], [-120.42153, 37.52044], [-120.42153, 37.52069], [-120.42039, 37.52071], [-120.4204, 37.52073], [-120.42071, 37.52083], [-120.42071, 37.52137], [-120.42316, 37.52197], [-120.42383, 37.52203], [-120.42437, 37.52204], [-120.4246, 37.52241], [-120.42584, 37.5224], [-120.42691, 37.52248], [-120.42727, 37.52272], [-120.42737, 37.52324]]]} | Open Access 1 | 17237 | Henderson Park | 19813 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 121.212 | Henderson Park | 0 | Local Park 2 | 4 | |
2407 | 2407 | 2406 | {"type": "Polygon", "coordinates": [[[-120.32258, 37.29171], [-120.3213, 37.29171], [-120.3213, 37.29016], [-120.32258, 37.29118], [-120.32258, 37.29171]]]} | Open Access 1 | 17240 | Houlihan Park | 20111 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 3.224 | Houlihan Park | 0 | Local Park 2 | 4 | |
2408 | 2408 | 2407 | {"type": "Polygon", "coordinates": [[[-121.0023, 37.25798], [-121.00198, 37.25807], [-121.00186, 37.25773], [-121.00217, 37.25766], [-121.0023, 37.25798]]]} | Open Access 1 | 17242 | Library | 21216 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 0.28 | Library | None 201 | |||
3856 | 3856 | 3855 | {"type": "Polygon", "coordinates": [[[-120.43799, 37.52002], [-120.43772, 37.5201], [-120.43759, 37.51977], [-120.43784, 37.51968], [-120.43799, 37.52002]]]} | Open Access 1 | 45506 | Snelling Courthouse Park | 28338 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 0.242 | Snelling Courthouse Park | 0 | Local Park 2 | 4 | |
3927 | 3927 | 3926 | {"type": "Polygon", "coordinates": [[[-120.60126, 37.35998], [-120.60123, 37.36033], [-120.59996, 37.36035], [-120.59996, 37.35936], [-120.60081, 37.35938], [-120.60081, 37.36], [-120.60126, 37.35998]]]} | Open Access 1 | 36303 | Merced holding 1 | 22161 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 2.379 | Merced holding 1 | 0 | Local Other or Unknown 14 | 4 | |
4825 | 4825 | 4824 | {"type": "Polygon", "coordinates": [[[-120.78357, 37.42217], [-120.78354, 37.42276], [-120.78299, 37.42273], [-120.78253, 37.42266], [-120.78176, 37.42243], [-120.78172, 37.42236], [-120.78187, 37.42206], [-120.78357, 37.42217]]]} | Open Access 1 | 48932 | Unknown park - Merced, County of | 33652 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 2.299 | 0 | Local Other or Unknown 14 | 4 | ||
9433 | 9433 | 9432 | {"type": "MultiPolygon", "coordinates": [[[[-120.43204, 37.36846], [-120.42762, 37.37141], [-120.42697, 37.37186], [-120.427, 37.37108], [-120.42698, 37.37064], [-120.42699, 37.37025], [-120.42695, 37.3699], [-120.42679, 37.36954], [-120.42777, 37.36795], [-120.42795, 37.36801], [-120.42871, 37.36789], [-120.42943, 37.36784], [-120.42982, 37.36783], [-120.43085, 37.36786], [-120.43203, 37.36805], [-120.43204, 37.36846]]], [[[-120.42642, 37.37224], [-120.42575, 37.37271], [-120.42498, 37.37322], [-120.42327, 37.37442], [-120.4218, 37.37538], [-120.42179, 37.37657], [-120.42138, 37.37656], [-120.42137, 37.37539], [-120.41926, 37.37516], [-120.42214, 37.37306], [-120.4256, 37.37055], [-120.42641, 37.36992], [-120.42646, 37.37001], [-120.42648, 37.37037], [-120.42649, 37.37077], [-120.42648, 37.37156], [-120.42643, 37.37193], [-120.42642, 37.37224]]]]} | Open Access 1 | 17265 | Yosemite Lake Regional Park | 27782 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 59.199 | Yosemite Lake RP | 0 | Local Park 2 | 4 | |
9910 | 9910 | 9909 | {"type": "Polygon", "coordinates": [[[-120.62652, 36.99189], [-120.62652, 36.99389], [-120.62266, 36.99388], [-120.62267, 36.99188], [-120.62652, 36.99189]]]} | Open Access 1 | 17249 | O'Bannion County Park | 22943 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 18.811 | O'Bannion County Park | 0 | Local Park 2 | 4 | |
9986 | 9986 | 9985 | {"type": "MultiPolygon", "coordinates": [[[[-120.47014, 37.28804], [-120.47013, 37.28838], [-120.4698, 37.28836], [-120.4698, 37.28804], [-120.47014, 37.28804]]], [[[-120.47272, 37.28809], [-120.4723, 37.28882], [-120.4702, 37.28805], [-120.47272, 37.28809], [-120.47272, 37.28809]]]]} | Open Access 1 | 17246 | Merced Cemetery | 22158 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 2.519 | Merced Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
10016 | 10016 | 10015 | {"type": "Polygon", "coordinates": [[[-120.78502, 37.43122], [-120.78427, 37.43177], [-120.78379, 37.43136], [-120.78379, 37.43129], [-120.78454, 37.43075], [-120.78464, 37.4307], [-120.78478, 37.43073], [-120.7848, 37.43091], [-120.7849, 37.43109], [-120.78502, 37.43122]]]} | Open Access 1 | 17259 | Taylor Park | 26204 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 1.655 | Taylor Park | 0 | Local Park 2 | 4 | |
12423 | 12423 | 12422 | {"type": "Polygon", "coordinates": [[[-120.64814, 36.96769], [-120.64814, 36.96965], [-120.64544, 36.96964], [-120.64543, 36.9691], [-120.64485, 36.96909], [-120.64485, 36.96767], [-120.64814, 36.96769]]]} | Open Access 1 | 27028 | South Dos Palos Park | 25648 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 15.022 | South Dos Palos Park | 0 | Local Park 2 | 4 | |
14945 | 14945 | 14944 | {"type": "Polygon", "coordinates": [[[-120.70104, 37.45213], [-120.70104, 37.45288], [-120.699, 37.45286], [-120.69901, 37.45211], [-120.70104, 37.45213]]]} | Open Access 1 | 45545 | Ballico Park | 28373 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=959 | Merced 37 | 3.672 | Ballico 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]);