units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where AGNCY_NAME = 300 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 14
- Local Recreation Area 3
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 19 ✖
MNG_AGENCY 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
984 | 984 | 983 | {"type": "Polygon", "coordinates": [[[-118.42055, 33.91726], [-118.42008, 33.91726], [-118.42008, 33.91715], [-118.42055, 33.91715], [-118.42055, 33.91726]]]} | Open Access 1 | 6143 | Candy Cane Park | 16800 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 0.131 | Candy Cane Park | 0 | Local Park 2 | 4 | |
2092 | 2092 | 2091 | {"type": "Polygon", "coordinates": [[[-118.39572, 33.91443], [-118.39518, 33.91444], [-118.39517, 33.91445], [-118.39529, 33.9147], [-118.39505, 33.91479], [-118.39406, 33.91293], [-118.39392, 33.9127], [-118.39375, 33.91247], [-118.39352, 33.9122], [-118.39318, 33.91187], [-118.39199, 33.91086], [-118.39445, 33.90986], [-118.39456, 33.90961], [-118.39553, 33.9096], [-118.39553, 33.90815], [-118.3951, 33.90815], [-118.3951, 33.90799], [-118.39556, 33.90798], [-118.39562, 33.908], [-118.39567, 33.90806], [-118.39568, 33.9096], [-118.39569, 33.9098], [-118.39572, 33.90991], [-118.39572, 33.91443]]]} | Restricted Access 2 | 6138 | The Lakes at El Segundo Municipal Golf Course | 33006 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 26.418 | The Lakes at El Segundo Municipal GC | 0 | Local Recreation Area 3 | 4 | |
2100 | 2100 | 2099 | {"type": "Polygon", "coordinates": [[[-118.41119, 33.93127], [-118.40819, 33.93129], [-118.40416, 33.93127], [-118.404, 33.93105], [-118.40398, 33.93097], [-118.41118, 33.93095], [-118.41119, 33.93127]]]} | Open Access 1 | 6164 | El Segundo Dog Park | 18540 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 5.671 | El Segundo Dog Park | 0 | Local Park 2 | 4 | |
3957 | 3957 | 3956 | {"type": "Polygon", "coordinates": [[[-118.3989, 33.92797], [-118.39844, 33.92797], [-118.39844, 33.92709], [-118.39889, 33.92709], [-118.3989, 33.92797]]]} | Open Access 1 | 46423 | Constitution Park | 29695 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 1.021 | Constitution Park | 0 | Local Park 2 | 4 | |
4074 | 4074 | 4073 | {"type": "Polygon", "coordinates": [[[-118.39889, 33.92504], [-118.39844, 33.92504], [-118.39843, 33.92369], [-118.39889, 33.92369], [-118.39889, 33.92504]]]} | Open Access 1 | 46430 | Washington Par Course | 29700 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 1.549 | Washington Par Course | None 352 | |||
5197 | 5197 | 5196 | {"type": "Polygon", "coordinates": [[[-118.41586, 33.93121], [-118.41479, 33.93127], [-118.41119, 33.93127], [-118.41118, 33.93095], [-118.41483, 33.93094], [-118.41583, 33.931], [-118.41586, 33.93121]]]} | Open Access 1 | 6163 | Clutter's Park | 17448 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 3.69 | Clutter's Park | 0 | Local Park 2 | 4 | |
6948 | 6948 | 6947 | {"type": "Polygon", "coordinates": [[[-118.4227, 33.92062], [-118.42268, 33.92075], [-118.42264, 33.92078], [-118.42223, 33.92078], [-118.42223, 33.92063], [-118.4227, 33.92062]]]} | Open Access 1 | 6162 | Holly Valley Park | 20047 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 0.173 | Holly Valley Park | 0 | Local Park 2 | 4 | |
7099 | 7099 | 7098 | {"type": "Polygon", "coordinates": [[[-118.40198, 33.92796], [-118.40129, 33.92797], [-118.40129, 33.92752], [-118.40198, 33.92752], [-118.40198, 33.92796]]]} | Open Access 1 | 6151 | Sycamore Park | 26134 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 0.773 | Sycamore Park | 0 | Local Park 2 | 4 | |
7100 | 7100 | 7099 | {"type": "Polygon", "coordinates": [[[-118.42321, 33.93034], [-118.42276, 33.93034], [-118.42276, 33.92986], [-118.4232, 33.92986], [-118.42321, 33.93034]]]} | Open Access 1 | 6152 | Acacia Park | 15243 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 0.538 | Acacia Park | 0 | Local Park 2 | 4 | |
7101 | 7101 | 7100 | {"type": "Polygon", "coordinates": [[[-118.40103, 33.92131], [-118.40057, 33.92131], [-118.40057, 33.92094], [-118.40103, 33.92094], [-118.40103, 33.92131]]]} | Open Access 1 | 6153 | Kansas Park | 20550 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 0.424 | Kansas Park | 0 | Local Park 2 | 4 | |
7102 | 7102 | 7101 | {"type": "Polygon", "coordinates": [[[-118.39889, 33.92695], [-118.39844, 33.92695], [-118.39843, 33.92606], [-118.39815, 33.92605], [-118.39815, 33.92515], [-118.39889, 33.92515], [-118.39889, 33.92695]]]} | Open Access 1 | 6154 | Washington Park | 27274 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 2.736 | Washington Park | 0 | Local Park 2 | 4 | |
7103 | 7103 | 7102 | {"type": "Polygon", "coordinates": [[[-118.41708, 33.925], [-118.41609, 33.925], [-118.41608, 33.92367], [-118.41707, 33.92366], [-118.41708, 33.925]]]} | Open Access 1 | 6155 | Library Park | 21217 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 3.344 | Library Park | 0 | Local Park 2 | 4 | |
7104 | 7104 | 7103 | {"type": "Polygon", "coordinates": [[[-118.40767, 33.92145], [-118.4072, 33.92145], [-118.40716, 33.92144], [-118.40715, 33.92148], [-118.40669, 33.92148], [-118.40667, 33.91952], [-118.40766, 33.91952], [-118.40767, 33.92145]]]} | Open Access 1 | 6157 | Hilltop Park | 19987 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 4.869 | Hilltop Park | 0 | Local Park 2 | 4 | |
7105 | 7105 | 7104 | {"type": "Polygon", "coordinates": [[[-118.40261, 33.92509], [-118.40215, 33.92509], [-118.40215, 33.92477], [-118.40261, 33.92477], [-118.40261, 33.92509]]]} | Restricted Access 2 | 6158 | Camp Eucalyptus | 29706 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 0.378 | Camp Eucalyptus | None 581 | |||
7106 | 7106 | 7105 | {"type": "MultiPolygon", "coordinates": [[[[-118.40946, 33.92138], [-118.40899, 33.92139], [-118.40899, 33.92093], [-118.40946, 33.92093], [-118.40946, 33.92138]]], [[[-118.41345, 33.92217], [-118.41122, 33.92218], [-118.40907, 33.92218], [-118.40924, 33.92199], [-118.40951, 33.92166], [-118.40951, 33.92093], [-118.40998, 33.92093], [-118.40998, 33.92105], [-118.40999, 33.92106], [-118.41014, 33.92089], [-118.41014, 33.92049], [-118.41061, 33.92049], [-118.41062, 33.9205], [-118.41087, 33.92035], [-118.41113, 33.92023], [-118.41113, 33.92048], [-118.41121, 33.92045], [-118.41129, 33.92044], [-118.41129, 33.92016], [-118.41195, 33.91995], [-118.41195, 33.91951], [-118.41343, 33.9195], [-118.41338, 33.91953], [-118.41343, 33.91957], [-118.41345, 33.92217]]]]} | Open Access 1 | 6156 | Recreation Park | 24215 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 21.499 | Rec. Park | 0 | Local Recreation Area 3 | 4 | |
7108 | 7108 | 7107 | {"type": "Polygon", "coordinates": [[[-118.42828, 33.93089], [-118.42628, 33.93115], [-118.42563, 33.9312], [-118.42508, 33.93122], [-118.41627, 33.93121], [-118.41619, 33.93113], [-118.41609, 33.93096], [-118.42734, 33.93097], [-118.42735, 33.93083], [-118.42826, 33.93083], [-118.42828, 33.93089]]]} | Open Access 1 | 6159 | Imperial Strip Park | 20182 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 6.927 | Imperial Strip Park | 0 | Local Park 2 | 4 | |
11886 | 11886 | 11885 | {"type": "Polygon", "coordinates": [[[-118.39887, 33.92355], [-118.39842, 33.92355], [-118.39841, 33.92095], [-118.39885, 33.92094], [-118.39887, 33.92355]]]} | Open Access 1 | 24506 | Freedom Park | 19084 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 3.003 | Freedom Park | 0 | Local Park 2 | 4 | |
15295 | 15295 | 15294 | {"type": "Polygon", "coordinates": [[[-118.3989, 33.92899], [-118.39866, 33.929], [-118.39865, 33.92811], [-118.3989, 33.92811], [-118.3989, 33.92899]]]} | Open Access 1 | 46427 | Independence Park | 29698 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 0.549 | Independence Park | 0 | Local Park 2 | 4 | |
15296 | 15296 | 15295 | {"type": "Polygon", "coordinates": [[[-118.38731, 33.92481], [-118.38575, 33.92482], [-118.38546, 33.92487], [-118.38531, 33.92493], [-118.3853, 33.92375], [-118.38721, 33.92374], [-118.38725, 33.92375], [-118.38729, 33.92381], [-118.38731, 33.92481]]]} | Restricted Access 2 | 46429 | Campus El Segundo Athletic Fields | 29699 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 5.455 | Campus El Segundo Athletic Fields | 0 | Local Recreation Area 3 | 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]);