superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AGENCY = 43, MNG_AG_TYP = 4 and YR_EST = 1987 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 2 ✖
MNG_AGENCY 1
- Marin County Open Space District · 2 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14747 | 14747 | 14746 | {"type": "Polygon", "coordinates": [[[-122.57082, 38.04648], [-122.57066, 38.04652], [-122.57052, 38.04659], [-122.57042, 38.04666], [-122.57041, 38.0467], [-122.57036, 38.04678], [-122.57025, 38.04685], [-122.57009, 38.04685], [-122.56981, 38.04683], [-122.56959, 38.0469], [-122.56956, 38.04695], [-122.56954, 38.0471], [-122.5695, 38.04716], [-122.56927, 38.04724], [-122.56905, 38.04726], [-122.56868, 38.04735], [-122.56856, 38.04743], [-122.56831, 38.04766], [-122.56766, 38.04791], [-122.56755, 38.04797], [-122.56737, 38.04799], [-122.5673, 38.04801], [-122.56721, 38.04809], [-122.56719, 38.04815], [-122.56719, 38.04833], [-122.56706, 38.04843], [-122.56698, 38.04844], [-122.56588, 38.04892], [-122.56545, 38.04922], [-122.56527, 38.04929], [-122.56486, 38.04929], [-122.56464, 38.04938], [-122.56438, 38.04963], [-122.56406, 38.04988], [-122.56391, 38.05001], [-122.56362, 38.05004], [-122.56342, 38.05005], [-122.56301, 38.05014], [-122.56245, 38.05031], [-122.56237, 38.05065], [-122.56211, 38.05093], [-122.56188, 38.0513], [-122.56184, 38.05147], [-122.56195, 38.05179], [-122.56195, 38.0519], [-122.5619, 38.05208], [-122.56168, 38.05259], [-122.56148, 38.05286], [-122.5614, 38.05293], [-122.56127, 38.053], [-122.561, 38.05322], [-122.56094, 38.05331], [-122.56093, 38.05342], [-122.56067, 38.05347], [-122.56032, 38.05344], [-122.5602, 38.05346], [-122.56008, 38.05358], [-122.56007, 38.05364], [-122.55984, 38.05372], [-122.55974, 38.05372], [-122.55965, 38.05379], [-122.55953, 38.05384], [-122.55895, 38.05398], [-122.5588, 38.054], [-122.55853, 38.05411], [-122.55772, 38.05424], [-122.55743, 38.05437], [-122.55665, 38.05464], [-122.55646, 38.05465], [-122.55626, 38.05463], [-122.55606, 38.05465], [-122.55596, 38.05467], [-122.55576, 38.05456], [-122.55558, 38.05457], [-122.55545, 38.05461], [-122.55529, 38.05472], [-122.5553, 38.05481], [-122.55526, 38.05489], [-122.55506, 38.05512], [-122.55481, 38.05525], [-122.55466, 38.05529], [-122.55457, 38.05529], [-122.55443, 38.05518], [-122.5543, 38.05512], [-122.55395, 38.05512], [-122.55385, 38.05513], [-122.55368, 38.05522], [-122.55346, 38.0553], [-122.55346, 38.05532], [-122.55291, 38.05517], [-122.55109, 38.0548], [-122.5507, 38.05475], [-122.54969, 38.05414], [-122.54332, 38.05555], [-122.54195, 38.05604], [-122.53981, 38.05538], [-122.54016, 38.05219], [-122.53868, 38.05083], [-122.53606, 38.05133], [-122.53543, 38.05198], [-122.53197, 38.052], [-122.53198, 38.05176], [-122.53344, 38.05162], [-122.53414, 38.05049], [-122.53476, 38.05129], [-122.53684, 38.05051], [-122.53684, 38.0505], [-122.53571, 38.04986], [-122.53543, 38.04958], [-122.53514, 38.0496], [-122.53484, 38.0495], [-122.53451, 38.04922], [-122.53427, 38.04921], [-122.53418, 38.04907], [-122.53413, 38.04892], [-122.53407, 38.04859], [-122.53436, 38.04873], [-122.53531, 38.04777], [-122.53493, 38.04731], [-122.53513, 38.04714], [-122.53527, 38.04707], [-122.53637, 38.0466], [-122.5367, 38.04638], [-122.53688, 38.04629], [-122.53704, 38.04622], [-122.53715, 38.0462], [-122.53729, 38.0462], [-122.53781, 38.0463], [-122.53801, 38.04638], [-122.53824, 38.04653], [-122.53836, 38.04658], [-122.53828, 38.04671], [-122.53754, 38.04705], [-122.53767, 38.04755], [-122.539, 38.04854], [-122.54034, 38.04811], [-122.5412, 38.04727], [-122.54138, 38.04689], [-122.54214, 38.04712], [-122.54225, 38.04717], [-122.54233, 38.04724], [-122.54241, 38.04732], [-122.54255, 38.04756], [-122.54275, 38.04777], [-122.54273, 38.04781], [-122.54263, 38.04792], [-122.54259, 38.04799], [-122.54258, 38.04809], [-122.54263, 38.04824], [-122.54263, 38.04834], [-122.54261, 38.04842], [-122.54251, 38.04858], [-122.54249, 38.04868], [-122.54251, 38.04883], [-122.54261, 38.04899], [-122.54262, 38.04916], [-122.54265, 38.04929], [-122.54244, 38.04933], [-122.54192, 38.04993], [-122.5422, 38.05018], [-122.54249, 38.05021], [-122.54284, 38.05004], [-122.54304, 38.05045], [-122.54311, 38.05056], [-122.5429, 38.05067], [-122.5426, 38.05096], [-122.54193, 38.05106], [-122.5417, 38.05139], [-122.54183, 38.05163], [-122.54256, 38.05182], [-122.54314, 38.05149], [-122.54373, 38.05234], [-122.54467, 38.0531], [-122.54518, 38.05278], [-122.54523, 38.05282], [-122.54546, 38.0527], [-122.54527, 38.05239], [-122.54532, 38.05222], [-122.54559, 38.05209], [-122.54521, 38.05147], [-122.54463, 38.05109], [-122.54406, 38.05035], [-122.54398, 38.05036], [-122.54379, 38.04975], [-122.54357, 38.04918], [-122.54368, 38.04823], [-122.54361, 38.04801], [-122.54457, 38.04801], [-122.54481, 38.04798], [-122.54507, 38.04842], [-122.54485, 38.04855], [-122.54485, 38.04858], [-122.54576, 38.04885], [-122.54652, 38.04879], [-122.54794, 38.04931], [-122.54908, 38.04945], [-122.55015, 38.05033], [-122.54999, 38.05057], [-122.54972, 38.05105], [-122.55112, 38.05167], [-122.55133, 38.05139], [-122.5517, 38.05192], [-122.55181, 38.05197], [-122.55191, 38.05185], [-122.55215, 38.05186], [-122.55235, 38.0516], [-122.55224, 38.05141], [-122.55277, 38.0507], [-122.55246, 38.05053], [-122.55248, 38.05047], [-122.55299, 38.05041], [-122.55327, 38.05004], [-122.55233, 38.04935], [-122.55127, 38.04862], [-122.54847, 38.04724], [-122.54555, 38.04712], [-122.54625, 38.04664], [-122.54489, 38.04489], [-122.54367, 38.04469], [-122.54194, 38.04475], [-122.54019, 38.0439], [-122.53984, 38.04383], [-122.53893, 38.04368], [-122.5383, 38.04336], [-122.53706, 38.04343], [-122.53663, 38.044], [-122.53563, 38.04383], [-122.53648, 38.04331], [-122.5371, 38.04253], [-122.53968, 38.04374], [-122.55523, 38.04708], [-122.56173, 38.04677], [-122.57082, 38.04648]], [[-122.53786, 38.04875], [-122.5369, 38.0482], [-122.53652, 38.04863], [-122.53754, 38.04928], [-122.5377, 38.0491], [-122.53786, 38.04875]], [[-122.54644, 38.04999], [-122.54644, 38.04997], [-122.54607, 38.04982], [-122.54578, 38.05007], [-122.54616, 38.05032], [-122.54644, 38.04999]]]} | Open Access 1 | Pacheco Valle Open Space Preserve | http://www.marincounty.org/depts/pk/divisions/open-space/pacheco-valle | 31438 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 461.177 | Pacheco Valle OSP | 1987 |
14692 | 14692 | 14691 | {"type": "Polygon", "coordinates": [[[-122.62143, 38.049], [-122.61549, 38.06024], [-122.61296, 38.06179], [-122.61216, 38.06374], [-122.60316, 38.05837], [-122.59696, 38.0546], [-122.59704, 38.05453], [-122.59703, 38.05451], [-122.59074, 38.05093], [-122.59054, 38.05083], [-122.59059, 38.05073], [-122.59022, 38.05051], [-122.57576, 38.04727], [-122.57455, 38.04706], [-122.57448, 38.04705], [-122.57445, 38.04703], [-122.57145, 38.04651], [-122.57317, 38.04372], [-122.57289, 38.04231], [-122.56931, 38.04008], [-122.56688, 38.0367], [-122.56544, 38.03155], [-122.5647, 38.0288], [-122.56865, 38.03], [-122.56879, 38.03015], [-122.569, 38.0303], [-122.56913, 38.03034], [-122.56926, 38.03043], [-122.56948, 38.03051], [-122.56954, 38.0305], [-122.56971, 38.03051], [-122.56977, 38.03048], [-122.57026, 38.03048], [-122.57234, 38.02968], [-122.57269, 38.02965], [-122.57313, 38.02998], [-122.57263, 38.03058], [-122.57242, 38.03108], [-122.57206, 38.03147], [-122.57188, 38.03164], [-122.57184, 38.03203], [-122.57235, 38.03229], [-122.57262, 38.03228], [-122.57296, 38.03207], [-122.5732, 38.03219], [-122.57357, 38.03218], [-122.57429, 38.03223], [-122.57429, 38.03228], [-122.57464, 38.03277], [-122.57501, 38.03302], [-122.57557, 38.03322], [-122.57576, 38.03322], [-122.5764, 38.03328], [-122.57679, 38.03303], [-122.57705, 38.03312], [-122.5771, 38.03316], [-122.57707, 38.03319], [-122.57713, 38.03345], [-122.57826, 38.03389], [-122.57814, 38.03426], [-122.57853, 38.03445], [-122.57867, 38.03447], [-122.57898, 38.03462], [-122.57947, 38.03472], [-122.57978, 38.03476], [-122.57983, 38.03519], [-122.58015, 38.03553], [-122.58043, 38.03563], [-122.58076, 38.03621], [-122.58134, 38.03615], [-122.58267, 38.03648], [-122.58285, 38.0365], [-122.58286, 38.03668], [-122.58288, 38.03674], [-122.58332, 38.03684], [-122.58261, 38.03862], [-122.58416, 38.03911], [-122.58477, 38.03842], [-122.58454, 38.03812], [-122.58492, 38.03756], [-122.58505, 38.03736], [-122.58569, 38.03727], [-122.58578, 38.03718], [-122.58582, 38.03678], [-122.5856, 38.03646], [-122.5851, 38.03625], [-122.58518, 38.03608], [-122.58559, 38.03582], [-122.58585, 38.03552], [-122.58594, 38.03552], [-122.58588, 38.03563], [-122.58582, 38.03614], [-122.58635, 38.03619], [-122.58667, 38.03631], [-122.58713, 38.03658], [-122.58731, 38.03715], [-122.58757, 38.03714], [-122.58766, 38.03686], [-122.58782, 38.03677], [-122.58792, 38.03659], [-122.58803, 38.03662], [-122.58799, 38.03683], [-122.58824, 38.03702], [-122.58858, 38.03695], [-122.5892, 38.03748], [-122.58904, 38.03797], [-122.58948, 38.03804], [-122.5903, 38.03832], [-122.59042, 38.03818], [-122.59046, 38.03782], [-122.59027, 38.03759], [-122.59034, 38.03753], [-122.59043, 38.0375], [-122.59054, 38.03768], [-122.59063, 38.03773], [-122.59106, 38.03751], [-122.59124, 38.03745], [-122.59125, 38.03714], [-122.59156, 38.03714], [-122.59181, 38.0372], [-122.59193, 38.03726], [-122.59217, 38.03743], [-122.5924, 38.03752], [-122.59239, 38.03763], [-122.59256, 38.03765], [-122.5926, 38.03754], [-122.59277, 38.03756], [-122.59294, 38.03755], [-122.59328, 38.03745], [-122.59359, 38.0374], [-122.59383, 38.03811], [-122.59418, 38.03816], [-122.59407, 38.03849], [-122.59427, 38.03854], [-122.59432, 38.03876], [-122.59491, 38.03865], [-122.59531, 38.03871], [-122.59654, 38.03935], [-122.5968, 38.03963], [-122.59695, 38.04001], [-122.59758, 38.03988], [-122.59777, 38.03973], [-122.5978, 38.03976], [-122.59775, 38.03992], [-122.59776, 38.03995], [-122.59744, 38.04004], [-122.59705, 38.04054], [-122.59836, 38.04091], [-122.59778, 38.04158], [-122.59769, 38.0416], [-122.59664, 38.04295], [-122.598, 38.04476], [-122.60386, 38.04443], [-122.6055, 38.04585], [-122.60862, 38.04563], [-122.61075, 38.04555], [-122.61305, 38.0455], [-122.61546, 38.04799], [-122.61914, 38.04793], [-122.62143, 38.049]]]} | Open Access 1 | Lucas Valley Open Space Preserve | http://www.marincountyparks.org/depts/pk/divisions/open-space/lucas-valley | 6294 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 1674.292 | Lucas Valley OSP | 1987 |
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]);