units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, MNG_AGENCY = 876 and MNG_AG_LEV = 4
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Moss Landing Harbor District · 2 ✖
ACCESS_TYP 1
- Open Access · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9051 | 9051 | 9050 | {"type": "MultiPolygon", "coordinates": [[[[-121.74811, 36.84037], [-121.74543, 36.84145], [-121.74463, 36.84106], [-121.74407, 36.84074], [-121.74335, 36.84028], [-121.74267, 36.83979], [-121.74204, 36.83925], [-121.7416, 36.83883], [-121.74132, 36.83854], [-121.74079, 36.83793], [-121.74035, 36.83733], [-121.74214, 36.83679], [-121.74112, 36.83498], [-121.74105, 36.83472], [-121.74284, 36.83471], [-121.74313, 36.83523], [-121.74319, 36.83641], [-121.74298, 36.83741], [-121.74303, 36.83802], [-121.74327, 36.83833], [-121.74358, 36.8388], [-121.74446, 36.83916], [-121.74503, 36.83945], [-121.74567, 36.83981], [-121.7469, 36.84016], [-121.74755, 36.84023], [-121.74811, 36.84037]]], [[[-121.74618, 36.82093], [-121.74511, 36.8275], [-121.74492, 36.82802], [-121.74274, 36.83083], [-121.74254, 36.83099], [-121.74174, 36.83099], [-121.74504, 36.82509], [-121.74514, 36.82461], [-121.74618, 36.82093]]], [[[-121.76322, 36.81416], [-121.76285, 36.81372], [-121.7627, 36.81373], [-121.75955, 36.81424], [-121.7514, 36.81598], [-121.75103, 36.81597], [-121.75085, 36.81605], [-121.74736, 36.8182], [-121.7467, 36.81878], [-121.74672, 36.81872], [-121.74919, 36.8163], [-121.75306, 36.81523], [-121.76193, 36.81384], [-121.76279, 36.81351], [-121.76322, 36.81416]]], [[[-121.76072, 36.85572], [-121.75963, 36.85711], [-121.75787, 36.85793], [-121.75783, 36.8579], [-121.75636, 36.85782], [-121.75564, 36.85821], [-121.75607, 36.85687], [-121.7567, 36.85712], [-121.75798, 36.85705], [-121.75926, 36.85652], [-121.75959, 36.85525], [-121.75933, 36.85394], [-121.75935, 36.85301], [-121.75969, 36.85239], [-121.76014, 36.85351], [-121.7605, 36.85466], [-121.76072, 36.85572]]], [[[-121.78009, 36.81303], [-121.77988, 36.81318], [-121.77742, 36.81323], [-121.77614, 36.81332], [-121.77508, 36.8137], [-121.77355, 36.81382], [-121.77157, 36.81358], [-121.7711, 36.8136], [-121.77036, 36.81426], [-121.76996, 36.81491], [-121.76992, 36.8157], [-121.76934, 36.81621], [-121.76829, 36.81698], [-121.76711, 36.81734], [-121.76565, 36.81736], [-121.76555, 36.81742], [-121.76494, 36.81743], [-121.76479, 36.8169], [-121.76424, 36.81608], [-121.76426, 36.81609], [-121.77109, 36.8136], [-121.77108, 36.81288], [-121.78009, 36.81277], [-121.78009, 36.81303]]], [[[-121.78782, 36.79713], [-121.78758, 36.79751], [-121.78748, 36.79779], [-121.78744, 36.79793], [-121.78745, 36.7984], [-121.78735, 36.79871], [-121.78728, 36.799], [-121.7872, 36.79914], [-121.78713, 36.7993], [-121.78711, 36.79949], [-121.78713, 36.79969], [-121.78646, 36.7993], [-121.7869, 36.79832], [-121.78689, 36.79831], [-121.78665, 36.79829], [-121.78684, 36.79719], [-121.78699, 36.7972], [-121.78704, 36.79698], [-121.78782, 36.79713]]], [[[-121.79025, 36.7907], [-121.78968, 36.79183], [-121.78832, 36.79147], [-121.78854, 36.79028], [-121.79025, 36.7907]]]]} | Open Access 1 | 14978 | Elkhorn Slough | 18571 | 2087 | Moss Landing Harbor District 902 | Special District 4 | Port/Harbor District 15 | http://mosslandingharbor.dst.ca.us/ | Special District 4 | 2087 | Moss Landing Harbor District 876 | Special District 4 | Port/Harbor District 14 | Monterey 14 | 131.427 | Elkhorn Slough | 0 | Local Conservation Area 4 | 2 | |
9107 | 9107 | 9106 | {"type": "Polygon", "coordinates": [[[-121.75969, 36.85239], [-121.7588, 36.85017], [-121.7571, 36.84595], [-121.75825, 36.84599], [-121.75836, 36.84608], [-121.75912, 36.84764], [-121.76009, 36.85016], [-121.76023, 36.85075], [-121.76019, 36.85134], [-121.75969, 36.85239]]]} | Open Access 1 | 15088 | Elkhorn Slough / Elkhorn Highlands | 18574 | 2087 | Moss Landing Harbor District 902 | Special District 4 | Port/Harbor District 15 | http://mosslandingharbor.dst.ca.us/ | Special District 4 | 2087 | Moss Landing Harbor District 876 | Special District 4 | Port/Harbor District 14 | Monterey 14 | 17.855 | Elkhorn Slough / Elkhorn Highlands | None 754 |
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]);