calands: superunits_with_maps: 1 row where ACCESS_TYP = 1, MNG_AG_TYP = 5 and PARK

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

1 row where ACCESS_TYP = 1, MNG_AG_TYP = 5 and PARK_NAME = "Crestridge Ecological Reserve"

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
14480	14480	14479	{"type": "MultiPolygon", "coordinates": [[[[-116.89826, 32.81246], [-116.89825, 32.81257], [-116.89819, 32.81268], [-116.89791, 32.81293], [-116.89789, 32.81297], [-116.89787, 32.81304], [-116.89788, 32.81313], [-116.89784, 32.81341], [-116.89781, 32.81354], [-116.89772, 32.81372], [-116.89751, 32.81401], [-116.89745, 32.81414], [-116.89738, 32.81419], [-116.89726, 32.81423], [-116.89711, 32.81423], [-116.897, 32.81417], [-116.89665, 32.81409], [-116.8965, 32.8141], [-116.89637, 32.81416], [-116.8962, 32.81435], [-116.89589, 32.81463], [-116.89582, 32.81471], [-116.89568, 32.81497], [-116.89552, 32.81542], [-116.89541, 32.81554], [-116.8953, 32.81558], [-116.89513, 32.81557], [-116.89446, 32.81522], [-116.89433, 32.81517], [-116.89416, 32.81514], [-116.89376, 32.81513], [-116.89336, 32.8152], [-116.89366, 32.81576], [-116.89398, 32.81603], [-116.89406, 32.81611], [-116.89419, 32.81639], [-116.89443, 32.81672], [-116.89452, 32.81692], [-116.89452, 32.81701], [-116.89447, 32.81711], [-116.89422, 32.81734], [-116.89417, 32.81741], [-116.89413, 32.81749], [-116.89413, 32.81758], [-116.89431, 32.81811], [-116.89432, 32.81823], [-116.8943, 32.81835], [-116.89426, 32.81845], [-116.89426, 32.81852], [-116.89428, 32.8186], [-116.89434, 32.81871], [-116.89435, 32.81876], [-116.89435, 32.81886], [-116.89431, 32.819], [-116.89432, 32.81921], [-116.89443, 32.81941], [-116.89463, 32.81961], [-116.89484, 32.81973], [-116.89509, 32.81981], [-116.89434, 32.82013], [-116.89132, 32.82039], [-116.89128, 32.82041], [-116.89186, 32.82552], [-116.89157, 32.82557], [-116.89143, 32.82588], [-116.88835, 32.82852], [-116.88682, 32.82695], [-116.88609, 32.82671], [-116.88563, 32.82649], [-116.88502, 32.82593], [-116.8842, 32.82588], [-116.88359, 32.82556], [-116.88279, 32.82497], [-116.88218, 32.82458], [-116.88146, 32.82421], [-116.87929, 32.82471], [-116.87782, 32.82521], [-116.87702, 32.82556], [-116.87465, 32.82578], [-116.87382, 32.82598], [-116.87103, 32.8299], [-116.8673, 32.82836], [-116.86654, 32.82882], [-116.86633, 32.82956], [-116.86058, 32.82923], [-116.8587, 32.83155], [-116.8589, 32.83212], [-116.85917, 32.83218], [-116.8603, 32.83305], [-116.86053, 32.83321], [-116.86078, 32.83336], [-116.86163, 32.8337], [-116.86216, 32.83418], [-116.86263, 32.83428], [-116.86206, 32.83556], [-116.86497, 32.83567], [-116.86787, 32.83689], [-116.86874, 32.83754], [-116.86949, 32.83736], [-116.87136, 32.84036], [-116.87231, 32.84127], [-116.87277, 32.84167], [-116.87402, 32.84255], [-116.87222, 32.84396], [-116.8717, 32.84428], [-116.87044, 32.8447], [-116.86787, 32.8452], [-116.86312, 32.84505], [-116.8618, 32.84476], [-116.86172, 32.8448], [-116.86187, 32.84502], [-116.85753, 32.84505], [-116.85469, 32.84869], [-116.85469, 32.84965], [-116.8479, 32.84965], [-116.84786, 32.85222], [-116.84718, 32.85213], [-116.84608, 32.85203], [-116.84493, 32.8524], [-116.8413, 32.85276], [-116.8393, 32.85312], [-116.83874, 32.85327], [-116.83822, 32.85354], [-116.83713, 32.85387], [-116.83686, 32.85388], [-116.83628, 32.85404], [-116.83518, 32.85475], [-116.83372, 32.85523], [-116.83301, 32.85542], [-116.83234, 32.85498], [-116.83213, 32.85515], [-116.83194, 32.85526], [-116.83183, 32.8553], [-116.83152, 32.85484], [-116.83006, 32.85502], [-116.82983, 32.85549], [-116.82979, 32.85548], [-116.82966, 32.85547], [-116.82954, 32.85549], [-116.8288, 32.85583], [-116.82878, 32.85501], [-116.82567, 32.85514], [-116.82496, 32.85213], [-116.82361, 32.85217], [-116.83312, 32.84494], [-116.84054, 32.83937], [-116.84609, 32.83513], [-116.84638, 32.83539], [-116.84715, 32.83482], [-116.84716, 32.83478], [-116.84689, 32.83452], [-116.84846, 32.8333], [-116.84916, 32.83278], [-116.85386, 32.82918], [-116.85825, 32.82722], [-116.85826, 32.82589], [-116.85904, 32.82541], [-116.85886, 32.82518], [-116.86165, 32.82335], [-116.86642, 32.81973], [-116.86661, 32.81991], [-116.86758, 32.8209], [-116.86783, 32.82112], [-116.8744, 32.81649], [-116.8744, 32.81647], [-116.87303, 32.81509], [-116.87601, 32.81296], [-116.87606, 32.81299], [-116.87877, 32.81111], [-116.88049, 32.81096], [-116.88102, 32.81118], [-116.88157, 32.81137], [-116.88403, 32.81236], [-116.88794, 32.81093], [-116.88952, 32.81064], [-116.88824, 32.80928], [-116.88866, 32.80934], [-116.88883, 32.80945], [-116.88908, 32.80952], [-116.88933, 32.80953], [-116.88945, 32.80951], [-116.8896, 32.80947], [-116.89023, 32.80955], [-116.89032, 32.80959], [-116.8906, 32.80966], [-116.89087, 32.80964], [-116.8912, 32.80968], [-116.89167, 32.80979], [-116.89172, 32.80981], [-116.89182, 32.80991], [-116.89192, 32.80997], [-116.89206, 32.81003], [-116.89217, 32.81006], [-116.89238, 32.81007], [-116.89254, 32.81005], [-116.89271, 32.8101], [-116.89307, 32.81016], [-116.89338, 32.81018], [-116.89366, 32.81016], [-116.89378, 32.81024], [-116.89395, 32.81028], [-116.89419, 32.81027], [-116.89433, 32.81023], [-116.89442, 32.81018], [-116.89493, 32.80981], [-116.8961, 32.80937], [-116.89663, 32.80949], [-116.89675, 32.80954], [-116.89685, 32.80964], [-116.89689, 32.80975], [-116.89688, 32.80981], [-116.89689, 32.80987], [-116.89694, 32.80998], [-116.897, 32.81005], [-116.89716, 32.81015], [-116.89732, 32.81018], [-116.89743, 32.81021], [-116.89752, 32.81027], [-116.89759, 32.81035], [-116.89765, 32.81048], [-116.89767, 32.81064], [-116.89762, 32.81077], [-116.89751, 32.81094], [-116.89746, 32.81105], [-116.89747, 32.81182], [-116.89748, 32.81186], [-116.89758, 32.81201], [-116.89768, 32.81209], [-116.89781, 32.81214], [-116.89801, 32.81217], [-116.89809, 32.81221], [-116.89822, 32.81233], [-116.89826, 32.81246]], [[-116.86989, 32.82199], [-116.86941, 32.82188], [-116.8692, 32.82245], [-116.8698, 32.82261], [-116.87001, 32.82204], [-116.86989, 32.82199]], [[-116.88653, 32.81516], [-116.88668, 32.81476], [-116.88566, 32.81448], [-116.8854, 32.81506], [-116.88643, 32.81537], [-116.88653, 32.81516]], [[-116.88728, 32.82623], [-116.88776, 32.8267], [-116.8884, 32.82634], [-116.88848, 32.82616], [-116.88773, 32.82522], [-116.88742, 32.82516], [-116.88709, 32.82535], [-116.88701, 32.82573], [-116.88728, 32.82623]]], [[[-116.89307, 32.79502], [-116.89303, 32.79805], [-116.89295, 32.79956], [-116.88974, 32.8021], [-116.88974, 32.80208], [-116.88925, 32.80165], [-116.88902, 32.80147], [-116.88889, 32.80129], [-116.88883, 32.80113], [-116.88881, 32.80097], [-116.88882, 32.80092], [-116.88895, 32.80074], [-116.88896, 32.80068], [-116.8889, 32.80061], [-116.88872, 32.80056], [-116.88855, 32.80046], [-116.88766, 32.79976], [-116.88743, 32.79964], [-116.8872, 32.79956], [-116.88701, 32.79952], [-116.88682, 32.7995], [-116.88651, 32.79952], [-116.88632, 32.79956], [-116.88614, 32.79962], [-116.8861, 32.79966], [-116.88608, 32.79976], [-116.88591, 32.79982], [-116.88588, 32.79984], [-116.88577, 32.79977], [-116.88553, 32.79992], [-116.88466, 32.80069], [-116.88469, 32.79425], [-116.89307, 32.79502]]], [[[-116.90141, 32.8184], [-116.90059, 32.81891], [-116.89961, 32.81854], [-116.89896, 32.81901], [-116.89789, 32.81901], [-116.89732, 32.81863], [-116.89554, 32.81807], [-116.89486, 32.81768], [-116.89484, 32.8174], [-116.89582, 32.81665], [-116.89697, 32.81678], [-116.89727, 32.8166], [-116.89736, 32.8164], [-116.89671, 32.81425], [-116.89719, 32.81441], [-116.89734, 32.81442], [-116.89746, 32.8144], [-116.8983, 32.81404], [-116.89841, 32.81402], [-116.8986, 32.81402], [-116.89869, 32.81406], [-116.89882, 32.81408], [-116.89901, 32.81407], [-116.89916, 32.81403], [-116.90008, 32.81359], [-116.90027, 32.81344], [-116.90051, 32.81502], [-116.90116, 32.8163], [-116.90116, 32.8181], [-116.90141, 32.8184]]]]}	Open Access 1	Crestridge Ecological Reserve	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Crestridge-ER	32141	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	2758.242	Crestridge ER	2000

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