calands: units_with_maps: 2 rows where ACRES = "6.767"

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

2 rows where ACRES = "6.767"

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
11115	11115	11114	{"type": "MultiPolygon", "coordinates": [[[[-121.79303, 38.68953], [-121.79303, 38.68978], [-121.793, 38.68976], [-121.79182, 38.68975], [-121.79135, 38.68992], [-121.79135, 38.68994], [-121.79148, 38.69016], [-121.79152, 38.69017], [-121.79134, 38.69024], [-121.79109, 38.6903], [-121.79058, 38.69035], [-121.79055, 38.69034], [-121.79052, 38.69031], [-121.79042, 38.69003], [-121.79023, 38.68971], [-121.7902, 38.68954], [-121.7902, 38.6895], [-121.79023, 38.68952], [-121.79133, 38.68953], [-121.79135, 38.68951], [-121.79136, 38.68927], [-121.79133, 38.68924], [-121.79145, 38.68925], [-121.79143, 38.68927], [-121.79142, 38.68951], [-121.79145, 38.68953], [-121.793, 38.68954], [-121.79303, 38.68953]]], [[[-121.79678, 38.69034], [-121.79678, 38.69045], [-121.79643, 38.69046], [-121.79642, 38.69086], [-121.79652, 38.69115], [-121.79652, 38.69146], [-121.79647, 38.69151], [-121.79645, 38.69156], [-121.79646, 38.69163], [-121.79652, 38.69168], [-121.79651, 38.69198], [-121.7963, 38.69198], [-121.79631, 38.6917], [-121.79622, 38.69165], [-121.79624, 38.69158], [-121.79622, 38.69151], [-121.79631, 38.69147], [-121.79631, 38.69098], [-121.79623, 38.69094], [-121.79625, 38.69086], [-121.79623, 38.69081], [-121.79619, 38.69076], [-121.79618, 38.69048], [-121.79463, 38.69047], [-121.79463, 38.69026], [-121.79458, 38.69021], [-121.79463, 38.69013], [-121.79462, 38.69006], [-121.79458, 38.69002], [-121.79463, 38.68998], [-121.79463, 38.68976], [-121.79324, 38.68975], [-121.79324, 38.68959], [-121.79463, 38.6896], [-121.79464, 38.68938], [-121.79459, 38.68934], [-121.79463, 38.6893], [-121.79464, 38.68925], [-121.79463, 38.68919], [-121.79459, 38.68914], [-121.79464, 38.6891], [-121.79465, 38.68857], [-121.79482, 38.68857], [-121.79482, 38.6891], [-121.79487, 38.68914], [-121.79483, 38.68919], [-121.79482, 38.68925], [-121.79483, 38.6893], [-121.79488, 38.68935], [-121.79488, 38.68959], [-121.79526, 38.6896], [-121.79526, 38.68985], [-121.79537, 38.6899], [-121.79536, 38.68996], [-121.79538, 38.69002], [-121.79526, 38.69008], [-121.79526, 38.69033], [-121.79678, 38.69034]]], [[[-121.7977, 38.69031], [-121.7977, 38.69039], [-121.79695, 38.69039], [-121.79695, 38.69031], [-121.7977, 38.69031]]]]}	Open Access 1	21379	Cline Park	17427	1665	Woodland, City of 547	City 2	City Agency 2	http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp	City 2	1665	Woodland, City of 540	City 2	City Agency 2		Yolo 33	6.767	Cline Park	0	Local Park 2	4
12344	12344	12343	{"type": "Polygon", "coordinates": [[[-117.81933, 33.62712], [-117.81916, 33.62746], [-117.81902, 33.62748], [-117.81879, 33.62748], [-117.81839, 33.62743], [-117.81831, 33.62741], [-117.81704, 33.62691], [-117.81689, 33.62675], [-117.81677, 33.62651], [-117.81667, 33.62604], [-117.81801, 33.62542], [-117.81803, 33.62565], [-117.81807, 33.62587], [-117.81815, 33.62609], [-117.81833, 33.62639], [-117.81848, 33.62658], [-117.81866, 33.62675], [-117.81887, 33.6269], [-117.81909, 33.62702], [-117.81933, 33.62712]]]}	Restricted Access 2	36117	HOA Community Park	31968	6022	Summit at Turtle Ridge Community Association 1019	Private 7	Home Owners Association 16	http://turtleridgehoa.net/	Private 14	6022	Summit at Turtle Ridge Community Association 981	Private 7	Home Owners Association 15		Orange 3	6.767	HOA Community Park	0	Private Recreation or Education 65	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]);