calands: units_with_maps: 1 row where ACCESS_TYP = 2, MNG_AGENCY = 313 and MNG_AG

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

1 row where ACCESS_TYP = 2, MNG_AGENCY = 313 and MNG_AG_LEV = 2

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
15710	15710	15709	{"type": "MultiPolygon", "coordinates": [[[[-122.6975, 38.36612], [-122.69734, 38.36619], [-122.69709, 38.36634], [-122.69536, 38.36726], [-122.69449, 38.36934], [-122.69517, 38.37036], [-122.69584, 38.37134], [-122.69411, 38.37136], [-122.69245, 38.37031], [-122.6907, 38.36986], [-122.69038, 38.36872], [-122.69177, 38.36859], [-122.69286, 38.36873], [-122.69358, 38.36666], [-122.69634, 38.36528], [-122.69642, 38.36534], [-122.69653, 38.36539], [-122.69676, 38.36547], [-122.69697, 38.36557], [-122.69712, 38.3657], [-122.6975, 38.36612]]], [[[-122.70898, 38.36012], [-122.70778, 38.36135], [-122.70767, 38.36152], [-122.7071, 38.36209], [-122.70702, 38.36205], [-122.70749, 38.36157], [-122.70685, 38.36117], [-122.70628, 38.36175], [-122.70462, 38.36108], [-122.70419, 38.36097], [-122.70374, 38.36092], [-122.70328, 38.36091], [-122.6964, 38.36125], [-122.69604, 38.36128], [-122.69564, 38.35972], [-122.69545, 38.35657], [-122.69691, 38.35647], [-122.69729, 38.35803], [-122.69748, 38.36003], [-122.69883, 38.3598], [-122.69954, 38.35961], [-122.6992, 38.35623], [-122.70064, 38.35614], [-122.70132, 38.35947], [-122.70166, 38.35957], [-122.70361, 38.35947], [-122.7057, 38.35799], [-122.70517, 38.35712], [-122.70522, 38.35674], [-122.70433, 38.35571], [-122.70408, 38.35529], [-122.70251, 38.35278], [-122.70262, 38.35201], [-122.70138, 38.35104], [-122.70123, 38.3508], [-122.70313, 38.35077], [-122.70898, 38.36012]]], [[[-122.70001, 38.36778], [-122.69854, 38.36776], [-122.69753, 38.36894], [-122.69828, 38.37051], [-122.69833, 38.37064], [-122.69784, 38.37126], [-122.69777, 38.3713], [-122.69774, 38.37131], [-122.69684, 38.37131], [-122.69615, 38.37029], [-122.6968, 38.37005], [-122.69645, 38.36954], [-122.69607, 38.36922], [-122.69604, 38.36805], [-122.69607, 38.36797], [-122.69626, 38.36772], [-122.69639, 38.36758], [-122.6976, 38.36692], [-122.69759, 38.36669], [-122.69761, 38.36658], [-122.69764, 38.36655], [-122.69857, 38.36607], [-122.70001, 38.36778]]], [[[-122.70675, 38.36236], [-122.70468, 38.36506], [-122.70424, 38.36526], [-122.70083, 38.36524], [-122.70082, 38.36531], [-122.69993, 38.36531], [-122.69981, 38.36545], [-122.69971, 38.36554], [-122.69938, 38.36556], [-122.6991, 38.36561], [-122.69892, 38.36568], [-122.69853, 38.36588], [-122.69755, 38.36467], [-122.7001, 38.36388], [-122.70223, 38.36407], [-122.70278, 38.36381], [-122.70414, 38.363], [-122.70537, 38.36235], [-122.70572, 38.36194], [-122.70675, 38.36236]]], [[[-122.705, 38.36688], [-122.70205, 38.36782], [-122.70046, 38.36783], [-122.69937, 38.36659], [-122.70193, 38.36629], [-122.7025, 38.36599], [-122.70448, 38.366], [-122.705, 38.36688]]], [[[-122.70295, 38.35048], [-122.70097, 38.35045], [-122.6998, 38.34855], [-122.70177, 38.34858], [-122.70295, 38.35048]]], [[[-122.71201, 38.36935], [-122.71009, 38.36937], [-122.70842, 38.36762], [-122.70643, 38.36764], [-122.70528, 38.36571], [-122.70759, 38.3627], [-122.70855, 38.36309], [-122.70858, 38.36313], [-122.70859, 38.36317], [-122.70813, 38.36387], [-122.70799, 38.36382], [-122.70739, 38.3645], [-122.70634, 38.36559], [-122.70696, 38.36676], [-122.70714, 38.36692], [-122.70862, 38.36683], [-122.70864, 38.36672], [-122.70856, 38.36671], [-122.70864, 38.36569], [-122.7087, 38.36569], [-122.7087, 38.36543], [-122.70875, 38.36542], [-122.70875, 38.36529], [-122.70871, 38.36529], [-122.70872, 38.36513], [-122.70868, 38.36512], [-122.70873, 38.36441], [-122.70877, 38.36415], [-122.70945, 38.3639], [-122.70951, 38.36446], [-122.70954, 38.36529], [-122.71015, 38.36529], [-122.71024, 38.36524], [-122.71043, 38.3652], [-122.71044, 38.36511], [-122.71048, 38.36504], [-122.71064, 38.36488], [-122.71069, 38.36478], [-122.71067, 38.36468], [-122.71071, 38.36464], [-122.71056, 38.36444], [-122.71052, 38.36438], [-122.7105, 38.3643], [-122.71047, 38.36415], [-122.7105, 38.36412], [-122.71044, 38.36393], [-122.71041, 38.36364], [-122.71078, 38.36365], [-122.71095, 38.36393], [-122.71102, 38.36391], [-122.71146, 38.36462], [-122.71163, 38.36782], [-122.71174, 38.36845], [-122.71201, 38.36935]]]]}	Restricted Access 2	28193	Rohnert Park Municipal Golf Course	33089	1281	Rohnert Park, City of 316	City 2	City Agency 2	http://www.ci.rohnert-park.ca.us/index.aspx?page=74	City 2	1281	Rohnert Park, City of 313	City 2	City Agency 2		Sonoma 16	282.784	Rohnert Park Municipal GC	0	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]);