units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AGENCY = 945 and MNG_AG_TYP = 13 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY
MNG_AG_TYP 1
- Water District · 3 ✖
MNG_AGENCY 1
- Monterey County Water Resources Agency · 3 ✖
DES_TP 1
AGNCY_LEV 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11482 | 11482 | 11481 | {"type": "Polygon", "coordinates": [[[-120.91526, 35.78846], [-120.91527, 35.78987], [-120.91515, 35.79239], [-120.91359, 35.79236], [-120.90224, 35.79227], [-120.90345, 35.79143], [-120.90605, 35.79048], [-120.90797, 35.7893], [-120.90973, 35.7888], [-120.9115, 35.78857], [-120.91526, 35.78846]]]} | Open Access 1 | 23113 | Lake San Antonio Recreation Area | 6818 | 2083 | Monterey County Water Resources Agency 982 | Special District 4 | Water District 13 | http://www.mcwra.co.monterey.ca.us/ | Special District 4 | 2083 | Monterey County Water Resources Agency 945 | Special District 4 | Water District 13 | http://www.co.monterey.ca.us/parks/sanantonio.html | San Luis Obispo 1 | 87.276 | Lake San Antonio Rec. Area | 0 | Local Recreation Area 3 | 4 |
11483 | 11483 | 11482 | {"type": "Polygon", "coordinates": [[[-120.95592, 35.82341], [-120.9451, 35.83277], [-120.94457, 35.83232], [-120.94388, 35.83169], [-120.94288, 35.8307], [-120.94195, 35.82968], [-120.94137, 35.82897], [-120.94059, 35.82797], [-120.93998, 35.82725], [-120.93933, 35.82656], [-120.93832, 35.82555], [-120.93723, 35.82458], [-120.93648, 35.82396], [-120.9357, 35.82337], [-120.93448, 35.82252], [-120.93364, 35.82198], [-120.93302, 35.8216], [-120.94, 35.81425], [-120.95255, 35.82143], [-120.95592, 35.82341]]]} | Open Access 1 | 23117 | Lake San Antonio Recreation Area | 6818 | 2083 | Monterey County Water Resources Agency 982 | Special District 4 | Water District 13 | http://www.mcwra.co.monterey.ca.us/ | Special District 4 | 2083 | Monterey County Water Resources Agency 945 | Special District 4 | Water District 13 | http://www.co.monterey.ca.us/parks/sanantonio.html | Monterey 14 | 500.546 | Lake San Antonio Rec. Area | 0 | Local Recreation Area 3 | 4 |
16816 | 16816 | 16815 | {"type": "Polygon", "coordinates": [[[-121.03478, 35.87389], [-121.03451, 35.89967], [-121.02864, 35.89717], [-121.02883, 35.89687], [-121.02882, 35.89686], [-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.9914, 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.87884], [-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.98255, 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.87155], [-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.97106, 35.86824], [-120.97102, 35.86808], [-120.96704, 35.86809], [-120.96704, 35.86756], [-120.96322, 35.86732], [-120.96306, 35.86728], [-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.86095], [-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.85899], [-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.85547], [-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.95018, 35.85177], [-120.95014, 35.85157], [-120.95016, 35.85144], [-120.95025, 35.85128], [-120.95039, 35.85114], [-120.95045, 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.94785, 35.84845], [-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.94706, 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.937, 35.83493], [-120.93643, 35.83462], [-120.93591, 35.83457], [-120.9354, 35.83476], [-120.93486, 35.83411], [-120.9339, 35.83404], [-120.9335, 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.92616, 35.83214], [-120.92573, 35.83176], [-120.92408, 35.83149], [-120.92333, 35.83056], [-120.92301, 35.82953], [-120.9224, 35.82816], [-120.92313, 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.91851, 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.81685], [-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.90431, 35.81506], [-120.90178, 35.81385], [-120.9014, 35.81292], [-120.90042, 35.81279], [-120.89968, 35.81189], [-120.89882, 35.81188], [-120.89604, 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.79623], [-120.87912, 35.7961], [-120.87991, 35.79414], [-120.88158, 35.79357], [-120.88278, 35.79202], [-120.90486, 35.7923], [-120.91359, 35.79236], [-120.90439, 35.7999], [-120.90439, 35.79991], [-120.91569, 35.80303], [-120.9222, 35.80307], [-120.93118, 35.80302], [-120.93118, 35.80459], [-120.94013, 35.80463], [-120.94015, 35.80344], [-120.94483, 35.80346], [-120.95921, 35.80533], [-120.95925, 35.80352], [-120.96146, 35.80353], [-120.96139, 35.80716], [-120.9633, 35.80717], [-120.96346, 35.81066], [-120.96108, 35.81066], [-120.95941, 35.81247], [-120.95949, 35.81423], [-120.96177, 35.81424], [-120.96417, 35.8187], [-120.96764, 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.82707], [-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.00783, 35.86156], [-121.01407, 35.8647], [-121.01581, 35.86195], [-121.02038, 35.86281], [-121.02349, 35.86049], [-121.02607, 35.86381], [-121.0255, 35.86419], [-121.02477, 35.8634], [-121.02383, 35.86337], [-121.02498, 35.86741], [-121.024, 35.86761], [-121.0246, 35.86984], [-121.02805, 35.87145], [-121.03072, 35.87227], [-121.03092, 35.872], [-121.03478, 35.87389]], [[-120.95071, 35.82792], [-120.95591, 35.82341], [-120.95255, 35.82143], [-120.94, 35.81425], [-120.93302, 35.8216], [-120.93448, 35.82252], [-120.9357, 35.82337], [-120.93648, 35.82396], [-120.93723, 35.82458], [-120.93832, 35.82555], [-120.93933, 35.82656], [-120.93998, 35.82725], [-120.94059, 35.82797], [-120.94137, 35.82897], [-120.94195, 35.82968], [-120.94288, 35.8307], [-120.94388, 35.83169], [-120.94457, 35.83232], [-120.9451, 35.83277], [-120.95071, 35.82792]]]} | Open Access 1 | 17228 | Lake San Antonio Recreation Area | 6818 | 2083 | Monterey County Water Resources Agency 982 | Special District 4 | Water District 13 | http://www.mcwra.co.monterey.ca.us/ | Special District 4 | 2083 | Monterey County Water Resources Agency 945 | Special District 4 | Water District 13 | http://www.co.monterey.ca.us/parks/sanantonio.html | Monterey 14 | 11872.837 | Lake San Antonio Rec. Area | 0 | Local Recreation Area 3 | 4 |
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]);