units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 4, MNG_AG_TYP = 4 and PARK_URL = "http://www.marincounty.org/depts/pk/divisions/open-space/loma-verde"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 1 ✖
MNG_AGENCY 1
DES_TP 1
- Local Conservation Area · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15906 | 15906 | 15905 | {"type": "Polygon", "coordinates": [[[-122.55433, 38.0614], [-122.55411, 38.0614], [-122.55399, 38.06138], [-122.55385, 38.0614], [-122.55354, 38.06151], [-122.55342, 38.06158], [-122.55331, 38.06159], [-122.55311, 38.06166], [-122.55305, 38.0617], [-122.55294, 38.06174], [-122.55281, 38.06174], [-122.55254, 38.06178], [-122.55209, 38.06205], [-122.55198, 38.06208], [-122.5517, 38.06212], [-122.5515, 38.06217], [-122.55136, 38.06223], [-122.55126, 38.0623], [-122.55121, 38.06238], [-122.55118, 38.06247], [-122.55141, 38.06263], [-122.55153, 38.06277], [-122.55156, 38.06285], [-122.55156, 38.06295], [-122.55153, 38.06305], [-122.55132, 38.06341], [-122.55121, 38.06354], [-122.55118, 38.0636], [-122.55092, 38.06382], [-122.55078, 38.064], [-122.55056, 38.06415], [-122.5504, 38.06422], [-122.55028, 38.0643], [-122.55003, 38.0646], [-122.55002, 38.06468], [-122.55008, 38.06475], [-122.55019, 38.06477], [-122.55056, 38.06471], [-122.55098, 38.06467], [-122.55072, 38.06491], [-122.55128, 38.06564], [-122.55128, 38.06566], [-122.55097, 38.0657], [-122.5502, 38.06594], [-122.54972, 38.06594], [-122.54902, 38.06591], [-122.5489, 38.06563], [-122.54884, 38.06532], [-122.54876, 38.06525], [-122.54854, 38.06345], [-122.54861, 38.06343], [-122.54868, 38.06397], [-122.54977, 38.06387], [-122.54962, 38.06258], [-122.54844, 38.06267], [-122.54824, 38.06115], [-122.54961, 38.06054], [-122.54924, 38.06], [-122.54806, 38.06013], [-122.5479, 38.05898], [-122.54634, 38.05915], [-122.54642, 38.05974], [-122.54653, 38.05999], [-122.54628, 38.0601], [-122.54338, 38.05949], [-122.5428, 38.06105], [-122.543, 38.06218], [-122.54174, 38.0625], [-122.54178, 38.06298], [-122.54122, 38.06315], [-122.54106, 38.06323], [-122.54091, 38.06334], [-122.54085, 38.06336], [-122.54051, 38.06313], [-122.5386, 38.06219], [-122.5383, 38.0621], [-122.53695, 38.06187], [-122.53698, 38.06171], [-122.53683, 38.06158], [-122.53733, 38.06052], [-122.53647, 38.05977], [-122.53603, 38.05984], [-122.53552, 38.05936], [-122.53599, 38.05918], [-122.53597, 38.05869], [-122.53571, 38.05832], [-122.53593, 38.05791], [-122.53566, 38.05775], [-122.53572, 38.05758], [-122.53578, 38.05751], [-122.53604, 38.05737], [-122.53659, 38.0573], [-122.53669, 38.05534], [-122.53981, 38.05538], [-122.54195, 38.05604], [-122.54331, 38.05555], [-122.5497, 38.05414], [-122.5507, 38.05475], [-122.55109, 38.0548], [-122.55291, 38.05517], [-122.55343, 38.05531], [-122.55322, 38.05542], [-122.55323, 38.05553], [-122.55344, 38.0557], [-122.55346, 38.05577], [-122.55342, 38.05581], [-122.55345, 38.05593], [-122.5532, 38.05635], [-122.55316, 38.05643], [-122.55316, 38.05656], [-122.55326, 38.05667], [-122.55357, 38.05678], [-122.55368, 38.05684], [-122.55379, 38.05692], [-122.55384, 38.05718], [-122.55385, 38.058], [-122.5539, 38.05838], [-122.55387, 38.05882], [-122.55382, 38.05906], [-122.55376, 38.05915], [-122.55376, 38.05933], [-122.55373, 38.05945], [-122.55371, 38.05961], [-122.55376, 38.05975], [-122.55383, 38.05985], [-122.5538, 38.0599], [-122.5538, 38.05995], [-122.55385, 38.06008], [-122.55387, 38.06018], [-122.55382, 38.06071], [-122.55384, 38.06085], [-122.5539, 38.06097], [-122.55406, 38.06114], [-122.55417, 38.0612], [-122.55424, 38.06126], [-122.55432, 38.0613], [-122.55433, 38.0614]], [[-122.5416, 38.06091], [-122.54164, 38.06118], [-122.54179, 38.06089], [-122.54181, 38.06076], [-122.54181, 38.06063], [-122.54148, 38.06069], [-122.5416, 38.06091]]]} | Open Access 1 | 17418 | Loma Verde Open Space Preserve | 6293 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincounty.org/depts/pk/divisions/open-space/loma-verde | Marin 23 | 277.565 | Loma Verde OSP | 1975 | 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]);