calands: units_with_maps: 1 row where COUNTY = 41, DES_TP = 964 and MNG

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where COUNTY = 41, DES_TP = 964 and MNG_AGENCY = 557

Search:

descending

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]);