units_with_maps

Table actions

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

2 rows where DES_TP = 4, MNG_AG_TYP = 4 and PARK_URL = "http://www.openspace.org/preserves/pr_long_ridge.asp"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 2 ✖

DES_TP 1

  • Local Conservation Area · 2 ✖

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
9537 9537 9536 {"type": "Polygon", "coordinates": [[[-122.17067, 37.26862], [-122.17944, 37.26914], [-122.17947, 37.27223], [-122.17063, 37.27223], [-122.1662, 37.27221], [-122.16623, 37.27584], [-122.1618, 37.27583], [-122.16169, 37.28221], [-122.17082, 37.28225], [-122.17084, 37.28664], [-122.17076, 37.29062], [-122.16751, 37.29053], [-122.166, 37.29165], [-122.16598, 37.29246], [-122.16438, 37.29246], [-122.16469, 37.2937], [-122.16469, 37.29391], [-122.16463, 37.294], [-122.16453, 37.29406], [-122.16413, 37.29413], [-122.1642, 37.29419], [-122.16427, 37.29414], [-122.16444, 37.29429], [-122.16453, 37.2944], [-122.16419, 37.29425], [-122.16415, 37.29426], [-122.16435, 37.29444], [-122.16447, 37.2946], [-122.16459, 37.2948], [-122.16466, 37.29497], [-122.1647, 37.29518], [-122.16472, 37.29537], [-122.16469, 37.29558], [-122.16465, 37.29575], [-122.1646, 37.29577], [-122.16466, 37.29554], [-122.16468, 37.29531], [-122.16466, 37.29508], [-122.16459, 37.29485], [-122.16447, 37.29463], [-122.16432, 37.29443], [-122.16412, 37.29424], [-122.16392, 37.29411], [-122.16371, 37.294], [-122.16348, 37.29392], [-122.16166, 37.29346], [-122.16046, 37.29317], [-122.16047, 37.29316], [-122.16046, 37.29315], [-122.15993, 37.29301], [-122.15814, 37.29233], [-122.15686, 37.29182], [-122.15642, 37.2916], [-122.15601, 37.29137], [-122.15386, 37.28999], [-122.15368, 37.28984], [-122.15347, 37.28965], [-122.15328, 37.28944], [-122.15312, 37.28921], [-122.15294, 37.28889], [-122.15279, 37.28849], [-122.15273, 37.28824], [-122.15259, 37.28737], [-122.15279, 37.28675], [-122.15255, 37.28669], [-122.15261, 37.28372], [-122.15287, 37.26505], [-122.15742, 37.26505], [-122.15744, 37.26326], [-122.16183, 37.26333], [-122.16184, 37.26507], [-122.16628, 37.26509], [-122.16628, 37.26612], [-122.16625, 37.26859], [-122.17067, 37.26862]], [[-122.16434, 37.29402], [-122.1644, 37.29402], [-122.1644, 37.29397], [-122.16434, 37.29397], [-122.16434, 37.29402]], [[-122.16033, 37.28853], [-122.16122, 37.28852], [-122.16121, 37.28789], [-122.16031, 37.2879], [-122.16033, 37.28853]]]} Open Access 1 17427 Long Ridge Open Space Preserve 6516 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 http://www.openspace.org/preserves/pr_long_ridge.asp San Mateo 15 1046.102 Long Ridge OSP 1999 Local Conservation Area 4 2
15915 15915 15914 {"type": "Polygon", "coordinates": [[[-122.15287, 37.274], [-122.15279, 37.28002], [-122.1525, 37.28615], [-122.15227, 37.28465], [-122.15221, 37.2844], [-122.15209, 37.28403], [-122.15197, 37.2838], [-122.15184, 37.28358], [-122.15156, 37.28322], [-122.15135, 37.28301], [-122.15111, 37.28282], [-122.15082, 37.28261], [-122.15059, 37.28248], [-122.14994, 37.28217], [-122.14971, 37.28202], [-122.14957, 37.2819], [-122.14933, 37.28165], [-122.14918, 37.28144], [-122.14908, 37.28122], [-122.14901, 37.28098], [-122.14898, 37.28075], [-122.14899, 37.28051], [-122.14902, 37.28035], [-122.14909, 37.28012], [-122.14912, 37.28004], [-122.14973, 37.27916], [-122.14979, 37.27898], [-122.14979, 37.27885], [-122.14959, 37.27791], [-122.14959, 37.27775], [-122.14961, 37.27765], [-122.14968, 37.27754], [-122.14989, 37.27735], [-122.15021, 37.27715], [-122.15051, 37.27688], [-122.1507, 37.27661], [-122.15076, 37.27648], [-122.15082, 37.2763], [-122.15084, 37.27617], [-122.15078, 37.27579], [-122.15065, 37.27552], [-122.15044, 37.27528], [-122.15029, 37.27515], [-122.15011, 37.27504], [-122.14977, 37.2749], [-122.14957, 37.27485], [-122.14889, 37.27487], [-122.14853, 37.27483], [-122.14836, 37.27478], [-122.14816, 37.2747], [-122.148, 37.27461], [-122.14787, 37.27451], [-122.14779, 37.27443], [-122.14655, 37.27239], [-122.14602, 37.27175], [-122.14458, 37.27028], [-122.14432, 37.27005], [-122.14411, 37.26993], [-122.1438, 37.2698], [-122.14096, 37.26906], [-122.14055, 37.26891], [-122.14022, 37.26876], [-122.13993, 37.26859], [-122.13972, 37.26845], [-122.13952, 37.2683], [-122.13928, 37.26808], [-122.13917, 37.26797], [-122.13824, 37.26685], [-122.13802, 37.26664], [-122.1375, 37.26627], [-122.13626, 37.26576], [-122.13603, 37.26562], [-122.13589, 37.26548], [-122.13578, 37.26533], [-122.13475, 37.26309], [-122.13458, 37.26288], [-122.13438, 37.26271], [-122.13424, 37.26261], [-122.1339, 37.26243], [-122.13412, 37.26206], [-122.13383, 37.26195], [-122.13335, 37.26157], [-122.13282, 37.26099], [-122.13139, 37.2602], [-122.13112, 37.26034], [-122.13097, 37.26024], [-122.13075, 37.26015], [-122.13029, 37.26004], [-122.12991, 37.25991], [-122.12966, 37.25977], [-122.1295, 37.25967], [-122.12911, 37.25932], [-122.12889, 37.25917], [-122.12859, 37.25904], [-122.12824, 37.25895], [-122.12795, 37.25893], [-122.12767, 37.25894], [-122.12739, 37.259], [-122.12698, 37.25912], [-122.12668, 37.25916], [-122.12644, 37.25915], [-122.12594, 37.25907], [-122.12554, 37.25907], [-122.1253, 37.25911], [-122.1251, 37.25916], [-122.12449, 37.25941], [-122.12432, 37.25946], [-122.12417, 37.25948], [-122.12401, 37.25948], [-122.12377, 37.25944], [-122.12362, 37.25938], [-122.12348, 37.25931], [-122.12287, 37.25882], [-122.12214, 37.25806], [-122.12472, 37.25606], [-122.12519, 37.25641], [-122.12587, 37.2563], [-122.12635, 37.25541], [-122.12688, 37.25482], [-122.13248, 37.2549], [-122.13467, 37.25383], [-122.13517, 37.25301], [-122.13519, 37.25244], [-122.13634, 37.25243], [-122.13688, 37.25055], [-122.13679, 37.24891], [-122.13808, 37.24809], [-122.13874, 37.24716], [-122.13873, 37.24681], [-122.13932, 37.24588], [-122.14222, 37.24416], [-122.14321, 37.24414], [-122.14347, 37.24428], [-122.14362, 37.2569], [-122.1348, 37.25682], [-122.13483, 37.26132], [-122.14416, 37.26194], [-122.15276, 37.26223], [-122.15286, 37.26582], [-122.1529, 37.27173], [-122.15287, 37.274]], [[-122.15184, 37.27456], [-122.15174, 37.27389], [-122.15155, 37.2737], [-122.15137, 37.27373], [-122.15124, 37.27372], [-122.1505, 37.27352], [-122.15037, 37.27351], [-122.15013, 37.27354], [-122.14996, 37.27351], [-122.14986, 37.27345], [-122.14978, 37.27338], [-122.14972, 37.27328], [-122.14968, 37.27318], [-122.14964, 37.27313], [-122.1494, 37.27304], [-122.14916, 37.27289], [-122.14946, 37.27363], [-122.14925, 37.27425], [-122.14933, 37.2747], [-122.15035, 37.27507], [-122.15083, 37.27539], [-122.15095, 37.27581], [-122.15142, 37.2763], [-122.1521, 37.27648], [-122.15238, 37.27616], [-122.15184, 37.27456]]]} Open Access 1 17399 Long Ridge Open Space Preserve 6516 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 http://www.openspace.org/preserves/pr_long_ridge.asp Santa Cruz 5 768.508 Long Ridge OSP 1999 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]);