superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "10.96" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14214 | 14214 | 14213 | {"type": "Polygon", "coordinates": [[[-117.61896, 33.65906], [-117.61894, 33.6595], [-117.61887, 33.65976], [-117.61872, 33.66002], [-117.61856, 33.66021], [-117.61813, 33.66053], [-117.61788, 33.66066], [-117.61763, 33.66075], [-117.61746, 33.66081], [-117.6173, 33.66083], [-117.61687, 33.66083], [-117.61685, 33.66021], [-117.61663, 33.65975], [-117.61673, 33.65943], [-117.6167, 33.65921], [-117.6166, 33.65904], [-117.6166, 33.65897], [-117.61643, 33.65896], [-117.6163, 33.65897], [-117.61627, 33.65881], [-117.61631, 33.65879], [-117.6165, 33.65864], [-117.61666, 33.65855], [-117.61678, 33.6585], [-117.61689, 33.65848], [-117.61715, 33.65846], [-117.61722, 33.65837], [-117.61758, 33.65853], [-117.61801, 33.65868], [-117.61827, 33.65875], [-117.6187, 33.6588], [-117.61873, 33.65889], [-117.61879, 33.65897], [-117.61896, 33.65906]]]} | Restricted Access 2 | Altistima Park | 31699 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | http://www.samlarc.org/ | Private 14 | 10.96 | Altistima 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]);