units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 128 and MNG_AG_TYP = 5 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
325 | 325 | 324 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.04949, 36.94929], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.04979, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | Open Access 1 | 1106 | Stockton Avenue Beach | 25857 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 0.139 | Stockton Avenue Beach | None 33 | ||||
4682 | 4682 | 4681 | {"type": "Polygon", "coordinates": [[[-121.68569, 36.44484], [-121.68518, 36.44573], [-121.68502, 36.44565], [-121.68518, 36.44552], [-121.68529, 36.44539], [-121.68537, 36.44527], [-121.68545, 36.44508], [-121.6855, 36.44499], [-121.68558, 36.44491], [-121.68569, 36.44484]]]} | Open Access 1 | 43073 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 0.221 | 0 | State Other or Unknown 104 | 4 | |||
2266 | 2266 | 2265 | {"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 | 16858 | Hidden Beach | 19901 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 0.488 | Hidden Beach | None 188 | ||||
3933 | 3933 | 3932 | {"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 | 36234 | Other State 26 | 23258 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Mono 32 | 0.864 | Other State 26 | None 338 | ||||
3862 | 3862 | 3861 | {"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 | 35608 | Other State 14 | 23252 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 1.203 | Other State 14 | None 329 | ||||
10344 | 10344 | 10343 | {"type": "MultiPolygon", "coordinates": [[[[-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]]], [[[-121.99494, 36.98782], [-121.99458, 36.98781], [-121.99399, 36.98777], [-121.99412, 36.98737], [-121.99417, 36.98738], [-121.99467, 36.98769], [-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]]]]} | Open Access 1 | 18253 | Ocean View Park | 23056 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 1.414 | Ocean View Park | 0 | None 904 | |||
3467 | 3467 | 3466 | {"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 | 35712 | Other State 11 | 23251 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 1.562 | Other State 11 | None 289 | ||||
3458 | 3458 | 3457 | {"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 | 35585 | Other State 43 | 23264 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 2.359 | Other State 43 | None 287 | ||||
3861 | 3861 | 3860 | {"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.62682, 40.48845], [-123.62683, 40.48846], [-123.62714, 40.48835], [-123.62753, 40.4883], [-123.62865, 40.48836]]]} | Open Access 1 | 35607 | Other State 18 | 23254 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 2.876 | Other State 18 | None 328 | ||||
9878 | 9878 | 9877 | {"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 | 16947 | Leonard Park | 21174 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Merced 37 | 2.938 | Leonard Park | None 856 | ||||
3860 | 3860 | 3859 | {"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 | 35598 | Other State 5 | 23265 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 3.304 | Other State 5 | None 327 | ||||
8380 | 8380 | 8379 | {"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 | 12975 | Davenport Landing Beach | 17938 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 3.924 | Davenport Landing Beach | None 701 | ||||
13746 | 13746 | 13745 | {"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.46248], [-123.84194, 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 | 36259 | Other State 37 | 23260 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 4.068 | Other State 37 | None 1182 | ||||
12197 | 12197 | 12196 | {"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 | 35662 | Tuolumne River Restoration Center | 26580 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Stanislaus 2 | 4.72 | Tuolumne River Restoration Ctr. | None 1063 | ||||
4615 | 4615 | 4614 | {"type": "Polygon", "coordinates": [[[-120.43434, 35.8989], [-120.4339, 35.89938], [-120.433, 35.89938], [-120.433, 35.89909], [-120.43279, 35.89769], [-120.4328, 35.89746], [-120.43285, 35.89727], [-120.43291, 35.89727], [-120.43341, 35.89756], [-120.43422, 35.89848], [-120.43434, 35.8989]]]} | Open Access 1 | 36133 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 5.226 | 0 | State Other or Unknown 104 | 4 | |||
4617 | 4617 | 4616 | {"type": "Polygon", "coordinates": [[[-121.44723, 35.87386], [-121.44572, 35.87386], [-121.44568, 35.87182], [-121.44593, 35.87189], [-121.44619, 35.87189], [-121.44641, 35.87183], [-121.44656, 35.87186], [-121.447, 35.87216], [-121.447, 35.87235], [-121.44694, 35.8725], [-121.44675, 35.87258], [-121.44665, 35.87274], [-121.44665, 35.87297], [-121.44685, 35.87305], [-121.44688, 35.87323], [-121.44688, 35.87356], [-121.44709, 35.87378], [-121.44723, 35.87386]]]} | Open Access 1 | 36110 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 5.733 | 0 | State Other or Unknown 104 | 4 | |||
3189 | 3189 | 3188 | {"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 | 28051 | Friant Cove | 19113 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Fresno 9 | 5.884 | Friant Cove | None 262 | ||||
15481 | 15481 | 15480 | {"type": "Polygon", "coordinates": [[[-121.90442, 36.37228], [-121.90409, 36.37302], [-121.90285, 36.37256], [-121.9025, 36.37238], [-121.90224, 36.3722], [-121.90207, 36.37203], [-121.90198, 36.37191], [-121.90184, 36.37165], [-121.90175, 36.37141], [-121.90168, 36.37116], [-121.90166, 36.37091], [-121.90167, 36.37059], [-121.90307, 36.3706], [-121.90305, 36.37087], [-121.90312, 36.37125], [-121.90317, 36.3714], [-121.90343, 36.37175], [-121.9036, 36.37192], [-121.90369, 36.37199], [-121.90388, 36.37208], [-121.90399, 36.37216], [-121.90408, 36.3722], [-121.90442, 36.37228]]]} | Open Access 1 | 43080 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 8.36 | 0 | State Other or Unknown 104 | 4 | |||
6844 | 6844 | 6843 | {"type": "Polygon", "coordinates": [[[-118.65109, 34.03761], [-118.65102, 34.03789], [-118.65008, 34.03771], [-118.6496, 34.03764], [-118.64921, 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.64907, 34.0373], [-118.64975, 34.03736], [-118.65109, 34.03761]]]} | Open Access 1 | 5473 | La Costa Beach | 29045 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Los Angeles 6 | 9.122 | La Costa Beach | None 555 | ||||
4681 | 4681 | 4680 | {"type": "Polygon", "coordinates": [[[-121.45347, 35.88079], [-121.45045, 35.88079], [-121.45039, 35.87782], [-121.45083, 35.87812], [-121.45128, 35.87836], [-121.45184, 35.87897], [-121.45199, 35.87926], [-121.45214, 35.87963], [-121.45241, 35.88005], [-121.45259, 35.88039], [-121.45312, 35.88067], [-121.45347, 35.88079]]]} | Open Access 1 | 43023 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 11.034 | 0 | State Other or Unknown 104 | 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]);