superunits_with_maps

Table actions

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

10 rows where ACCESS_TYP = 1 and MNG_AGENCY = 133

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Buena Park, City of · 10 ✖

ACCESS_TYP 1

  • Open Access · 10 ✖
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
725 725 724 {"type": "Polygon", "coordinates": [[[-117.99435, 33.87165], [-117.99397, 33.87165], [-117.99397, 33.87136], [-117.99435, 33.87136], [-117.99435, 33.87165]]]} Open Access 1 Lindergh Mini Park   21296 1037 Buena Park, City of 133 City 2 City Agency 2 http://www.buenapark.com/ City 2 0.28 Lindergh MP  
2225 2225 2224 {"type": "Polygon", "coordinates": [[[-118.02675, 33.8558], [-118.02523, 33.85568], [-118.02423, 33.85562], [-118.02423, 33.85501], [-118.02674, 33.85498], [-118.02675, 33.8558]]]} Open Access 1 Brenner Park   16352 1037 Buena Park, City of 133 City 2 City Agency 2 http://www.buenapark.com/ City 2 4.525 Brenner Park  
4536 4536 4535 {"type": "Polygon", "coordinates": [[[-118.01117, 33.86901], [-118.00853, 33.86905], [-118.0085, 33.86928], [-118.00512, 33.86932], [-118.00511, 33.86863], [-118.0042, 33.86862], [-118.0042, 33.86848], [-118.00833, 33.86842], [-118.00833, 33.86716], [-118.01114, 33.86713], [-118.01117, 33.86901]]]} Open Access 1 George Bellis Park   19259 1037 Buena Park, City of 133 City 2 City Agency 2 http://www.buenapark.com/ City 2 20.993 George Bellis Park  
5033 5033 5032 {"type": "Polygon", "coordinates": [[[-117.98463, 33.85221], [-117.98458, 33.85237], [-117.98455, 33.85272], [-117.98456, 33.85403], [-117.98058, 33.85408], [-117.98055, 33.85224], [-117.98463, 33.85221]]]} Open Access 1 Henry Boisseranc Park   19823 1037 Buena Park, City of 133 City 2 City Agency 2 http://www.buenapark.com/ City 2 18.479 Henry Boisseranc Park  
5546 5546 5545 {"type": "Polygon", "coordinates": [[[-118.01741, 33.82081], [-118.01658, 33.82083], [-118.01419, 33.82085], [-118.01604, 33.8202], [-118.0163, 33.82027], [-118.01646, 33.82022], [-118.01741, 33.82081]]]} Open Access 1 John Beat Park   20430 1037 Buena Park, City of 133 City 2 City Agency 2 http://www.buenapark.com/ City 2 2.832 John Beat Park  
9151 9151 9150 {"type": "Polygon", "coordinates": [[[-118.01535, 33.83558], [-118.01341, 33.83559], [-118.01341, 33.83489], [-118.01515, 33.83489], [-118.01522, 33.83492], [-118.01535, 33.8349], [-118.01535, 33.83558]]]} Open Access 1 San Antonio Park   24830 1037 Buena Park, City of 133 City 2 City Agency 2 http://www.buenapark.com/ City 2 3.42 San Antonio Park  
9222 9222 9221 {"type": "Polygon", "coordinates": [[[-118.02624, 33.83684], [-118.02477, 33.83684], [-118.02475, 33.83669], [-118.02453, 33.83672], [-118.02426, 33.8368], [-118.02407, 33.83682], [-118.02406, 33.83586], [-118.02504, 33.83585], [-118.02505, 33.83553], [-118.02623, 33.83552], [-118.02624, 33.83684]]]} Open Access 1 San Marino Park   24948 1037 Buena Park, City of 133 City 2 City Agency 2 http://www.buenapark.com/ City 2 6.25 San Marino Park  
9724 9724 9723 {"type": "Polygon", "coordinates": [[[-117.99293, 33.88586], [-117.99171, 33.88558], [-117.9917, 33.88298], [-117.9919, 33.88311], [-117.99227, 33.88341], [-117.99242, 33.88359], [-117.99253, 33.88381], [-117.99258, 33.88381], [-117.99288, 33.88457], [-117.99299, 33.88491], [-117.99303, 33.88531], [-117.99298, 33.88568], [-117.99293, 33.88586]]]} Open Access 1 Smith-Murphy Park   25566 1037 Buena Park, City of 133 City 2 City Agency 2 http://www.buenapark.com/ City 2 6.739 Smith-Murphy Park  
11261 11261 11260 {"type": "Polygon", "coordinates": [[[-118.01005, 33.85021], [-118.00647, 33.85024], [-118.00656, 33.84922], [-118.00669, 33.84858], [-118.00994, 33.84854], [-118.00992, 33.84931], [-118.00997, 33.84938], [-118.01004, 33.84939], [-118.01005, 33.85021]]]} Open Access 1 William Peak Park   27555 1037 Buena Park, City of 133 City 2 City Agency 2 http://www.buenapark.com/ City 2 14.465 William Peak Park  
14254 14254 14253 {"type": "Polygon", "coordinates": [[[-118.02628, 33.81697], [-118.02508, 33.81698], [-118.02506, 33.81525], [-118.02626, 33.81523], [-118.02628, 33.81697]]]} Open Access 1 Larwin Park   21041 1037 Buena Park, City of 133 City 2 City Agency 2 http://www.buenapark.com/ City 2 5.289 Larwin 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]);