units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where AGNCY_NAME = 626, MNG_AGENCY = 615 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 7 ✖
MNG_AGENCY 1
- Big Bear Valley Recreation and Park District · 7 ✖
DES_TP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3361 | 3361 | 3360 | {"type": "Polygon", "coordinates": [[[-116.94595, 34.2707], [-116.94595, 34.27072], [-116.94563, 34.27071], [-116.94562, 34.27077], [-116.94497, 34.27093], [-116.94464, 34.27093], [-116.94464, 34.27032], [-116.94497, 34.27032], [-116.94562, 34.2706], [-116.94562, 34.27069], [-116.94595, 34.2707]]]} | Open Access 1 | 24294 | Miller Park | 22245 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.155 | Miller Park | 0 | Local Park 2 | 4 | |
6773 | 6773 | 6772 | {"type": "Polygon", "coordinates": [[[-116.90495, 34.24779], [-116.90474, 34.24781], [-116.90462, 34.24807], [-116.90448, 34.24827], [-116.90431, 34.24846], [-116.90403, 34.24873], [-116.90396, 34.24889], [-116.90389, 34.24891], [-116.90385, 34.24888], [-116.90384, 34.24884], [-116.90405, 34.24859], [-116.9042, 34.24846], [-116.9043, 34.24833], [-116.90447, 34.24807], [-116.90457, 34.24781], [-116.90364, 34.24786], [-116.90349, 34.24799], [-116.90332, 34.2481], [-116.90318, 34.24817], [-116.90296, 34.24825], [-116.90253, 34.24807], [-116.90234, 34.24797], [-116.90204, 34.24794], [-116.9013, 34.24797], [-116.90048, 34.24739], [-116.89837, 34.24635], [-116.89837, 34.24628], [-116.90046, 34.24631], [-116.9026, 34.24714], [-116.90378, 34.24716], [-116.90436, 34.24666], [-116.90495, 34.24714], [-116.90495, 34.24779]]]} | Open Access 1 | 5242 | Meadow Park/ Ski Beach Park | 22077 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 14.954 | Meadow Park/ Ski Beach Park | 0 | Local Park 2 | 4 | |
11854 | 11854 | 11853 | {"type": "Polygon", "coordinates": [[[-116.80514, 34.23956], [-116.80401, 34.23957], [-116.80401, 34.23911], [-116.80513, 34.23911], [-116.80514, 34.23956]]]} | Open Access 1 | 24291 | Erwin Lake Park | 18700 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.293 | Erwin Lake Park | 0 | Local Park 2 | 4 | |
11856 | 11856 | 11855 | {"type": "Polygon", "coordinates": [[[-116.9437, 34.26661], [-116.94353, 34.26684], [-116.94343, 34.26702], [-116.94368, 34.26716], [-116.94319, 34.26782], [-116.94314, 34.26784], [-116.9431, 34.26783], [-116.94307, 34.26779], [-116.94306, 34.26702], [-116.94262, 34.26717], [-116.9425, 34.26666], [-116.94236, 34.26665], [-116.94236, 34.26662], [-116.94243, 34.26661], [-116.94235, 34.26648], [-116.94232, 34.26619], [-116.94237, 34.26586], [-116.94244, 34.26557], [-116.94254, 34.26533], [-116.94266, 34.2654], [-116.94281, 34.26529], [-116.94316, 34.26527], [-116.94339, 34.26541], [-116.94356, 34.26563], [-116.94368, 34.26603], [-116.94368, 34.26629], [-116.94363, 34.2666], [-116.9437, 34.26661]]]} | Open Access 1 | 24299 | Dana Point Park | 17913 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 5.904 | Dana Point Park | 0 | Local Park 2 | 4 | |
11858 | 11858 | 11857 | {"type": "Polygon", "coordinates": [[[-116.82518, 34.25059], [-116.82517, 34.25111], [-116.82511, 34.2514], [-116.82264, 34.2514], [-116.82262, 34.25055], [-116.82512, 34.25055], [-116.82516, 34.25057], [-116.82518, 34.25059]]]} | Open Access 1 | 24303 | Sugarloaf Park | 25945 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 5.455 | Sugarloaf Park | 0 | Local Park 2 | 4 | |
12012 | 12012 | 12011 | {"type": "Polygon", "coordinates": [[[-116.80742, 34.25033], [-116.80527, 34.25034], [-116.80523, 34.25032], [-116.8052, 34.25028], [-116.80519, 34.24883], [-116.8052, 34.2488], [-116.80525, 34.24878], [-116.80741, 34.24877], [-116.80742, 34.25033]]]} | Open Access 1 | 24682 | The Ranch | 26292 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 8.733 | The Ranch | 0 | Local Park 2 | 4 | |
14219 | 14219 | 14218 | {"type": "Polygon", "coordinates": [[[-116.84618, 34.26482], [-116.84437, 34.26482], [-116.84437, 34.26376], [-116.84458, 34.26376], [-116.84475, 34.26357], [-116.84509, 34.26291], [-116.8452, 34.26282], [-116.84548, 34.26282], [-116.84618, 34.26482]]]} | Open Access 1 | 44098 | Big Bear City Park | 16073 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 6.163 | Big Bear City Park | 0 | 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]);