superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 138 and PARK_URL = "http://www.cityofalisoviejo.com/location/aliso-canyon-community-park/"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 1 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1142 | 1142 | 1141 | {"type": "Polygon", "coordinates": [[[-117.73018, 33.55145], [-117.73006, 33.55133], [-117.72978, 33.55133], [-117.72939, 33.55053], [-117.72916, 33.55018], [-117.72897, 33.54996], [-117.72876, 33.54976], [-117.72853, 33.54958], [-117.72827, 33.54942], [-117.72799, 33.54928], [-117.72755, 33.54911], [-117.72751, 33.54904], [-117.72738, 33.54901], [-117.72731, 33.54903], [-117.72704, 33.54898], [-117.72655, 33.54894], [-117.72607, 33.54895], [-117.72575, 33.549], [-117.72543, 33.54907], [-117.72512, 33.54917], [-117.72468, 33.54936], [-117.72441, 33.54952], [-117.72416, 33.54971], [-117.72393, 33.54991], [-117.72373, 33.55013], [-117.72359, 33.55033], [-117.7234, 33.55064], [-117.72207, 33.55341], [-117.72199, 33.55343], [-117.72127, 33.55319], [-117.72092, 33.55312], [-117.72067, 33.5531], [-117.72063, 33.55307], [-117.7206, 33.55302], [-117.72044, 33.55301], [-117.72053, 33.55288], [-117.72059, 33.55272], [-117.72067, 33.55258], [-117.72097, 33.55223], [-117.72098, 33.55213], [-117.72095, 33.55209], [-117.7209, 33.55205], [-117.72162, 33.55113], [-117.72088, 33.55051], [-117.72113, 33.55036], [-117.72217, 33.55008], [-117.72278, 33.54928], [-117.72298, 33.54867], [-117.72267, 33.548], [-117.72316, 33.54718], [-117.72349, 33.54598], [-117.7245, 33.54554], [-117.72578, 33.54423], [-117.72935, 33.54504], [-117.7294, 33.54846], [-117.72929, 33.54921], [-117.72978, 33.54978], [-117.73, 33.55017], [-117.72998, 33.55076], [-117.73018, 33.55145]]]} | Open Access 1 | Aliso Canyon Community Park | http://www.cityofalisoviejo.com/location/aliso-canyon-community-park/ | 15369 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 90.098 | Aliso Canyon Community Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);