units_with_maps

Table actions

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

1 row where DES_TP = 3, MNG_AGENCY = 543 and UNIT_NAME = "Laguna Creek Parkway"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Sacramento, County of · 1 ✖

DES_TP 1

  • Local Recreation Area · 1 ✖

ACCESS_TYP 1

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
11404 11404 11403 {"type": "MultiPolygon", "coordinates": [[[[-121.34337, 38.42102], [-121.34299, 38.42102], [-121.34294, 38.42105], [-121.34288, 38.42102], [-121.34281, 38.42101], [-121.34231, 38.4211], [-121.34215, 38.42109], [-121.34206, 38.42113], [-121.342, 38.4211], [-121.34169, 38.42116], [-121.34132, 38.42126], [-121.3413, 38.42129], [-121.34121, 38.42128], [-121.34114, 38.42132], [-121.34111, 38.42138], [-121.34083, 38.42138], [-121.34065, 38.42153], [-121.34024, 38.4216], [-121.34023, 38.42183], [-121.34015, 38.42182], [-121.34007, 38.42185], [-121.34002, 38.4218], [-121.33939, 38.42179], [-121.3394, 38.42127], [-121.33946, 38.42122], [-121.3397, 38.42118], [-121.34181, 38.42062], [-121.34197, 38.42062], [-121.34204, 38.42059], [-121.34208, 38.42054], [-121.34214, 38.42056], [-121.34244, 38.42056], [-121.34275, 38.42053], [-121.34281, 38.4205], [-121.34286, 38.42054], [-121.34293, 38.42055], [-121.34306, 38.42053], [-121.34331, 38.42053], [-121.34337, 38.42056], [-121.34338, 38.42059], [-121.34337, 38.42102]]], [[[-121.348, 38.42339], [-121.34793, 38.42339], [-121.34784, 38.42349], [-121.34725, 38.42351], [-121.34725, 38.42321], [-121.3472, 38.42317], [-121.34724, 38.42314], [-121.34726, 38.42308], [-121.34723, 38.42298], [-121.34722, 38.42258], [-121.34717, 38.42232], [-121.34709, 38.42212], [-121.34692, 38.42185], [-121.34667, 38.42158], [-121.34663, 38.42151], [-121.34658, 38.42147], [-121.3465, 38.42146], [-121.3465, 38.4214], [-121.34617, 38.4212], [-121.34574, 38.42108], [-121.34568, 38.42111], [-121.34564, 38.42107], [-121.34555, 38.42106], [-121.34546, 38.42107], [-121.34521, 38.42105], [-121.34422, 38.42105], [-121.34408, 38.42102], [-121.34398, 38.42106], [-121.34393, 38.42102], [-121.34355, 38.42102], [-121.34357, 38.41969], [-121.34366, 38.41886], [-121.3437, 38.41882], [-121.34376, 38.4188], [-121.34483, 38.4188], [-121.34482, 38.42053], [-121.34515, 38.42053], [-121.3452, 38.42049], [-121.34531, 38.42053], [-121.34542, 38.42051], [-121.34561, 38.42052], [-121.34588, 38.42056], [-121.34599, 38.4206], [-121.34605, 38.42059], [-121.34612, 38.42056], [-121.34617, 38.42059], [-121.34656, 38.42078], [-121.34687, 38.42084], [-121.34691, 38.42094], [-121.34697, 38.42104], [-121.34705, 38.42113], [-121.34715, 38.42122], [-121.34737, 38.42134], [-121.34765, 38.42141], [-121.34769, 38.42143], [-121.34772, 38.42147], [-121.34773, 38.42167], [-121.34778, 38.42186], [-121.34795, 38.42229], [-121.348, 38.42247], [-121.34802, 38.42262], [-121.34802, 38.42291], [-121.348, 38.42302], [-121.348, 38.42339]]], [[[-121.3531, 38.42257], [-121.35311, 38.42341], [-121.35308, 38.42346], [-121.35302, 38.42348], [-121.35198, 38.42348], [-121.35198, 38.42332], [-121.35204, 38.42312], [-121.35213, 38.42298], [-121.35228, 38.42282], [-121.35243, 38.42272], [-121.35265, 38.42263], [-121.35289, 38.42258], [-121.3531, 38.42257]]], [[[-121.36834, 38.41988], [-121.36825, 38.41988], [-121.36759, 38.41811], [-121.36706, 38.41799], [-121.36678, 38.41806], [-121.3666, 38.41807], [-121.36657, 38.41802], [-121.36652, 38.41797], [-121.36645, 38.41795], [-121.36637, 38.41796], [-121.36628, 38.4178], [-121.36371, 38.41719], [-121.36245, 38.41682], [-121.36183, 38.41627], [-121.36165, 38.41627], [-121.35967, 38.41682], [-121.35955, 38.41693], [-121.35946, 38.41691], [-121.35936, 38.41693], [-121.35926, 38.41701], [-121.35892, 38.41715], [-121.35854, 38.41733], [-121.35817, 38.41754], [-121.35779, 38.41778], [-121.35768, 38.41782], [-121.35763, 38.41786], [-121.35762, 38.41792], [-121.35763, 38.41798], [-121.35766, 38.41802], [-121.35718, 38.41834], [-121.35717, 38.41841], [-121.35709, 38.41842], [-121.35705, 38.41845], [-121.35703, 38.41849], [-121.35703, 38.41854], [-121.35706, 38.41859], [-121.3571, 38.41861], [-121.35694, 38.41884], [-121.35691, 38.41931], [-121.35684, 38.41932], [-121.35679, 38.41937], [-121.35678, 38.41943], [-121.35681, 38.41948], [-121.35673, 38.41953], [-121.35653, 38.42003], [-121.35645, 38.42003], [-121.35638, 38.42006], [-121.3563, 38.42018], [-121.35614, 38.42031], [-121.35594, 38.42043], [-121.35582, 38.42054], [-121.35533, 38.42139], [-121.3552, 38.42149], [-121.35518, 38.42153], [-121.35518, 38.42157], [-121.35512, 38.42159], [-121.35495, 38.42184], [-121.35563, 38.42207], [-121.35612, 38.42336], [-121.35363, 38.42338], [-121.35357, 38.42336], [-121.35353, 38.4233], [-121.35332, 38.42353], [-121.35324, 38.4163], [-121.3563, 38.41629], [-121.35595, 38.41801], [-121.35597, 38.41802], [-121.35628, 38.41799], [-121.35705, 38.41727], [-121.35779, 38.417], [-121.35794, 38.41628], [-121.35944, 38.41627], [-121.35944, 38.41534], [-121.36041, 38.41535], [-121.36095, 38.4153], [-121.36196, 38.41542], [-121.36268, 38.41542], [-121.36362, 38.4161], [-121.36457, 38.4166], [-121.3658, 38.41631], [-121.36584, 38.41638], [-121.36592, 38.41642], [-121.36601, 38.41641], [-121.36608, 38.41637], [-121.36733, 38.41717], [-121.36834, 38.41988]]], [[[-121.35312, 38.42382], [-121.35203, 38.42429], [-121.35182, 38.42415], [-121.35182, 38.42407], [-121.35185, 38.42393], [-121.35182, 38.42379], [-121.35182, 38.42368], [-121.35192, 38.42365], [-121.35295, 38.42366], [-121.3531, 38.4237], [-121.35312, 38.42382]]], [[[-121.35447, 38.42365], [-121.3538, 38.42377], [-121.3536, 38.42387], [-121.35346, 38.424], [-121.35337, 38.42417], [-121.35334, 38.42437], [-121.35328, 38.42467], [-121.35327, 38.42374], [-121.35332, 38.42367], [-121.35337, 38.42365], [-121.35373, 38.42365], [-121.35373, 38.42367], [-121.35374, 38.42369], [-121.35387, 38.42365], [-121.35447, 38.42365]]], [[[-121.37599, 38.43282], [-121.37587, 38.43303], [-121.37545, 38.4329], [-121.37505, 38.43271], [-121.37466, 38.43242], [-121.37452, 38.4323], [-121.37425, 38.43221], [-121.37404, 38.43224], [-121.37392, 38.43231], [-121.37383, 38.4324], [-121.37353, 38.43288], [-121.37343, 38.43262], [-121.37365, 38.4321], [-121.37447, 38.43205], [-121.37528, 38.43261], [-121.37599, 38.43282]]], [[[-121.38109, 38.43438], [-121.38073, 38.43439], [-121.38069, 38.43442], [-121.38059, 38.43441], [-121.38052, 38.43444], [-121.38045, 38.43437], [-121.37978, 38.43427], [-121.37971, 38.43428], [-121.37967, 38.43423], [-121.37961, 38.4342], [-121.37959, 38.43407], [-121.37926, 38.43394], [-121.37886, 38.43384], [-121.37883, 38.43378], [-121.37877, 38.43374], [-121.37869, 38.43374], [-121.37861, 38.43378], [-121.37852, 38.43372], [-121.37828, 38.43363], [-121.37828, 38.43358], [-121.37788, 38.43349], [-121.37745, 38.43332], [-121.377, 38.43319], [-121.37689, 38.43317], [-121.37687, 38.43331], [-121.37669, 38.43318], [-121.37659, 38.43314], [-121.37606, 38.43309], [-121.37615, 38.43292], [-121.38002, 38.43402], [-121.38039, 38.43422], [-121.38109, 38.43426], [-121.38109, 38.43438]]], [[[-121.41743, 38.43574], [-121.41727, 38.43566], [-121.41709, 38.43562], [-121.4169, 38.4356], [-121.41666, 38.4356], [-121.41648, 38.43558], [-121.41633, 38.43553], [-121.41618, 38.43546], [-121.41606, 38.43536], [-121.41595, 38.43523], [-121.41588, 38.43507], [-121.41586, 38.43493], [-121.41553, 38.43459], [-121.41522, 38.43433], [-121.41495, 38.43413], [-121.41461, 38.43392], [-121.41431, 38.43377], [-121.414, 38.43369], [-121.41371, 38.43364], [-121.41284, 38.43361], [-121.4124, 38.43356], [-121.41197, 38.43348], [-121.41143, 38.43333], [-121.41108, 38.43327], [-121.41084, 38.43325], [-121.41061, 38.43326], [-121.41037, 38.4333], [-121.4101, 38.43332], [-121.40989, 38.43329], [-121.40948, 38.43318], [-121.40872, 38.43309], [-121.40871, 38.43284], [-121.40795, 38.43275], [-121.40774, 38.43271], [-121.4074, 38.43258], [-121.40713, 38.43241], [-121.40647, 38.4334], [-121.40637, 38.43328], [-121.40593, 38.43262], [-121.4058, 38.43249], [-121.40568, 38.43238], [-121.40547, 38.43224], [-121.40526, 38.43214], [-121.40501, 38.43205], [-121.40472, 38.432], [-121.40388, 38.4319], [-121.40366, 38.4319], [-121.40339, 38.43193], [-121.4031, 38.432], [-121.40291, 38.43207], [-121.40205, 38.43255], [-121.40186, 38.43263], [-121.40166, 38.43269], [-121.40136, 38.43274], [-121.40109, 38.43275], [-121.40076, 38.43272], [-121.40049, 38.43266], [-121.40027, 38.43258], [-121.40005, 38.43246], [-121.39985, 38.43231], [-121.3997, 38.43216], [-121.39909, 38.43082], [-121.39895, 38.4304], [-121.39889, 38.43028], [-121.39889, 38.43024], [-121.39894, 38.4302], [-121.39927, 38.43011], [-121.39945, 38.43008], [-121.39956, 38.43031], [-121.39998, 38.43046], [-121.40079, 38.43023], [-121.40086, 38.43003], [-121.40075, 38.4298], [-121.40226, 38.42939], [-121.40232, 38.42959], [-121.40265, 38.42973], [-121.40275, 38.42992], [-121.4029, 38.43015], [-121.40322, 38.43015], [-121.40345, 38.43013], [-121.40367, 38.42993], [-121.40378, 38.42988], [-121.40429, 38.42997], [-121.40434, 38.43003], [-121.40442, 38.43006], [-121.40455, 38.43005], [-121.40473, 38.43006], [-121.40497, 38.43009], [-121.40554, 38.43028], [-121.40589, 38.43034], [-121.40603, 38.43041], [-121.40612, 38.43042], [-121.40621, 38.43039], [-121.40622, 38.43053], [-121.40655, 38.4306], [-121.40692, 38.43073], [-121.40777, 38.43114], [-121.40837, 38.43145], [-121.40872, 38.4315], [-121.40873, 38.43149], [-121.40874, 38.43084], [-121.41306, 38.43081], [-121.4173, 38.43327], [-121.4173, 38.43363], [-121.41743, 38.43512], [-121.41743, 38.43574]]], [[[-121.39814, 38.43322], [-121.39812, 38.43418], [-121.39788, 38.43417], [-121.39764, 38.43408], [-121.39736, 38.43403], [-121.39681, 38.43401], [-121.3968, 38.43398], [-121.39409, 38.43397], [-121.39409, 38.43348], [-121.39232, 38.43347], [-121.39231, 38.43627], [-121.39217, 38.43648], [-121.39186, 38.43656], [-121.39189, 38.43319], [-121.39814, 38.43322]]], [[[-121.42456, 38.43799], [-121.42243, 38.438], [-121.41963, 38.43674], [-121.41945, 38.43662], [-121.41932, 38.43649], [-121.4192, 38.43633], [-121.41912, 38.43618], [-121.41788, 38.43618], [-121.41786, 38.43448], [-121.42043, 38.43446], [-121.42019, 38.43274], [-121.42042, 38.43274], [-121.42044, 38.43341], [-121.42056, 38.43409], [-121.4209, 38.43413], [-121.42089, 38.43432], [-121.42085, 38.43448], [-121.42081, 38.43479], [-121.42098, 38.43539], [-121.42307, 38.43538], [-121.42376, 38.4356], [-121.42396, 38.43652], [-121.42446, 38.4374], [-121.42456, 38.43787], [-121.42456, 38.43799]], [[-121.42126, 38.43616], [-121.42075, 38.43588], [-121.42074, 38.43589], [-121.42073, 38.43617], [-121.42028, 38.43617], [-121.42027, 38.43618], [-121.42083, 38.43649], [-121.42209, 38.43706], [-121.42322, 38.43761], [-121.42346, 38.43769], [-121.42322, 38.43705], [-121.42313, 38.43693], [-121.42297, 38.4368], [-121.42286, 38.43673], [-121.42271, 38.43668], [-121.42254, 38.43664], [-121.42241, 38.43662], [-121.42204, 38.43647], [-121.4216, 38.43634], [-121.42126, 38.43616]]]]} Open Access 1 22184 Laguna Creek Parkway 20850 316 Sacramento, County of 550 County 3 County Agency 3 http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx County 3 316 Sacramento, County of 543 County 3 County Agency 3   Sacramento 41 248.446 Laguna Creek Parkway 0 Local Recreation Area 3 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);