calands: units_with_maps: 1 row where DES_TP = 3, MNG_AG_TYP = 4 and SUID

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

1 row where DES_TP = 3, MNG_AG_TYP = 4 and SUID_NMA = 26366

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
13657	13657	13656	{"type": "MultiPolygon", "coordinates": [[[[-121.37155, 38.45985], [-121.37154, 38.45996], [-121.37146, 38.46003], [-121.37017, 38.45991], [-121.36763, 38.45992], [-121.36735, 38.45994], [-121.367, 38.46], [-121.36674, 38.4601], [-121.36661, 38.45993], [-121.3657, 38.45993], [-121.36568, 38.45996], [-121.36559, 38.45994], [-121.36551, 38.45996], [-121.36548, 38.45994], [-121.36472, 38.45994], [-121.3647, 38.45996], [-121.36461, 38.45994], [-121.36453, 38.45996], [-121.36451, 38.45994], [-121.36244, 38.45996], [-121.36243, 38.45997], [-121.36206, 38.45998], [-121.36202, 38.46], [-121.36197, 38.45996], [-121.3619, 38.45995], [-121.3618, 38.45998], [-121.36102, 38.45998], [-121.36098, 38.46], [-121.36093, 38.45997], [-121.36088, 38.45996], [-121.36082, 38.45997], [-121.36077, 38.46], [-121.36073, 38.45998], [-121.35998, 38.45998], [-121.35995, 38.46001], [-121.35987, 38.45996], [-121.35981, 38.45995], [-121.35966, 38.45998], [-121.35918, 38.45998], [-121.35902, 38.45995], [-121.35895, 38.45997], [-121.3589, 38.46], [-121.35888, 38.45999], [-121.35793, 38.45999], [-121.35789, 38.46002], [-121.35783, 38.45998], [-121.35778, 38.45997], [-121.35771, 38.45999], [-121.35767, 38.46002], [-121.35763, 38.46], [-121.35723, 38.46], [-121.35723, 38.45991], [-121.35778, 38.4599], [-121.35779, 38.45983], [-121.35781, 38.45982], [-121.35784, 38.45983], [-121.35846, 38.45983], [-121.35852, 38.4598], [-121.35858, 38.45985], [-121.35868, 38.45987], [-121.35881, 38.45984], [-121.36025, 38.45983], [-121.36038, 38.45986], [-121.36046, 38.45984], [-121.36054, 38.45979], [-121.36059, 38.45981], [-121.36111, 38.45981], [-121.3612, 38.45984], [-121.36141, 38.45978], [-121.36177, 38.45978], [-121.36188, 38.45981], [-121.36242, 38.45981], [-121.36244, 38.45952], [-121.36488, 38.45951], [-121.36489, 38.45988], [-121.36602, 38.45987], [-121.36603, 38.45976], [-121.36696, 38.45976], [-121.3672, 38.45978], [-121.36792, 38.45978], [-121.36798, 38.45973], [-121.36807, 38.45976], [-121.36816, 38.45974], [-121.36822, 38.45978], [-121.36948, 38.45978], [-121.36949, 38.45986], [-121.37155, 38.45985]]], [[[-121.37517, 38.45985], [-121.37514, 38.46002], [-121.37508, 38.46005], [-121.372, 38.46001], [-121.37194, 38.45999], [-121.37193, 38.45994], [-121.37196, 38.45976], [-121.37479, 38.45976], [-121.37483, 38.45985], [-121.37517, 38.45985]]], [[[-121.3809, 38.46015], [-121.38018, 38.46015], [-121.38012, 38.46009], [-121.38002, 38.46006], [-121.37988, 38.46009], [-121.37944, 38.46009], [-121.37928, 38.46005], [-121.37919, 38.46008], [-121.37913, 38.46014], [-121.37844, 38.46014], [-121.37837, 38.46007], [-121.37828, 38.46005], [-121.37814, 38.46008], [-121.37769, 38.46008], [-121.37753, 38.46005], [-121.37744, 38.46007], [-121.37738, 38.46013], [-121.37661, 38.46012], [-121.37656, 38.46008], [-121.37649, 38.46007], [-121.37642, 38.46008], [-121.37637, 38.46012], [-121.37599, 38.46012], [-121.37599, 38.46036], [-121.37565, 38.46019], [-121.37532, 38.46009], [-121.37529, 38.46007], [-121.37528, 38.46004], [-121.37531, 38.45985], [-121.37605, 38.45985], [-121.37609, 38.45989], [-121.37615, 38.45991], [-121.37623, 38.4599], [-121.37629, 38.45985], [-121.37703, 38.45985], [-121.37707, 38.4599], [-121.37715, 38.45992], [-121.37723, 38.4599], [-121.37728, 38.45986], [-121.37802, 38.45986], [-121.37807, 38.4599], [-121.37813, 38.45992], [-121.37821, 38.4599], [-121.37827, 38.45986], [-121.379, 38.45986], [-121.37906, 38.45991], [-121.37913, 38.45992], [-121.3792, 38.45991], [-121.37925, 38.45987], [-121.38003, 38.45987], [-121.38014, 38.4599], [-121.3803, 38.45987], [-121.38084, 38.45987], [-121.38087, 38.45989], [-121.3809, 38.45992], [-121.3809, 38.46015]]], [[[-121.38329, 38.46015], [-121.38276, 38.46015], [-121.38275, 38.46011], [-121.38271, 38.46008], [-121.38262, 38.46004], [-121.38117, 38.46004], [-121.38113, 38.46003], [-121.38111, 38.46], [-121.3811, 38.45988], [-121.38319, 38.45988], [-121.38329, 38.46015]]], [[[-121.39484, 38.46015], [-121.3925, 38.46016], [-121.39247, 38.46018], [-121.39237, 38.46015], [-121.39232, 38.46016], [-121.39227, 38.46019], [-121.39223, 38.46016], [-121.3915, 38.46016], [-121.39147, 38.46018], [-121.39139, 38.46016], [-121.39133, 38.46017], [-121.39128, 38.46021], [-121.39123, 38.46016], [-121.39051, 38.46016], [-121.39049, 38.46018], [-121.39042, 38.46016], [-121.39035, 38.46018], [-121.3903, 38.46021], [-121.39024, 38.46017], [-121.38951, 38.46017], [-121.3895, 38.46018], [-121.38943, 38.46016], [-121.38936, 38.46017], [-121.3893, 38.46022], [-121.38925, 38.46017], [-121.38878, 38.46016], [-121.38877, 38.46012], [-121.38858, 38.46012], [-121.38855, 38.46014], [-121.38847, 38.46013], [-121.38838, 38.46015], [-121.38834, 38.46012], [-121.38756, 38.46013], [-121.38753, 38.46015], [-121.38746, 38.46013], [-121.38736, 38.46015], [-121.38733, 38.46013], [-121.38658, 38.46013], [-121.38654, 38.46015], [-121.38648, 38.46012], [-121.38641, 38.46011], [-121.38629, 38.46012], [-121.38496, 38.46013], [-121.38484, 38.46011], [-121.38474, 38.46014], [-121.38365, 38.46014], [-121.38356, 38.45989], [-121.38662, 38.4599], [-121.38665, 38.45989], [-121.39349, 38.45984], [-121.3935, 38.4599], [-121.39483, 38.45991], [-121.39484, 38.46015]]], [[[-121.39891, 38.46013], [-121.39502, 38.46013], [-121.39502, 38.46007], [-121.39504, 38.46003], [-121.39509, 38.46002], [-121.3964, 38.46002], [-121.39657, 38.46005], [-121.39664, 38.46003], [-121.3967, 38.45998], [-121.39672, 38.45992], [-121.3967, 38.45986], [-121.39737, 38.45986], [-121.39742, 38.45993], [-121.39752, 38.45996], [-121.39763, 38.45994], [-121.3985, 38.45995], [-121.39885, 38.45998], [-121.39891, 38.46003], [-121.39891, 38.46013]]], [[[-121.40372, 38.46016], [-121.40302, 38.46016], [-121.40298, 38.46019], [-121.40287, 38.46016], [-121.40278, 38.46019], [-121.40274, 38.46016], [-121.40204, 38.46016], [-121.402, 38.46018], [-121.4019, 38.46015], [-121.4018, 38.46019], [-121.40176, 38.46015], [-121.40107, 38.46015], [-121.40102, 38.46018], [-121.40092, 38.46015], [-121.40082, 38.46019], [-121.40075, 38.46015], [-121.40011, 38.46015], [-121.40004, 38.46018], [-121.39994, 38.46015], [-121.39983, 38.46018], [-121.39978, 38.46014], [-121.39911, 38.46014], [-121.39912, 38.46004], [-121.39919, 38.46001], [-121.40273, 38.46003], [-121.40307, 38.46], [-121.40364, 38.45998], [-121.40368, 38.45999], [-121.40371, 38.46003], [-121.40372, 38.46016]]], [[[-121.40625, 38.46008], [-121.4054, 38.46014], [-121.40386, 38.46015], [-121.40386, 38.46006], [-121.40392, 38.45997], [-121.40393, 38.45989], [-121.40565, 38.45943], [-121.40587, 38.45972], [-121.40625, 38.46008]]]]}	Open Access 1	36024	Tillotson Parkway	26366	2160	Southgate Recreation and Park District 502	Special District 4	Recreation/Parks District 4	http://www.southgaterecandpark.net/	Special District 4	2160	Southgate Recreation and Park District 494	Special District 4	Recreation/Parks District 4		Sacramento 41	25.76	Tillotson Parkway	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]);