units_with_maps

Table actions

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

11 rows where COUNTY = 3, MNG_AGENCY = 133 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 11 ✖

MNG_AGENCY 1

  • Buena Park, City of · 11 ✖

DES_TP 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
334 334 333 {"type": "Polygon", "coordinates": [[[-118.01117, 33.86901], [-118.00852, 33.86905], [-118.0085, 33.86928], [-118.00512, 33.86932], [-118.00511, 33.86863], [-118.0042, 33.86862], [-118.0042, 33.86848], [-118.00834, 33.86842], [-118.00833, 33.86716], [-118.01114, 33.86713], [-118.01117, 33.86901]]]} Open Access 1 913 George Bellis Park 19259 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2   Orange 3 20.977 George Bellis Park 0 Local Park 2 4
632 632 631 {"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 2504 John Beat Park 20430 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2   Orange 3 2.833 John Beat Park 0 Local Park 2 4
851 851 850 {"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 5510 Brenner Park 16352 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2   Orange 3 4.526 Brenner Park 0 Local Park 2 4
858 858 857 {"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.84932], [-118.00997, 33.84938], [-118.01004, 33.84939], [-118.01005, 33.85021]]]} Open Access 1 5571 William Peak Park 27555 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2   Orange 3 14.468 William Peak Park 0 Local Park 2 4
1003 1003 1002 {"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 6752 Henry Boisseranc Park 19823 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2   Orange 3 18.48 Henry Boisseranc Park 0 Local Park 2 4
2351 2351 2350 {"type": "Polygon", "coordinates": [[[-118.02624, 33.83684], [-118.02477, 33.83684], [-118.02476, 33.83668], [-118.02453, 33.83671], [-118.02426, 33.8368], [-118.02407, 33.83682], [-118.02406, 33.83586], [-118.02505, 33.83585], [-118.02505, 33.83553], [-118.02623, 33.83552], [-118.02624, 33.83684]]]} Open Access 1 11165 San Marino Park 24948 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2   Orange 3 6.246 San Marino Park 0 Local Park 2 4
4995 4995 4994 {"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 3625 Larwin Park 21041 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2   Orange 3 5.29 Larwin Park 0 Local Park 2 4
5177 5177 5176 {"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 5776 San Antonio Park 24830 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2   Orange 3 3.422 San Antonio Park 0 Local Park 2 4
8325 8325 8324 {"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.99254, 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 12805 Smith-Murphy Park 25566 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2   Orange 3 6.74 Smith-Murphy Park 0 Local Park 2 4
12771 12771 12770 {"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 30326 Lindergh Mini Park 21296 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2   Orange 3 0.28 Lindergh MP 0 Local Park 2 4
15417 15417 15416 {"type": "Polygon", "coordinates": [[[-118.01776, 33.8507], [-118.01418, 33.8507], [-118.01417, 33.85018], [-118.01775, 33.85014], [-118.01776, 33.8507]]]} Restricted Access 2 46649 City of Buena Park Community Gardens 29984 1037 Buena Park, City of 136 City 2 City Agency 2 http://www.buenapark.com/ City 2 1037 Buena Park, City of 133 City 2 City Agency 2 http://www.buenapark.com/index.aspx?page=109 Orange 3 4.9 City of Buena Park Community Gardens 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]);