units_with_maps

Table actions

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

7 rows where DES_TP = 14, MNG_AGENCY = 104 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 7 ✖

MNG_AGENCY 1

  • Scotts Valley, City of · 7 ✖

DES_TP 1

  • Local Other or Unknown · 7 ✖

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
13260 13260 13259 {"type": "Polygon", "coordinates": [[[-122.03502, 37.03122], [-122.03293, 37.03323], [-122.03274, 37.03239], [-122.03256, 37.03183], [-122.03206, 37.0318], [-122.0321, 37.03172], [-122.03201, 37.03169], [-122.03209, 37.03149], [-122.03209, 37.03129], [-122.03202, 37.0311], [-122.03196, 37.031], [-122.03196, 37.03096], [-122.03246, 37.03041], [-122.03201, 37.02973], [-122.03166, 37.0299], [-122.03121, 37.03053], [-122.03146, 37.03092], [-122.02985, 37.03093], [-122.02891, 37.03117], [-122.02888, 37.03114], [-122.03278, 37.02919], [-122.03502, 37.03122]]]} Open Access 1 35307 Scotts Valley holding 5 25211 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 18.344 Scotts Valley holding 5 0 Local Other or Unknown 14 4
13281 13281 13280 {"type": "Polygon", "coordinates": [[[-121.99859, 37.06655], [-121.99847, 37.06705], [-121.99811, 37.06695], [-121.99814, 37.06685], [-121.99824, 37.06674], [-121.99859, 37.06655]]]} Open Access 1 35335 Scotts Valley holding 7 25213 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 0.3 Scotts Valley holding 7 0 Local Other or Unknown 14 4
13302 13302 13301 {"type": "Polygon", "coordinates": [[[-122.03188, 37.03168], [-122.03188, 37.03172], [-122.03176, 37.03191], [-122.03156, 37.03235], [-122.03132, 37.03272], [-122.03101, 37.03338], [-122.03098, 37.0336], [-122.03107, 37.03381], [-122.0311, 37.03394], [-122.031, 37.03405], [-122.03097, 37.03406], [-122.03021, 37.03269], [-122.0307, 37.03251], [-122.03036, 37.03189], [-122.02955, 37.03246], [-122.02938, 37.03274], [-122.02926, 37.0327], [-122.02891, 37.03265], [-122.0287, 37.0326], [-122.02878, 37.03216], [-122.02774, 37.03172], [-122.02888, 37.03114], [-122.02929, 37.03214], [-122.0302, 37.03151], [-122.03026, 37.03157], [-122.03039, 37.03149], [-122.03108, 37.03165], [-122.03126, 37.03166], [-122.03153, 37.03163], [-122.03168, 37.03162], [-122.03184, 37.03166], [-122.03188, 37.03168]]]} Open Access 1 35364 Scotts Valley holding 1 25207 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 8.816 Scotts Valley holding 1 0 Local Other or Unknown 14 4
13340 13340 13339 {"type": "Polygon", "coordinates": [[[-121.99514, 37.05375], [-121.99504, 37.05378], [-121.99487, 37.05355], [-121.99458, 37.05324], [-121.99485, 37.05316], [-121.99499, 37.05319], [-121.99502, 37.05361], [-121.99514, 37.05375]]]} Open Access 1 35418 Scotts Valley holding 2 25208 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 0.324 Scotts Valley holding 2 0 Local Other or Unknown 14 4
13341 13341 13340 {"type": "Polygon", "coordinates": [[[-121.99808, 37.05018], [-121.99776, 37.05056], [-121.99753, 37.05077], [-121.99737, 37.05101], [-121.99762, 37.0513], [-121.99776, 37.05178], [-121.99705, 37.05155], [-121.99651, 37.05186], [-121.99548, 37.05262], [-121.99581, 37.05336], [-121.99485, 37.05316], [-121.99458, 37.05324], [-121.99423, 37.05383], [-121.99209, 37.05371], [-121.99208, 37.05138], [-121.99372, 37.05137], [-121.9937, 37.05014], [-121.99699, 37.05015], [-121.99808, 37.05018]]]} Open Access 1 35419 Scotts Valley holding 4 25210 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 33.56 Scotts Valley holding 4 0 Local Other or Unknown 14 4
13342 13342 13341 {"type": "Polygon", "coordinates": [[[-122.00556, 37.06268], [-122.0055, 37.06275], [-122.00535, 37.06284], [-122.00528, 37.06254], [-122.00532, 37.06251], [-122.00537, 37.06251], [-122.00552, 37.0626], [-122.00556, 37.06268]]]} Open Access 1 35420 Scotts Valley holding 3 25209 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 0.132 Scotts Valley holding 3 0 Local Other or Unknown 14 4
13984 13984 13983 {"type": "Polygon", "coordinates": [[[-121.99423, 37.05383], [-121.99408, 37.05456], [-121.99386, 37.05528], [-121.99284, 37.05628], [-121.99279, 37.05727], [-121.99213, 37.05728], [-121.99209, 37.05371], [-121.99423, 37.05383]]]} Open Access 1 36665 Scotts Valley holding 6 25212 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 11.96 Scotts Valley holding 6 0 Local Other or Unknown 14 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]);