calands: units_with_maps: 3 rows where COUNTY = 9 and DES

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

3 rows where COUNTY = 9 and DES_TP = 65

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
5694	5694	5693	{"type": "MultiPolygon", "coordinates": [[[[-119.63503, 36.86465], [-119.63507, 36.86466], [-119.63533, 36.86484], [-119.63533, 36.86486], [-119.63468, 36.86486], [-119.63468, 36.86484], [-119.63503, 36.86465]]], [[[-119.63664, 36.86487], [-119.63569, 36.86487], [-119.63566, 36.86484], [-119.63602, 36.86449], [-119.63664, 36.86487]]], [[[-119.64194, 36.86363], [-119.64191, 36.86365], [-119.6416, 36.86365], [-119.64158, 36.86363], [-119.6416, 36.86306], [-119.64163, 36.86303], [-119.6419, 36.86303], [-119.64193, 36.86305], [-119.64194, 36.86363]]], [[[-119.64596, 36.86344], [-119.64596, 36.86363], [-119.64537, 36.86363], [-119.64537, 36.86344], [-119.64596, 36.86344]]], [[[-119.64569, 36.86041], [-119.64624, 36.86041], [-119.64627, 36.86042], [-119.6463, 36.86046], [-119.6463, 36.86082], [-119.64628, 36.86085], [-119.64624, 36.86087], [-119.6457, 36.86088], [-119.64566, 36.86086], [-119.64564, 36.86083], [-119.64564, 36.86047], [-119.64565, 36.86043], [-119.64569, 36.86041]]]]}	Restricted Access 2	48939	Unknown park - Harlan Ranch Community Association	33655	6138	Harlan Ranch Community Association 814	Private 7	Home Owners Association 16	http://www.harlanranchca.com/default.php	Private 14	6138	Harlan Ranch Community Association 793	Private 7	Home Owners Association 15		Fresno 9	2.17		Private Recreation or Education 65	4
5753	5753	5752	{"type": "Polygon", "coordinates": [[[-119.54118, 36.51798], [-119.54116, 36.52003], [-119.54018, 36.52002], [-119.54021, 36.51798], [-119.54118, 36.51798]]]}	Restricted Access 2	3683	Kingsburg Historical Park	32675	3138	Kingsburg Historical Society 817	Non Profit 6	Non Profit - Other 22	http://www.kingsburghistoricalpark.org/	Non Governmental Organization 10	3138	Kingsburg Historical Society 795	Non Profit 6	Non Profit - Other 20	http://kingsburghistoricalpark.org/	Fresno 9	4.887	Kingsburg Historical Park	Private Recreation or Education 65	4
12454	12454	12453	{"type": "Polygon", "coordinates": [[[-119.76638, 36.87034], [-119.76629, 36.87046], [-119.76408, 36.8694], [-119.76326, 36.86965], [-119.76233, 36.87081], [-119.76208, 36.87074], [-119.7624, 36.87065], [-119.76252, 36.87049], [-119.7625, 36.87038], [-119.76256, 36.87037], [-119.76263, 36.87028], [-119.76271, 36.87026], [-119.7628, 36.87015], [-119.76278, 36.87009], [-119.76286, 36.87007], [-119.76291, 36.87001], [-119.76286, 36.86982], [-119.76309, 36.86977], [-119.76322, 36.86962], [-119.76333, 36.8696], [-119.76338, 36.86952], [-119.76353, 36.86947], [-119.76368, 36.86929], [-119.76359, 36.86895], [-119.76313, 36.86876], [-119.76329, 36.86858], [-119.76333, 36.86848], [-119.76336, 36.86837], [-119.76337, 36.86821], [-119.76329, 36.86781], [-119.76331, 36.86778], [-119.76346, 36.86777], [-119.76382, 36.86776], [-119.76417, 36.86781], [-119.76404, 36.86792], [-119.76406, 36.86877], [-119.7637, 36.86896], [-119.76375, 36.86923], [-119.7638, 36.86933], [-119.76389, 36.86937], [-119.76408, 36.86931], [-119.76411, 36.86937], [-119.76417, 36.8694], [-119.76435, 36.86935], [-119.76442, 36.86951], [-119.76448, 36.8695], [-119.76506, 36.86978], [-119.76509, 36.86975], [-119.76525, 36.86982], [-119.76523, 36.86986], [-119.76555, 36.87001], [-119.76558, 36.86999], [-119.76576, 36.87008], [-119.76574, 36.87013], [-119.76616, 36.87034], [-119.76638, 36.87034]]]}	No Public Access 3	48758	Floyd Boler Park	33798	6130	Park Fort Washington Association 1026	Private 7	Home Owners Association 16	http://parkfortwashington.com/	Private 14	6130	Park Fort Washington Association 988	Private 7	Home Owners Association 15		Fresno 9	3.203	Floyd Boler Park	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]);