units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 2, AGNCY_WEB = "http://www.parks.ca.gov/" and DES_TP = 8

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • State Conservation Area · 2 ✖

ACCESS_TYP 1

  • Restricted Access · 2 ✖
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
10507 10507 10506 {"type": "Polygon", "coordinates": [[[-122.41293, 37.25988], [-122.41295, 37.25997], [-122.41206, 37.26401], [-122.41184, 37.2647], [-122.41161, 37.2652], [-122.41159, 37.26533], [-122.41128, 37.26576], [-122.4113, 37.26579], [-122.41094, 37.26638], [-122.4098, 37.2687], [-122.40947, 37.26959], [-122.40843, 37.27365], [-122.40815, 37.274], [-122.40808, 37.2744], [-122.40529, 37.27429], [-122.40521, 37.27413], [-122.40479, 37.27394], [-122.40452, 37.27375], [-122.40434, 37.2736], [-122.40436, 37.27315], [-122.40434, 37.27296], [-122.40415, 37.27255], [-122.40354, 37.27164], [-122.40392, 37.2708], [-122.4039, 37.27061], [-122.40373, 37.27008], [-122.40286, 37.26946], [-122.40273, 37.2694], [-122.40192, 37.2695], [-122.40167, 37.2696], [-122.40142, 37.26976], [-122.40087, 37.26961], [-122.40028, 37.26914], [-122.3996, 37.26883], [-122.3989, 37.26729], [-122.39829, 37.26639], [-122.39808, 37.26579], [-122.39826, 37.2658], [-122.39835, 37.26527], [-122.39769, 37.263], [-122.39969, 37.26224], [-122.40032, 37.26221], [-122.40033, 37.2622], [-122.39899, 37.26081], [-122.39849, 37.26053], [-122.39838, 37.26007], [-122.39715, 37.2589], [-122.39639, 37.25856], [-122.39593, 37.25842], [-122.39535, 37.25805], [-122.39395, 37.25808], [-122.39357, 37.25795], [-122.39351, 37.25769], [-122.39361, 37.25734], [-122.39402, 37.25686], [-122.39407, 37.25651], [-122.39443, 37.25615], [-122.39451, 37.256], [-122.39446, 37.25594], [-122.39453, 37.25583], [-122.39458, 37.25557], [-122.39745, 37.25524], [-122.39749, 37.25525], [-122.39812, 37.25516], [-122.39624, 37.25305], [-122.3962, 37.25299], [-122.39476, 37.2514], [-122.39605, 37.25124], [-122.39588, 37.2509], [-122.39583, 37.25085], [-122.39573, 37.25059], [-122.39556, 37.2503], [-122.39701, 37.25003], [-122.39842, 37.24988], [-122.39936, 37.24994], [-122.39991, 37.25003], [-122.40056, 37.25021], [-122.40116, 37.25057], [-122.40158, 37.25089], [-122.402, 37.25141], [-122.40238, 37.25191], [-122.4027, 37.25228], [-122.40313, 37.25257], [-122.40363, 37.25272], [-122.40409, 37.25289], [-122.40483, 37.25312], [-122.40541, 37.25337], [-122.40618, 37.25364], [-122.40676, 37.25399], [-122.40706, 37.25426], [-122.40726, 37.25469], [-122.40754, 37.25545], [-122.40803, 37.25646], [-122.40868, 37.25772], [-122.40892, 37.25813], [-122.40913, 37.25843], [-122.40947, 37.25879], [-122.40992, 37.25914], [-122.41039, 37.25939], [-122.41067, 37.2595], [-122.41157, 37.25973], [-122.41229, 37.25979], [-122.41283, 37.25981], [-122.41293, 37.25988]]]} Restricted Access 2 18614 Pescadero Marsh Natural Preserve 23620 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5   San Mateo 15 606.372 Pescadero Marsh Natural Preserve 1974 State Conservation Area 8 2
16518 16518 16517 {"type": "MultiPolygon", "coordinates": [[[[-123.82123, 40.13925], [-123.81466, 40.13936], [-123.81156, 40.13939], [-123.80906, 40.14122], [-123.80928, 40.13941], [-123.80891, 40.13941], [-123.80883, 40.13849], [-123.80858, 40.13733], [-123.80758, 40.13584], [-123.80675, 40.13432], [-123.80657, 40.1341], [-123.80645, 40.13238], [-123.81136, 40.1323], [-123.81124, 40.12797], [-123.81226, 40.12808], [-123.81291, 40.12754], [-123.82106, 40.12717], [-123.82074, 40.12801], [-123.82048, 40.12825], [-123.82008, 40.1285], [-123.82009, 40.12851], [-123.82109, 40.1285], [-123.82107, 40.12901], [-123.82108, 40.13566], [-123.82123, 40.13925]]], [[[-123.85492, 40.12513], [-123.85376, 40.12519], [-123.85009, 40.12519], [-123.84531, 40.12533], [-123.84534, 40.12621], [-123.84561, 40.12957], [-123.83164, 40.12877], [-123.83149, 40.12715], [-123.83249, 40.127], [-123.8338, 40.1263], [-123.83436, 40.1259], [-123.83581, 40.12477], [-123.83615, 40.12454], [-123.83615, 40.12452], [-123.83603, 40.12446], [-123.83632, 40.12418], [-123.83671, 40.12293], [-123.83665, 40.12271], [-123.83659, 40.12217], [-123.8349, 40.12204], [-123.83489, 40.12074], [-123.83563, 40.12077], [-123.83638, 40.12092], [-123.83635, 40.12052], [-123.84012, 40.12111], [-123.83998, 40.11884], [-123.83483, 40.1187], [-123.83477, 40.11851], [-123.83572, 40.11817], [-123.83572, 40.11773], [-123.83561, 40.11757], [-123.83495, 40.11696], [-123.83423, 40.11661], [-123.83362, 40.11628], [-123.8333, 40.11596], [-123.83184, 40.11551], [-123.83108, 40.11522], [-123.83092, 40.11531], [-123.8308, 40.11517], [-123.8306, 40.11502], [-123.83022, 40.1149], [-123.83068, 40.11027], [-123.82515, 40.11039], [-123.82502, 40.10649], [-123.84453, 40.10712], [-123.84865, 40.10686], [-123.84968, 40.12166], [-123.85477, 40.1215], [-123.85492, 40.12513]]], [[[-123.82948, 40.12628], [-123.82806, 40.12582], [-123.8262, 40.12562], [-123.82656, 40.12531], [-123.82727, 40.125], [-123.82786, 40.12509], [-123.82805, 40.12533], [-123.82807, 40.12542], [-123.82876, 40.12548], [-123.82935, 40.12517], [-123.82948, 40.12505], [-123.82948, 40.12628]]], [[[-123.83224, 40.11696], [-123.8313, 40.11723], [-123.83058, 40.11725], [-123.83076, 40.11713], [-123.83094, 40.11704], [-123.83187, 40.11665], [-123.83207, 40.1168], [-123.83223, 40.11688], [-123.83224, 40.11696]]], [[[-123.83477, 40.12005], [-123.83429, 40.12011], [-123.8342, 40.11991], [-123.8337, 40.11999], [-123.83354, 40.1196], [-123.83409, 40.11951], [-123.83406, 40.11931], [-123.83473, 40.11921], [-123.83477, 40.12005]]], [[[-123.8348, 40.12203], [-123.83399, 40.12189], [-123.83399, 40.12134], [-123.83435, 40.12136], [-123.83435, 40.12099], [-123.83397, 40.12095], [-123.83395, 40.12067], [-123.8348, 40.12071], [-123.8348, 40.12203]]]]} Restricted Access 2 20490 John B. Dewitt Redwoods State Natural Reserve 31547 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5   Humboldt 45 1226.346 John B. Dewitt Redwoods SNR 1929 State Conservation Area 8 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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