superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, LABEL_NAME = "Central Park" and MNG_AG_TYP = 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14196 | 14196 | 14195 | {"type": "MultiPolygon", "coordinates": [[[[-117.56834, 33.65338], [-117.56831, 33.65345], [-117.56817, 33.65353], [-117.56768, 33.65384], [-117.56738, 33.65406], [-117.56728, 33.65414], [-117.56682, 33.65472], [-117.56663, 33.6549], [-117.56639, 33.65508], [-117.56617, 33.65519], [-117.56594, 33.65527], [-117.56562, 33.6553], [-117.56637, 33.65377], [-117.56695, 33.65295], [-117.56755, 33.65213], [-117.56775, 33.65229], [-117.56794, 33.65253], [-117.56804, 33.65272], [-117.56834, 33.65338]]], [[[-117.59395, 33.64177], [-117.59353, 33.64184], [-117.5933, 33.64212], [-117.59332, 33.64226], [-117.5917, 33.6425], [-117.59138, 33.64242], [-117.59072, 33.64304], [-117.59072, 33.64277], [-117.59123, 33.64229], [-117.59111, 33.64158], [-117.59158, 33.64113], [-117.59308, 33.64092], [-117.59309, 33.64101], [-117.59313, 33.64108], [-117.59311, 33.64112], [-117.59339, 33.64129], [-117.59383, 33.64123], [-117.59395, 33.64177]]]]} | Restricted Access 2 | Central Park | 31698 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | http://www.samlarc.org/ | Private 14 | 16.485 | Central 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]);