units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where LAYER = 4, MNG_AGENCY = 753 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA
MNG_AG_TYP 1
- Recreation/Parks District · 8 ✖
MNG_AGENCY 1
- La Selva Beach Recreation District · 8 ✖
DES_TP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4559 | 4559 | 4558 | {"type": "Polygon", "coordinates": [[[-121.86369, 36.93775], [-121.86367, 36.9378], [-121.86349, 36.938], [-121.86335, 36.93821], [-121.86263, 36.93764], [-121.86282, 36.9375], [-121.86287, 36.9375], [-121.86293, 36.93754], [-121.86296, 36.93752], [-121.86302, 36.93756], [-121.86312, 36.93749], [-121.86321, 36.93756], [-121.86335, 36.93746], [-121.86366, 36.93771], [-121.86369, 36.93775]]]} | Open Access 1 | 35179 | Unknown park - La Selva Beach Parks and Recreation District | 28690 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 1.005 | 0 | Local Other or Unknown 14 | 4 | ||
4618 | 4618 | 4617 | {"type": "Polygon", "coordinates": [[[-121.86433, 36.93568], [-121.86428, 36.93572], [-121.8632, 36.9346], [-121.86325, 36.93456], [-121.86433, 36.93568]]]} | Open Access 1 | 36130 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.256 | 0 | Local Other or Unknown 14 | 4 | ||
4619 | 4619 | 4618 | {"type": "Polygon", "coordinates": [[[-121.86, 36.94078], [-121.85982, 36.94067], [-121.85962, 36.94058], [-121.85956, 36.94051], [-121.8596, 36.94044], [-121.85969, 36.9404], [-121.86, 36.94039], [-121.86, 36.94078]]]} | Open Access 1 | 36131 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.265 | 0 | Local Other or Unknown 14 | 4 | ||
4628 | 4628 | 4627 | {"type": "MultiPolygon", "coordinates": [[[[-121.86066, 36.93962], [-121.86062, 36.93973], [-121.86059, 36.94006], [-121.86048, 36.94029], [-121.86042, 36.94033], [-121.86035, 36.94032], [-121.86032, 36.94029], [-121.86032, 36.94025], [-121.86066, 36.93962]]], [[[-121.8624, 36.9389], [-121.86234, 36.93895], [-121.86222, 36.93911], [-121.86212, 36.9392], [-121.86196, 36.93931], [-121.86184, 36.93937], [-121.8617, 36.93936], [-121.86144, 36.93927], [-121.86121, 36.93924], [-121.86099, 36.9393], [-121.86083, 36.9394], [-121.86071, 36.93953], [-121.86082, 36.93939], [-121.86095, 36.93926], [-121.86106, 36.93919], [-121.86116, 36.93917], [-121.86153, 36.93924], [-121.86176, 36.93924], [-121.86197, 36.93918], [-121.8624, 36.9389]]], [[[-121.86359, 36.93809], [-121.86355, 36.9382], [-121.86353, 36.93834], [-121.86347, 36.93848], [-121.86323, 36.93869], [-121.86305, 36.9388], [-121.86297, 36.93883], [-121.86269, 36.93881], [-121.86256, 36.93883], [-121.86292, 36.93873], [-121.86307, 36.93867], [-121.86324, 36.93857], [-121.86336, 36.93843], [-121.86356, 36.93807], [-121.86359, 36.93809]]]]} | Open Access 1 | 36258 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.768 | 0 | Local Other or Unknown 14 | 4 | ||
4673 | 4673 | 4672 | {"type": "Polygon", "coordinates": [[[-121.86411, 36.93794], [-121.86404, 36.93797], [-121.86384, 36.93798], [-121.86379, 36.93797], [-121.86377, 36.93793], [-121.86383, 36.93779], [-121.86393, 36.93787], [-121.86398, 36.93783], [-121.86411, 36.93794]]]} | Open Access 1 | 36646 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.092 | 0 | Local Other or Unknown 14 | 4 | ||
4683 | 4683 | 4682 | {"type": "Polygon", "coordinates": [[[-121.8613, 36.93786], [-121.86128, 36.9379], [-121.86099, 36.93813], [-121.86095, 36.93813], [-121.86093, 36.9381], [-121.86095, 36.93798], [-121.86093, 36.93765], [-121.86096, 36.93761], [-121.86102, 36.93762], [-121.86128, 36.93782], [-121.8613, 36.93786]]]} | Open Access 1 | 43074 | Unknown park - La Selva Beach Recreation District | 28639 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.278 | 0 | Local Other or Unknown 14 | 4 | ||
15482 | 15482 | 15481 | {"type": "Polygon", "coordinates": [[[-121.85976, 36.9403], [-121.85956, 36.94034], [-121.85939, 36.94045], [-121.85932, 36.94046], [-121.85927, 36.94041], [-121.85927, 36.94028], [-121.85951, 36.94009], [-121.85976, 36.9403]]]} | Open Access 1 | 43081 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.222 | 0 | Local Other or Unknown 14 | 4 | ||
15485 | 15485 | 15484 | {"type": "Polygon", "coordinates": [[[-121.8621, 36.93337], [-121.86183, 36.93378], [-121.86183, 36.93423], [-121.86175, 36.93427], [-121.86176, 36.93376], [-121.86206, 36.93332], [-121.8621, 36.93337]]]} | Open Access 1 | 43087 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.166 | 0 | Local Other or Unknown 14 | 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]);