calands: units_with_maps: 3 rows where AGNCY_TYP = 2, DES_TP = 3 and MNG

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

3 rows where AGNCY_TYP = 2, DES_TP = 3 and MNG_AGENCY = 90

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	DES_TP	GAP_STS
12521	12521	12520	{"type": "Polygon", "coordinates": [[[-117.67825, 33.48833], [-117.67824, 33.48894], [-117.67809, 33.48923], [-117.67786, 33.48945], [-117.67776, 33.48951], [-117.67769, 33.48954], [-117.67726, 33.48962], [-117.6771, 33.4897], [-117.67691, 33.48986], [-117.67683, 33.49], [-117.67669, 33.49032], [-117.67579, 33.4903], [-117.67544, 33.49001], [-117.67554, 33.48727], [-117.67711, 33.48729], [-117.67714, 33.48828], [-117.67825, 33.48833]]]}	Open Access 1	29007	Sports Park	25731	1305	San Juan Capistrano, City of 92	City 2	City Agency 2	http://www.sanjuancapistrano.org/	City 2	1305	San Juan Capistrano, City of 90	City 2	City Agency 2		Orange 3	15.42	Sports Park	Local Recreation Area 3	4
12522	12522	12521	{"type": "Polygon", "coordinates": [[[-117.68106, 33.48928], [-117.68085, 33.48956], [-117.67999, 33.49078], [-117.67939, 33.49175], [-117.67845, 33.49145], [-117.67845, 33.49126], [-117.6785, 33.49068], [-117.67849, 33.48932], [-117.67848, 33.48916], [-117.68063, 33.48917], [-117.68088, 33.4892], [-117.68106, 33.48928]]]}	Open Access 1	29008	Marco Forster Field	21797	1305	San Juan Capistrano, City of 92	City 2	City Agency 2	http://www.sanjuancapistrano.org/	City 2	1305	San Juan Capistrano, City of 90	City 2	City Agency 2		Orange 3	11.102	Marco Forster Field	Local Recreation Area 3	4
16097	16097	16096	{"type": "Polygon", "coordinates": [[[-117.66833, 33.48239], [-117.66753, 33.48349], [-117.66636, 33.48315], [-117.66522, 33.48358], [-117.66332, 33.48553], [-117.66332, 33.48643], [-117.66267, 33.4871], [-117.66177, 33.4874], [-117.66187, 33.4882], [-117.66208, 33.48854], [-117.66304, 33.48862], [-117.66279, 33.48938], [-117.66144, 33.49124], [-117.66074, 33.49125], [-117.65966, 33.48948], [-117.65845, 33.48856], [-117.65703, 33.48785], [-117.65532, 33.48752], [-117.65451, 33.48701], [-117.65494, 33.48562], [-117.65395, 33.48563], [-117.65255, 33.48732], [-117.6512, 33.48729], [-117.65017, 33.48585], [-117.64931, 33.48578], [-117.64897, 33.48637], [-117.64757, 33.48676], [-117.64706, 33.48744], [-117.64769, 33.48996], [-117.64704, 33.49115], [-117.6475, 33.49233], [-117.64727, 33.49452], [-117.64656, 33.49482], [-117.64626, 33.49449], [-117.6461, 33.49343], [-117.64584, 33.49259], [-117.64524, 33.4923], [-117.64453, 33.49192], [-117.64496, 33.49029], [-117.64495, 33.49028], [-117.64427, 33.49045], [-117.64391, 33.49015], [-117.64415, 33.48914], [-117.64345, 33.4891], [-117.64295, 33.49008], [-117.64139, 33.48953], [-117.64167, 33.48747], [-117.64267, 33.48569], [-117.64337, 33.48564], [-117.64353, 33.48601], [-117.64418, 33.48559], [-117.64392, 33.4845], [-117.64315, 33.48252], [-117.64103, 33.48203], [-117.63903, 33.48355], [-117.63817, 33.48309], [-117.63701, 33.4831], [-117.63525, 33.48366], [-117.63441, 33.48455], [-117.63391, 33.48531], [-117.63427, 33.48658], [-117.63428, 33.48754], [-117.63498, 33.48826], [-117.63559, 33.48884], [-117.63666, 33.48939], [-117.63761, 33.49044], [-117.63767, 33.49086], [-117.63989, 33.49156], [-117.6404, 33.49161], [-117.64152, 33.49282], [-117.64186, 33.49273], [-117.64187, 33.49388], [-117.64213, 33.49459], [-117.64259, 33.49522], [-117.64325, 33.49559], [-117.6437, 33.49581], [-117.6433, 33.49611], [-117.64265, 33.49615], [-117.64246, 33.49628], [-117.6433, 33.49665], [-117.64396, 33.49669], [-117.64426, 33.49677], [-117.64441, 33.49702], [-117.64393, 33.49905], [-117.64262, 33.49911], [-117.64131, 33.49949], [-117.63798, 33.49757], [-117.63773, 33.49708], [-117.63772, 33.49706], [-117.63797, 33.49705], [-117.63745, 33.49471], [-117.63819, 33.49263], [-117.63773, 33.49162], [-117.6348, 33.49114], [-117.63507, 33.49315], [-117.63358, 33.49455], [-117.63594, 33.4961], [-117.63616, 33.49716], [-117.63294, 33.49772], [-117.627, 33.49142], [-117.63103, 33.49068], [-117.63212, 33.48865], [-117.63214, 33.48579], [-117.62945, 33.48335], [-117.62627, 33.48104], [-117.62721, 33.48003], [-117.62851, 33.47993], [-117.62872, 33.47897], [-117.63304, 33.47912], [-117.63316, 33.48013], [-117.63759, 33.48111], [-117.63885, 33.48102], [-117.64236, 33.47809], [-117.64232, 33.47367], [-117.65552, 33.4736], [-117.65547, 33.47875], [-117.66069, 33.47842], [-117.66323, 33.47499], [-117.66298, 33.48136], [-117.66833, 33.48239]]]}	Open Access 1	12607	San Juan Capistrano City Open Space	11314	1305	San Juan Capistrano, City of 92	City 2	City Agency 2	http://www.sanjuancapistrano.org/	City 2	1305	San Juan Capistrano, City of 90	City 2	City Agency 2	http://www.sjcopenspacefoundation.org/explore.html	Orange 3	1109.775	San Juan Capistrano City OS	Local Recreation Area 3	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]);