units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, AGNCY_LEV = 4 and MNG_AGENCY = 78
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Rancho Simi Recreation and Park District · 2 ✖
DES_TP 1
ACCESS_TYP 1
- Restricted 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15657 | 15657 | 15656 | {"type": "MultiPolygon", "coordinates": [[[[-118.68934, 34.28971], [-118.68908, 34.28982], [-118.68888, 34.28999], [-118.68859, 34.29019], [-118.68794, 34.2908], [-118.68765, 34.29118], [-118.68704, 34.29168], [-118.68663, 34.29223], [-118.68643, 34.29236], [-118.68622, 34.29243], [-118.68598, 34.29246], [-118.68572, 34.29244], [-118.68461, 34.29194], [-118.68445, 34.29177], [-118.68442, 34.29155], [-118.68444, 34.29087], [-118.68461, 34.29039], [-118.68517, 34.29001], [-118.68555, 34.2896], [-118.68587, 34.28962], [-118.68634, 34.28973], [-118.68707, 34.28971], [-118.6877, 34.28926], [-118.68801, 34.28909], [-118.68812, 34.28922], [-118.68824, 34.28916], [-118.68836, 34.28906], [-118.68854, 34.28918], [-118.68885, 34.28932], [-118.68902, 34.28941], [-118.68919, 34.28955], [-118.68934, 34.28971]]], [[[-118.69728, 34.29277], [-118.69727, 34.2928], [-118.69687, 34.29267], [-118.69635, 34.2933], [-118.69631, 34.29329], [-118.69622, 34.29345], [-118.69601, 34.29371], [-118.69572, 34.29411], [-118.69548, 34.29453], [-118.69541, 34.29457], [-118.69535, 34.29468], [-118.69538, 34.29474], [-118.69532, 34.29481], [-118.69529, 34.29488], [-118.69529, 34.29493], [-118.6951, 34.29552], [-118.695, 34.29571], [-118.69488, 34.29584], [-118.69485, 34.2959], [-118.69484, 34.29598], [-118.69489, 34.29612], [-118.69489, 34.29636], [-118.69498, 34.29691], [-118.69611, 34.29865], [-118.69605, 34.29868], [-118.69605, 34.29869], [-118.69619, 34.29883], [-118.69622, 34.29882], [-118.69653, 34.29931], [-118.69648, 34.29935], [-118.69593, 34.29904], [-118.69585, 34.29915], [-118.69593, 34.29942], [-118.69589, 34.29955], [-118.69583, 34.29969], [-118.69577, 34.30037], [-118.69589, 34.30039], [-118.69585, 34.30072], [-118.69372, 34.30072], [-118.69396, 34.30183], [-118.6937, 34.30188], [-118.69367, 34.3018], [-118.69341, 34.30185], [-118.69341, 34.30193], [-118.69333, 34.30194], [-118.69306, 34.30195], [-118.69279, 34.30193], [-118.69251, 34.30188], [-118.69227, 34.30182], [-118.69201, 34.30171], [-118.69179, 34.30159], [-118.69161, 34.30146], [-118.69146, 34.30134], [-118.69145, 34.30134], [-118.69122, 34.30108], [-118.69104, 34.30076], [-118.69097, 34.30058], [-118.69093, 34.3004], [-118.6909, 34.30019], [-118.69092, 34.2999], [-118.69096, 34.29971], [-118.69123, 34.29884], [-118.69127, 34.29862], [-118.69128, 34.29842], [-118.69128, 34.29821], [-118.69125, 34.29799], [-118.69118, 34.29774], [-118.69108, 34.29747], [-118.69086, 34.29709], [-118.69087, 34.29707], [-118.69059, 34.29676], [-118.68992, 34.29622], [-118.68965, 34.29594], [-118.68945, 34.29575], [-118.6892, 34.29557], [-118.68881, 34.29533], [-118.68879, 34.29529], [-118.68881, 34.29526], [-118.68884, 34.29522], [-118.68896, 34.29515], [-118.68901, 34.29508], [-118.68903, 34.29499], [-118.68901, 34.29489], [-118.68894, 34.29482], [-118.6887, 34.29466], [-118.68821, 34.29422], [-118.68846, 34.29401], [-118.68785, 34.29348], [-118.68779, 34.29348], [-118.68783, 34.29342], [-118.68793, 34.29342], [-118.68806, 34.29333], [-118.6882, 34.29285], [-118.68818, 34.29262], [-118.68797, 34.29232], [-118.68824, 34.29207], [-118.68881, 34.29163], [-118.68881, 34.29161], [-118.68877, 34.29158], [-118.6888, 34.29156], [-118.68885, 34.29159], [-118.68929, 34.29111], [-118.68955, 34.29093], [-118.68988, 34.29096], [-118.69047, 34.29096], [-118.69171, 34.29034], [-118.69208, 34.28988], [-118.69181, 34.28948], [-118.6913, 34.28931], [-118.69044, 34.28934], [-118.68973, 34.28953], [-118.68954, 34.28962], [-118.68953, 34.28969], [-118.6894, 34.28951], [-118.6892, 34.28934], [-118.68899, 34.2892], [-118.68861, 34.28903], [-118.68846, 34.28892], [-118.68834, 34.28881], [-118.6881, 34.28847], [-118.68919, 34.28793], [-118.68937, 34.28787], [-118.68927, 34.28761], [-118.68943, 34.28759], [-118.69069, 34.28758], [-118.69091, 34.28754], [-118.69114, 34.28744], [-118.69133, 34.28728], [-118.69147, 34.28708], [-118.69152, 34.28688], [-118.69152, 34.28641], [-118.69157, 34.28636], [-118.69487, 34.28636], [-118.69487, 34.28664], [-118.69497, 34.28678], [-118.69526, 34.28696], [-118.69589, 34.28727], [-118.69636, 34.28758], [-118.69697, 34.28806], [-118.69699, 34.28807], [-118.697, 34.28827], [-118.69659, 34.29067], [-118.69659, 34.29095], [-118.69661, 34.2912], [-118.69693, 34.29249], [-118.6969, 34.29264], [-118.69728, 34.29277]]]]} | Restricted Access 2 | 824 | Simi Hills Golf Course | 32992 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 250.429 | Simi Hills GC | 0 | Local Recreation Area 3 | 4 | |
15658 | 15658 | 15657 | {"type": "Polygon", "coordinates": [[[-118.79721, 34.25624], [-118.79668, 34.25662], [-118.79642, 34.25684], [-118.79615, 34.25713], [-118.79592, 34.25744], [-118.79571, 34.25782], [-118.79559, 34.25817], [-118.79552, 34.25853], [-118.7955, 34.25887], [-118.79393, 34.2589], [-118.79345, 34.25909], [-118.79345, 34.2586], [-118.79339, 34.25847], [-118.79309, 34.25833], [-118.79259, 34.25793], [-118.7935, 34.25684], [-118.79425, 34.25586], [-118.79447, 34.25545], [-118.79699, 34.25546], [-118.79721, 34.25624]]]} | Restricted Access 2 | 834 | Sinaloa Golf Course | 32993 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 24.34 | Sinaloa GC | 0 | Local Recreation Area 3 | 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]);