superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 266 and PARK_NAME = "Heritage Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5061 | 5061 | 5060 | {"type": "Polygon", "coordinates": [[[-117.78086, 33.70027], [-117.78075, 33.70072], [-117.7807, 33.7008], [-117.7806, 33.70085], [-117.78027, 33.70086], [-117.78023, 33.70088], [-117.78016, 33.70097], [-117.77979, 33.70281], [-117.77977, 33.70299], [-117.77956, 33.70288], [-117.77939, 33.70284], [-117.77925, 33.70283], [-117.77909, 33.70284], [-117.77894, 33.70289], [-117.77872, 33.7031], [-117.77862, 33.7033], [-117.7785, 33.70404], [-117.77844, 33.70421], [-117.77816, 33.70418], [-117.77764, 33.70341], [-117.77759, 33.70343], [-117.77669, 33.70213], [-117.7772, 33.70185], [-117.7765, 33.70075], [-117.77767, 33.69954], [-117.77828, 33.69995], [-117.77854, 33.69994], [-117.77909, 33.69938], [-117.77899, 33.69929], [-117.77925, 33.69903], [-117.78064, 33.69999], [-117.78059, 33.70007], [-117.78086, 33.70027]]]} | Open Access 1 | Heritage Park | 19850 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 30.629 | Heritage 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]);