units_with_maps

Table actions

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

3 rows where COUNTY = 24, DES_TP = 39 and MNG_AGENCY = 47

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Parks and Recreation · 3 ✖

DES_TP 1

  • State Recreation Area · 3 ✖

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
2525 2525 2524 {"type": "Polygon", "coordinates": [[[-123.62389, 39.64708], [-123.6238, 39.64742], [-123.62309, 39.64784], [-123.62253, 39.64744], [-123.62189, 39.64786], [-123.61327, 39.64798], [-123.61378, 39.64766], [-123.61419, 39.64711], [-123.61424, 39.64691], [-123.6147, 39.64626], [-123.61443, 39.6461], [-123.61453, 39.64591], [-123.61541, 39.6462], [-123.61603, 39.64616], [-123.61642, 39.64567], [-123.61611, 39.64514], [-123.61634, 39.64482], [-123.61905, 39.64553], [-123.62042, 39.64618], [-123.62084, 39.64617], [-123.62153, 39.64579], [-123.62214, 39.64578], [-123.62369, 39.64684], [-123.62389, 39.64708]]]} Open Access 1 20456 Admiral William Standley State Recreation Area 1385 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 http://www.parks.ca.gov/?page_id=424 Mendocino 24 46.532 Admiral William Standley SRA 1944 State Recreation Area 39 4
2976 2976 2975 {"type": "Polygon", "coordinates": [[[-123.7844, 39.94648], [-123.78441, 39.94683], [-123.78435, 39.94708], [-123.78407, 39.94778], [-123.78392, 39.94811], [-123.78379, 39.94856], [-123.78249, 39.94857], [-123.78136, 39.94676], [-123.78036, 39.94442], [-123.78005, 39.94309], [-123.78049, 39.94179], [-123.77938, 39.94079], [-123.77914, 39.94063], [-123.77901, 39.94025], [-123.77821, 39.93938], [-123.77841, 39.93907], [-123.77847, 39.93855], [-123.77837, 39.93806], [-123.77853, 39.93765], [-123.77851, 39.93708], [-123.77914, 39.93668], [-123.77941, 39.93678], [-123.77966, 39.93706], [-123.78091, 39.93646], [-123.78141, 39.93673], [-123.78151, 39.93687], [-123.78157, 39.93706], [-123.78158, 39.93725], [-123.78152, 39.93743], [-123.78143, 39.93758], [-123.78129, 39.93769], [-123.78078, 39.93804], [-123.78048, 39.93817], [-123.78019, 39.93827], [-123.77996, 39.9384], [-123.77979, 39.93858], [-123.77972, 39.93869], [-123.77971, 39.93884], [-123.77977, 39.93898], [-123.77995, 39.93931], [-123.78, 39.93948], [-123.78009, 39.93965], [-123.78034, 39.94008], [-123.78041, 39.94016], [-123.78147, 39.94084], [-123.78187, 39.94116], [-123.78232, 39.94165], [-123.78257, 39.94203], [-123.78276, 39.94237], [-123.78299, 39.94285], [-123.78316, 39.94327], [-123.78357, 39.94413], [-123.78386, 39.94487], [-123.78416, 39.94572], [-123.7844, 39.94648]]]} Open Access 1 20514 Reynolds Wayside Campgrounds 1704 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 http://www.parks.ca.gov/?page_id=428 Mendocino 24 68.476 Reynolds Wayside Campgrounds 1966 State Recreation Area 39 4
16662 16662 16661 {"type": "MultiPolygon", "coordinates": [[[[-123.755, 39.87752], [-123.75055, 39.87759], [-123.75066, 39.88593], [-123.75094, 39.88594], [-123.75092, 39.88684], [-123.75087, 39.88704], [-123.75058, 39.89043], [-123.75052, 39.89133], [-123.75038, 39.89109], [-123.749, 39.8906], [-123.74871, 39.89041], [-123.74865, 39.89024], [-123.74867, 39.89014], [-123.74908, 39.88965], [-123.7491, 39.88932], [-123.74952, 39.88836], [-123.74918, 39.88773], [-123.74887, 39.88724], [-123.7483, 39.88721], [-123.74778, 39.88698], [-123.74754, 39.88669], [-123.747, 39.88634], [-123.7459, 39.8862], [-123.74548, 39.88623], [-123.74448, 39.88606], [-123.74281, 39.88631], [-123.74168, 39.8868], [-123.74075, 39.88691], [-123.73998, 39.88672], [-123.73935, 39.88646], [-123.73875, 39.8863], [-123.73814, 39.88634], [-123.73792, 39.88625], [-123.73756, 39.88601], [-123.73747, 39.88542], [-123.73781, 39.8847], [-123.7379, 39.8844], [-123.73814, 39.88399], [-123.73821, 39.88343], [-123.73818, 39.88291], [-123.73798, 39.88262], [-123.73766, 39.88234], [-123.73659, 39.88168], [-123.73606, 39.88143], [-123.73523, 39.88072], [-123.73486, 39.88024], [-123.73477, 39.87985], [-123.7346, 39.8795], [-123.73434, 39.87912], [-123.73385, 39.87865], [-123.73272, 39.87868], [-123.73158, 39.87814], [-123.73089, 39.87795], [-123.73049, 39.8778], [-123.72278, 39.87776], [-123.72224, 39.87746], [-123.72231, 39.87425], [-123.72056, 39.87422], [-123.72014, 39.87474], [-123.71949, 39.8752], [-123.7185, 39.87573], [-123.71811, 39.87606], [-123.71783, 39.87654], [-123.71767, 39.87751], [-123.71887, 39.8775], [-123.71833, 39.87805], [-123.718, 39.87829], [-123.71745, 39.87862], [-123.71721, 39.8787], [-123.71683, 39.87879], [-123.7166, 39.8788], [-123.71643, 39.87871], [-123.71594, 39.87795], [-123.71439, 39.87795], [-123.71401, 39.87776], [-123.71342, 39.87738], [-123.71321, 39.8773], [-123.71297, 39.87726], [-123.71294, 39.87563], [-123.7128, 39.87542], [-123.71248, 39.8751], [-123.71232, 39.87497], [-123.71216, 39.87468], [-123.71205, 39.87422], [-123.71206, 39.87371], [-123.71204, 39.8734], [-123.71211, 39.87311], [-123.71225, 39.87281], [-123.71274, 39.87221], [-123.71296, 39.872], [-123.71319, 39.87186], [-123.7131, 39.87078], [-123.71373, 39.87073], [-123.71771, 39.87076], [-123.7317, 39.87066], [-123.73178, 39.86706], [-123.73285, 39.86693], [-123.73306, 39.86696], [-123.73319, 39.86793], [-123.73633, 39.86793], [-123.73635, 39.87067], [-123.7411, 39.87063], [-123.74117, 39.87419], [-123.74549, 39.87415], [-123.75493, 39.87397], [-123.75503, 39.87595], [-123.755, 39.87752]]], [[[-123.71376, 39.87805], [-123.71298, 39.87807], [-123.71302, 39.87765], [-123.7134, 39.87773], [-123.7136, 39.87785], [-123.71376, 39.87805]]], [[[-123.73643, 39.88607], [-123.73235, 39.88614], [-123.73237, 39.88849], [-123.72993, 39.88851], [-123.72993, 39.88603], [-123.72945, 39.88602], [-123.72928, 39.87809], [-123.73095, 39.87825], [-123.73203, 39.87858], [-123.73261, 39.87927], [-123.73299, 39.88019], [-123.73282, 39.88058], [-123.73328, 39.88099], [-123.73332, 39.88171], [-123.734, 39.88208], [-123.7339, 39.88265], [-123.73432, 39.88267], [-123.73433, 39.88311], [-123.73504, 39.88356], [-123.73643, 39.88607]]]]} Open Access 1 20522 Standish-Hickey State Recreation Area 1755 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 http://www.parks.ca.gov/?page_id=423 Mendocino 24 1010.72 Standish-Hickey SRA 1921 State Recreation Area 39 4

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