units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where ACCESS_TYP = 2, MNG_AGENCY = 411 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • Milpitas, City of · 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
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

CSV options: 

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]);