calands: superunits_with_maps: 1 row where MNG_AGENCY = 945 and MNG_AG

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

1 row where MNG_AGENCY = 945 and MNG_AG_TYP = 13

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
15401	15401	15400	{"type": "Polygon", "coordinates": [[[-121.03478, 35.87389], [-121.03451, 35.89967], [-121.02864, 35.89717], [-121.02883, 35.89687], [-121.02882, 35.89685], [-121.02791, 35.89647], [-121.02771, 35.89677], [-121.02015, 35.89355], [-121.01681, 35.89201], [-121.01527, 35.89087], [-121.01169, 35.88808], [-121.00096, 35.88079], [-120.99826, 35.8788], [-120.99141, 35.87882], [-120.99162, 35.87973], [-120.99155, 35.88069], [-120.99103, 35.88147], [-120.98952, 35.88125], [-120.98901, 35.8804], [-120.98776, 35.88038], [-120.9878, 35.87987], [-120.98805, 35.87885], [-120.98786, 35.87883], [-120.98789, 35.87853], [-120.98786, 35.87842], [-120.9878, 35.87836], [-120.98499, 35.87591], [-120.98488, 35.87574], [-120.98484, 35.87555], [-120.98494, 35.87484], [-120.98493, 35.87476], [-120.9849, 35.87467], [-120.98484, 35.87458], [-120.98363, 35.87327], [-120.98356, 35.87322], [-120.98346, 35.87318], [-120.98334, 35.87317], [-120.98256, 35.87336], [-120.98242, 35.87335], [-120.98232, 35.87331], [-120.97975, 35.87157], [-120.97774, 35.87016], [-120.97752, 35.87003], [-120.97728, 35.86993], [-120.97707, 35.86986], [-120.97677, 35.8698], [-120.97632, 35.86977], [-120.97588, 35.86981], [-120.97565, 35.86986], [-120.97539, 35.86993], [-120.97518, 35.87002], [-120.97502, 35.87011], [-120.97495, 35.87019], [-120.9749, 35.87029], [-120.97462, 35.87143], [-120.97457, 35.87151], [-120.97451, 35.87158], [-120.97444, 35.87163], [-120.97434, 35.87168], [-120.97419, 35.87171], [-120.97186, 35.87167], [-120.97177, 35.87166], [-120.97165, 35.87162], [-120.97153, 35.87156], [-120.97145, 35.87147], [-120.97041, 35.87002], [-120.97034, 35.86986], [-120.97035, 35.86973], [-120.97041, 35.86959], [-120.97099, 35.86909], [-120.97109, 35.86895], [-120.97111, 35.86879], [-120.97107, 35.86825], [-120.97102, 35.86809], [-120.96704, 35.86809], [-120.96703, 35.86756], [-120.96322, 35.86732], [-120.96306, 35.86727], [-120.96295, 35.86722], [-120.96287, 35.86714], [-120.96281, 35.86704], [-120.96278, 35.86693], [-120.9628, 35.86677], [-120.96293, 35.86654], [-120.96296, 35.86637], [-120.96295, 35.86625], [-120.96281, 35.86584], [-120.9628, 35.86574], [-120.96283, 35.86564], [-120.96295, 35.8655], [-120.96298, 35.8654], [-120.96289, 35.86493], [-120.96278, 35.86449], [-120.95819, 35.86452], [-120.95827, 35.86096], [-120.95375, 35.8609], [-120.95391, 35.86033], [-120.95369, 35.86027], [-120.95356, 35.86019], [-120.95342, 35.86007], [-120.95333, 35.85992], [-120.95331, 35.85981], [-120.95331, 35.85969], [-120.95342, 35.85922], [-120.95341, 35.85909], [-120.95336, 35.85898], [-120.95332, 35.85893], [-120.95184, 35.85763], [-120.95177, 35.8575], [-120.95175, 35.85737], [-120.9518, 35.85723], [-120.95225, 35.85672], [-120.95229, 35.85664], [-120.95231, 35.85656], [-120.95229, 35.85643], [-120.95221, 35.85632], [-120.95152, 35.85584], [-120.95146, 35.85573], [-120.95146, 35.85562], [-120.95151, 35.85552], [-120.95157, 35.85546], [-120.95177, 35.85534], [-120.95186, 35.85522], [-120.95189, 35.85506], [-120.95188, 35.85497], [-120.95184, 35.85489], [-120.95179, 35.85482], [-120.9517, 35.85475], [-120.95152, 35.85467], [-120.95136, 35.85466], [-120.95074, 35.85472], [-120.95058, 35.85469], [-120.95042, 35.85461], [-120.94979, 35.85394], [-120.94941, 35.85313], [-120.94939, 35.85304], [-120.94939, 35.85296], [-120.94946, 35.8528], [-120.94996, 35.85235], [-120.9501, 35.85215], [-120.95015, 35.85204], [-120.95018, 35.8519], [-120.95017, 35.85177], [-120.95014, 35.85157], [-120.95016, 35.85144], [-120.95025, 35.85128], [-120.95039, 35.85114], [-120.95044, 35.85107], [-120.95048, 35.85099], [-120.9505, 35.85089], [-120.95048, 35.85075], [-120.9504, 35.85062], [-120.94982, 35.85012], [-120.94972, 35.85], [-120.94964, 35.84983], [-120.94959, 35.84956], [-120.94951, 35.84942], [-120.94937, 35.84931], [-120.94917, 35.84923], [-120.94898, 35.84921], [-120.94856, 35.84923], [-120.94843, 35.84921], [-120.94835, 35.84917], [-120.94822, 35.84906], [-120.94781, 35.84841], [-120.94773, 35.84835], [-120.94762, 35.8483], [-120.94743, 35.84826], [-120.9473, 35.84827], [-120.94717, 35.84831], [-120.94707, 35.84837], [-120.94698, 35.84845], [-120.94691, 35.84856], [-120.94672, 35.84922], [-120.94657, 35.84939], [-120.94637, 35.8495], [-120.94622, 35.84954], [-120.9461, 35.84956], [-120.94565, 35.84954], [-120.94528, 35.84946], [-120.94487, 35.8493], [-120.94461, 35.84915], [-120.9445, 35.84902], [-120.94447, 35.84893], [-120.94445, 35.84884], [-120.94448, 35.8486], [-120.94446, 35.8484], [-120.94437, 35.84813], [-120.94409, 35.84755], [-120.94385, 35.8471], [-120.94368, 35.8469], [-120.94352, 35.84675], [-120.94317, 35.84651], [-120.94284, 35.84635], [-120.9408, 35.84562], [-120.93928, 35.84511], [-120.93825, 35.84387], [-120.93748, 35.84115], [-120.93764, 35.83999], [-120.93821, 35.83864], [-120.93789, 35.83801], [-120.93847, 35.83722], [-120.93854, 35.83673], [-120.93853, 35.8362], [-120.93793, 35.83579], [-120.93741, 35.83581], [-120.93699, 35.83493], [-120.93643, 35.83462], [-120.93591, 35.83457], [-120.9354, 35.83476], [-120.93486, 35.83411], [-120.9339, 35.83404], [-120.93349, 35.83368], [-120.93174, 35.83431], [-120.93078, 35.83398], [-120.92966, 35.83391], [-120.92835, 35.83257], [-120.92746, 35.83233], [-120.92671, 35.83275], [-120.92632, 35.83269], [-120.92615, 35.83214], [-120.92573, 35.83176], [-120.92408, 35.83149], [-120.92333, 35.83056], [-120.92301, 35.82953], [-120.9224, 35.82816], [-120.92312, 35.82638], [-120.92285, 35.8256], [-120.92241, 35.82523], [-120.92168, 35.82477], [-120.92088, 35.82463], [-120.91935, 35.82527], [-120.91874, 35.82528], [-120.91834, 35.825], [-120.9185, 35.82435], [-120.91732, 35.82351], [-120.91684, 35.82167], [-120.91623, 35.82112], [-120.91561, 35.82104], [-120.91428, 35.82152], [-120.91257, 35.8217], [-120.91177, 35.82147], [-120.91015, 35.81998], [-120.9097, 35.81988], [-120.90921, 35.82011], [-120.90891, 35.8199], [-120.90874, 35.81904], [-120.90844, 35.81876], [-120.90806, 35.81859], [-120.90803, 35.81807], [-120.90745, 35.81761], [-120.90669, 35.81822], [-120.90626, 35.81799], [-120.90634, 35.81686], [-120.9059, 35.8166], [-120.90494, 35.81647], [-120.90316, 35.81719], [-120.90283, 35.81691], [-120.90293, 35.81661], [-120.90349, 35.81633], [-120.9043, 35.81505], [-120.90178, 35.81385], [-120.9014, 35.81292], [-120.90042, 35.81279], [-120.89968, 35.81189], [-120.89882, 35.81188], [-120.89605, 35.80857], [-120.89603, 35.80858], [-120.89605, 35.81034], [-120.89162, 35.81031], [-120.88719, 35.80649], [-120.87824, 35.80638], [-120.87827, 35.7984], [-120.879, 35.79839], [-120.87972, 35.79624], [-120.87912, 35.7961], [-120.87991, 35.79414], [-120.88158, 35.79357], [-120.88278, 35.79202], [-120.90224, 35.79227], [-120.90345, 35.79143], [-120.90605, 35.79048], [-120.90798, 35.7893], [-120.90973, 35.7888], [-120.9115, 35.78857], [-120.91526, 35.78846], [-120.91527, 35.78987], [-120.91515, 35.79239], [-120.91359, 35.79236], [-120.90439, 35.7999], [-120.90439, 35.79992], [-120.91569, 35.80303], [-120.9222, 35.80307], [-120.93118, 35.80302], [-120.93119, 35.80459], [-120.94012, 35.80463], [-120.94015, 35.80344], [-120.94483, 35.80346], [-120.9592, 35.80533], [-120.95925, 35.80352], [-120.96146, 35.80353], [-120.96139, 35.80715], [-120.9633, 35.80717], [-120.96346, 35.81066], [-120.96107, 35.81066], [-120.95942, 35.81247], [-120.9595, 35.81423], [-120.96177, 35.81424], [-120.96417, 35.8187], [-120.96763, 35.82136], [-120.97469, 35.82132], [-120.97503, 35.82095], [-120.97508, 35.82171], [-120.97594, 35.82219], [-120.97632, 35.82383], [-120.97685, 35.82456], [-120.97745, 35.82488], [-120.97831, 35.82706], [-120.9788, 35.82745], [-120.97979, 35.82749], [-120.98001, 35.8281], [-120.98315, 35.83373], [-120.99672, 35.85028], [-121.00918, 35.85932], [-121.00784, 35.86157], [-121.01407, 35.8647], [-121.01581, 35.86195], [-121.02038, 35.8628], [-121.02349, 35.86049], [-121.02607, 35.86381], [-121.0255, 35.86419], [-121.02477, 35.86341], [-121.02384, 35.86338], [-121.02498, 35.86741], [-121.024, 35.86762], [-121.0246, 35.86984], [-121.02805, 35.87145], [-121.03071, 35.87227], [-121.03092, 35.872], [-121.03478, 35.87389]]]}	Open Access 1	Lake San Antonio Recreation Area	http://www.co.monterey.ca.us/parks/sanantonio.html	6818	2083	Monterey County Water Resources Agency 945	Special District 4	Water District 13	http://www.mcwra.co.monterey.ca.us/	Special District 4	12461.092	Lake San Antonio Rec. Area

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