calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES_TP = 490 and MNG

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

1 row where ACCESS_TYP = 1, DES_TP = 490 and MNG_AGENCY = 104

Search:

descending

This data as json, copyable, CSV (advanced)

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
6083	6083	6082	{"type": "MultiPolygon", "coordinates": [[[[-122.03315, 37.05095], [-122.03281, 37.0516], [-122.0327, 37.05176], [-122.03245, 37.05195], [-122.03227, 37.05182], [-122.03216, 37.05193], [-122.03207, 37.05206], [-122.03202, 37.05221], [-122.03199, 37.05235], [-122.03201, 37.0525], [-122.03205, 37.05265], [-122.03247, 37.05332], [-122.03224, 37.05356], [-122.03205, 37.0536], [-122.03196, 37.05369], [-122.03213, 37.05381], [-122.03213, 37.0539], [-122.03218, 37.05395], [-122.03226, 37.05397], [-122.03226, 37.05404], [-122.03213, 37.05419], [-122.0318, 37.05403], [-122.03136, 37.05427], [-122.03093, 37.05448], [-122.03059, 37.05448], [-122.03059, 37.05423], [-122.03074, 37.05397], [-122.03119, 37.05372], [-122.03147, 37.05364], [-122.03203, 37.05325], [-122.03165, 37.05261], [-122.03094, 37.05129], [-122.03064, 37.05122], [-122.03064, 37.05086], [-122.02946, 37.05085], [-122.02943, 37.05008], [-122.03105, 37.05005], [-122.0314, 37.05002], [-122.03174, 37.04996], [-122.03204, 37.04988], [-122.03315, 37.05095]]], [[[-122.03187, 37.04973], [-122.0314, 37.04983], [-122.03104, 37.04985], [-122.02999, 37.04987], [-122.03115, 37.04903], [-122.03187, 37.04973]]], [[[-122.03631, 37.0512], [-122.03628, 37.05127], [-122.03593, 37.05127], [-122.03585, 37.05136], [-122.03582, 37.0515], [-122.03566, 37.05167], [-122.03551, 37.05173], [-122.03551, 37.05182], [-122.03543, 37.05187], [-122.03543, 37.05195], [-122.03504, 37.05281], [-122.03455, 37.05232], [-122.03458, 37.05225], [-122.03465, 37.05225], [-122.03471, 37.05223], [-122.03499, 37.05231], [-122.03527, 37.0517], [-122.03534, 37.0516], [-122.03574, 37.05116], [-122.0358, 37.05101], [-122.03547, 37.05039], [-122.03537, 37.05026], [-122.0351, 37.05005], [-122.03437, 37.04976], [-122.03373, 37.04941], [-122.03358, 37.0493], [-122.03327, 37.04949], [-122.03294, 37.04964], [-122.0329, 37.04969], [-122.0329, 37.0498], [-122.03292, 37.04982], [-122.03295, 37.04982], [-122.03296, 37.04985], [-122.03292, 37.04985], [-122.03287, 37.04982], [-122.03288, 37.04967], [-122.03293, 37.04961], [-122.03333, 37.04943], [-122.03358, 37.04926], [-122.03375, 37.04908], [-122.03388, 37.04885], [-122.03394, 37.04877], [-122.03416, 37.04859], [-122.03411, 37.0489], [-122.03425, 37.04906], [-122.03488, 37.04953], [-122.03506, 37.04954], [-122.03528, 37.04967], [-122.03559, 37.04978], [-122.03568, 37.04988], [-122.03586, 37.04989], [-122.0356, 37.05018], [-122.03574, 37.05034], [-122.03591, 37.05041], [-122.03592, 37.05045], [-122.03582, 37.05054], [-122.03583, 37.05066], [-122.03604, 37.05092], [-122.03613, 37.05111], [-122.03631, 37.0512]]]]}	Open Access 1	885	Skypark	25545	1328	Scotts Valley, City of 107	City 2	City Agency 2	http://www.scottsvalley.org/parks/parks_recs.html	City 2	1328	Scotts Valley, City of 104	City 2	City Agency 2		Santa Cruz 5	22.469	Skypark		None 490

Advanced export

JSON shape: default, array, newline-delimited

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