superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "Sunshine Berardini Field", MNG_AGENCY = 4 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12869 | 12869 | 12868 | {"type": "MultiPolygon", "coordinates": [[[[-117.0971, 32.72542], [-117.09577, 32.72601], [-117.0955, 32.72607], [-117.09522, 32.72606], [-117.09396, 32.72568], [-117.0942, 32.7253], [-117.09454, 32.72487], [-117.09362, 32.72485], [-117.09363, 32.72452], [-117.0937, 32.7244], [-117.09378, 32.72432], [-117.09383, 32.7243], [-117.09387, 32.7243], [-117.09404, 32.72447], [-117.09431, 32.72467], [-117.09462, 32.72483], [-117.09489, 32.72494], [-117.09514, 32.72499], [-117.09534, 32.72502], [-117.09613, 32.7251], [-117.09648, 32.72516], [-117.09678, 32.72525], [-117.0971, 32.72542]]], [[[-117.10149, 32.72194], [-117.10138, 32.72239], [-117.10094, 32.7224], [-117.10108, 32.72297], [-117.10107, 32.72305], [-117.10051, 32.72279], [-117.09969, 32.72346], [-117.09779, 32.72509], [-117.09779, 32.72559], [-117.09767, 32.72549], [-117.09754, 32.72543], [-117.09727, 32.72523], [-117.09708, 32.72512], [-117.09674, 32.72499], [-117.09656, 32.72493], [-117.09622, 32.72488], [-117.09523, 32.72477], [-117.09506, 32.72474], [-117.0949, 32.72468], [-117.09466, 32.72459], [-117.09451, 32.7245], [-117.09424, 32.72432], [-117.09409, 32.72416], [-117.09567, 32.72418], [-117.09568, 32.72328], [-117.09664, 32.72327], [-117.09781, 32.72248], [-117.09782, 32.72237], [-117.09775, 32.72236], [-117.09954, 32.72121], [-117.09981, 32.72116], [-117.09982, 32.72118], [-117.10108, 32.72095], [-117.10149, 32.72194]]]]} | Open Access 1 | Sunshine Berardini Field | 30097 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 39.626 | Sunshine Berardini Field |
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]);