calands: superunits_with_maps: 1 row where ACCESS_TYP = 3 and YR

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

1 row where ACCESS_TYP = 3 and YR_EST = 1933

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
12292	12292	12291	{"type": "MultiPolygon", "coordinates": [[[[-116.10313, 32.97253], [-116.08534, 32.97217], [-116.06792, 32.9725], [-116.05047, 32.97274], [-116.03293, 32.97275], [-116.0329, 32.94732], [-115.9981, 32.94734], [-115.99811, 32.91832], [-116.0064, 32.91832], [-116.00641, 32.91436], [-116.011, 32.91439], [-116.01099, 32.91832], [-116.01542, 32.91832], [-116.01532, 32.90382], [-115.99811, 32.90381], [-115.99809, 32.89992], [-115.98549, 32.89992], [-115.98547, 32.89629], [-115.98544, 32.85633], [-116.00259, 32.85632], [-116.01982, 32.85635], [-116.03708, 32.8563], [-116.05427, 32.85633], [-116.07149, 32.85628], [-116.10254, 32.85628], [-116.10241, 32.85775], [-116.10377, 32.88899], [-116.10332, 32.89611], [-116.10334, 32.90363], [-116.10325, 32.91815], [-116.1032, 32.94713], [-116.10313, 32.97253]], [[-116.06794, 32.96175], [-116.06798, 32.94726], [-116.05046, 32.94736], [-116.05047, 32.96187], [-116.06794, 32.96175]], [[-116.06858, 32.87224], [-116.0686, 32.87223], [-116.06867, 32.85754], [-116.05054, 32.85747], [-116.05053, 32.8721], [-116.06858, 32.87224]]], [[[-116.08442, 33.33923], [-116.067, 33.33919], [-116.04977, 33.3391], [-116.03248, 33.33904], [-116.01568, 33.339], [-116.01214, 33.33901], [-116.01231, 33.3389], [-116.01218, 33.33872], [-116.01207, 33.33869], [-116.01196, 33.33864], [-116.01182, 33.3385], [-116.0118, 33.33847], [-116.01177, 33.33806], [-116.00945, 33.33805], [-116.00893, 33.33786], [-116.00864, 33.33771], [-116.00861, 33.33772], [-116.00835, 33.33754], [-116.00819, 33.3374], [-116.00791, 33.33709], [-116.00779, 33.33691], [-116.0021, 33.32939], [-116.00204, 33.32921], [-116.00202, 33.3291], [-116.00202, 33.32888], [-116.00227, 33.32779], [-116.0023, 33.32753], [-116.00228, 33.32728], [-116.00224, 33.32715], [-116.00214, 33.32691], [-116.00197, 33.32662], [-116.00247, 33.32632], [-116.00331, 33.3259], [-116.00317, 33.3257], [-116.00231, 33.32612], [-116.00179, 33.32632], [-116.00162, 33.32612], [-116.0014, 33.32593], [-116.00128, 33.32585], [-116.00101, 33.32571], [-116.00071, 33.3256], [-115.99955, 33.32533], [-115.99917, 33.32516], [-115.99895, 33.32501], [-115.99877, 33.32483], [-115.99869, 33.3244], [-115.99864, 33.32431], [-115.99855, 33.32426], [-115.99844, 33.32424], [-115.99836, 33.32425], [-115.99822, 33.32432], [-115.99808, 33.32411], [-115.99843, 33.32374], [-115.99897, 33.32328], [-115.99988, 33.3227], [-116.00023, 33.32253], [-116.00053, 33.32241], [-116.00079, 33.3224], [-116.00101, 33.32231], [-116.0012, 33.32205], [-116.00123, 33.32173], [-116.00134, 33.32158], [-116.00153, 33.32145], [-116.00174, 33.32141], [-116.00196, 33.32145], [-116.00219, 33.32157], [-116.00235, 33.3216], [-116.00257, 33.32157], [-116.00276, 33.32149], [-116.00298, 33.32131], [-116.0034, 33.32087], [-116.00368, 33.32069], [-116.00397, 33.32061], [-116.00444, 33.32054], [-116.00477, 33.32052], [-116.00553, 33.32038], [-116.00585, 33.32027], [-116.00613, 33.32024], [-116.00634, 33.32024], [-116.00671, 33.32003], [-116.00695, 33.31968], [-116.00712, 33.31954], [-116.00735, 33.31946], [-116.0076, 33.3194], [-116.00828, 33.31941], [-116.00843, 33.31934], [-116.00855, 33.31915], [-116.00856, 33.31893], [-116.00851, 33.31868], [-116.00855, 33.31849], [-116.0087, 33.31833], [-116.00893, 33.31819], [-116.00945, 33.31799], [-116.00993, 33.31784], [-116.01006, 33.31776], [-116.01013, 33.31754], [-116.01009, 33.31729], [-116.01016, 33.3171], [-116.01035, 33.31702], [-116.01069, 33.31698], [-116.01097, 33.31697], [-116.01123, 33.317], [-116.01146, 33.31701], [-116.01165, 33.31694], [-116.01178, 33.31681], [-116.01179, 33.31668], [-116.01172, 33.31656], [-116.01162, 33.31646], [-116.01112, 33.31636], [-116.01087, 33.31636], [-116.01067, 33.3163], [-116.01054, 33.31619], [-116.01049, 33.31601], [-116.01054, 33.31584], [-116.01065, 33.31576], [-116.0114, 33.31576], [-116.01221, 33.31569], [-116.01303, 33.31575], [-116.01329, 33.31569], [-116.01367, 33.31551], [-116.01394, 33.31529], [-116.01423, 33.3151], [-116.01489, 33.31473], [-116.0151, 33.31465], [-116.01527, 33.31465], [-116.0155, 33.3147], [-116.01575, 33.31466], [-116.01632, 33.31446], [-116.01658, 33.31444], [-116.017, 33.31434], [-116.01721, 33.31442], [-116.01754, 33.31467], [-116.01765, 33.31468], [-116.01779, 33.31461], [-116.01787, 33.31449], [-116.01803, 33.31418], [-116.01812, 33.31411], [-116.01823, 33.31409], [-116.01837, 33.31411], [-116.01845, 33.31416], [-116.01864, 33.31463], [-116.01882, 33.31478], [-116.01899, 33.31495], [-116.01908, 33.31514], [-116.01921, 33.31518], [-116.01935, 33.31514], [-116.01951, 33.31505], [-116.01967, 33.31499], [-116.01979, 33.31499], [-116.02025, 33.31518], [-116.02041, 33.31519], [-116.02059, 33.31517], [-116.02069, 33.31523], [-116.02078, 33.31534], [-116.02093, 33.31545], [-116.02109, 33.31551], [-116.02187, 33.3154], [-116.02225, 33.3155], [-116.02249, 33.31568], [-116.0226, 33.31571], [-116.02279, 33.31562], [-116.02278, 33.31557], [-116.02257, 33.31531], [-116.02254, 33.31516], [-116.02263, 33.31509], [-116.0227, 33.31506], [-116.02294, 33.31504], [-116.02362, 33.31519], [-116.02393, 33.31522], [-116.02423, 33.3152], [-116.02469, 33.3151], [-116.02541, 33.3149], [-116.02582, 33.3147], [-116.02629, 33.3144], [-116.02681, 33.314], [-116.02702, 33.31394], [-116.02727, 33.31389], [-116.02726, 33.31421], [-116.02728, 33.31434], [-116.02738, 33.31447], [-116.02761, 33.3146], [-116.02791, 33.31457], [-116.02808, 33.31462], [-116.0282, 33.31478], [-116.02834, 33.31491], [-116.02857, 33.31501], [-116.02882, 33.31508], [-116.02935, 33.3153], [-116.02948, 33.31544], [-116.02958, 33.31557], [-116.0297, 33.31556], [-116.02993, 33.31541], [-116.02996, 33.3153], [-116.03002, 33.31521], [-116.03003, 33.31511], [-116.03021, 33.31491], [-116.03023, 33.31476], [-116.03031, 33.31469], [-116.03034, 33.31461], [-116.03034, 33.3144], [-116.03043, 33.31432], [-116.03057, 33.31425], [-116.03069, 33.31425], [-116.03105, 33.31437], [-116.03123, 33.31445], [-116.03136, 33.31448], [-116.03159, 33.31431], [-116.03184, 33.31417], [-116.03188, 33.31411], [-116.03218, 33.31406], [-116.03232, 33.31406], [-116.03302, 33.31383], [-116.03336, 33.31391], [-116.03351, 33.31387], [-116.0336, 33.3138], [-116.03358, 33.31362], [-116.03361, 33.31359], [-116.03366, 33.31355], [-116.03369, 33.3135], [-116.03382, 33.31343], [-116.03387, 33.31344], [-116.0341, 33.31362], [-116.0342, 33.31366], [-116.03433, 33.31366], [-116.0345, 33.31359], [-116.0348, 33.31355], [-116.03491, 33.31356], [-116.03518, 33.31362], [-116.03535, 33.31351], [-116.03538, 33.31341], [-116.03536, 33.31328], [-116.03539, 33.3132], [-116.03544, 33.3131], [-116.03554, 33.31306], [-116.03563, 33.31308], [-116.03573, 33.31318], [-116.0359, 33.3132], [-116.03607, 33.31324], [-116.03616, 33.31324], [-116.03631, 33.31327], [-116.0364, 33.31335], [-116.03644, 33.31342], [-116.03636, 33.31362], [-116.03636, 33.31374], [-116.03644, 33.31384], [-116.03655, 33.31388], [-116.03662, 33.31393], [-116.03662, 33.314], [-116.03666, 33.31409], [-116.03683, 33.31429], [-116.03682, 33.31436], [-116.03689, 33.31447], [-116.03698, 33.31449], [-116.03708, 33.31443], [-116.03713, 33.31433], [-116.03726, 33.31422], [-116.03749, 33.31417], [-116.03759, 33.3141], [-116.03782, 33.31399], [-116.03806, 33.31386], [-116.03831, 33.31386], [-116.0385, 33.31389], [-116.03859, 33.31395], [-116.03846, 33.31425], [-116.03835, 33.31448], [-116.03831, 33.31467], [-116.03834, 33.31485], [-116.03847, 33.31511], [-116.03859, 33.31523], [-116.03875, 33.3153], [-116.03911, 33.3154], [-116.0392, 33.31548], [-116.03923, 33.31571], [-116.0393, 33.3158], [-116.03943, 33.31584], [-116.03957, 33.31583], [-116.03979, 33.31577], [-116.04001, 33.31569], [-116.04025, 33.31563], [-116.04042, 33.31554], [-116.04089, 33.31523], [-116.04114, 33.31519], [-116.04134, 33.31524], [-116.04199, 33.31565], [-116.04233, 33.31584], [-116.04267, 33.31608], [-116.04277, 33.31623], [-116.04281, 33.3165], [-116.04276, 33.31669], [-116.04267, 33.31686], [-116.04272, 33.317], [-116.04285, 33.31719], [-116.04312, 33.31733], [-116.04353, 33.31734], [-116.04386, 33.31718], [-116.04415, 33.31675], [-116.0442, 33.31662], [-116.04446, 33.31649], [-116.0446, 33.31648], [-116.04474, 33.31649], [-116.04487, 33.31656], [-116.04511, 33.31694], [-116.0452, 33.31704], [-116.04529, 33.3172], [-116.04547, 33.31744], [-116.04569, 33.31763], [-116.04595, 33.31775], [-116.04615, 33.31778], [-116.0463, 33.31774], [-116.04637, 33.31767], [-116.04671, 33.31713], [-116.04698, 33.31675], [-116.0471, 33.31644], [-116.04722, 33.31623], [-116.0472, 33.31613], [-116.04723, 33.31601], [-116.04713, 33.31587], [-116.0469, 33.31563], [-116.04686, 33.31536], [-116.04705, 33.31513], [-116.04726, 33.31505], [-116.04733, 33.31501], [-116.04757, 33.31479], [-116.04781, 33.31469], [-116.04798, 33.31462], [-116.04831, 33.31462], [-116.0485, 33.31456], [-116.04879, 33.31442], [-116.04923, 33.31435], [-116.04943, 33.31419], [-116.04946, 33.31395], [-116.04952, 33.31375], [-116.04966, 33.31361], [-116.04964, 33.30977], [-116.06695, 33.30979], [-116.06692, 33.2951], [-116.06994, 33.2951], [-116.06995, 33.29509], [-116.06983, 33.29504], [-116.06961, 33.29498], [-116.06944, 33.29489], [-116.06923, 33.29455], [-116.0692, 33.29443], [-116.06918, 33.29421], [-116.06911, 33.29415], [-116.06887, 33.29414], [-116.06867, 33.29416], [-116.06821, 33.29436], [-116.0681, 33.29437], [-116.06796, 33.2943], [-116.06785, 33.29416], [-116.06781, 33.294], [-116.0678, 33.2938], [-116.06785, 33.29368], [-116.06812, 33.29345], [-116.06817, 33.29336], [-116.06815, 33.29329], [-116.06809, 33.2932], [-116.06807, 33.29311], [-116.06807, 33.293], [-116.0681, 33.29295], [-116.06816, 33.29289], [-116.06858, 33.29275], [-116.06868, 33.29268], [-116.06871, 33.29263], [-116.06872, 33.29258], [-116.06867, 33.29253], [-116.06846, 33.29253], [-116.06835, 33.29249], [-116.06813, 33.29227], [-116.06812, 33.29219], [-116.06814, 33.29202], [-116.06809, 33.29194], [-116.06799, 33.29187], [-116.06788, 33.29183], [-116.06775, 33.29185], [-116.06767, 33.29192], [-116.06759, 33.29204], [-116.06743, 33.2922], [-116.06734, 33.29226], [-116.06724, 33.29228], [-116.06711, 33.29225], [-116.06699, 33.2922], [-116.06691, 33.29214], [-116.06684, 33.29202], [-116.06666, 33.29178], [-116.06664, 33.2917], [-116.06664, 33.29156], [-116.06672, 33.29137], [-116.06685, 33.2912], [-116.0669, 33.29109], [-116.0669, 33.29093], [-116.06687, 33.29083], [-116.06681, 33.29077], [-116.06674, 33.29075], [-116.06647, 33.29089], [-116.0663, 33.29093], [-116.0661, 33.29094], [-116.06595, 33.29091], [-116.06586, 33.29084], [-116.06583, 33.29073], [-116.06581, 33.29033], [-116.06577, 33.29023], [-116.06571, 33.29015], [-116.06563, 33.29012], [-116.06552, 33.2901], [-116.06536, 33.29009], [-116.06523, 33.29012], [-116.06512, 33.29011], [-116.06493, 33.29], [-116.06484, 33.28994], [-116.06473, 33.28974], [-116.06463, 33.28962], [-116.06438, 33.28943], [-116.064, 33.28927], [-116.06369, 33.28917], [-116.06339, 33.28904], [-116.06369, 33.28857], [-116.06393, 33.28814], [-116.06406, 33.28768], [-116.06425, 33.28751], [-116.0645, 33.28746], [-116.06512, 33.28755], [-116.06617, 33.28791], [-116.0669, 33.28802], [-116.06757, 33.28801], [-116.06806, 33.28795], [-116.06878, 33.28799], [-116.06903, 33.28797], [-116.06921, 33.28789], [-116.06955, 33.28762], [-116.06967, 33.28749], [-116.06975, 33.28728], [-116.06983, 33.28718], [-116.07, 33.28709], [-116.07018, 33.28705], [-116.07082, 33.28704], [-116.07152, 33.2871], [-116.07182, 33.28716], [-116.07255, 33.28741], [-116.0731, 33.28764], [-116.07348, 33.28772], [-116.07379, 33.28774], [-116.07399, 33.28766], [-116.07413, 33.28751], [-116.07419, 33.2873], [-116.07423, 33.28692], [-116.07425, 33.28685], [-116.07433, 33.28671], [-116.0746, 33.28648], [-116.0747, 33.28645], [-116.07504, 33.28658], [-116.07536, 33.28666], [-116.07562, 33.28676], [-116.07577, 33.2868], [-116.07592, 33.2868], [-116.07617, 33.28673], [-116.07634, 33.28657], [-116.07656, 33.28644], [-116.07703, 33.2864], [-116.07715, 33.28638], [-116.07735, 33.28642], [-116.07765, 33.28652], [-116.07793, 33.28668], [-116.07829, 33.28707], [-116.07839, 33.28714], [-116.07854, 33.28716], [-116.07864, 33.28715], [-116.07878, 33.28709], [-116.07906, 33.28677], [-116.07929, 33.28654], [-116.07969, 33.28629], [-116.08001, 33.28622], [-116.08032, 33.28626], [-116.0806, 33.28643], [-116.0809, 33.28655], [-116.0812, 33.28664], [-116.08142, 33.28663], [-116.08146, 33.2865], [-116.08143, 33.28638], [-116.08133, 33.28619], [-116.08119, 33.28605], [-116.08118, 33.28587], [-116.08139, 33.28572], [-116.08163, 33.28558], [-116.08193, 33.28546], [-116.08207, 33.2853], [-116.08206, 33.28519], [-116.0821, 33.28509], [-116.08231, 33.28494], [-116.08252, 33.28482], [-116.08274, 33.28483], [-116.08295, 33.28492], [-116.08318, 33.28498], [-116.0834, 33.28491], [-116.08389, 33.2844], [-116.084, 33.28417], [-116.08407, 33.28397], [-116.08441, 33.28392], [-116.08441, 33.30246], [-116.0844, 33.30978], [-116.08442, 33.3098], [-116.08442, 33.33923]], [[-116.03243, 33.32451], [-116.01535, 33.32447], [-116.01551, 33.33172], [-116.0282, 33.33176], [-116.02819, 33.32812], [-116.03244, 33.32812], [-116.03243, 33.32451]], [[-116.03247, 33.33856], [-116.03249, 33.33858], [-116.03255, 33.33856], [-116.03247, 33.3328], [-116.03247, 33.33856]]], [[[-116.00161, 33.32639], [-116.00058, 33.32661], [-115.99915, 33.32552], [-115.99879, 33.32506], [-115.99894, 33.32522], [-115.9992, 33.32537], [-115.99934, 33.32544], [-115.99963, 33.32553], [-116.00065, 33.32576], [-116.00092, 33.32585], [-116.00104, 33.32591], [-116.00127, 33.32605], [-116.00147, 33.32622], [-116.00161, 33.32639]]], [[[-116.00188, 33.32936], [-116.00116, 33.32817], [-116.00122, 33.32711], [-116.00182, 33.32673], [-116.00195, 33.32697], [-116.00204, 33.32718], [-116.00207, 33.3273], [-116.0021, 33.32752], [-116.00207, 33.32775], [-116.00181, 33.32886], [-116.00182, 33.32911], [-116.00184, 33.32924], [-116.00188, 33.32936]]]]}	No Public Access 3	Anza-Borrego Desert State Park	http://www.parks.ca.gov/?page_id=638	30751	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	34664.425	Anza-Borrego Desert SP	1933

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