superunits_with_maps

Table actions

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

21 rows where ACCESS_TYP = 1, MNG_AGENCY = 221 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP

MNG_AGENCY 1

  • Cerritos, City of · 21 ✖

ACCESS_TYP 1

  • Open Access · 21 ✖
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
2279 2279 2278 {"type": "Polygon", "coordinates": [[[-118.05293, 33.86585], [-118.05292, 33.86593], [-118.052, 33.86618], [-118.05162, 33.86627], [-118.05118, 33.86635], [-118.0507, 33.8664], [-118.05044, 33.86625], [-118.05003, 33.86596], [-118.05033, 33.86601], [-118.05204, 33.86599], [-118.05226, 33.86597], [-118.05245, 33.86589], [-118.05277, 33.86572], [-118.05284, 33.86574], [-118.05291, 33.86578], [-118.05293, 33.86585]]]} Open Access 1 Brookhaven Park   16422 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1.761 Brookhaven Park  
2802 2802 2801 {"type": "Polygon", "coordinates": [[[-118.05197, 33.87864], [-118.0517, 33.87858], [-118.05103, 33.87857], [-118.05089, 33.87868], [-118.05091, 33.88043], [-118.04871, 33.88045], [-118.04867, 33.87687], [-118.05195, 33.87685], [-118.05196, 33.87799], [-118.05185, 33.878], [-118.05185, 33.87816], [-118.05197, 33.87818], [-118.05197, 33.87864]]]} Open Access 1 Cerritos Park East   17088 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 24.737 Cerritos Park East  
3808 3808 3807 {"type": "Polygon", "coordinates": [[[-118.09066, 33.8501], [-118.08213, 33.85012], [-118.08212, 33.84964], [-118.09066, 33.84962], [-118.09066, 33.8501]]]} Open Access 1 Gridley Park   19513 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 10.398 Gridley Park  
3837 3837 3836 {"type": "Polygon", "coordinates": [[[-118.09204, 33.87619], [-118.09159, 33.8762], [-118.09157, 33.87591], [-118.09149, 33.87562], [-118.09116, 33.87468], [-118.09115, 33.87461], [-118.09117, 33.87459], [-118.09117, 33.87417], [-118.09142, 33.87482], [-118.09146, 33.87483], [-118.09179, 33.87547], [-118.09204, 33.87619]]]} Open Access 1 Ecology Park   18422 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1.382 Ecology Park  
5053 5053 5052 {"type": "Polygon", "coordinates": [[[-118.06361, 33.86403], [-118.06242, 33.86403], [-118.0624, 33.86397], [-118.06237, 33.86394], [-118.06227, 33.8639], [-118.06219, 33.86391], [-118.0621, 33.86397], [-118.06202, 33.86399], [-118.05989, 33.864], [-118.05986, 33.86224], [-118.06149, 33.86223], [-118.06151, 33.8625], [-118.06309, 33.86249], [-118.06311, 33.86291], [-118.0635, 33.8629], [-118.06351, 33.86249], [-118.06359, 33.86248], [-118.06361, 33.86403]]]} Open Access 1 Heritage Park   19843 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 14.919 Heritage Park  
5459 5459 5458 {"type": "Polygon", "coordinates": [[[-118.07651, 33.85016], [-118.07229, 33.85019], [-118.07228, 33.84971], [-118.0765, 33.84968], [-118.07651, 33.85016]]]} Open Access 1 Jacob Park   20328 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 5.143 Jacob Park  
5537 5537 5536 {"type": "Polygon", "coordinates": [[[-118.04216, 33.88206], [-118.04067, 33.88206], [-118.04066, 33.88077], [-118.04067, 33.88072], [-118.04075, 33.88069], [-118.04215, 33.88068], [-118.04216, 33.88206]]]} Open Access 1 Joe A. Gonsalves Park   20418 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 5.169 Joe A. Gonsalves Park  
6147 6147 6146 {"type": "MultiPolygon", "coordinates": [[[[-118.10099, 33.85324], [-118.10009, 33.85324], [-118.10007, 33.85322], [-118.09975, 33.85322], [-118.0997, 33.85318], [-118.09967, 33.8513], [-118.09969, 33.85001], [-118.09967, 33.84962], [-118.10001, 33.84962], [-118.10099, 33.85324]]], [[[-118.10233, 33.85814], [-118.10201, 33.85814], [-118.10201, 33.85819], [-118.10123, 33.8582], [-118.10121, 33.85753], [-118.09975, 33.85754], [-118.0997, 33.85333], [-118.10102, 33.85333], [-118.10175, 33.85601], [-118.10175, 33.85691], [-118.102, 33.85693], [-118.10233, 33.85814]], [[-118.1013, 33.85762], [-118.10131, 33.85755], [-118.10124, 33.85755], [-118.10124, 33.85761], [-118.1013, 33.85762]]]]} Open Access 1 Liberty Park   21208 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 28.866 Liberty Park  
6329 6329 6328 {"type": "Polygon", "coordinates": [[[-118.06818, 33.87234], [-118.06786, 33.87234], [-118.06784, 33.8714], [-118.06785, 33.87137], [-118.06787, 33.87135], [-118.06817, 33.87135], [-118.06818, 33.87234]]]} Open Access 1 Loma Park   21407 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 0.819 Loma Park  
8004 8004 8003 {"type": "Polygon", "coordinates": [[[-118.0682, 33.85768], [-118.06803, 33.8577], [-118.06803, 33.85778], [-118.06797, 33.85783], [-118.06802, 33.85798], [-118.06793, 33.85803], [-118.06795, 33.85808], [-118.06806, 33.85809], [-118.06807, 33.85841], [-118.06782, 33.85841], [-118.06779, 33.85702], [-118.06819, 33.85702], [-118.0682, 33.85768]]]} Open Access 1 Pat Nixon Park   23504 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1.071 Pat Nixon Park  
8644 8644 8643 {"type": "Polygon", "coordinates": [[[-118.10168, 33.87869], [-118.10142, 33.87908], [-118.10145, 33.87916], [-118.10138, 33.8792], [-118.10135, 33.87928], [-118.10135, 33.87932], [-118.10139, 33.87938], [-118.10119, 33.8794], [-118.1004, 33.87941], [-118.1002, 33.87936], [-118.09996, 33.87936], [-118.09994, 33.87788], [-118.10118, 33.87839], [-118.1013, 33.87846], [-118.10149, 33.8786], [-118.10168, 33.87869]]]} Open Access 1 Reservoir Hill Park   24300 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 4.632 Reservoir Hill Park  
9110 9110 9109 {"type": "Polygon", "coordinates": [[[-118.05442, 33.87211], [-118.05444, 33.8723], [-118.05443, 33.87237], [-118.0544, 33.87245], [-118.05433, 33.87253], [-118.05425, 33.87258], [-118.05415, 33.87262], [-118.05405, 33.87263], [-118.05331, 33.87263], [-118.05331, 33.87219], [-118.05338, 33.87215], [-118.05347, 33.87214], [-118.0535, 33.87209], [-118.05354, 33.87208], [-118.05438, 33.87207], [-118.05442, 33.87211]]]} Open Access 1 Saddleback Park   24776 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1.48 Saddleback Park  
9375 9375 9374 {"type": "Polygon", "coordinates": [[[-118.07221, 33.88219], [-118.07219, 33.88225], [-118.07204, 33.88225], [-118.07201, 33.88226], [-118.07199, 33.88229], [-118.07167, 33.88229], [-118.07166, 33.88244], [-118.07139, 33.88244], [-118.07137, 33.88246], [-118.07121, 33.88246], [-118.07118, 33.88244], [-118.07058, 33.88245], [-118.07054, 33.88246], [-118.07038, 33.88246], [-118.07034, 33.88244], [-118.06975, 33.88245], [-118.06971, 33.88246], [-118.06955, 33.88247], [-118.06949, 33.88244], [-118.06892, 33.88245], [-118.06891, 33.88242], [-118.06889, 33.8824], [-118.06871, 33.8824], [-118.06867, 33.88236], [-118.06839, 33.88236], [-118.06838, 33.88293], [-118.06725, 33.88294], [-118.06725, 33.88271], [-118.06745, 33.8827], [-118.06746, 33.88217], [-118.06837, 33.88216], [-118.06839, 33.8822], [-118.07221, 33.88219]]]} Open Access 1 Satellite Park   25165 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 4.041 Satellite Park  
10141 10141 10140 {"type": "Polygon", "coordinates": [[[-118.05318, 33.85509], [-118.0532, 33.85589], [-118.05316, 33.85604], [-118.05304, 33.85628], [-118.05301, 33.85629], [-118.05279, 33.85626], [-118.05165, 33.85626], [-118.0516, 33.85624], [-118.05159, 33.85589], [-118.0516, 33.85579], [-118.05167, 33.85564], [-118.05178, 33.85554], [-118.05192, 33.85545], [-118.05208, 33.85542], [-118.0522, 33.85542], [-118.05234, 33.85547], [-118.05242, 33.85546], [-118.05249, 33.85542], [-118.05252, 33.85533], [-118.05278, 33.8551], [-118.05289, 33.85513], [-118.05305, 33.85508], [-118.05318, 33.85509]]]} Open Access 1 Sunshine Park   26073 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 3.668 Sunshine Park  
12516 12516 12515 {"type": "Polygon", "coordinates": [[[-118.0415, 33.86236], [-118.0415, 33.86236], [-118.03943, 33.86237], [-118.04016, 33.86174], [-118.0415, 33.86228], [-118.0415, 33.86236]]]} Open Access 1 Rainbow Park http://www.cerritos.us/RESIDENTS/recreation/facilities/neighborhood_parks/rainbow_park.php 29718 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1.772 Rainbow Park  
12753 12753 12752 {"type": "Polygon", "coordinates": [[[-118.1041, 33.86195], [-118.104, 33.86194], [-118.10376, 33.86108], [-118.10372, 33.86076], [-118.10359, 33.86024], [-118.10355, 33.86022], [-118.10309, 33.85854], [-118.1034, 33.85854], [-118.1034, 33.85845], [-118.10373, 33.85845], [-118.10375, 33.85868], [-118.10388, 33.85868], [-118.10407, 33.85859], [-118.1041, 33.86195]], [[-118.10323, 33.85876], [-118.10326, 33.85876], [-118.10334, 33.85864], [-118.10334, 33.85861], [-118.10319, 33.85862], [-118.10323, 33.85876]]]} Open Access 1 Westgate Park   29939 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 4.554 Westgate Park  
12760 12760 12759 {"type": "Polygon", "coordinates": [[[-118.06329, 33.84982], [-118.0591, 33.84985], [-118.05908, 33.84981], [-118.05833, 33.84982], [-118.05826, 33.8482], [-118.05747, 33.84819], [-118.05849, 33.8467], [-118.05885, 33.84652], [-118.05886, 33.84646], [-118.05925, 33.84648], [-118.05965, 33.84672], [-118.05953, 33.84687], [-118.05953, 33.84689], [-118.06124, 33.84794], [-118.06125, 33.84798], [-118.06132, 33.84798], [-118.06328, 33.84919], [-118.06329, 33.84982]]]} Open Access 1 Cerritos Sports Complex   29946 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 28.534 Cerritos Sports Complex  
12761 12761 12760 {"type": "Polygon", "coordinates": [[[-118.04189, 33.86024], [-118.04187, 33.8616], [-118.04175, 33.8616], [-118.0409, 33.86124], [-118.04104, 33.86112], [-118.04104, 33.86109], [-118.04097, 33.86103], [-118.04189, 33.86024]]]} Open Access 1 Bettencourt Park   29947 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1.883 Bettencourt Park  
12784 12784 12783 {"type": "Polygon", "coordinates": [[[-118.05493, 33.84996], [-118.05442, 33.85033], [-118.05038, 33.85035], [-118.05037, 33.84987], [-118.05458, 33.84984], [-118.0546, 33.84915], [-118.05485, 33.84915], [-118.05493, 33.84996]]]} Open Access 1 El Rancho Verde Park, West http://www.cerritos.us/RESIDENTS/recreation/facilities/neighborhood_parks/el_rancho_verde_park.php 29978 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 5.831 El Rancho Verde Park, West  
14263 14263 14262 {"type": "Polygon", "coordinates": [[[-118.09645, 33.8693], [-118.09644, 33.87086], [-118.09533, 33.87086], [-118.09531, 33.8686], [-118.09645, 33.8693]]]} Open Access 1 Rosewood Park   24670 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 5.439 Rosewood Park  

Next page

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