units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where COUNTY = 20, DES_TP = 2 and MNG_AGENCY = 92
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 13
MNG_AGENCY 1
- El Centro, City of · 13 ✖
DES_TP 1
- Local Park · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
803 | 803 | 802 | {"type": "Polygon", "coordinates": [[[-115.54406, 32.79085], [-115.54196, 32.79085], [-115.54196, 32.78986], [-115.54406, 32.78986], [-115.54406, 32.79085]]]} | Open Access 1 | 5217 | McGee Park | 22034 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 5.333 | McGee Park | 0 | Local Park 2 | 4 | |
3229 | 3229 | 3228 | {"type": "Polygon", "coordinates": [[[-115.54648, 32.75841], [-115.54632, 32.75839], [-115.54615, 32.75839], [-115.54607, 32.75841], [-115.54563, 32.7584], [-115.54563, 32.75772], [-115.54595, 32.75773], [-115.54596, 32.75769], [-115.54603, 32.7577], [-115.54609, 32.75769], [-115.5461, 32.75773], [-115.54647, 32.75773], [-115.54648, 32.75841]]]} | Open Access 1 | 48108 | Legacy Park | 32620 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 1.479 | Legacy Park | 0 | Local Park 2 | 4 |
3236 | 3236 | 3235 | {"type": "Polygon", "coordinates": [[[-115.58573, 32.7835], [-115.58573, 32.78513], [-115.58476, 32.78513], [-115.58479, 32.78468], [-115.58479, 32.7835], [-115.58573, 32.7835]]]} | Open Access 1 | 48109 | Wildflower Park | 32621 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 3.973 | Wildflower Park | 0 | Local Park 2 | 4 |
3237 | 3237 | 3236 | {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} | Restricted Access 2 | 48110 | Sunflower Park | 32835 | 2422 | El Centro Elementary School District 602 | Special District 4 | School District 14 | www.ecesd.org | Special District 4 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 18.451 | Sunflower Park | 2000 | Local Park 2 | 4 |
3575 | 3575 | 3574 | {"type": "Polygon", "coordinates": [[[-115.53957, 32.78512], [-115.53661, 32.78511], [-115.53661, 32.78462], [-115.53957, 32.78458], [-115.53957, 32.78512]]]} | Open Access 1 | 29144 | Gomez Park | 19389 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 3.926 | Gomez Park | 0 | Local Park 2 | 4 | |
6854 | 6854 | 6853 | {"type": "MultiPolygon", "coordinates": [[[[-115.55482, 32.79638], [-115.55473, 32.79638], [-115.55446, 32.79632], [-115.55423, 32.79625], [-115.55403, 32.79617], [-115.55367, 32.79598], [-115.55459, 32.79597], [-115.55459, 32.79604], [-115.55462, 32.7961], [-115.55477, 32.79627], [-115.55482, 32.79638]]], [[[-115.55697, 32.7964], [-115.55502, 32.7964], [-115.55499, 32.79631], [-115.55488, 32.79612], [-115.55485, 32.79597], [-115.5568, 32.79596], [-115.55684, 32.79611], [-115.55694, 32.79628], [-115.55697, 32.7964]]], [[[-115.55913, 32.7964], [-115.55717, 32.7964], [-115.55707, 32.79606], [-115.55706, 32.79596], [-115.55902, 32.79595], [-115.55904, 32.79608], [-115.55911, 32.79629], [-115.55913, 32.7964]]], [[[-115.56129, 32.7964], [-115.55932, 32.7964], [-115.55932, 32.79632], [-115.55924, 32.79606], [-115.55922, 32.79595], [-115.56129, 32.79594], [-115.56129, 32.7964]]]]} | Open Access 1 | 5483 | Adams Park | 15260 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 7.435 | Adams Park | 0 | Local Park 2 | 4 | |
6894 | 6894 | 6893 | {"type": "Polygon", "coordinates": [[[-115.57346, 32.80572], [-115.57237, 32.80573], [-115.57237, 32.80519], [-115.57248, 32.80519], [-115.57249, 32.80471], [-115.57239, 32.80469], [-115.57234, 32.80393], [-115.57345, 32.80393], [-115.57346, 32.80572]]]} | Open Access 1 | 5736 | Carlos Aguilar Park | 16859 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 4.876 | Carlos Aguilar Park | 0 | Local Park 2 | 4 | |
8080 | 8080 | 8079 | {"type": "Polygon", "coordinates": [[[-115.56431, 32.7814], [-115.56141, 32.78139], [-115.56134, 32.7785], [-115.56423, 32.7785], [-115.56431, 32.7814]]]} | Open Access 1 | 12078 | Bucklin Park | 16476 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 21.526 | Bucklin Park | 0 | Local Park 2 | 4 | |
8984 | 8984 | 8983 | {"type": "Polygon", "coordinates": [[[-115.57838, 32.78867], [-115.57712, 32.78866], [-115.57707, 32.78723], [-115.57833, 32.78723], [-115.57838, 32.78867]]]} | Open Access 1 | 15267 | West Park | 27371 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 4.661 | West Park | 0 | Local Park 2 | 4 | |
11402 | 11402 | 11401 | {"type": "Polygon", "coordinates": [[[-115.58573, 32.79079], [-115.58572, 32.7924], [-115.58483, 32.7924], [-115.58482, 32.79079], [-115.58573, 32.79079]]]} | Open Access 1 | 48107 | Leeper Park | 32619 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 3.693 | Leeper Park | 1980 | Local Park 2 | 4 |
11408 | 11408 | 11407 | {"type": "Polygon", "coordinates": [[[-115.54531, 32.76157], [-115.5453, 32.76193], [-115.54472, 32.76194], [-115.54451, 32.76195], [-115.54426, 32.76202], [-115.54411, 32.76204], [-115.54368, 32.76207], [-115.54357, 32.76207], [-115.54356, 32.76168], [-115.54359, 32.76168], [-115.5436, 32.76165], [-115.54404, 32.76165], [-115.54459, 32.76156], [-115.54531, 32.76157]]]} | Open Access 1 | 48092 | Countryside Park | 32595 | 6122 | Pulte Home Corporation 976 | Private 7 | Commercial 20 | https://www.pulte.com/ | Private 14 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 1.727 | Countryside Park | 2007 | Local Park 2 | 4 | |
12580 | 12580 | 12579 | {"type": "Polygon", "coordinates": [[[-115.57417, 32.77313], [-115.57379, 32.77352], [-115.57363, 32.77349], [-115.57363, 32.7724], [-115.57407, 32.7724], [-115.57413, 32.77241], [-115.57415, 32.77244], [-115.57417, 32.77248], [-115.57417, 32.77285], [-115.5741, 32.773], [-115.57412, 32.77307], [-115.57417, 32.77313]]]} | Open Access 1 | 29142 | Farmer's Park | 18846 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 1.307 | Farmer's Park | 0 | Local Park 2 | 4 | |
12584 | 12584 | 12583 | {"type": "Polygon", "coordinates": [[[-115.55922, 32.79271], [-115.55861, 32.79271], [-115.55861, 32.79234], [-115.55922, 32.79234], [-115.55922, 32.79271]]]} | Open Access 1 | 29152 | Town Square Park | 26493 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 0.583 | Town Square 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]);