units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, DES_TP = 907 and MNG_AGENCY = 173
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Pacific Grove, City of · 1 ✖
DES_TP 1
- - · 1 ✖
ACCESS_TYP 1
- Restricted 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10378 | 10378 | 10377 | {"type": "MultiPolygon", "coordinates": [[[[-121.92445, 36.62692], [-121.92367, 36.62794], [-121.92237, 36.62731], [-121.92247, 36.62704], [-121.91997, 36.62581], [-121.92003, 36.62571], [-121.91989, 36.62563], [-121.91971, 36.62549], [-121.91887, 36.62507], [-121.91881, 36.62498], [-121.91882, 36.62488], [-121.91886, 36.62482], [-121.91893, 36.62478], [-121.91901, 36.62475], [-121.9191, 36.62476], [-121.92302, 36.62586], [-121.92292, 36.62621], [-121.92316, 36.62628], [-121.9236, 36.62644], [-121.92382, 36.62655], [-121.9242, 36.62678], [-121.92445, 36.62692]]], [[[-121.92659, 36.62954], [-121.9265, 36.62993], [-121.92645, 36.62997], [-121.92639, 36.62997], [-121.92345, 36.62854], [-121.92375, 36.62815], [-121.92659, 36.62954]]], [[[-121.92669, 36.62885], [-121.92661, 36.62939], [-121.92384, 36.62803], [-121.92418, 36.6276], [-121.92669, 36.62885]]], [[[-121.93197, 36.6333], [-121.93172, 36.634], [-121.93169, 36.63404], [-121.93163, 36.63405], [-121.92913, 36.63361], [-121.92879, 36.6335], [-121.92834, 36.63329], [-121.92832, 36.63325], [-121.92832, 36.63321], [-121.92865, 36.63278], [-121.9287, 36.63263], [-121.92867, 36.63201], [-121.92861, 36.63176], [-121.92855, 36.63158], [-121.92845, 36.63137], [-121.92829, 36.63114], [-121.92812, 36.63094], [-121.9279, 36.63074], [-121.92752, 36.63049], [-121.92732, 36.63039], [-121.927, 36.63027], [-121.92672, 36.63013], [-121.92671, 36.63008], [-121.92678, 36.62964], [-121.92943, 36.63095], [-121.92971, 36.63106], [-121.92997, 36.63113], [-121.9294, 36.63268], [-121.93197, 36.6333]]], [[[-121.92934, 36.63016], [-121.92922, 36.63068], [-121.9268, 36.62949], [-121.92689, 36.62894], [-121.92934, 36.63016]]], [[[-121.9352, 36.63631], [-121.93508, 36.63686], [-121.93454, 36.63701], [-121.93434, 36.63703], [-121.93421, 36.63702], [-121.9341, 36.63698], [-121.93401, 36.63693], [-121.93388, 36.63682], [-121.93402, 36.63596], [-121.93434, 36.63622], [-121.9352, 36.63631]]]]} | Restricted Access 2 | 18334 | Pacific Grove Golf Links | 33064 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 42.199 | Pacific Grove Golf Links | None 907 |
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]);