calands: units_with_maps: 4 rows where ACCESS

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

4 rows where ACCESS_TYP = 1 and ACRES = "0.925"

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
7063	7063	7062	{"type": "MultiPolygon", "coordinates": [[[[-118.38413, 33.84424], [-118.3838, 33.84437], [-118.38362, 33.84405], [-118.3836, 33.84397], [-118.38363, 33.8439], [-118.38368, 33.84385], [-118.38376, 33.84383], [-118.38386, 33.84383], [-118.38392, 33.84387], [-118.38397, 33.84393], [-118.38413, 33.84424]]], [[[-118.38438, 33.84494], [-118.38429, 33.84499], [-118.3841, 33.84497], [-118.38404, 33.8449], [-118.38388, 33.84456], [-118.38423, 33.84445], [-118.38441, 33.84478], [-118.38441, 33.84486], [-118.38438, 33.84494]]]]}	Open Access 1	6061	Vincent Park	27128	1270	Redondo Beach, City of 246	City 2	City Agency 2	http://www.redondo.org	City 2	1270	Redondo Beach, City of 242	City 2	City Agency 2		Los Angeles 6	0.925	Vincent Park	Local Park 2	4
7169	7169	7168	{"type": "Polygon", "coordinates": [[[-118.50409, 34.09527], [-118.5041, 34.09539], [-118.50408, 34.09553], [-118.50389, 34.09616], [-118.50387, 34.0965], [-118.50376, 34.0969], [-118.50375, 34.09712], [-118.50371, 34.09712], [-118.5037, 34.09707], [-118.50362, 34.09707], [-118.50363, 34.09692], [-118.50374, 34.09653], [-118.50377, 34.09614], [-118.50396, 34.09549], [-118.50397, 34.09527], [-118.50389, 34.09486], [-118.50364, 34.09423], [-118.50374, 34.09421], [-118.50392, 34.0946], [-118.50404, 34.09495], [-118.50409, 34.09527]]]}	Open Access 1	6383	Mandeville Canyon Open Space	21739	1188	Los Angeles, City of 24	City 2	City Agency 2	http://lacity.org/	City 2	1188	Los Angeles, City of 24	City 2	City Agency 2		Los Angeles 6	0.925	Mandeville Canyon OS	Local Recreation Area 3	4
9308	9308	9307	{"type": "Polygon", "coordinates": [[[-122.19271, 37.80049], [-122.19222, 37.80069], [-122.19223, 37.80074], [-122.19163, 37.80082], [-122.19163, 37.8007], [-122.19166, 37.80061], [-122.19171, 37.80053], [-122.19181, 37.80044], [-122.19203, 37.80032], [-122.19249, 37.80017], [-122.19271, 37.80049]]]}	Open Access 1	15515	Avenue Terrance Park	15726	1228	Oakland, City of 58	City 2	City Agency 2	http://www2.oaklandnet.com/Government/o/opr/index.htm	City 2	1228	Oakland, City of 56	City 2	City Agency 2		Alameda 17	0.925	Avenue Terrance Park	Local Park 2	4
14474	14474	14473	{"type": "Polygon", "coordinates": [[[-121.40937, 38.39491], [-121.40933, 38.39492], [-121.40931, 38.39494], [-121.40931, 38.39518], [-121.40915, 38.39516], [-121.40907, 38.39518], [-121.40901, 38.39524], [-121.409, 38.39531], [-121.40903, 38.39538], [-121.40903, 38.39545], [-121.40856, 38.39544], [-121.40857, 38.39481], [-121.40908, 38.39481], [-121.40937, 38.39491]]]}	Open Access 1	47132	Bridgeview Park	30809	2194	Consumnes Community Services District 567	Special District 4	Community Services District 19	http://www.yourcsd.com/parks/parks_list.asp	Special District 4	2194	Consumnes Community Services District 559	Special District 4	Community Services District 17	http://www.yourcsd.com/595/Bridgeview-Park	Sacramento 41	0.925	Bridgeview 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]);