units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where AGNCY_ID = 103, AGNCY_TYP = 1 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10390 | 10390 | 10389 | {"type": "MultiPolygon", "coordinates": [[[[-114.59933, 34.8403], [-114.59817, 34.8403], [-114.59816, 34.8402], [-114.5974, 34.8402], [-114.59631, 34.83958], [-114.5963, 34.83674], [-114.59756, 34.83674], [-114.59859, 34.8376], [-114.59933, 34.83869], [-114.59933, 34.8403]]], [[[-114.60795, 34.84404], [-114.60512, 34.84402], [-114.60511, 34.84467], [-114.60415, 34.8444], [-114.60324, 34.84401], [-114.60287, 34.84401], [-114.60287, 34.84392], [-114.6039, 34.84392], [-114.6039, 34.84287], [-114.60365, 34.84287], [-114.60365, 34.84339], [-114.60348, 34.84339], [-114.60348, 34.84286], [-114.6026, 34.84286], [-114.6026, 34.84339], [-114.60251, 34.84339], [-114.60251, 34.84286], [-114.60171, 34.84285], [-114.60171, 34.8423], [-114.60114, 34.84229], [-114.60113, 34.84294], [-114.60104, 34.84294], [-114.60104, 34.84285], [-114.60095, 34.84285], [-114.60095, 34.84276], [-114.60071, 34.84255], [-114.60071, 34.84219], [-114.6002, 34.84219], [-114.6002, 34.84197], [-114.60003, 34.84197], [-114.60003, 34.84164], [-114.59969, 34.84163], [-114.59969, 34.84108], [-114.59892, 34.84108], [-114.59891, 34.841], [-114.59885, 34.841], [-114.59885, 34.84052], [-114.59986, 34.84052], [-114.59987, 34.84029], [-114.60042, 34.84029], [-114.60048, 34.84038], [-114.60071, 34.84038], [-114.60071, 34.84051], [-114.6002, 34.84053], [-114.6002, 34.84107], [-114.60054, 34.84107], [-114.60055, 34.8417], [-114.60312, 34.84171], [-114.60701, 34.84358], [-114.60702, 34.84394], [-114.60717, 34.84394], [-114.60718, 34.84366], [-114.60795, 34.84404]], [[-114.60449, 34.84342], [-114.60448, 34.84392], [-114.60464, 34.84393], [-114.60465, 34.84343], [-114.60449, 34.84342]]], [[[-114.60513, 34.84766], [-114.60318, 34.84764], [-114.60299, 34.84743], [-114.60187, 34.84686], [-114.60072, 34.84634], [-114.60071, 34.844], [-114.60242, 34.84401], [-114.60412, 34.84467], [-114.60511, 34.84523], [-114.60513, 34.84766]]]]} | Restricted Access 2 | 49071 | River's Edge Golf Course | 33774 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/services/rivers-edge-golf-course/ | San Bernardino 22 | 77.93 | River's Edge GC | 0 | Local Recreation Area 3 | 4 |
12958 | 12958 | 12957 | {"type": "Polygon", "coordinates": [[[-114.60317, 34.84764], [-114.60145, 34.84762], [-114.60072, 34.84705], [-114.60071, 34.84633], [-114.60186, 34.84686], [-114.60298, 34.84742], [-114.60317, 34.84764]]]} | Open Access 1 | 30413 | Manny Morris Beach Side Park | 33661 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/manny-morris-beach-side-park/ | San Bernardino 22 | 3.852 | Manny Morris Beach Side 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]);