units_with_maps

Table actions

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

1 row where AGNCY_NAME = 107, DES_TP = 490 and MNG_AGENCY = 104

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Scotts Valley, City of · 1 ✖

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
6083 6083 6082 {"type": "MultiPolygon", "coordinates": [[[[-122.03315, 37.05095], [-122.03281, 37.0516], [-122.0327, 37.05176], [-122.03245, 37.05195], [-122.03227, 37.05182], [-122.03216, 37.05193], [-122.03207, 37.05206], [-122.03202, 37.05221], [-122.03199, 37.05235], [-122.03201, 37.0525], [-122.03205, 37.05265], [-122.03247, 37.05332], [-122.03224, 37.05356], [-122.03205, 37.0536], [-122.03196, 37.05369], [-122.03213, 37.05381], [-122.03213, 37.0539], [-122.03218, 37.05395], [-122.03226, 37.05397], [-122.03226, 37.05404], [-122.03213, 37.05419], [-122.0318, 37.05403], [-122.03136, 37.05427], [-122.03093, 37.05448], [-122.03059, 37.05448], [-122.03059, 37.05423], [-122.03074, 37.05397], [-122.03119, 37.05372], [-122.03147, 37.05364], [-122.03203, 37.05325], [-122.03165, 37.05261], [-122.03094, 37.05129], [-122.03064, 37.05122], [-122.03064, 37.05086], [-122.02946, 37.05085], [-122.02943, 37.05008], [-122.03105, 37.05005], [-122.0314, 37.05002], [-122.03174, 37.04996], [-122.03204, 37.04988], [-122.03315, 37.05095]]], [[[-122.03187, 37.04973], [-122.0314, 37.04983], [-122.03104, 37.04985], [-122.02999, 37.04987], [-122.03115, 37.04903], [-122.03187, 37.04973]]], [[[-122.03631, 37.0512], [-122.03628, 37.05127], [-122.03593, 37.05127], [-122.03585, 37.05136], [-122.03582, 37.0515], [-122.03566, 37.05167], [-122.03551, 37.05173], [-122.03551, 37.05182], [-122.03543, 37.05187], [-122.03543, 37.05195], [-122.03504, 37.05281], [-122.03455, 37.05232], [-122.03458, 37.05225], [-122.03465, 37.05225], [-122.03471, 37.05223], [-122.03499, 37.05231], [-122.03527, 37.0517], [-122.03534, 37.0516], [-122.03574, 37.05116], [-122.0358, 37.05101], [-122.03547, 37.05039], [-122.03537, 37.05026], [-122.0351, 37.05005], [-122.03437, 37.04976], [-122.03373, 37.04941], [-122.03358, 37.0493], [-122.03327, 37.04949], [-122.03294, 37.04964], [-122.0329, 37.04969], [-122.0329, 37.0498], [-122.03292, 37.04982], [-122.03295, 37.04982], [-122.03296, 37.04985], [-122.03292, 37.04985], [-122.03287, 37.04982], [-122.03288, 37.04967], [-122.03293, 37.04961], [-122.03333, 37.04943], [-122.03358, 37.04926], [-122.03375, 37.04908], [-122.03388, 37.04885], [-122.03394, 37.04877], [-122.03416, 37.04859], [-122.03411, 37.0489], [-122.03425, 37.04906], [-122.03488, 37.04953], [-122.03506, 37.04954], [-122.03528, 37.04967], [-122.03559, 37.04978], [-122.03568, 37.04988], [-122.03586, 37.04989], [-122.0356, 37.05018], [-122.03574, 37.05034], [-122.03591, 37.05041], [-122.03592, 37.05045], [-122.03582, 37.05054], [-122.03583, 37.05066], [-122.03604, 37.05092], [-122.03613, 37.05111], [-122.03631, 37.0512]]]]} Open Access 1 885 Skypark 25545 1328 Scotts Valley, City of 107 City 2 City Agency 2 http://www.scottsvalley.org/parks/parks_recs.html City 2 1328 Scotts Valley, City of 104 City 2 City Agency 2   Santa Cruz 5 22.469 Skypark   None 490  

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