units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Fitzgerald Marine Reserve" and MNG_AG_TYP = 7
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9714 | 9714 | 9713 | {"type": "MultiPolygon", "coordinates": [[[[-122.51293, 37.51591], [-122.51282, 37.51587], [-122.51276, 37.51587], [-122.5127, 37.51589], [-122.51266, 37.51596], [-122.5127, 37.51618], [-122.51292, 37.51669], [-122.51266, 37.51646], [-122.51264, 37.51646], [-122.51234, 37.51597], [-122.51239, 37.51578], [-122.51241, 37.51543], [-122.51239, 37.51543], [-122.51213, 37.51579], [-122.51209, 37.5158], [-122.51207, 37.51577], [-122.51209, 37.51561], [-122.51208, 37.51544], [-122.51241, 37.51537], [-122.51241, 37.51527], [-122.5124, 37.51524], [-122.51206, 37.5153], [-122.51197, 37.51489], [-122.512, 37.51484], [-122.51227, 37.51477], [-122.51221, 37.51454], [-122.51212, 37.51438], [-122.51165, 37.51363], [-122.51121, 37.51345], [-122.51068, 37.51278], [-122.51043, 37.51254], [-122.51022, 37.51236], [-122.51035, 37.51216], [-122.51095, 37.51266], [-122.51121, 37.51295], [-122.5114, 37.51323], [-122.51148, 37.51331], [-122.51196, 37.51364], [-122.51208, 37.51378], [-122.51239, 37.51428], [-122.51247, 37.51439], [-122.51255, 37.51446], [-122.5126, 37.51453], [-122.51266, 37.51478], [-122.5127, 37.51486], [-122.51276, 37.51493], [-122.51274, 37.51502], [-122.51278, 37.51509], [-122.51281, 37.51525], [-122.51286, 37.51532], [-122.51287, 37.51554], [-122.51293, 37.51591]]], [[[-122.51803, 37.52448], [-122.51793, 37.52462], [-122.51781, 37.52472], [-122.51775, 37.52482], [-122.5176, 37.52492], [-122.51754, 37.52506], [-122.51735, 37.52532], [-122.51734, 37.52537], [-122.51729, 37.52548], [-122.5172, 37.52559], [-122.51716, 37.52573], [-122.5171, 37.52582], [-122.5171, 37.52598], [-122.51715, 37.52622], [-122.51716, 37.52655], [-122.51714, 37.52667], [-122.51716, 37.52683], [-122.51705, 37.527], [-122.51702, 37.5271], [-122.51712, 37.52718], [-122.51722, 37.5273], [-122.51724, 37.52735], [-122.51759, 37.52774], [-122.51745, 37.52776], [-122.51744, 37.52766], [-122.51733, 37.52754], [-122.51728, 37.52755], [-122.51709, 37.52734], [-122.51686, 37.5272], [-122.51682, 37.52702], [-122.51683, 37.52697], [-122.51675, 37.52694], [-122.51662, 37.52712], [-122.51647, 37.5278], [-122.5164, 37.5279], [-122.51545, 37.52829], [-122.51536, 37.52826], [-122.51638, 37.52784], [-122.51657, 37.52709], [-122.51675, 37.52685], [-122.5168, 37.52686], [-122.51701, 37.5266], [-122.51687, 37.52608], [-122.51668, 37.52602], [-122.51625, 37.52619], [-122.51587, 37.52631], [-122.51577, 37.52647], [-122.51562, 37.52661], [-122.51531, 37.52674], [-122.51511, 37.52674], [-122.51448, 37.52667], [-122.51429, 37.52657], [-122.51406, 37.52672], [-122.51427, 37.52642], [-122.51439, 37.52642], [-122.51477, 37.52651], [-122.51499, 37.52654], [-122.51523, 37.52656], [-122.51541, 37.52652], [-122.51557, 37.52638], [-122.51565, 37.52628], [-122.51577, 37.52617], [-122.51614, 37.52596], [-122.51627, 37.52591], [-122.51686, 37.52555], [-122.51724, 37.52485], [-122.5175, 37.52449], [-122.51663, 37.52411], [-122.51646, 37.52434], [-122.51617, 37.52422], [-122.51608, 37.52434], [-122.51578, 37.52421], [-122.51589, 37.52406], [-122.51598, 37.5236], [-122.51603, 37.52349], [-122.51561, 37.52349], [-122.5153, 37.52335], [-122.51544, 37.52315], [-122.51543, 37.52314], [-122.51477, 37.52311], [-122.51465, 37.52305], [-122.5143, 37.52313], [-122.51413, 37.52306], [-122.51387, 37.52306], [-122.51393, 37.52298], [-122.51416, 37.52298], [-122.51431, 37.52304], [-122.51466, 37.52296], [-122.51481, 37.52302], [-122.51586, 37.52308], [-122.51585, 37.52306], [-122.51434, 37.52239], [-122.51439, 37.52229], [-122.51568, 37.52284], [-122.51539, 37.52257], [-122.51492, 37.52224], [-122.51456, 37.52208], [-122.51449, 37.52211], [-122.51328, 37.52159], [-122.51303, 37.52195], [-122.51239, 37.52167], [-122.51289, 37.52092], [-122.51287, 37.52087], [-122.51304, 37.52063], [-122.51304, 37.52051], [-122.51379, 37.51945], [-122.51377, 37.51926], [-122.5138, 37.51921], [-122.5138, 37.51917], [-122.51377, 37.51911], [-122.51369, 37.51907], [-122.51375, 37.51861], [-122.51359, 37.5183], [-122.51357, 37.51816], [-122.51367, 37.51802], [-122.51357, 37.51794], [-122.51365, 37.51779], [-122.51356, 37.51764], [-122.51358, 37.51761], [-122.51346, 37.51751], [-122.51334, 37.51709], [-122.51301, 37.51681], [-122.51304, 37.51678], [-122.51304, 37.51672], [-122.51278, 37.51613], [-122.51275, 37.51599], [-122.51277, 37.51597], [-122.51296, 37.51605], [-122.51302, 37.51636], [-122.51309, 37.51651], [-122.51312, 37.51663], [-122.51322, 37.51669], [-122.51353, 37.51705], [-122.51363, 37.51721], [-122.51365, 37.51741], [-122.51375, 37.51751], [-122.51383, 37.51771], [-122.51385, 37.51786], [-122.5138, 37.51793], [-122.51378, 37.5182], [-122.51381, 37.51826], [-122.51384, 37.51848], [-122.51389, 37.51855], [-122.51393, 37.51873], [-122.51396, 37.51877], [-122.51395, 37.51899], [-122.51399, 37.51912], [-122.51398, 37.51922], [-122.514, 37.51929], [-122.51406, 37.51936], [-122.51406, 37.51946], [-122.51412, 37.51957], [-122.51412, 37.51965], [-122.51418, 37.51974], [-122.51424, 37.51979], [-122.51434, 37.51999], [-122.51456, 37.5202], [-122.51469, 37.52036], [-122.51477, 37.52039], [-122.51496, 37.52052], [-122.51503, 37.52061], [-122.5151, 37.52068], [-122.51524, 37.52073], [-122.51535, 37.52084], [-122.5154, 37.52095], [-122.51555, 37.52111], [-122.51599, 37.52131], [-122.51607, 37.52131], [-122.51636, 37.52138], [-122.51687, 37.52176], [-122.517, 37.52195], [-122.51728, 37.52223], [-122.5173, 37.52234], [-122.51744, 37.52265], [-122.51745, 37.52273], [-122.5175, 37.52283], [-122.51759, 37.52317], [-122.51766, 37.52327], [-122.51767, 37.52335], [-122.51774, 37.52343], [-122.51774, 37.52349], [-122.51795, 37.52396], [-122.51796, 37.52413], [-122.51787, 37.52427], [-122.51787, 37.52432], [-122.51803, 37.52445], [-122.51803, 37.52448]]], [[[-122.519, 37.53325], [-122.51884, 37.53324], [-122.51847, 37.53279], [-122.51837, 37.5328], [-122.51797, 37.53236], [-122.51785, 37.53198], [-122.51723, 37.53064], [-122.51731, 37.53036], [-122.5169, 37.52989], [-122.51666, 37.52916], [-122.51677, 37.52909], [-122.51671, 37.52889], [-122.51678, 37.52896], [-122.517, 37.52894], [-122.51704, 37.5289], [-122.51711, 37.52868], [-122.51716, 37.52864], [-122.51717, 37.52847], [-122.51727, 37.52845], [-122.51744, 37.52852], [-122.51736, 37.52863], [-122.51731, 37.52874], [-122.51722, 37.52891], [-122.51718, 37.52911], [-122.51718, 37.52937], [-122.51719, 37.52948], [-122.51728, 37.52979], [-122.51736, 37.52995], [-122.51777, 37.53032], [-122.51777, 37.53041], [-122.51771, 37.53054], [-122.51773, 37.53062], [-122.51787, 37.53078], [-122.51791, 37.53086], [-122.51792, 37.53117], [-122.51795, 37.53126], [-122.51808, 37.53147], [-122.51808, 37.53159], [-122.51811, 37.53171], [-122.51829, 37.53187], [-122.51828, 37.53211], [-122.51835, 37.53224], [-122.51846, 37.53228], [-122.51863, 37.53238], [-122.51872, 37.53249], [-122.519, 37.53325]]]]} | Open Access 1 | 16441 | Fitzgerald Marine Reserve | 18928 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 41.49 | Fitzgerald Marine Reserve | 2000 | Local Conservation Area 4 | 2 |
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]);