calands: superunits_with_maps: 1 row where ACCESS_TYP = 1 and PARK_URL = "http://www.parks.ca.gov/default.asp?page

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

1 row where ACCESS_TYP = 1 and PARK_URL = "http://www.parks.ca.gov/default.asp?page_id=559"

Search:

descending

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
15241	15241	15240	{"type": "MultiPolygon", "coordinates": [[[[-120.92991, 37.30949], [-120.92937, 37.30985], [-120.92969, 37.31018], [-120.92945, 37.31029], [-120.92918, 37.31039], [-120.92878, 37.3105], [-120.92613, 37.31106], [-120.92594, 37.31096], [-120.92349, 37.30829], [-120.92342, 37.3082], [-120.92204, 37.30776], [-120.92125, 37.30735], [-120.92097, 37.30701], [-120.92067, 37.30657], [-120.92062, 37.30606], [-120.92079, 37.3021], [-120.92066, 37.30158], [-120.92022, 37.30114], [-120.91869, 37.3002], [-120.91777, 37.2993], [-120.91661, 37.29878], [-120.91533, 37.29864], [-120.91487, 37.29873], [-120.91372, 37.29933], [-120.91269, 37.30009], [-120.90975, 37.30248], [-120.90697, 37.30406], [-120.90668, 37.30413], [-120.90639, 37.30414], [-120.90601, 37.30406], [-120.90497, 37.30361], [-120.90449, 37.30346], [-120.90309, 37.30357], [-120.90231, 37.30361], [-120.90186, 37.30361], [-120.90125, 37.30389], [-120.89943, 37.30462], [-120.89885, 37.30487], [-120.89856, 37.30494], [-120.89806, 37.305], [-120.89758, 37.30501], [-120.89721, 37.30498], [-120.89684, 37.30487], [-120.89647, 37.30469], [-120.8958, 37.30433], [-120.89551, 37.30424], [-120.89484, 37.30412], [-120.89343, 37.30391], [-120.89249, 37.30388], [-120.89226, 37.30382], [-120.8916, 37.30343], [-120.89062, 37.30294], [-120.88926, 37.30248], [-120.88812, 37.30211], [-120.88692, 37.30162], [-120.88553, 37.30068], [-120.88442, 37.30037], [-120.88295, 37.29997], [-120.88158, 37.29987], [-120.87941, 37.29978], [-120.87905, 37.29972], [-120.87669, 37.29957], [-120.87604, 37.2994], [-120.87421, 37.29906], [-120.87241, 37.29863], [-120.87202, 37.29857], [-120.87191, 37.29793], [-120.8715, 37.29848], [-120.86853, 37.2989], [-120.86833, 37.29879], [-120.86775, 37.29868], [-120.86066, 37.29614], [-120.85878, 37.29648], [-120.85581, 37.29705], [-120.85403, 37.29721], [-120.85148, 37.29747], [-120.85151, 37.29531], [-120.8521, 37.29544], [-120.85267, 37.29554], [-120.85312, 37.2956], [-120.85346, 37.29553], [-120.85363, 37.29541], [-120.85381, 37.29519], [-120.85405, 37.29476], [-120.85414, 37.29449], [-120.85418, 37.29398], [-120.85418, 37.2935], [-120.85429, 37.29313], [-120.8545, 37.29291], [-120.85484, 37.29274], [-120.85528, 37.29268], [-120.85569, 37.29272], [-120.85614, 37.29283], [-120.8566, 37.29299], [-120.85693, 37.293], [-120.85792, 37.29282], [-120.85816, 37.29276], [-120.85918, 37.29234], [-120.86028, 37.29202], [-120.86133, 37.29138], [-120.86217, 37.29007], [-120.86296, 37.28907], [-120.86355, 37.28849], [-120.86486, 37.28837], [-120.86553, 37.28856], [-120.866, 37.29002], [-120.86574, 37.29153], [-120.86588, 37.29231], [-120.86633, 37.29276], [-120.86693, 37.29284], [-120.86798, 37.29289], [-120.86896, 37.29252], [-120.86955, 37.29213], [-120.86968, 37.29107], [-120.8698, 37.28986], [-120.8698, 37.28913], [-120.87017, 37.28891], [-120.87085, 37.2887], [-120.87183, 37.2886], [-120.87295, 37.2887], [-120.87375, 37.28901], [-120.87434, 37.2893], [-120.87486, 37.28982], [-120.87625, 37.29142], [-120.87655, 37.29236], [-120.87623, 37.29276], [-120.87534, 37.29282], [-120.87472, 37.29316], [-120.87334, 37.29403], [-120.87242, 37.29477], [-120.87162, 37.29694], [-120.87182, 37.29739], [-120.87256, 37.29763], [-120.87329, 37.29747], [-120.8744, 37.29699], [-120.87535, 37.29633], [-120.87602, 37.29586], [-120.8766, 37.29517], [-120.87703, 37.29446], [-120.87725, 37.29417], [-120.87752, 37.29337], [-120.87803, 37.29358], [-120.87833, 37.29379], [-120.87851, 37.29399], [-120.87862, 37.29414], [-120.87858, 37.29463], [-120.87859, 37.29464], [-120.87894, 37.29338], [-120.87821, 37.2928], [-120.87734, 37.29291], [-120.87656, 37.29463], [-120.87423, 37.29644], [-120.87326, 37.29706], [-120.87264, 37.29734], [-120.87198, 37.29706], [-120.87276, 37.29516], [-120.87367, 37.29435], [-120.87544, 37.29318], [-120.87656, 37.29304], [-120.87701, 37.29228], [-120.8766, 37.29132], [-120.87594, 37.29063], [-120.87534, 37.28899], [-120.87449, 37.28773], [-120.87341, 37.28693], [-120.87084, 37.28678], [-120.86935, 37.28741], [-120.86919, 37.28884], [-120.86916, 37.28986], [-120.86921, 37.29067], [-120.86905, 37.29208], [-120.86844, 37.29238], [-120.86695, 37.29254], [-120.86622, 37.2915], [-120.86649, 37.29], [-120.86598, 37.28843], [-120.86517, 37.28802], [-120.86363, 37.28795], [-120.8627, 37.28848], [-120.86233, 37.28886], [-120.86204, 37.28934], [-120.8614, 37.29007], [-120.86053, 37.29099], [-120.85968, 37.29161], [-120.85856, 37.29173], [-120.85699, 37.29232], [-120.85611, 37.29252], [-120.85524, 37.29231], [-120.85387, 37.29242], [-120.85335, 37.2932], [-120.85312, 37.29453], [-120.85244, 37.29508], [-120.85151, 37.29478], [-120.85154, 37.28889], [-120.85152, 37.28225], [-120.85154, 37.27456], [-120.85153, 37.2707], [-120.85154, 37.26022], [-120.85153, 37.25765], [-120.85153, 37.25693], [-120.85183, 37.2547], [-120.85224, 37.25197], [-120.85228, 37.24777], [-120.85291, 37.24789], [-120.85325, 37.24825], [-120.85393, 37.24843], [-120.85431, 37.24845], [-120.85624, 37.24896], [-120.85685, 37.24931], [-120.85732, 37.24937], [-120.85793, 37.25011], [-120.85799, 37.2507], [-120.85773, 37.25112], [-120.85781, 37.25211], [-120.85824, 37.25259], [-120.85871, 37.25297], [-120.85933, 37.25317], [-120.85974, 37.25375], [-120.86013, 37.25399], [-120.8607, 37.25421], [-120.86128, 37.25422], [-120.86181, 37.2545], [-120.86261, 37.25461], [-120.86279, 37.2551], [-120.86304, 37.25603], [-120.86291, 37.25696], [-120.8624, 37.2573], [-120.86153, 37.25732], [-120.86139, 37.25744], [-120.8617, 37.25888], [-120.86229, 37.25996], [-120.86267, 37.26028], [-120.8636, 37.26046], [-120.86449, 37.261], [-120.86491, 37.26135], [-120.86529, 37.26174], [-120.86582, 37.26208], [-120.86622, 37.2623], [-120.86614, 37.26272], [-120.86523, 37.26302], [-120.86421, 37.26331], [-120.86388, 37.26364], [-120.86379, 37.26407], [-120.86382, 37.26432], [-120.86415, 37.2648], [-120.86494, 37.26623], [-120.86538, 37.26666], [-120.86596, 37.26742], [-120.86675, 37.26759], [-120.86729, 37.26796], [-120.8673, 37.26906], [-120.86785, 37.27007], [-120.86825, 37.2704], [-120.86921, 37.27024], [-120.86805, 37.27129], [-120.86783, 37.27182], [-120.86779, 37.27227], [-120.86867, 37.27305], [-120.86891, 37.27338], [-120.86942, 37.27328], [-120.86946, 37.27376], [-120.87002, 37.27443], [-120.87018, 37.27443], [-120.87023, 37.27449], [-120.87071, 37.27493], [-120.87122, 37.27564], [-120.87136, 37.27599], [-120.87167, 37.27626], [-120.87181, 37.2816], [-120.88049, 37.28157], [-120.88089, 37.29659], [-120.88023, 37.29634], [-120.87896, 37.2956], [-120.87856, 37.29479], [-120.87832, 37.29535], [-120.8783, 37.29583], [-120.87838, 37.29621], [-120.87862, 37.29657], [-120.87871, 37.29681], [-120.87889, 37.29701], [-120.87927, 37.29724], [-120.87976, 37.2974], [-120.88088, 37.29721], [-120.88286, 37.29705], [-120.88338, 37.29697], [-120.88466, 37.2972], [-120.88549, 37.29741], [-120.88617, 37.29723], [-120.88654, 37.29719], [-120.88661, 37.29732], [-120.88661, 37.2976], [-120.88665, 37.29804], [-120.88684, 37.29853], [-120.88732, 37.29936], [-120.88812, 37.30063], [-120.88899, 37.30119], [-120.89009, 37.30128], [-120.89036, 37.30106], [-120.89107, 37.29996], [-120.89166, 37.29934], [-120.89224, 37.29883], [-120.89308, 37.29865], [-120.89362, 37.2987], [-120.89438, 37.29933], [-120.8949, 37.29957], [-120.89586, 37.29959], [-120.89626, 37.29923], [-120.89716, 37.29853], [-120.89791, 37.29827], [-120.89877, 37.29828], [-120.89926, 37.29844], [-120.89951, 37.29858], [-120.89972, 37.29888], [-120.89949, 37.29926], [-120.8995, 37.30008], [-120.89929, 37.30081], [-120.8999, 37.30113], [-120.90112, 37.30163], [-120.90173, 37.30165], [-120.90231, 37.30094], [-120.90234, 37.30035], [-120.90126, 37.29913], [-120.9011, 37.29849], [-120.90098, 37.29752], [-120.90076, 37.29693], [-120.9015, 37.29647], [-120.90266, 37.29673], [-120.90326, 37.29745], [-120.90376, 37.29801], [-120.90371, 37.29834], [-120.90374, 37.29907], [-120.90486, 37.29958], [-120.90567, 37.29914], [-120.90608, 37.29937], [-120.9069, 37.30089], [-120.90777, 37.3015], [-120.90874, 37.3017], [-120.90916, 37.30168], [-120.90991, 37.30145], [-120.91084, 37.30061], [-120.91147, 37.29944], [-120.91163, 37.2981], [-120.91259, 37.29819], [-120.91321, 37.29738], [-120.9136, 37.29695], [-120.91408, 37.29598], [-120.91524, 37.29493], [-120.91574, 37.2946], [-120.91656, 37.29432], [-120.91744, 37.29425], [-120.91835, 37.29462], [-120.91942, 37.29538], [-120.92066, 37.29528], [-120.92158, 37.29527], [-120.92227, 37.29617], [-120.92225, 37.29682], [-120.92186, 37.29716], [-120.92136, 37.29808], [-120.92137, 37.29921], [-120.92108, 37.3006], [-120.9214, 37.30162], [-120.92195, 37.3023], [-120.92264, 37.30286], [-120.92331, 37.30301], [-120.9237, 37.30374], [-120.92282, 37.30398], [-120.92229, 37.30348], [-120.92107, 37.30362], [-120.92102, 37.3043], [-120.9211, 37.30503], [-120.92111, 37.30561], [-120.92158, 37.30608], [-120.92188, 37.30651], [-120.92196, 37.30682], [-120.92188, 37.30728], [-120.92188, 37.30744], [-120.92199, 37.30756], [-120.92213, 37.30755], [-120.92228, 37.30752], [-120.92359, 37.30583], [-120.92378, 37.30517], [-120.92434, 37.30486], [-120.92502, 37.30501], [-120.92522, 37.30519], [-120.9251, 37.30598], [-120.9254, 37.30648], [-120.92599, 37.30673], [-120.92591, 37.30712], [-120.92596, 37.3075], [-120.92628, 37.30768], [-120.92672, 37.30775], [-120.92728, 37.30778], [-120.92784, 37.30803], [-120.92825, 37.30834], [-120.9288, 37.30872], [-120.92918, 37.30902], [-120.92973, 37.30939], [-120.92991, 37.30949]]], [[[-120.93113, 37.30843], [-120.93032, 37.30902], [-120.92851, 37.3079], [-120.928, 37.30777], [-120.92774, 37.3073], [-120.92617, 37.30644], [-120.92566, 37.30632], [-120.92598, 37.30539], [-120.92575, 37.30492], [-120.92471, 37.30454], [-120.92403, 37.30439], [-120.92306, 37.3052], [-120.9224, 37.30647], [-120.92217, 37.3065], [-120.92233, 37.30551], [-120.92133, 37.3039], [-120.92174, 37.30371], [-120.92243, 37.30383], [-120.9227, 37.30432], [-120.92418, 37.30404], [-120.92407, 37.30331], [-120.92353, 37.30296], [-120.92329, 37.30263], [-120.92242, 37.30219], [-120.9218, 37.30165], [-120.92163, 37.30116], [-120.9218, 37.30077], [-120.92192, 37.2986], [-120.92234, 37.29759], [-120.9227, 37.2974], [-120.92296, 37.29691], [-120.92471, 37.29693], [-120.92563, 37.29719], [-120.92692, 37.29771], [-120.92791, 37.2984], [-120.92821, 37.29916], [-120.92726, 37.30012], [-120.92821, 37.30243], [-120.92717, 37.30306], [-120.92739, 37.30594], [-120.93113, 37.30843]]]]}	Open Access 1	Great Valley Grasslands State Park	http://www.parks.ca.gov/default.asp?page_id=559	1550	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	2732.183	Great Valley Grasslands SP	1982

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