units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 87, MNG_AG_TYP = 4 and YR_EST = 2006
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 1 ✖
MNG_AGENCY 1
- East Bay Regional Park District · 1 ✖
DES_TP 1
ACCESS_TYP 1
- Open Access · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16379 | 16379 | 16378 | {"type": "MultiPolygon", "coordinates": [[[[-122.22214, 38.01075], [-122.22214, 38.01075], [-122.22189, 38.0414], [-122.21985, 38.03985], [-122.21743, 38.03824], [-122.21573, 38.03546], [-122.21572, 38.03488], [-122.21505, 38.03426], [-122.21389, 38.0342], [-122.21325, 38.03321], [-122.21205, 38.03281], [-122.2123, 38.03259], [-122.2123, 38.03257], [-122.21199, 38.03238], [-122.21158, 38.03216], [-122.21088, 38.03149], [-122.2104, 38.03111], [-122.20991, 38.03053], [-122.20943, 38.03014], [-122.20876, 38.02969], [-122.20749, 38.02873], [-122.20687, 38.02836], [-122.20728, 38.02784], [-122.20728, 38.02783], [-122.20659, 38.02826], [-122.20614, 38.02808], [-122.20621, 38.02419], [-122.20638, 38.0175], [-122.20398, 38.01753], [-122.20198, 38.01669], [-122.20191, 38.01472], [-122.20192, 38.01217], [-122.20369, 38.01147], [-122.20439, 38.01063], [-122.20779, 38.00949], [-122.20884, 38.01012], [-122.2093, 38.01008], [-122.21085, 38.00964], [-122.21133, 38.00874], [-122.2127, 38.0089], [-122.21413, 38.00921], [-122.21419, 38.00908], [-122.21456, 38.00914], [-122.21492, 38.00918], [-122.21538, 38.00921], [-122.21598, 38.00919], [-122.21598, 38.01072], [-122.22214, 38.01075]]], [[[-122.22191, 38.04246], [-122.22189, 38.04847], [-122.22144, 38.04852], [-122.22131, 38.04857], [-122.22036, 38.04704], [-122.22014, 38.04658], [-122.22062, 38.04658], [-122.22062, 38.04712], [-122.22083, 38.04713], [-122.22083, 38.04609], [-122.22056, 38.04565], [-122.21975, 38.04596], [-122.21956, 38.04559], [-122.21975, 38.04552], [-122.21945, 38.04502], [-122.21823, 38.04363], [-122.21677, 38.04258], [-122.21597, 38.04189], [-122.21494, 38.04029], [-122.21451, 38.03991], [-122.21429, 38.03984], [-122.21377, 38.03979], [-122.21191, 38.03886], [-122.21161, 38.03895], [-122.21052, 38.03865], [-122.21011, 38.0385], [-122.20992, 38.0384], [-122.2097, 38.03825], [-122.20879, 38.03671], [-122.20876, 38.0365], [-122.2088, 38.03624], [-122.20888, 38.03598], [-122.209, 38.03575], [-122.20918, 38.03553], [-122.2094, 38.03533], [-122.20966, 38.03517], [-122.20995, 38.03504], [-122.21025, 38.03495], [-122.21049, 38.0349], [-122.2117, 38.03501], [-122.21187, 38.03507], [-122.21216, 38.03519], [-122.21241, 38.03534], [-122.2129, 38.03568], [-122.21296, 38.03584], [-122.21344, 38.03605], [-122.21538, 38.03737], [-122.21614, 38.03702], [-122.21657, 38.03774], [-122.21669, 38.03829], [-122.21714, 38.03858], [-122.21801, 38.03944], [-122.21934, 38.04012], [-122.21957, 38.04034], [-122.21995, 38.04095], [-122.22146, 38.04224], [-122.22191, 38.04246]]]]} | Open Access 1 | 22284 | Crockett Hills Regional Park | 3246 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/crockett_hills | Contra Costa 12 | 1127.007 | Crockett Hills RP | 2006 | Local Park 2 | 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]);