superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and PARK_URL = "http://www.ocparks.com/parks/yorba"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15108 | 15108 | 15107 | {"type": "Polygon", "coordinates": [[[-117.78127, 33.86017], [-117.78126, 33.86048], [-117.77728, 33.8624], [-117.77698, 33.86256], [-117.7767, 33.86274], [-117.77644, 33.86294], [-117.7762, 33.86315], [-117.77064, 33.86917], [-117.77041, 33.86938], [-117.77014, 33.86958], [-117.76987, 33.86975], [-117.76958, 33.8699], [-117.76928, 33.87002], [-117.76893, 33.87013], [-117.75791, 33.87317], [-117.75789, 33.87331], [-117.7563, 33.87375], [-117.75624, 33.87364], [-117.7559, 33.87373], [-117.75592, 33.87385], [-117.75575, 33.8739], [-117.75567, 33.87365], [-117.75568, 33.87335], [-117.75452, 33.87319], [-117.75419, 33.87318], [-117.75369, 33.87321], [-117.75366, 33.87309], [-117.75339, 33.8731], [-117.75323, 33.87313], [-117.75305, 33.87321], [-117.75276, 33.87329], [-117.75249, 33.8734], [-117.7522, 33.87353], [-117.75193, 33.87367], [-117.75157, 33.87392], [-117.75115, 33.87428], [-117.75095, 33.87452], [-117.7508, 33.87474], [-117.75069, 33.87478], [-117.74982, 33.87457], [-117.75063, 33.8741], [-117.75188, 33.87343], [-117.75274, 33.87301], [-117.75407, 33.87242], [-117.75549, 33.87185], [-117.75646, 33.87151], [-117.75743, 33.87119], [-117.75748, 33.87124], [-117.75843, 33.87093], [-117.75937, 33.87059], [-117.76077, 33.87004], [-117.76213, 33.86943], [-117.78035, 33.86059], [-117.78127, 33.86017]]]} | Open Access 1 | Yorba Regional Park | http://www.ocparks.com/parks/yorba | 27778 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 155.372 | Yorba RP |
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]);