units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, COUNTY = 15 and MNG_AGENCY = 631

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Midpeninsula Regional Open Space District · 1 ✖

ACCESS_TYP 1

  • Restricted Access · 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
15945 15945 15944 {"type": "MultiPolygon", "coordinates": [[[[-122.31171, 37.31299], [-122.30924, 37.31361], [-122.30896, 37.31369], [-122.30858, 37.31384], [-122.30842, 37.31371], [-122.30972, 37.31236], [-122.31041, 37.31218], [-122.31059, 37.31255], [-122.3114, 37.31234], [-122.31171, 37.31299]]], [[[-122.31237, 37.32216], [-122.31219, 37.32245], [-122.31171, 37.32232], [-122.31152, 37.32177], [-122.31139, 37.32155], [-122.31124, 37.32135], [-122.311, 37.32114], [-122.31082, 37.3211], [-122.31068, 37.32109], [-122.31039, 37.32112], [-122.31007, 37.32111], [-122.30958, 37.32102], [-122.3093, 37.32104], [-122.30893, 37.3211], [-122.30819, 37.32115], [-122.30798, 37.32116], [-122.30769, 37.32113], [-122.30743, 37.32096], [-122.30737, 37.32069], [-122.3074, 37.32055], [-122.30755, 37.32034], [-122.30771, 37.32018], [-122.30753, 37.32006], [-122.30733, 37.31988], [-122.30726, 37.31955], [-122.30734, 37.31914], [-122.30742, 37.31893], [-122.30759, 37.31873], [-122.30783, 37.31852], [-122.3081, 37.31834], [-122.30844, 37.31823], [-122.30878, 37.31818], [-122.30918, 37.31817], [-122.30943, 37.31818], [-122.30974, 37.31816], [-122.30977, 37.31789], [-122.30973, 37.31743], [-122.30967, 37.31711], [-122.30943, 37.31694], [-122.30944, 37.3166], [-122.3096, 37.3164], [-122.30971, 37.31595], [-122.30971, 37.31546], [-122.30975, 37.31528], [-122.31004, 37.31473], [-122.3106, 37.31429], [-122.31021, 37.31412], [-122.31033, 37.31387], [-122.3103, 37.3137], [-122.31211, 37.31329], [-122.31205, 37.31341], [-122.31199, 37.31348], [-122.31177, 37.31363], [-122.31161, 37.31371], [-122.31161, 37.31372], [-122.3117, 37.31372], [-122.31186, 37.31378], [-122.31196, 37.3139], [-122.31198, 37.31402], [-122.31192, 37.31416], [-122.31186, 37.31426], [-122.31156, 37.31453], [-122.31127, 37.31466], [-122.31096, 37.31475], [-122.31063, 37.31501], [-122.31033, 37.31539], [-122.31029, 37.31559], [-122.3104, 37.31602], [-122.3102, 37.31676], [-122.31032, 37.31693], [-122.31036, 37.31705], [-122.3104, 37.3173], [-122.31046, 37.31785], [-122.31045, 37.3181], [-122.31037, 37.31842], [-122.31018, 37.31866], [-122.30979, 37.31874], [-122.3089, 37.31872], [-122.30854, 37.31878], [-122.3084, 37.31884], [-122.30819, 37.31901], [-122.30805, 37.31916], [-122.30795, 37.31958], [-122.30813, 37.31964], [-122.30833, 37.31973], [-122.30846, 37.3199], [-122.30848, 37.32018], [-122.3084, 37.32037], [-122.30819, 37.32058], [-122.3082, 37.3206], [-122.3087, 37.32057], [-122.30893, 37.32043], [-122.30943, 37.32048], [-122.30961, 37.32047], [-122.31028, 37.32057], [-122.31059, 37.32055], [-122.31089, 37.32055], [-122.31127, 37.32063], [-122.31159, 37.32082], [-122.31181, 37.32104], [-122.31201, 37.3213], [-122.31216, 37.32156], [-122.31237, 37.32216]]], [[[-122.29778, 37.37792], [-122.2977, 37.3782], [-122.29751, 37.37842], [-122.29705, 37.37865], [-122.29581, 37.37867], [-122.29579, 37.37994], [-122.29562, 37.37938], [-122.29518, 37.37891], [-122.29391, 37.3789], [-122.29387, 37.38057], [-122.28672, 37.38057], [-122.2867, 37.38161], [-122.2823, 37.3816], [-122.28227, 37.38814], [-122.28082, 37.38773], [-122.28025, 37.38768], [-122.2795, 37.38774], [-122.2783, 37.38797], [-122.27756, 37.38796], [-122.27657, 37.38789], [-122.27586, 37.38775], [-122.27522, 37.3878], [-122.2748, 37.3879], [-122.27428, 37.38789], [-122.27329, 37.38801], [-122.2733, 37.38159], [-122.27326, 37.37799], [-122.27373, 37.37798], [-122.27866, 37.37661], [-122.27777, 37.37518], [-122.27747, 37.37428], [-122.27673, 37.37381], [-122.27614, 37.37296], [-122.27641, 37.37176], [-122.27656, 37.37071], [-122.27657, 37.36964], [-122.27721, 37.36879], [-122.27712, 37.36698], [-122.2868, 37.36709], [-122.28677, 37.37424], [-122.28674, 37.37861], [-122.2915, 37.37861], [-122.29219, 37.37791], [-122.29239, 37.37791], [-122.29238, 37.37769], [-122.29211, 37.37757], [-122.29219, 37.37749], [-122.2926, 37.37757], [-122.29276, 37.3777], [-122.29279, 37.37787], [-122.29276, 37.37791], [-122.29277, 37.37792], [-122.29778, 37.37792]]]]} Restricted Access 2 43105 La Honda Creek Open Space Preserve 20760 2079 Midpeninsula Regional Open Space District 366 Special District 4 Recreation/Parks District 4 http://www.openspace.org Special District 4 2079 Midpeninsula Regional Open Space District 631 Special District 4 Recreation/Parks District 4   San Mateo 15 594.683 La Honda Creek OSP 1984 Local Conservation Area 4 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]);