superunits_with_maps

Table actions

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

12 rows where MNG_AGENCY = 456

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Madera, City of · 12 ✖

ACCESS_TYP 1

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
2573 2573 2572 {"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 Courthouse Park   17718 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 2.782 Courthouse Park  
2747 2747 2746 {"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 Centennial Park   17024 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 3.541 Centennial Park  
5768 5768 5767 {"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 Knox Park   20708 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 2.092 Knox Park  
6263 6263 6262 {"type": "Polygon", "coordinates": [[[-120.09205, 36.95148], [-120.09058, 36.95151], [-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 Lions Town and Country Regional Park   21327 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 50.321 Lions Town and Country RP  
6517 6517 6516 {"type": "MultiPolygon", "coordinates": [[[[-120.03757, 36.97222], [-120.03747, 36.97229], [-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 Madera Sunrise Rotary Sports Complex   21655 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 48.946 Madera Sunrise Rotary Sports Complex  
6606 6606 6605 {"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 Maple Court Park   21773 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 0.41 Maple Court Park  
6851 6851 6850 {"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 McNally Memorial Park   22058 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 1.93 McNally Memorial Park  
7912 7912 7911 {"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 Pan-Am Park   23382 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 4.705 Pan-Am Park  
7959 7959 7958 {"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 Parksdale Park   23446 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 3.101 Parksdale Park  
8788 8788 8787 {"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.06659, 36.96907], [-120.06685, 36.969], [-120.06701, 36.96907], [-120.06706, 36.96913]]]} Open Access 1 Riverside Park   24455 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 1.216 Riverside Park  
8804 8804 8803 {"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 Riverview Park   24465 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 1.953 Riverview Park  
9015 9015 9014 {"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 Rotary Park   24690 1192 Madera, City of 456 City 2 City Agency 2 http://www.cityofmadera.org/ City 2 9.678 Rotary Park  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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