units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where LAYER = 2 and MNG_AGENCY = 456
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- City Agency 12
MNG_AGENCY 1
- Madera, City of · 12 ✖
ACCESS_TYP 1
- Open Access 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1967 | 1967 | 1966 | {"type": "Polygon", "coordinates": [[[-120.06135, 36.96054], [-120.06054, 36.9611], [-120.0597, 36.96026], [-120.06051, 36.95971], [-120.06135, 36.96054]]]} | Open Access 1 | 16733 | Courthouse Park | 17718 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 2.782 | Courthouse Park | 0 | Local Park 2 | 4 | |
2255 | 2255 | 2254 | {"type": "Polygon", "coordinates": [[[-120.07438, 36.9734], [-120.07385, 36.97387], [-120.07132, 36.97176], [-120.07077, 36.97126], [-120.07196, 36.97043], [-120.07235, 36.97104], [-120.07275, 36.97158], [-120.07411, 36.97315], [-120.07438, 36.9734]]]} | Open Access 1 | 16807 | Rotary Park | 24690 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 9.679 | Rotary Park | 0 | Local Park 2 | 4 | |
2258 | 2258 | 2257 | {"type": "MultiPolygon", "coordinates": [[[[-120.03757, 36.97222], [-120.03747, 36.97228], [-120.03752, 36.97427], [-120.03278, 36.97428], [-120.03277, 36.9707], [-120.03753, 36.9707], [-120.03757, 36.97222]]], [[[-120.03977, 36.97349], [-120.03845, 36.97429], [-120.03773, 36.97429], [-120.03768, 36.97236], [-120.03835, 36.97198], [-120.03977, 36.97349]]]]} | Open Access 1 | 16743 | Madera Sunrise Rotary Sports Complex | 21655 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 48.947 | Madera Sunrise Rotary Sports Complex | 0 | Local Recreation Area 3 | 4 | |
5263 | 5263 | 5262 | {"type": "Polygon", "coordinates": [[[-120.05541, 36.9684], [-120.05477, 36.96843], [-120.05413, 36.96854], [-120.05328, 36.96772], [-120.05413, 36.96716], [-120.05541, 36.9684]]]} | Open Access 1 | 24540 | Centennial Park | 17024 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 3.541 | Centennial Park | 0 | Local Park 2 | 4 | |
9827 | 9827 | 9826 | {"type": "Polygon", "coordinates": [[[-120.09205, 36.95148], [-120.09057, 36.9515], [-120.09058, 36.95264], [-120.08485, 36.95272], [-120.08359, 36.95266], [-120.08358, 36.95143], [-120.08346, 36.95079], [-120.08345, 36.95009], [-120.09205, 36.95002], [-120.09205, 36.95148]]]} | Open Access 1 | 16788 | Lions Town and Country Regional Park | 21327 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 50.314 | Lions Town and Country RP | 0 | Local Park 2 | 4 | |
9828 | 9828 | 9827 | {"type": "Polygon", "coordinates": [[[-120.04779, 36.95758], [-120.04695, 36.95815], [-120.04679, 36.95799], [-120.04678, 36.95683], [-120.04692, 36.95674], [-120.04779, 36.95758]]]} | Open Access 1 | 16791 | McNally Memorial Park | 22058 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 1.931 | McNally Memorial Park | 0 | Local Park 2 | 4 | |
9832 | 9832 | 9831 | {"type": "Polygon", "coordinates": [[[-120.05954, 36.97731], [-120.05954, 36.97786], [-120.05631, 36.97786], [-120.05631, 36.97731], [-120.05632, 36.97728], [-120.05636, 36.97726], [-120.05948, 36.97727], [-120.05951, 36.97728], [-120.05954, 36.97731]]]} | Open Access 1 | 16794 | Pan-Am Park | 23382 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 4.706 | Pan-Am Park | 0 | Local Park 2 | 4 | |
10504 | 10504 | 10503 | {"type": "Polygon", "coordinates": [[[-120.04201, 36.95708], [-120.041, 36.95707], [-120.041, 36.95622], [-120.04201, 36.95625], [-120.04201, 36.95708]]]} | Open Access 1 | 24871 | Knox Park | 20708 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 2.093 | Knox Park | 0 | Local Park 2 | 4 | |
12300 | 12300 | 12299 | {"type": "Polygon", "coordinates": [[[-120.01821, 36.94471], [-120.01718, 36.9447], [-120.01718, 36.94347], [-120.01821, 36.94347], [-120.01821, 36.94471]]]} | Open Access 1 | 25956 | Parksdale Park | 23446 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 3.102 | Parksdale Park | 0 | Local Park 2 | 4 | |
12301 | 12301 | 12300 | {"type": "Polygon", "coordinates": [[[-120.06681, 36.9502], [-120.06625, 36.9502], [-120.06624, 36.9499], [-120.06681, 36.9499], [-120.06681, 36.9502]]]} | Open Access 1 | 25957 | Maple Court Park | 21773 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 0.411 | Maple Court Park | 0 | Local Park 2 | 4 | |
12302 | 12302 | 12301 | {"type": "Polygon", "coordinates": [[[-120.07527, 36.96901], [-120.07524, 36.96923], [-120.07421, 36.96928], [-120.07179, 36.96919], [-120.07167, 36.96895], [-120.07511, 36.96907], [-120.07527, 36.96901]]]} | Open Access 1 | 25958 | Riverview Park | 24465 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 1.953 | Riverview Park | 0 | Local Park 2 | 4 | |
12303 | 12303 | 12302 | {"type": "Polygon", "coordinates": [[[-120.06706, 36.96913], [-120.06617, 36.96914], [-120.06554, 36.96905], [-120.0649, 36.9689], [-120.06379, 36.96856], [-120.06329, 36.96848], [-120.06328, 36.96845], [-120.06372, 36.9684], [-120.06391, 36.96842], [-120.06572, 36.96897], [-120.0666, 36.96907], [-120.06685, 36.969], [-120.06701, 36.96907], [-120.06706, 36.96913]]]} | Open Access 1 | 25959 | Riverside Park | 24455 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 1.216 | Riverside 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]);