units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, MNG_AG_TYP = 2 and YR_EST = 1968
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15684 | 15684 | 15683 | {"type": "MultiPolygon", "coordinates": [[[[-121.88339, 37.45608], [-121.88337, 37.4563], [-121.88338, 37.45676], [-121.88435, 37.4581], [-121.88439, 37.45824], [-121.88437, 37.45839], [-121.88411, 37.45894], [-121.88403, 37.45929], [-121.88405, 37.45946], [-121.8842, 37.45998], [-121.88427, 37.46011], [-121.88428, 37.46025], [-121.88426, 37.46033], [-121.88418, 37.46043], [-121.88411, 37.46048], [-121.88396, 37.46054], [-121.88309, 37.46065], [-121.88177, 37.46067], [-121.88137, 37.46076], [-121.88108, 37.46086], [-121.88083, 37.46088], [-121.88066, 37.46086], [-121.8805, 37.46082], [-121.88035, 37.46074], [-121.88025, 37.46066], [-121.88017, 37.46062], [-121.87999, 37.46055], [-121.87981, 37.46051], [-121.87961, 37.4605], [-121.87917, 37.46053], [-121.87856, 37.46052], [-121.8784, 37.46049], [-121.87804, 37.46039], [-121.87785, 37.46038], [-121.87772, 37.46041], [-121.8776, 37.46046], [-121.87747, 37.46057], [-121.87741, 37.46066], [-121.87729, 37.46096], [-121.87717, 37.46109], [-121.87706, 37.46115], [-121.87694, 37.46119], [-121.87674, 37.46119], [-121.87661, 37.46116], [-121.8765, 37.4611], [-121.8762, 37.46082], [-121.87607, 37.46075], [-121.87593, 37.4607], [-121.87578, 37.46068], [-121.87563, 37.46068], [-121.87548, 37.46071], [-121.87525, 37.46079], [-121.87514, 37.4608], [-121.87503, 37.46079], [-121.87488, 37.46072], [-121.8748, 37.46066], [-121.8747, 37.46049], [-121.87461, 37.46041], [-121.87362, 37.45984], [-121.87344, 37.45971], [-121.87206, 37.45854], [-121.87198, 37.45846], [-121.87193, 37.45832], [-121.87195, 37.45818], [-121.87204, 37.45805], [-121.87213, 37.45799], [-121.87224, 37.45795], [-121.87242, 37.45794], [-121.87485, 37.45908], [-121.87732, 37.45937], [-121.87878, 37.45978], [-121.88001, 37.45977], [-121.88283, 37.45912], [-121.88265, 37.45858], [-121.8803, 37.4566], [-121.88033, 37.45653], [-121.8803, 37.45623], [-121.88032, 37.45611], [-121.8804, 37.45588], [-121.88047, 37.45578], [-121.88057, 37.4557], [-121.88069, 37.45564], [-121.88087, 37.4556], [-121.88106, 37.45562], [-121.88145, 37.45576], [-121.88161, 37.4558], [-121.88178, 37.45582], [-121.88179, 37.45583], [-121.88203, 37.45582], [-121.88204, 37.4558], [-121.8826, 37.4557], [-121.88283, 37.45601], [-121.88339, 37.45608]]], [[[-121.88252, 37.45558], [-121.88232, 37.45562], [-121.88213, 37.45555], [-121.88191, 37.45557], [-121.88187, 37.45561], [-121.88188, 37.45567], [-121.88178, 37.4557], [-121.88177, 37.45572], [-121.8815, 37.45567], [-121.88104, 37.45551], [-121.88083, 37.4555], [-121.88063, 37.45555], [-121.88045, 37.45565], [-121.88036, 37.45574], [-121.88031, 37.45583], [-121.88022, 37.45609], [-121.88019, 37.45622], [-121.88012, 37.45628], [-121.88009, 37.45632], [-121.88009, 37.45636], [-121.88015, 37.45643], [-121.88016, 37.45649], [-121.87827, 37.45541], [-121.87696, 37.45533], [-121.87678, 37.4554], [-121.87665, 37.45537], [-121.87645, 37.45535], [-121.87636, 37.45547], [-121.87557, 37.45586], [-121.8754, 37.4557], [-121.87528, 37.45562], [-121.87505, 37.45557], [-121.87468, 37.45575], [-121.87388, 37.45513], [-121.87366, 37.45498], [-121.8734, 37.45488], [-121.87276, 37.45472], [-121.87252, 37.4546], [-121.87234, 37.45443], [-121.87225, 37.4543], [-121.87217, 37.45409], [-121.87216, 37.45388], [-121.87222, 37.45367], [-121.87231, 37.45354], [-121.87249, 37.45339], [-121.87264, 37.45331], [-121.87283, 37.45325], [-121.87345, 37.45312], [-121.87612, 37.45241], [-121.87637, 37.45237], [-121.87663, 37.45234], [-121.87755, 37.45237], [-121.8777, 37.4524], [-121.87796, 37.45256], [-121.8781, 37.4526], [-121.87824, 37.4526], [-121.87839, 37.45256], [-121.87853, 37.45251], [-121.87865, 37.45243], [-121.87898, 37.45216], [-121.8791, 37.4521], [-121.8793, 37.45205], [-121.8795, 37.45206], [-121.87963, 37.4521], [-121.87976, 37.45216], [-121.88012, 37.45239], [-121.88033, 37.45256], [-121.88061, 37.45284], [-121.8821, 37.45502], [-121.88252, 37.45558]]]]} | Restricted Access 2 | 14968 | Summit Pointe Golf Course | 33044 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 121.004 | Summit Pointe GC | 1968 | 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]);