units_with_maps

Table actions

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

19 rows where ACCESS_TYP = 1, COUNTY = 6 and MNG_AGENCY = 221

This data as json, copyable, CSV (advanced)

These facets timed out: DES_TP

MNG_AG_TYP 1

MNG_AGENCY 1

  • Cerritos, City of · 19 ✖

ACCESS_TYP 1

  • Open Access · 19 ✖
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
629 629 628 {"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 2488 Joe A. Gonsalves Park 20418 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 5.171 Joe A. Gonsalves Park 0 Local Park 2 4
727 727 726 {"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 4620 Loma Park 21407 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 0.82 Loma Park 0 Local Park 2 4
1074 1074 1073 {"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.0615, 33.8625], [-118.06309, 33.86249], [-118.0631, 33.86291], [-118.06351, 33.8629], [-118.06351, 33.86249], [-118.06359, 33.86248], [-118.06361, 33.86403]]]} Open Access 1 5660 Heritage Park 19843 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 14.909 Heritage Park 0 Local Park 2 4
1277 1277 1276 {"type": "Polygon", "coordinates": [[[-118.10168, 33.87869], [-118.10142, 33.87909], [-118.10145, 33.87916], [-118.10138, 33.8792], [-118.10135, 33.87928], [-118.10135, 33.87933], [-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 9820 Reservoir Hill Park 24300 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 4.631 Reservoir Hill Park 0 Local Park 2 4
1358 1358 1357 {"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.85802], [-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 8071 Pat Nixon Park 23504 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 1.069 Pat Nixon Park 0 Local Park 2 4
1909 1909 1908 {"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 5801 Sunshine Park 26073 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 3.668 Sunshine Park 0 Local Park 2 4
2942 2942 2941 {"type": "Polygon", "coordinates": [[[-118.1041, 33.86195], [-118.104, 33.86194], [-118.10376, 33.86108], [-118.10372, 33.86076], [-118.10359, 33.86023], [-118.10355, 33.86022], [-118.10309, 33.85854], [-118.10341, 33.85854], [-118.1034, 33.85845], [-118.10373, 33.85845], [-118.10374, 33.85868], [-118.10388, 33.85868], [-118.10407, 33.85859], [-118.1041, 33.86195]], [[-118.10324, 33.85877], [-118.10325, 33.85877], [-118.10335, 33.85864], [-118.10334, 33.85861], [-118.10319, 33.85862], [-118.10324, 33.85877]]]} Open Access 1 20051 Westgate Park 29939 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 4.549 Westgate Park 0 Local Park 2 4
4540 4540 4539 {"type": "Polygon", "coordinates": [[[-118.09143, 33.87602], [-118.09139, 33.87609], [-118.09128, 33.87602], [-118.09124, 33.87543], [-118.09143, 33.87602]]]} Open Access 1 19997 Unnamed site - Artesia, City of 29525 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 0.128   0 Local Other or Unknown 14 4
5402 5402 5401 {"type": "Polygon", "coordinates": [[[-118.05293, 33.86586], [-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.86586]]]} Open Access 1 11242 Brookhaven Park 16422 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 1.761 Brookhaven Park 0 Local Park 2 4
6183 6183 6182 {"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 1234 Gridley Park 19513 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 10.41 Gridley Park 0 Local Park 2 4
6602 6602 6601 {"type": "MultiPolygon", "coordinates": [[[[-118.10099, 33.85324], [-118.10009, 33.85325], [-118.10007, 33.85322], [-118.09975, 33.85322], [-118.0997, 33.85318], [-118.09967, 33.8513], [-118.09969, 33.85], [-118.09967, 33.84962], [-118.10001, 33.84962], [-118.10099, 33.85324]]], [[[-118.10233, 33.85814], [-118.102, 33.85814], [-118.10201, 33.85819], [-118.10123, 33.8582], [-118.10122, 33.85753], [-118.09975, 33.85754], [-118.0997, 33.85333], [-118.10102, 33.85333], [-118.10175, 33.85601], [-118.10175, 33.85692], [-118.102, 33.85693], [-118.10233, 33.85814]], [[-118.10131, 33.85762], [-118.10132, 33.85755], [-118.10124, 33.85755], [-118.10124, 33.85761], [-118.10131, 33.85762]]]]} Open Access 1 4119 Liberty Park 21208 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 28.855 Liberty Park 0 Local Park 2 4
9168 9168 9167 {"type": "Polygon", "coordinates": [[[-118.05197, 33.87864], [-118.0517, 33.87858], [-118.05102, 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.87817], [-118.05197, 33.87818], [-118.05197, 33.87864]]]} Open Access 1 15216 Cerritos Park East 17088 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 24.732 Cerritos Park East 0 Local Park 2 4
10757 10757 10756 {"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.87548], [-118.09204, 33.87619]]]} Open Access 1 20053 Ecology Park 18422 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 1.382 Ecology Park 0 Local Park 2 4
10758 10758 10757 {"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 20055 Jacob Park 20328 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 5.146 Jacob Park 0 Local Park 2 4
10759 10759 10758 {"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 20056 Rosewood Park 24670 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 5.44 Rosewood Park 0 Local Park 2 4
10760 10760 10759 {"type": "Polygon", "coordinates": [[[-118.05338, 33.87215], [-118.05348, 33.87214], [-118.0535, 33.87209], [-118.05354, 33.87208], [-118.05438, 33.87207], [-118.05442, 33.87211], [-118.05444, 33.8723], [-118.05444, 33.87236], [-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]]]} Open Access 1 20057 Saddleback Park 24776 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 1.481 Saddleback Park 0 Local Park 2 4
10761 10761 10760 {"type": "Polygon", "coordinates": [[[-118.07221, 33.88219], [-118.07219, 33.88225], [-118.07204, 33.88225], [-118.072, 33.88226], [-118.07199, 33.88229], [-118.07166, 33.88229], [-118.07166, 33.88244], [-118.07139, 33.88244], [-118.07137, 33.88246], [-118.07121, 33.88246], [-118.07118, 33.88244], [-118.07057, 33.88245], [-118.07054, 33.88246], [-118.07038, 33.88246], [-118.07035, 33.88244], [-118.06975, 33.88245], [-118.06971, 33.88246], [-118.06955, 33.88247], [-118.0695, 33.88244], [-118.06892, 33.88245], [-118.06891, 33.88242], [-118.06889, 33.8824], [-118.06871, 33.8824], [-118.06868, 33.88236], [-118.06838, 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.06838, 33.8822], [-118.07221, 33.88219]]]} Open Access 1 20058 Satellite Park 25165 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 4.031 Satellite Park 0 Local Park 2 4
15004 15004 15003 {"type": "Polygon", "coordinates": [[[-118.05493, 33.84996], [-118.05442, 33.85033], [-118.05038, 33.85035], [-118.05037, 33.84987], [-118.05459, 33.84984], [-118.0546, 33.84915], [-118.05485, 33.84915], [-118.05493, 33.84996]]]} Open Access 1 45652 El Rancho Verde Park, West 29978 1051 Cerritos, City of 225 City 2 City Agency 2 http://www.ci.cerritos.ca.us/ City 2 1051 Cerritos, City of 221 City 2 City Agency 2 http://www.cerritos.us/RESIDENTS/recreation/facilities/neighborhood_parks/el_rancho_verde_park.php Los Angeles 6 5.827 El Rancho Verde Park, West   None 1292  
15402 15402 15401 {"type": "Polygon", "coordinates": [[[-118.06329, 33.84982], [-118.0591, 33.84985], [-118.05909, 33.84981], [-118.05833, 33.84982], [-118.05826, 33.8482], [-118.05747, 33.84819], [-118.05849, 33.8467], [-118.05885, 33.84651], [-118.05886, 33.84646], [-118.05925, 33.84648], [-118.05965, 33.84672], [-118.05952, 33.84687], [-118.05953, 33.84688], [-118.06124, 33.84794], [-118.06125, 33.84798], [-118.06132, 33.84798], [-118.06328, 33.84919], [-118.06329, 33.84982]]]} Open Access 1 46623 Cerritos Sports Complex 29946 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 1051 Cerritos, City of 221 City 2 City Agency 2   Los Angeles 6 28.529 Cerritos Sports Complex 0 Local Recreation Area 3 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]);