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.openspace.org" and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 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
15928 15928 15927 {"type": "Polygon", "coordinates": [[[-122.01096, 37.17045], [-122.01066, 37.17058], [-122.0105, 37.17074], [-122.0103, 37.17084], [-122.00975, 37.17124], [-122.00965, 37.17139], [-122.00932, 37.17152], [-122.00919, 37.17162], [-122.00907, 37.17163], [-122.00898, 37.17167], [-122.00854, 37.17155], [-122.00786, 37.17166], [-122.00758, 37.17183], [-122.00748, 37.17194], [-122.0073, 37.17197], [-122.00706, 37.17214], [-122.00678, 37.17245], [-122.00663, 37.1725], [-122.00652, 37.17265], [-122.00631, 37.17276], [-122.00628, 37.17289], [-122.00607, 37.17308], [-122.00594, 37.17325], [-122.00586, 37.17333], [-122.00564, 37.17343], [-122.00553, 37.17351], [-122.00539, 37.17356], [-122.00523, 37.17371], [-122.0052, 37.17384], [-122.00478, 37.17427], [-122.00493, 37.17449], [-122.00529, 37.1748], [-122.00566, 37.17501], [-122.00595, 37.17514], [-122.00624, 37.17533], [-122.00649, 37.17542], [-122.0068, 37.17558], [-122.00708, 37.17577], [-122.00746, 37.17586], [-122.00912, 37.17491], [-122.00915, 37.17502], [-122.00921, 37.17511], [-122.00935, 37.17526], [-122.00979, 37.17563], [-122.00993, 37.1757], [-122.01007, 37.17574], [-122.01035, 37.17576], [-122.01039, 37.17602], [-122.01024, 37.17631], [-122.01016, 37.17661], [-122.00971, 37.17712], [-122.00978, 37.17759], [-122.00995, 37.17776], [-122.01007, 37.17791], [-122.0101, 37.17808], [-122.01006, 37.1782], [-122.01002, 37.17823], [-122.00978, 37.17824], [-122.00927, 37.17869], [-122.00968, 37.17911], [-122.00968, 37.17931], [-122.00955, 37.17977], [-122.00931, 37.1799], [-122.00893, 37.17991], [-122.00843, 37.17999], [-122.00776, 37.17978], [-122.00713, 37.18034], [-122.00687, 37.18045], [-122.00652, 37.18045], [-122.00617, 37.18083], [-122.0057, 37.18106], [-122.0053, 37.18114], [-122.00509, 37.18109], [-122.0048, 37.18086], [-122.00442, 37.1804], [-122.00418, 37.18021], [-122.00373, 37.18015], [-122.00288, 37.18041], [-122.00259, 37.18084], [-122.00256, 37.18115], [-122.0031, 37.18184], [-122.00354, 37.18234], [-122.00452, 37.18287], [-122.00463, 37.18315], [-122.00485, 37.18341], [-122.00503, 37.18392], [-122.00501, 37.18399], [-122.00497, 37.18401], [-122.00443, 37.18397], [-122.00423, 37.18399], [-122.00388, 37.18413], [-122.00329, 37.1843], [-122.0032, 37.18431], [-122.00307, 37.18427], [-122.00275, 37.18414], [-122.00239, 37.18403], [-122.00238, 37.18429], [-122.0026, 37.1847], [-122.00273, 37.18509], [-122.0031, 37.18521], [-122.00276, 37.18561], [-122.00258, 37.18563], [-122.00218, 37.18559], [-122.00186, 37.18569], [-122.00186, 37.18571], [-122.00188, 37.18572], [-122.00154, 37.18585], [-122.00154, 37.18588], [-122.00128, 37.18594], [-122.00051, 37.18632], [-121.99863, 37.187], [-121.9984, 37.18703], [-121.99796, 37.18715], [-121.9978, 37.18717], [-121.99763, 37.18714], [-121.99731, 37.18705], [-121.99615, 37.18697], [-121.99586, 37.18703], [-121.99546, 37.18716], [-121.99524, 37.18728], [-121.9951, 37.18749], [-121.99508, 37.18772], [-121.99465, 37.18773], [-121.99471, 37.18951], [-121.99455, 37.18969], [-121.99421, 37.18993], [-121.99378, 37.19009], [-121.99339, 37.18947], [-121.99281, 37.1891], [-121.99224, 37.18819], [-121.99172, 37.18702], [-121.99235, 37.18586], [-121.99179, 37.18542], [-121.99214, 37.18481], [-121.9925, 37.18442], [-121.99327, 37.18282], [-121.99434, 37.18216], [-121.99402, 37.18107], [-121.99486, 37.17957], [-121.99613, 37.17899], [-121.99618, 37.17738], [-121.9968, 37.17713], [-121.99712, 37.17722], [-121.99772, 37.17722], [-121.99788, 37.17741], [-121.99816, 37.17741], [-121.99819, 37.1777], [-121.99827, 37.17777], [-121.99871, 37.17777], [-121.99875, 37.17773], [-121.99877, 37.17761], [-121.99923, 37.17747], [-121.99934, 37.17719], [-121.99966, 37.17714], [-121.9996, 37.17693], [-122.00016, 37.17675], [-122.00024, 37.17649], [-122.00024, 37.17631], [-122.00015, 37.176], [-122.00003, 37.17262], [-122.00092, 37.17054], [-122.00091, 37.17053], [-122.00017, 37.17054], [-122.00011, 37.16903], [-122.00007, 37.16708], [-122.0, 37.16707], [-121.9999, 37.1636], [-122.0034, 37.1636], [-122.00335, 37.15994], [-122.00784, 37.15996], [-122.008, 37.17047], [-122.01096, 37.17045]]]} Restricted Access 2 18511 Bear Creek Redwoods Open Space Preserve 31478 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   Santa Clara 19 577.047 Bear Creek Redwoods OSP 2003 Local Conservation Area 4 2
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]);