units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 221
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 18
MNG_AGENCY 1
- Cerritos, City of · 18 ✖
DES_TP 1
- Local Park · 18 ✖
ACCESS_TYP 1
- Open Access · 18 ✖
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 | |
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 | |
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
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]);