superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where MNG_AGENCY = 128 and MNG_AG_TYP = 5 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9976 | 9976 | 9975 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.0495, 36.9493], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.0498, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | Open Access 1 | Stockton Avenue Beach | 25857 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 0.139 | Stockton Avenue Beach | |||
5090 | 5090 | 5089 | {"type": "Polygon", "coordinates": [[[-121.88959, 36.95741], [-121.88855, 36.95826], [-121.88843, 36.95817], [-121.88948, 36.95731], [-121.88959, 36.95741]]]} | Open Access 1 | Hidden Beach | 19901 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 0.487 | Hidden Beach | |||
7803 | 7803 | 7802 | {"type": "Polygon", "coordinates": [[[-119.21361, 38.30059], [-119.21338, 38.30059], [-119.21339, 38.29848], [-119.21349, 38.29872], [-119.21356, 38.29909], [-119.21361, 38.30059]]]} | Open Access 1 | Other State 26 | 23258 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 0.864 | Other State 26 | |||
7799 | 7799 | 7798 | {"type": "Polygon", "coordinates": [[[-123.67237, 40.14091], [-123.67235, 40.14147], [-123.67148, 40.1415], [-123.6715, 40.14089], [-123.67237, 40.14091]]]} | Open Access 1 | Other State 14 | 23252 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 1.203 | Other State 14 | |||
7622 | 7622 | 7621 | {"type": "MultiPolygon", "coordinates": [[[[-121.99494, 36.98782], [-121.99458, 36.98781], [-121.99399, 36.98777], [-121.99412, 36.98737], [-121.99417, 36.98738], [-121.99467, 36.98768], [-121.99482, 36.98772], [-121.99494, 36.98782]]], [[[-121.99677, 36.98791], [-121.99677, 36.98791], [-121.99571, 36.98786], [-121.99615, 36.98769], [-121.99642, 36.98771], [-121.99677, 36.98791]]], [[[-122.01191, 36.97056], [-122.01184, 36.97079], [-122.01121, 36.97116], [-122.0112, 36.97122], [-122.01103, 36.97109], [-122.01178, 36.97054], [-122.0118, 36.97027], [-122.01191, 36.96996], [-122.01196, 36.97022], [-122.01191, 36.97056]]]]} | Open Access 1 | Ocean View Park | 23056 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 1.415 | Ocean View Park | |||
7798 | 7798 | 7797 | {"type": "Polygon", "coordinates": [[[-123.67235, 40.14486], [-123.67136, 40.14484], [-123.67139, 40.14413], [-123.67233, 40.14419], [-123.67235, 40.14486]]]} | Open Access 1 | Other State 11 | 23251 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 1.561 | Other State 11 | |||
7810 | 7810 | 7809 | {"type": "Polygon", "coordinates": [[[-123.78183, 40.4786], [-123.78172, 40.47967], [-123.78083, 40.47987], [-123.78082, 40.47937], [-123.78064, 40.47893], [-123.78183, 40.4786]]]} | Open Access 1 | Other State 43 | 23264 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 2.359 | Other State 43 | |||
7801 | 7801 | 7800 | {"type": "Polygon", "coordinates": [[[-123.62865, 40.48836], [-123.62865, 40.48852], [-123.62837, 40.48861], [-123.62769, 40.48868], [-123.62714, 40.48877], [-123.62629, 40.48945], [-123.62628, 40.48822], [-123.62671, 40.48819], [-123.62692, 40.48819], [-123.62683, 40.48844], [-123.62684, 40.48846], [-123.62714, 40.48835], [-123.62753, 40.4883], [-123.62865, 40.48836]]]} | Open Access 1 | Other State 18 | 23254 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 2.877 | Other State 18 | |||
6113 | 6113 | 6112 | {"type": "Polygon", "coordinates": [[[-120.50114, 37.29562], [-120.50068, 37.29642], [-120.49943, 37.29596], [-120.49989, 37.29516], [-120.50114, 37.29562]]]} | Open Access 1 | Leonard Park | 21174 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 2.938 | Leonard Park | |||
7811 | 7811 | 7810 | {"type": "Polygon", "coordinates": [[[-123.84468, 40.46319], [-123.84303, 40.46319], [-123.84302, 40.4623], [-123.8433, 40.46219], [-123.84379, 40.4621], [-123.84428, 40.46233], [-123.8444, 40.46257], [-123.84445, 40.46277], [-123.84468, 40.46319]]]} | Open Access 1 | Other State 5 | 23265 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 3.303 | Other State 5 | |||
3451 | 3451 | 3450 | {"type": "Polygon", "coordinates": [[[-122.21602, 37.02342], [-122.21509, 37.02378], [-122.2149, 37.02335], [-122.21472, 37.02237], [-122.21561, 37.02182], [-122.21602, 37.02342]]]} | Open Access 1 | Davenport Landing Beach | 17938 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 3.923 | Davenport Landing Beach | |||
7805 | 7805 | 7804 | {"type": "Polygon", "coordinates": [[[-123.84302, 40.46142], [-123.84302, 40.4623], [-123.84241, 40.46266], [-123.84217, 40.46286], [-123.84184, 40.46272], [-123.84171, 40.46257], [-123.84194, 40.46247], [-123.84193, 40.46233], [-123.84169, 40.46226], [-123.84173, 40.46216], [-123.84179, 40.46206], [-123.84179, 40.46192], [-123.84166, 40.46178], [-123.84133, 40.46157], [-123.84123, 40.46146], [-123.84168, 40.46116], [-123.8422, 40.4614], [-123.84302, 40.46142]]]} | Open Access 1 | Other State 37 | 23260 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 4.071 | Other State 37 | |||
10503 | 10503 | 10502 | {"type": "Polygon", "coordinates": [[[-120.46492, 37.66834], [-120.46421, 37.66774], [-120.4619, 37.66728], [-120.4618, 37.66725], [-120.46168, 37.66715], [-120.46163, 37.66704], [-120.46164, 37.66696], [-120.4617, 37.66675], [-120.46266, 37.66675], [-120.4649, 37.66747], [-120.46492, 37.66834]]]} | Open Access 1 | Tuolumne River Restoration Center | 26580 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 4.72 | Tuolumne River Restoration Ctr. | |||
4420 | 4420 | 4419 | {"type": "Polygon", "coordinates": [[[-119.71275, 36.9916], [-119.71191, 36.99249], [-119.7112, 36.99207], [-119.71091, 36.99196], [-119.71085, 36.99186], [-119.71077, 36.99183], [-119.71053, 36.99176], [-119.71044, 36.99178], [-119.71062, 36.99139], [-119.71109, 36.99063], [-119.71154, 36.99058], [-119.71275, 36.9916]]]} | Open Access 1 | Friant Cove | 19113 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 5.884 | Friant Cove | |||
12104 | 12104 | 12103 | {"type": "Polygon", "coordinates": [[[-118.65109, 34.03761], [-118.65102, 34.03789], [-118.65008, 34.03771], [-118.64961, 34.03764], [-118.64922, 34.03765], [-118.64889, 34.0377], [-118.64882, 34.03758], [-118.64861, 34.03759], [-118.64839, 34.0377], [-118.64783, 34.03813], [-118.64748, 34.03823], [-118.64702, 34.03832], [-118.64694, 34.0382], [-118.64591, 34.03819], [-118.64439, 34.03805], [-118.64366, 34.03796], [-118.64298, 34.03782], [-118.64224, 34.03772], [-118.63951, 34.03714], [-118.6382, 34.03681], [-118.63828, 34.0365], [-118.63964, 34.03684], [-118.64039, 34.03708], [-118.64171, 34.03736], [-118.64261, 34.03748], [-118.64325, 34.03763], [-118.64555, 34.03791], [-118.64655, 34.03796], [-118.64744, 34.03791], [-118.64803, 34.03772], [-118.64845, 34.03742], [-118.64906, 34.0373], [-118.64975, 34.03736], [-118.65109, 34.03761]]]} | Open Access 1 | La Costa Beach | 29045 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 9.124 | La Costa Beach | |||
13249 | 13249 | 13248 | {"type": "Polygon", "coordinates": [[[-124.11238, 40.99977], [-124.11173, 41.00363], [-124.1111, 41.00601], [-124.11088, 41.00673], [-124.10992, 41.00671], [-124.11008, 41.00583], [-124.11159, 41.00045], [-124.11204, 40.99978], [-124.11238, 40.99977]]]} | Unknown Access 4 | Clam Beach Ponds | 30554 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 14.52 | Clam Beach Ponds | |||
7809 | 7809 | 7808 | {"type": "Polygon", "coordinates": [[[-123.83901, 40.46367], [-123.839, 40.46751], [-123.83762, 40.46759], [-123.83761, 40.46748], [-123.83744, 40.46699], [-123.83691, 40.46742], [-123.83606, 40.46793], [-123.83527, 40.46801], [-123.83421, 40.46791], [-123.83495, 40.46784], [-123.83542, 40.46767], [-123.83587, 40.46725], [-123.83707, 40.46639], [-123.83754, 40.46561], [-123.8379, 40.46507], [-123.83813, 40.46474], [-123.83856, 40.46406], [-123.83884, 40.46367], [-123.83901, 40.46367]]]} | Open Access 1 | Other State 4 | 23263 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 14.858 | Other State 4 | |||
7802 | 7802 | 7801 | {"type": "Polygon", "coordinates": [[[-121.0547, 39.80881], [-121.05325, 39.80955], [-121.05329, 39.80949], [-121.04991, 39.8062], [-121.05152, 39.80559], [-121.0547, 39.80881]]]} | Open Access 1 | Other State 23 | 23256 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 16.582 | Other State 23 | |||
9180 | 9180 | 9179 | {"type": "Polygon", "coordinates": [[[-116.90615, 32.72851], [-116.90484, 32.7283], [-116.90399, 32.72803], [-116.90394, 32.72518], [-116.90608, 32.72533], [-116.90615, 32.72851]]]} | Open Access 1 | San Diego National Wildlife Refuge | 24858 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 16.777 | San Diego NWR | 1996 | ||
7808 | 7808 | 7807 | {"type": "Polygon", "coordinates": [[[-119.79203, 36.87905], [-119.79109, 36.87905], [-119.79022, 36.87875], [-119.79018, 36.87791], [-119.7879, 36.87794], [-119.7874, 36.87857], [-119.78724, 36.87929], [-119.78642, 36.87929], [-119.78673, 36.87858], [-119.78817, 36.87701], [-119.79199, 36.87641], [-119.79203, 36.87905]]]} | Open Access 1 | Other State 39 | 23262 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 19.325 | Other State 39 |
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]);