units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_ID = 1108, DES_TP = 964 and MNG_AGENCY = 557
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11091 | 11091 | 11090 | {"type": "MultiPolygon", "coordinates": [[[[-121.15283, 38.66929], [-121.15244, 38.66956], [-121.15227, 38.66976], [-121.15193, 38.67007], [-121.15162, 38.67023], [-121.15144, 38.67034], [-121.15108, 38.67064], [-121.15081, 38.67081], [-121.15066, 38.67094], [-121.1507, 38.67119], [-121.15058, 38.67134], [-121.15064, 38.67148], [-121.14779, 38.67328], [-121.14747, 38.67347], [-121.1471, 38.67362], [-121.14426, 38.67463], [-121.14348, 38.67386], [-121.14276, 38.67375], [-121.14221, 38.67383], [-121.14166, 38.67381], [-121.14154, 38.67466], [-121.14139, 38.67479], [-121.14023, 38.67482], [-121.13953, 38.67492], [-121.1389, 38.67497], [-121.13858, 38.67509], [-121.13759, 38.67428], [-121.13891, 38.67428], [-121.13895, 38.67427], [-121.13865, 38.67328], [-121.14013, 38.673], [-121.14071, 38.67261], [-121.14095, 38.67262], [-121.14115, 38.67324], [-121.14222, 38.67321], [-121.14267, 38.67312], [-121.14278, 38.67337], [-121.14301, 38.67345], [-121.14466, 38.67282], [-121.14527, 38.67249], [-121.14571, 38.67284], [-121.14682, 38.67235], [-121.14683, 38.67202], [-121.14711, 38.67183], [-121.14795, 38.67141], [-121.14778, 38.67116], [-121.1484, 38.67088], [-121.1486, 38.67097], [-121.14974, 38.67063], [-121.15009, 38.67072], [-121.15196, 38.66946], [-121.15218, 38.66918], [-121.15283, 38.66929]]], [[[-121.15031, 38.66599], [-121.14773, 38.66807], [-121.14734, 38.66796], [-121.1469, 38.66781], [-121.14702, 38.66762], [-121.1475, 38.66746], [-121.14784, 38.66716], [-121.14799, 38.66711], [-121.14832, 38.66703], [-121.14846, 38.66695], [-121.14853, 38.66689], [-121.14861, 38.66644], [-121.1487, 38.66616], [-121.14895, 38.6657], [-121.14906, 38.66559], [-121.14932, 38.6655], [-121.1496, 38.6655], [-121.1499, 38.66546], [-121.15014, 38.66535], [-121.15031, 38.66525], [-121.15031, 38.66599]]], [[[-121.15691, 38.66159], [-121.15756, 38.66168], [-121.1576, 38.6617], [-121.15762, 38.66174], [-121.15735, 38.66297], [-121.15729, 38.6632], [-121.15718, 38.66346], [-121.15701, 38.66376], [-121.15683, 38.66399], [-121.15641, 38.66447], [-121.15623, 38.66473], [-121.15607, 38.665], [-121.15593, 38.6653], [-121.15498, 38.66751], [-121.15489, 38.66769], [-121.15476, 38.66789], [-121.1545, 38.6682], [-121.15405, 38.6686], [-121.15353, 38.66844], [-121.15303, 38.66845], [-121.15289, 38.66896], [-121.1518, 38.66877], [-121.15177, 38.66872], [-121.15181, 38.66848], [-121.15187, 38.66826], [-121.15201, 38.66796], [-121.15241, 38.66799], [-121.15315, 38.66817], [-121.1532, 38.66806], [-121.15352, 38.66808], [-121.1536, 38.66793], [-121.15396, 38.668], [-121.1544, 38.66779], [-121.1548, 38.66718], [-121.15457, 38.66676], [-121.15459, 38.66653], [-121.15482, 38.6661], [-121.15463, 38.66593], [-121.15459, 38.6657], [-121.15433, 38.66576], [-121.15438, 38.66553], [-121.15447, 38.66532], [-121.15467, 38.66512], [-121.15475, 38.66511], [-121.15474, 38.66492], [-121.15463, 38.6649], [-121.15459, 38.66463], [-121.15467, 38.66454], [-121.15524, 38.66432], [-121.15534, 38.66408], [-121.15548, 38.66392], [-121.15562, 38.6638], [-121.15562, 38.66369], [-121.15556, 38.66361], [-121.15551, 38.66359], [-121.15542, 38.66353], [-121.15543, 38.66339], [-121.15549, 38.66322], [-121.15565, 38.66319], [-121.15566, 38.66312], [-121.1556, 38.66309], [-121.15574, 38.66272], [-121.15585, 38.66258], [-121.15603, 38.66244], [-121.15599, 38.6624], [-121.15599, 38.66235], [-121.15653, 38.66184], [-121.15673, 38.66175], [-121.15689, 38.66184], [-121.15695, 38.66182], [-121.15699, 38.6617], [-121.15691, 38.66159]]], [[[-121.15775, 38.66094], [-121.15772, 38.66132], [-121.1577, 38.66141], [-121.15766, 38.66145], [-121.15759, 38.66146], [-121.15691, 38.66137], [-121.15691, 38.66126], [-121.15775, 38.66094]]], [[[-121.18078, 38.66357], [-121.18039, 38.66363], [-121.17955, 38.66385], [-121.17868, 38.6639], [-121.17834, 38.66337], [-121.17733, 38.6638], [-121.17604, 38.66229], [-121.17582, 38.6616], [-121.17523, 38.65863], [-121.17544, 38.65768], [-121.17557, 38.65767], [-121.17565, 38.65814], [-121.17571, 38.65897], [-121.17579, 38.65926], [-121.17588, 38.65945], [-121.17597, 38.6596], [-121.17592, 38.6598], [-121.17596, 38.65992], [-121.17582, 38.66024], [-121.17589, 38.66049], [-121.1759, 38.66073], [-121.17727, 38.6625], [-121.17729, 38.66257], [-121.17726, 38.66264], [-121.17722, 38.66269], [-121.17705, 38.66279], [-121.17712, 38.66289], [-121.17723, 38.66297], [-121.17736, 38.663], [-121.17801, 38.6629], [-121.17827, 38.66289], [-121.17854, 38.6629], [-121.17892, 38.66296], [-121.17934, 38.66308], [-121.17943, 38.66309], [-121.17958, 38.66307], [-121.17973, 38.66299], [-121.17981, 38.66289], [-121.17983, 38.66277], [-121.17945, 38.66047], [-121.18033, 38.66036], [-121.18085, 38.66287], [-121.18085, 38.663], [-121.18082, 38.66312], [-121.18077, 38.66323], [-121.18069, 38.66334], [-121.18074, 38.66338], [-121.18078, 38.66357]]], [[[-121.18229, 38.6581], [-121.18099, 38.65834], [-121.18087, 38.65831], [-121.18012, 38.65845], [-121.17998, 38.65852], [-121.17991, 38.65862], [-121.17989, 38.65875], [-121.18012, 38.65933], [-121.18029, 38.66019], [-121.17942, 38.66031], [-121.17935, 38.65984], [-121.17929, 38.65932], [-121.17926, 38.65884], [-121.17925, 38.65832], [-121.1792, 38.65822], [-121.17912, 38.65814], [-121.17903, 38.6581], [-121.17873, 38.65802], [-121.17847, 38.65797], [-121.1782, 38.65795], [-121.17617, 38.65796], [-121.17613, 38.65793], [-121.17612, 38.65784], [-121.176, 38.65777], [-121.17582, 38.65777], [-121.17587, 38.65767], [-121.17699, 38.65767], [-121.177, 38.65768], [-121.17749, 38.65766], [-121.17749, 38.65765], [-121.17763, 38.65763], [-121.17762, 38.65752], [-121.17943, 38.65752], [-121.17943, 38.65644], [-121.1797, 38.65638], [-121.17973, 38.65634], [-121.17988, 38.65638], [-121.18003, 38.65639], [-121.18025, 38.65637], [-121.1804, 38.65633], [-121.18095, 38.6561], [-121.18167, 38.65595], [-121.18133, 38.6548], [-121.1816, 38.65476], [-121.18165, 38.65477], [-121.18168, 38.65481], [-121.18206, 38.65607], [-121.1809, 38.65632], [-121.18059, 38.65643], [-121.18023, 38.6566], [-121.17998, 38.65658], [-121.17979, 38.6568], [-121.17951, 38.657], [-121.17965, 38.65765], [-121.18153, 38.65764], [-121.18154, 38.65763], [-121.18118, 38.65637], [-121.18133, 38.65641], [-121.18181, 38.6564], [-121.18229, 38.6581]]]]} | Open Access 1 | 21295 | City Of Folsom | 17313 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 109.0 | City Of Folsom | None 964 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps(
id INT,
map,
ACCESS_TYP INT,
UNIT_ID INT,
UNIT_NAME TEXT,
SUID_NMA INT,
AGNCY_ID INT,
AGNCY_NAME INT,
AGNCY_LEV INT,
AGNCY_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
PARK_URL TEXT,
COUNTY INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
DES_TP INT,
GAP_STS TEXT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
ON [units_with_maps] ([ACCESS_TYP]);