superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Kensington/College OS" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14874 | 14874 | 14873 | {"type": "MultiPolygon", "coordinates": [[[[-117.09292, 32.76267], [-117.09289, 32.7647], [-117.09257, 32.76464], [-117.09256, 32.76396], [-117.09034, 32.76332], [-117.09032, 32.7633], [-117.0897, 32.76331], [-117.09013, 32.7631], [-117.09024, 32.76323], [-117.0904, 32.76315], [-117.09055, 32.76316], [-117.09072, 32.76324], [-117.09094, 32.76331], [-117.09123, 32.76338], [-117.09149, 32.76349], [-117.09153, 32.76349], [-117.09164, 32.76355], [-117.09173, 32.76352], [-117.09179, 32.76348], [-117.09191, 32.76349], [-117.0919, 32.76344], [-117.09194, 32.76336], [-117.09191, 32.76317], [-117.09235, 32.76317], [-117.09235, 32.76285], [-117.09223, 32.76283], [-117.09223, 32.76267], [-117.09264, 32.7627], [-117.09292, 32.76267]]], [[[-117.09734, 32.77391], [-117.09657, 32.77426], [-117.0963, 32.77399], [-117.09703, 32.77345], [-117.09734, 32.77391]]], [[[-117.09722, 32.75933], [-117.09681, 32.75932], [-117.09682, 32.75912], [-117.09722, 32.75913], [-117.09722, 32.75933]]], [[[-117.10233, 32.76015], [-117.10232, 32.76036], [-117.10227, 32.76034], [-117.10212, 32.7603], [-117.10198, 32.76024], [-117.10162, 32.75989], [-117.1015, 32.75981], [-117.1013, 32.75974], [-117.10086, 32.75968], [-117.09964, 32.76112], [-117.09966, 32.76203], [-117.09862, 32.76214], [-117.0978, 32.76289], [-117.09774, 32.76286], [-117.09785, 32.7626], [-117.09865, 32.76175], [-117.10036, 32.7601], [-117.10086, 32.75968], [-117.10096, 32.75955], [-117.10126, 32.75959], [-117.10154, 32.75968], [-117.10171, 32.75978], [-117.10199, 32.76005], [-117.10212, 32.76014], [-117.10224, 32.76019], [-117.10228, 32.76019], [-117.10233, 32.76015]]], [[[-117.1123, 32.77158], [-117.11168, 32.77353], [-117.1092, 32.7766], [-117.10925, 32.77695], [-117.10925, 32.77708], [-117.10824, 32.777], [-117.10727, 32.77701], [-117.10436, 32.77699], [-117.10311, 32.77705], [-117.10314, 32.77601], [-117.10339, 32.776], [-117.10411, 32.77477], [-117.10518, 32.77473], [-117.10522, 32.77564], [-117.10572, 32.77589], [-117.10909, 32.7759], [-117.10932, 32.77544], [-117.10931, 32.77532], [-117.10932, 32.77522], [-117.10936, 32.77513], [-117.10969, 32.77515], [-117.10962, 32.77449], [-117.10915, 32.77461], [-117.1087, 32.77379], [-117.109, 32.77367], [-117.10886, 32.77338], [-117.10854, 32.77349], [-117.10814, 32.77276], [-117.10861, 32.7725], [-117.10873, 32.77201], [-117.10875, 32.77182], [-117.10888, 32.77172], [-117.10913, 32.77209], [-117.10969, 32.77265], [-117.11011, 32.77263], [-117.11065, 32.77226], [-117.11105, 32.77261], [-117.11111, 32.77277], [-117.11185, 32.77295], [-117.11147, 32.77213], [-117.11103, 32.77059], [-117.11056, 32.77059], [-117.11006, 32.77014], [-117.11021, 32.76997], [-117.11045, 32.76987], [-117.11051, 32.76975], [-117.11113, 32.76975], [-117.11116, 32.76902], [-117.11115, 32.76866], [-117.11083, 32.76849], [-117.1108, 32.76847], [-117.11071, 32.76843], [-117.1101, 32.76882], [-117.11002, 32.76875], [-117.11095, 32.76803], [-117.1112, 32.76812], [-117.11156, 32.76863], [-117.1116, 32.76886], [-117.11178, 32.76932], [-117.1123, 32.77158]]], [[[-117.10994, 32.76641], [-117.1097, 32.76615], [-117.10898, 32.76573], [-117.1089, 32.76582], [-117.1089, 32.76564], [-117.10937, 32.76578], [-117.10969, 32.76575], [-117.10994, 32.76641]]], [[[-117.11078, 32.76765], [-117.11076, 32.76779], [-117.11017, 32.76794], [-117.1099, 32.7676], [-117.10935, 32.76787], [-117.10929, 32.76778], [-117.11037, 32.76711], [-117.11038, 32.76705], [-117.11078, 32.76765]]]]} | Open Access 1 | Kensington/College Open Space | 20616 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 62.715 | Kensington/College OS |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);