units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where LABEL_NAME = "City of Oceanside OS", MNG_AGENCY = 75 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6262 | 6262 | 6261 | {"type": "Polygon", "coordinates": [[[-117.2722, 33.23324], [-117.27092, 33.23441], [-117.26866, 33.23481], [-117.269, 33.23353], [-117.26892, 33.2335], [-117.26927, 33.23204], [-117.26989, 33.23228], [-117.27007, 33.23157], [-117.27137, 33.23208], [-117.2715, 33.23242], [-117.27176, 33.23279], [-117.2722, 33.23324]]]} | Open Access 1 | 1729 | City of Oceanside Open Space | 17324 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 17.519 | City of Oceanside OS | 0 | Local Recreation Area 3 | 4 | |
16008 | 16008 | 16007 | {"type": "Polygon", "coordinates": [[[-117.2855, 33.22691], [-117.28548, 33.22693], [-117.28508, 33.22706], [-117.28476, 33.22719], [-117.28433, 33.22742], [-117.28393, 33.2277], [-117.2835, 33.22804], [-117.28332, 33.22792], [-117.28331, 33.22789], [-117.28316, 33.22777], [-117.28314, 33.22774], [-117.28298, 33.22763], [-117.28298, 33.22758], [-117.28281, 33.22748], [-117.2828, 33.22744], [-117.28263, 33.22729], [-117.28262, 33.22727], [-117.2824, 33.2271], [-117.28225, 33.22701], [-117.28206, 33.22703], [-117.28185, 33.227], [-117.28167, 33.22712], [-117.2815, 33.22732], [-117.28144, 33.22751], [-117.2812, 33.22732], [-117.28101, 33.22719], [-117.28067, 33.22715], [-117.28051, 33.22721], [-117.28015, 33.22748], [-117.28012, 33.22766], [-117.28025, 33.22794], [-117.28085, 33.22823], [-117.2812, 33.22844], [-117.28133, 33.22858], [-117.28146, 33.22876], [-117.28163, 33.22892], [-117.28186, 33.22904], [-117.28134, 33.22959], [-117.28119, 33.22971], [-117.28054, 33.23032], [-117.2786, 33.22891], [-117.27844, 33.22881], [-117.27751, 33.22853], [-117.27737, 33.2285], [-117.2769, 33.22847], [-117.27676, 33.22844], [-117.27662, 33.22837], [-117.27677, 33.22818], [-117.27756, 33.22804], [-117.27813, 33.22785], [-117.27826, 33.22775], [-117.27853, 33.22799], [-117.27883, 33.22837], [-117.27912, 33.22859], [-117.27957, 33.22859], [-117.28017, 33.22899], [-117.28042, 33.22898], [-117.28048, 33.22882], [-117.28033, 33.22859], [-117.27992, 33.22818], [-117.27982, 33.22801], [-117.27903, 33.2272], [-117.2787, 33.22693], [-117.27959, 33.22561], [-117.27971, 33.2255], [-117.27984, 33.22543], [-117.28004, 33.2254], [-117.28048, 33.22539], [-117.28059, 33.22594], [-117.28089, 33.22616], [-117.28127, 33.22616], [-117.28302, 33.22595], [-117.28319, 33.226], [-117.28335, 33.22608], [-117.28342, 33.22623], [-117.28346, 33.22639], [-117.28347, 33.22659], [-117.28363, 33.22688], [-117.28393, 33.22693], [-117.28436, 33.22674], [-117.28443, 33.22655], [-117.28433, 33.22615], [-117.28419, 33.2258], [-117.28428, 33.22581], [-117.28443, 33.22569], [-117.28474, 33.22555], [-117.2853, 33.22604], [-117.28524, 33.22612], [-117.28524, 33.22618], [-117.28535, 33.22638], [-117.28541, 33.22664], [-117.2855, 33.22691]]]} | Open Access 1 | 1733 | City of Oceanside Open Space | 17324 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 35.391 | City of Oceanside OS | 0 | Local Recreation Area 3 | 4 | |
16219 | 16219 | 16218 | {"type": "Polygon", "coordinates": [[[-117.17233, 33.2342], [-117.17202, 33.23604], [-117.17189, 33.23648], [-117.17178, 33.23675], [-117.17165, 33.23702], [-117.17032, 33.23703], [-117.1702, 33.23718], [-117.17023, 33.23751], [-117.17011, 33.23751], [-117.16988, 33.23783], [-117.16972, 33.23784], [-117.16977, 33.2384], [-117.16849, 33.23842], [-117.16846, 33.24102], [-117.16803, 33.24124], [-117.16763, 33.24094], [-117.16776, 33.24042], [-117.16769, 33.2402], [-117.16743, 33.23991], [-117.16592, 33.23931], [-117.16579, 33.23935], [-117.16431, 33.23922], [-117.16405, 33.23994], [-117.16386, 33.23992], [-117.16381, 33.23961], [-117.16384, 33.23934], [-117.15908, 33.23938], [-117.15804, 33.23852], [-117.15919, 33.23818], [-117.15945, 33.23775], [-117.15995, 33.23749], [-117.16145, 33.23719], [-117.16196, 33.23581], [-117.1627, 33.23526], [-117.16318, 33.23561], [-117.16327, 33.23494], [-117.16638, 33.23486], [-117.16638, 33.23119], [-117.16608, 33.23118], [-117.16622, 33.2307], [-117.16638, 33.23055], [-117.16638, 33.23112], [-117.16644, 33.23112], [-117.16649, 33.23108], [-117.16651, 33.23101], [-117.16644, 33.23081], [-117.16645, 33.23065], [-117.16653, 33.23046], [-117.16659, 33.23041], [-117.16665, 33.23038], [-117.16671, 33.23037], [-117.16745, 33.2305], [-117.16762, 33.2305], [-117.16779, 33.23047], [-117.1683, 33.23026], [-117.16876, 33.22996], [-117.16893, 33.22982], [-117.16899, 33.22975], [-117.1691, 33.22972], [-117.16919, 33.22975], [-117.1693, 33.22992], [-117.16944, 33.23004], [-117.16958, 33.23012], [-117.16978, 33.23017], [-117.16979, 33.23023], [-117.16989, 33.23025], [-117.16996, 33.23029], [-117.17, 33.23033], [-117.17008, 33.23044], [-117.17016, 33.23051], [-117.17022, 33.23053], [-117.17059, 33.23058], [-117.1706, 33.23248], [-117.17094, 33.2325], [-117.17188, 33.23359], [-117.17209, 33.23384], [-117.17201, 33.23419], [-117.17233, 33.2342]]]} | No Public Access 3 | 44881 | City of Oceanside Open Space | 17323 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 175.69 | City of Oceanside OS | 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]);