units_with_maps

Table actions

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

20 rows where AGNCY_TYP = 2, DES_TP = 2 and MNG_AGENCY = 221

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Cerritos, City of · 20 ✖

DES_TP 1

  • Local Park · 20 ✖
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
772 772 771 {"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 4495 Bettencourt Park 29947 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   Orange 3 1.883 Bettencourt Park 0 Local Park 2 4
1030 1030 1029 {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} Restricted Access 2 5646 Friendship Park 19120 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.848 Friendship 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
1425 1425 1424 {"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 9276 Rainbow Park 29718 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/rainbow_park.php Orange 3 1.772 Rainbow 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
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
6022 6022 6021 {"type": "Polygon", "coordinates": [[[-118.06026, 33.87842], [-118.05959, 33.87842], [-118.05956, 33.87688], [-118.06001, 33.87688], [-118.06019, 33.87686], [-118.06024, 33.87689], [-118.06026, 33.87842]]]} Restricted Access 2 729 Frontier Park 19131 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 2.643 Frontier 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

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