units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and LABEL_NAME = "Frank Seymour Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, DES_TP
MNG_AG_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11036 | 11036 | 11035 | {"type": "MultiPolygon", "coordinates": [[[[-121.5303, 38.5013], [-121.53015, 38.50152], [-121.53011, 38.50154], [-121.52972, 38.5014], [-121.52942, 38.50137], [-121.52913, 38.50139], [-121.52852, 38.50152], [-121.52841, 38.50125], [-121.52672, 38.50166], [-121.52642, 38.50206], [-121.5259, 38.50284], [-121.52586, 38.50307], [-121.52622, 38.5031], [-121.52622, 38.5032], [-121.52624, 38.5033], [-121.52643, 38.50376], [-121.52648, 38.50382], [-121.52653, 38.50385], [-121.52651, 38.504], [-121.52659, 38.50421], [-121.52628, 38.50429], [-121.52639, 38.50457], [-121.52634, 38.50463], [-121.52633, 38.50471], [-121.52653, 38.50523], [-121.5266, 38.50531], [-121.52671, 38.50534], [-121.52678, 38.50552], [-121.52728, 38.50591], [-121.52727, 38.506], [-121.52748, 38.50652], [-121.52747, 38.50655], [-121.52744, 38.50658], [-121.52699, 38.50669], [-121.52664, 38.5068], [-121.52659, 38.5068], [-121.52655, 38.50677], [-121.52649, 38.5068], [-121.52635, 38.50658], [-121.5264, 38.50655], [-121.52625, 38.50632], [-121.52617, 38.50581], [-121.52599, 38.50554], [-121.52591, 38.50551], [-121.52592, 38.50546], [-121.52591, 38.50541], [-121.52574, 38.50512], [-121.52558, 38.50492], [-121.52545, 38.50482], [-121.52538, 38.5048], [-121.52529, 38.50481], [-121.52488, 38.50452], [-121.52461, 38.50444], [-121.52425, 38.50446], [-121.52416, 38.50435], [-121.5254, 38.50257], [-121.52539, 38.5025], [-121.52544, 38.50248], [-121.52551, 38.50243], [-121.52583, 38.50199], [-121.52585, 38.50194], [-121.52585, 38.50187], [-121.52594, 38.50184], [-121.52629, 38.50134], [-121.52637, 38.50137], [-121.52647, 38.50138], [-121.52656, 38.50135], [-121.52661, 38.5013], [-121.52707, 38.50067], [-121.52713, 38.50065], [-121.52784, 38.49884], [-121.52796, 38.49857], [-121.52842, 38.49708], [-121.52896, 38.49719], [-121.52839, 38.49897], [-121.52804, 38.49998], [-121.52802, 38.50016], [-121.52802, 38.50034], [-121.52805, 38.50043], [-121.52815, 38.50067], [-121.52822, 38.50075], [-121.52834, 38.50078], [-121.52845, 38.50108], [-121.5293, 38.50092], [-121.52936, 38.50105], [-121.52998, 38.50116], [-121.5303, 38.5013]]], [[[-121.52943, 38.51134], [-121.52941, 38.5114], [-121.52941, 38.51145], [-121.5296, 38.51193], [-121.52959, 38.51197], [-121.52956, 38.51199], [-121.52903, 38.51219], [-121.52896, 38.51218], [-121.52864, 38.51172], [-121.52853, 38.51166], [-121.52855, 38.51159], [-121.52822, 38.51109], [-121.52814, 38.51106], [-121.52815, 38.51101], [-121.52812, 38.51094], [-121.52783, 38.51049], [-121.52778, 38.51045], [-121.52772, 38.51042], [-121.52774, 38.51035], [-121.52741, 38.50986], [-121.52733, 38.50983], [-121.52733, 38.50974], [-121.5272, 38.50954], [-121.52853, 38.50922], [-121.52857, 38.50931], [-121.52865, 38.50938], [-121.52861, 38.50944], [-121.52882, 38.50998], [-121.5289, 38.51002], [-121.52887, 38.51013], [-121.52907, 38.51062], [-121.5291, 38.51066], [-121.52916, 38.5107], [-121.52912, 38.51076], [-121.52935, 38.51131], [-121.52943, 38.51134]]], [[[-121.52995, 38.49414], [-121.52974, 38.49478], [-121.5298, 38.49484], [-121.52972, 38.49493], [-121.52956, 38.49543], [-121.52956, 38.49552], [-121.52947, 38.49555], [-121.52937, 38.49587], [-121.52987, 38.49599], [-121.52952, 38.49671], [-121.52944, 38.49694], [-121.52833, 38.49671], [-121.52852, 38.49609], [-121.52849, 38.49603], [-121.52857, 38.49595], [-121.52874, 38.49544], [-121.52874, 38.49537], [-121.52871, 38.49532], [-121.52879, 38.49527], [-121.52898, 38.49469], [-121.52893, 38.49462], [-121.529, 38.49458], [-121.52904, 38.49452], [-121.5292, 38.49402], [-121.52919, 38.49394], [-121.52913, 38.49387], [-121.52906, 38.49383], [-121.5289, 38.4938], [-121.529, 38.49328], [-121.52899, 38.49234], [-121.52953, 38.49234], [-121.52954, 38.49259], [-121.52965, 38.49327], [-121.52989, 38.49359], [-121.52986, 38.49364], [-121.52986, 38.49369], [-121.52992, 38.49409], [-121.52995, 38.49414]]], [[[-121.53119, 38.51589], [-121.53094, 38.51624], [-121.52935, 38.51644], [-121.52903, 38.51578], [-121.53009, 38.51548], [-121.53, 38.51435], [-121.52993, 38.5141], [-121.5304, 38.51402], [-121.53047, 38.51403], [-121.53051, 38.51407], [-121.53113, 38.5158], [-121.53119, 38.51589]]], [[[-121.53038, 38.51381], [-121.53004, 38.51385], [-121.52906, 38.51233], [-121.52966, 38.5121], [-121.5301, 38.51325], [-121.53038, 38.51381]]], [[[-121.5316, 38.50197], [-121.53124, 38.50215], [-121.53112, 38.50204], [-121.53101, 38.50195], [-121.53036, 38.50166], [-121.53034, 38.50164], [-121.53033, 38.5016], [-121.53049, 38.50138], [-121.53155, 38.50183], [-121.5316, 38.50197]]]]} | Open Access 1 | 21211 | Frank Seymour Park | 19053 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 49.538 | Frank Seymour Park | 0 | Local Park 2 | 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]);