units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

14 rows where COUNTY = 48 and DES_TP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV

MNG_AG_TYP 2

DES_TP 1

  • Local Park · 14 ✖

ACCESS_TYP 1

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
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
9823 9823 9822 {"type": "Polygon", "coordinates": [[[-120.27786, 37.11495], [-120.27785, 37.11845], [-120.2765, 37.11832], [-120.27455, 37.11672], [-120.2748, 37.115], [-120.27786, 37.11495]]]} Open Access 1 16782 Sports Leisure Park 25730 1055 Chowchilla, City of 801 City 2 City Agency 2 http://www.ci.chowchilla.ca.us/ City 2 1055 Chowchilla, City of 781 City 2 City Agency 2   Madera 48 22.831 Sports Leisure 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
11509 11509 11508 {"type": "Polygon", "coordinates": [[[-120.26521, 37.12013], [-120.26448, 37.12071], [-120.26376, 37.12012], [-120.26449, 37.11955], [-120.26521, 37.12013]]]} Open Access 1 24538 Veterans Memorial Park 27025 1055 Chowchilla, City of 801 City 2 City Agency 2 http://www.ci.chowchilla.ca.us/ City 2 1055 Chowchilla, City of 781 City 2 City Agency 2   Madera 48 2.068 Veterans Memorial Park 0 Local Park 2 4
11735 11735 11734 {"type": "Polygon", "coordinates": [[[-120.05325, 36.93233], [-120.05133, 36.93232], [-120.05132, 36.93211], [-120.05142, 36.9321], [-120.05141, 36.93204], [-120.05132, 36.93204], [-120.05131, 36.93136], [-120.05323, 36.93136], [-120.05325, 36.93233]]]} Open Access 1 24541 Parkwood Park 23464 346 Madera, County of 989 County 3 County Agency 3 http://www.madera-county.com County 3 346 Madera, County of 953 County 3 County Agency 3   Madera 48 4.523 Parkwood 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

CSV options: 

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]);