superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "City OS" and MNG_AGENCY = 533
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14849 | 14849 | 14848 | {"type": "MultiPolygon", "coordinates": [[[[-121.23553, 38.74068], [-121.23539, 38.74086], [-121.23514, 38.74106], [-121.23489, 38.74119], [-121.23435, 38.74156], [-121.23407, 38.7416], [-121.23393, 38.74169], [-121.23375, 38.74167], [-121.23358, 38.74188], [-121.23352, 38.74209], [-121.23333, 38.74225], [-121.23302, 38.74237], [-121.23287, 38.74239], [-121.23276, 38.74249], [-121.23248, 38.74254], [-121.23238, 38.74274], [-121.23176, 38.74268], [-121.23136, 38.74271], [-121.2312, 38.74277], [-121.23094, 38.74266], [-121.23083, 38.74274], [-121.23059, 38.74277], [-121.2302, 38.74297], [-121.22966, 38.74303], [-121.22909, 38.74307], [-121.22908, 38.7427], [-121.22927, 38.74277], [-121.22951, 38.74278], [-121.23, 38.74251], [-121.23004, 38.74238], [-121.23036, 38.7422], [-121.2305, 38.74232], [-121.23084, 38.74228], [-121.2314, 38.74228], [-121.23169, 38.7422], [-121.23181, 38.74208], [-121.23207, 38.74207], [-121.23242, 38.742], [-121.23269, 38.74192], [-121.23315, 38.74164], [-121.23324, 38.7414], [-121.23344, 38.74119], [-121.23374, 38.74106], [-121.2342, 38.74085], [-121.2344, 38.74083], [-121.23447, 38.74069], [-121.23465, 38.74057], [-121.23471, 38.74048], [-121.23472, 38.74022], [-121.23454, 38.74011], [-121.23439, 38.73991], [-121.23418, 38.73977], [-121.23403, 38.73974], [-121.23367, 38.73958], [-121.23347, 38.73954], [-121.23328, 38.73946], [-121.23307, 38.73953], [-121.23289, 38.73952], [-121.23197, 38.7393], [-121.23187, 38.73941], [-121.23172, 38.73944], [-121.23159, 38.73962], [-121.23135, 38.73959], [-121.2307, 38.73978], [-121.2304, 38.73988], [-121.23003, 38.73988], [-121.22985, 38.73978], [-121.22921, 38.73951], [-121.22858, 38.73909], [-121.22824, 38.73905], [-121.2281, 38.73914], [-121.22757, 38.73919], [-121.22729, 38.73924], [-121.22708, 38.73921], [-121.22685, 38.73904], [-121.22673, 38.73886], [-121.2266, 38.73885], [-121.22655, 38.73895], [-121.22645, 38.73898], [-121.22619, 38.73895], [-121.22611, 38.73895], [-121.22604, 38.73787], [-121.22607, 38.73754], [-121.22607, 38.73741], [-121.2263, 38.73732], [-121.22674, 38.73728], [-121.22707, 38.73733], [-121.22751, 38.73732], [-121.22773, 38.73735], [-121.2279, 38.73746], [-121.228, 38.73756], [-121.22818, 38.73759], [-121.22841, 38.73789], [-121.22864, 38.73809], [-121.22878, 38.73829], [-121.22911, 38.73851], [-121.22931, 38.73872], [-121.22965, 38.73897], [-121.22984, 38.73919], [-121.22965, 38.7393], [-121.22957, 38.73944], [-121.23023, 38.73974], [-121.23203, 38.73923], [-121.23264, 38.7393], [-121.23264, 38.73865], [-121.23316, 38.73897], [-121.23339, 38.73894], [-121.23351, 38.73884], [-121.23378, 38.73876], [-121.23407, 38.73883], [-121.23455, 38.73912], [-121.23461, 38.73949], [-121.23479, 38.73937], [-121.23492, 38.73933], [-121.23519, 38.7394], [-121.23543, 38.73936], [-121.23545, 38.7401], [-121.23553, 38.74068]]], [[[-121.24491, 38.74107], [-121.24484, 38.74123], [-121.24457, 38.74138], [-121.24422, 38.74146], [-121.24418, 38.74154], [-121.24404, 38.74157], [-121.24404, 38.74167], [-121.24388, 38.74162], [-121.24361, 38.74174], [-121.24348, 38.74176], [-121.24336, 38.74188], [-121.24332, 38.74202], [-121.24326, 38.74209], [-121.24321, 38.74212], [-121.24305, 38.74211], [-121.24295, 38.74207], [-121.24284, 38.74199], [-121.24319, 38.74176], [-121.24334, 38.74147], [-121.24416, 38.74137], [-121.2443, 38.74114], [-121.24424, 38.74094], [-121.24427, 38.74082], [-121.24421, 38.74072], [-121.24491, 38.74107]]], [[[-121.24785, 38.7396], [-121.24782, 38.73969], [-121.24773, 38.73968], [-121.24758, 38.73962], [-121.2475, 38.73967], [-121.24747, 38.73977], [-121.24742, 38.73982], [-121.24707, 38.73982], [-121.24692, 38.73977], [-121.2465, 38.73989], [-121.24636, 38.73987], [-121.24623, 38.74001], [-121.24596, 38.74004], [-121.24564, 38.74004], [-121.24543, 38.74002], [-121.2452, 38.73997], [-121.2451, 38.73998], [-121.24492, 38.74025], [-121.24486, 38.7404], [-121.2448, 38.74051], [-121.2447, 38.74063], [-121.24456, 38.74056], [-121.24477, 38.74033], [-121.24497, 38.73995], [-121.24464, 38.73963], [-121.2447, 38.7396], [-121.24482, 38.73963], [-121.24575, 38.73969], [-121.2459, 38.73964], [-121.24624, 38.73959], [-121.24647, 38.73948], [-121.24652, 38.73948], [-121.24659, 38.73955], [-121.24687, 38.73948], [-121.24703, 38.7395], [-121.24712, 38.73947], [-121.24715, 38.73941], [-121.2471, 38.73924], [-121.24711, 38.73914], [-121.24716, 38.7391], [-121.24723, 38.73907], [-121.24717, 38.73902], [-121.24718, 38.73889], [-121.24706, 38.73873], [-121.24772, 38.73942], [-121.24785, 38.7396]]], [[[-121.25361, 38.73874], [-121.25361, 38.73897], [-121.25358, 38.73925], [-121.25344, 38.73991], [-121.25342, 38.74016], [-121.25343, 38.74087], [-121.25342, 38.7409], [-121.25337, 38.74092], [-121.25329, 38.74093], [-121.2533, 38.74014], [-121.2531, 38.73997], [-121.25273, 38.73983], [-121.2527, 38.73961], [-121.2524, 38.73945], [-121.2523, 38.73954], [-121.25222, 38.73951], [-121.25215, 38.73951], [-121.25211, 38.73945], [-121.2502, 38.73947], [-121.24987, 38.73937], [-121.25006, 38.73908], [-121.25045, 38.73908], [-121.25053, 38.73904], [-121.25061, 38.73907], [-121.25072, 38.73906], [-121.2508, 38.73911], [-121.25117, 38.73907], [-121.25138, 38.73892], [-121.25157, 38.73883], [-121.25181, 38.73889], [-121.25204, 38.73889], [-121.25226, 38.73886], [-121.25227, 38.73884], [-121.25246, 38.73889], [-121.25272, 38.73904], [-121.25279, 38.73904], [-121.25282, 38.7391], [-121.25288, 38.73914], [-121.25299, 38.73915], [-121.25303, 38.7392], [-121.25341, 38.73932], [-121.25348, 38.73891], [-121.25347, 38.7387], [-121.25355, 38.7387], [-121.25361, 38.73874]]], [[[-121.31032, 38.73631], [-121.30904, 38.73645], [-121.30901, 38.73417], [-121.31032, 38.73417], [-121.31032, 38.73631]]]]} | Open Access 1 | City Open Space | 17336 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 44.739 | City 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]);