calands: units_with_maps: 4 rows where AGNCY_LEV = 7 and MNG

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

4 rows where AGNCY_LEV = 7 and MNG_AGENCY = 350

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	LAYER	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	PARK_URL	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
13144	13144	13143	{"type": "Polygon", "coordinates": [[[-117.6363, 33.4373], [-117.63625, 33.43732], [-117.63621, 33.43736], [-117.63622, 33.43744], [-117.63619, 33.43747], [-117.63618, 33.43754], [-117.63611, 33.43758], [-117.6361, 33.43765], [-117.636, 33.43768], [-117.63601, 33.43753], [-117.63591, 33.4373], [-117.63591, 33.43715], [-117.63589, 33.4371], [-117.6358, 33.43706], [-117.6357, 33.43709], [-117.63566, 33.43715], [-117.63567, 33.4372], [-117.6357, 33.43723], [-117.63547, 33.43703], [-117.63541, 33.437], [-117.63532, 33.43699], [-117.63532, 33.43695], [-117.63553, 33.43688], [-117.63566, 33.43668], [-117.6357, 33.43666], [-117.63577, 33.43667], [-117.63585, 33.43672], [-117.63594, 33.43687], [-117.63593, 33.43698], [-117.63596, 33.43709], [-117.63593, 33.43725], [-117.63595, 33.43735], [-117.63598, 33.43737], [-117.63604, 33.43735], [-117.6362, 33.43724], [-117.63627, 33.43727], [-117.6363, 33.4373]]]}	Open Access 1	48825	Vista Del Sol Park	33544	6132	Marblehead Development Partners LLC 1045	Private 7	Home Owners Association 16	Private 14	1296	San Clemente, City of 350	City 2	City Agency 2	https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/175/2553?npage=2	Orange 3	0.637	Vista Del Sol Park	Local Park 2	4
13544	13544	13543	{"type": "Polygon", "coordinates": [[[-117.63464, 33.44433], [-117.63368, 33.44513], [-117.63359, 33.44529], [-117.63357, 33.44527], [-117.63343, 33.44529], [-117.63333, 33.44533], [-117.63317, 33.44552], [-117.63307, 33.44557], [-117.63301, 33.44552], [-117.63294, 33.44537], [-117.63296, 33.44526], [-117.63278, 33.44448], [-117.63247, 33.44421], [-117.63228, 33.44418], [-117.63214, 33.44405], [-117.63214, 33.444], [-117.63222, 33.44385], [-117.63236, 33.44332], [-117.6324, 33.44296], [-117.63253, 33.44286], [-117.63261, 33.44289], [-117.63314, 33.4433], [-117.63313, 33.44335], [-117.63427, 33.4443], [-117.63438, 33.44434], [-117.63448, 33.44433], [-117.63456, 33.44428], [-117.63464, 33.44433]]]}	Open Access 1	48827	Jim Johnson Memorial Sports Park	33546	6132	Marblehead Development Partners LLC 1045	Private 7	Home Owners Association 16	Private 14	1296	San Clemente, City of 350	City 2	City Agency 2	https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/187/2783	Orange 3	7.375	Jim Johnson Memorial Sports Park	Local Recreation Area 3	4
13701	13701	13700	{"type": "MultiPolygon", "coordinates": [[[[-117.63252, 33.4339], [-117.63259, 33.43393], [-117.63262, 33.43399], [-117.63263, 33.43406], [-117.63262, 33.43414], [-117.63251, 33.43429], [-117.63248, 33.43427], [-117.63244, 33.43427], [-117.63226, 33.43438], [-117.6319, 33.43429], [-117.63182, 33.43432], [-117.63142, 33.43433], [-117.63138, 33.43432], [-117.63136, 33.43428], [-117.6312, 33.43434], [-117.63105, 33.43432], [-117.63095, 33.43434], [-117.63103, 33.43432], [-117.63107, 33.43427], [-117.63109, 33.43427], [-117.63111, 33.43423], [-117.63109, 33.43416], [-117.63125, 33.43393], [-117.63252, 33.4339]]], [[[-117.63431, 33.44132], [-117.6342, 33.44142], [-117.63397, 33.44124], [-117.63408, 33.44114], [-117.63431, 33.44132]]]]}	Open Access 1	48828	Pico Park	33547	6132	Marblehead Development Partners LLC 1045	Private 7	Home Owners Association 16	Private 14	1296	San Clemente, City of 350	City 2	City Agency 2	https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/177/2783	Orange 3	1.598	Pico Park	Local Park 2	4
13710	13710	13709	{"type": "Polygon", "coordinates": [[[-117.63508, 33.43915], [-117.63504, 33.43931], [-117.63483, 33.43958], [-117.6348, 33.43975], [-117.63483, 33.43992], [-117.63482, 33.43996], [-117.6348, 33.43996], [-117.63467, 33.43984], [-117.63463, 33.43977], [-117.63447, 33.43944], [-117.63446, 33.43937], [-117.63453, 33.43926], [-117.63476, 33.43918], [-117.63492, 33.4391], [-117.63508, 33.43915]]]}	Open Access 1	48829	Canyon View Park	33548	6132	Marblehead Development Partners LLC 1045	Private 7	Home Owners Association 16	Private 14	1296	San Clemente, City of 350	City 2	City Agency 2	https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/173/2783	Orange 3	0.667	Canyon View Park	Local Park 2	4

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