superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "35.629" and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7926 | 7926 | 7925 | {"type": "Polygon", "coordinates": [[[-117.06282, 32.69333], [-117.0628, 32.69336], [-117.06249, 32.69356], [-117.06216, 32.69374], [-117.06192, 32.69384], [-117.06162, 32.69394], [-117.05967, 32.69448], [-117.05919, 32.69468], [-117.05841, 32.69514], [-117.05809, 32.69527], [-117.05774, 32.69538], [-117.05721, 32.69547], [-117.05703, 32.69547], [-117.05675, 32.69545], [-117.05574, 32.69533], [-117.05535, 32.69532], [-117.05509, 32.69535], [-117.05365, 32.6956], [-117.05337, 32.69571], [-117.05303, 32.69589], [-117.05276, 32.69607], [-117.05249, 32.69631], [-117.0522, 32.69669], [-117.05215, 32.69672], [-117.05208, 32.69671], [-117.0514, 32.69648], [-117.05086, 32.69625], [-117.05061, 32.69611], [-117.05044, 32.69599], [-117.05024, 32.69583], [-117.0501, 32.69568], [-117.05086, 32.69543], [-117.05167, 32.69504], [-117.05187, 32.69478], [-117.05273, 32.69435], [-117.05293, 32.69435], [-117.05312, 32.69399], [-117.05305, 32.6937], [-117.05323, 32.69372], [-117.05347, 32.69457], [-117.05354, 32.69454], [-117.05341, 32.69403], [-117.05354, 32.69405], [-117.05393, 32.69405], [-117.05499, 32.69406], [-117.05552, 32.69402], [-117.05617, 32.69417], [-117.05694, 32.69446], [-117.05819, 32.69422], [-117.05991, 32.69339], [-117.0604, 32.69325], [-117.06048, 32.69338], [-117.06081, 32.69334], [-117.06176, 32.69363], [-117.06259, 32.69307], [-117.06281, 32.69325], [-117.06282, 32.69333]]]} | Open Access 1 | Paradise Canyon Park | 23399 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 35.629 | Paradise Canyon 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]);