units_with_maps

Table actions

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

1 row where AGNCY_NAME = 403, DES_TP = 773 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 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
9397 9397 9396 {"type": "Polygon", "coordinates": [[[-122.44466, 40.60043], [-122.4434, 40.60041], [-122.44331, 40.60019], [-122.44295, 40.59974], [-122.44266, 40.5994], [-122.44251, 40.59917], [-122.44224, 40.59894], [-122.44206, 40.59867], [-122.44161, 40.59819], [-122.4413, 40.59794], [-122.44111, 40.59774], [-122.44088, 40.59758], [-122.44065, 40.59735], [-122.43969, 40.59689], [-122.43938, 40.59661], [-122.4391, 40.59639], [-122.43892, 40.59629], [-122.43838, 40.59587], [-122.43793, 40.59556], [-122.43781, 40.5955], [-122.43759, 40.59542], [-122.4368, 40.59506], [-122.43647, 40.59495], [-122.43603, 40.59468], [-122.43548, 40.59445], [-122.43533, 40.5944], [-122.4352, 40.5944], [-122.43491, 40.59434], [-122.43458, 40.5942], [-122.43432, 40.59416], [-122.43416, 40.5941], [-122.4339, 40.59404], [-122.43327, 40.59383], [-122.43312, 40.59381], [-122.43296, 40.59375], [-122.43285, 40.59374], [-122.43276, 40.59375], [-122.43248, 40.59384], [-122.4324, 40.59391], [-122.43218, 40.59396], [-122.43162, 40.59393], [-122.43113, 40.59406], [-122.43093, 40.59408], [-122.43084, 40.59412], [-122.43075, 40.59411], [-122.43034, 40.59416], [-122.43023, 40.59419], [-122.42992, 40.59413], [-122.42989, 40.59415], [-122.42988, 40.59418], [-122.4298, 40.59422], [-122.42964, 40.59423], [-122.42957, 40.59422], [-122.42934, 40.59431], [-122.42908, 40.59436], [-122.42878, 40.59434], [-122.42882, 40.59402], [-122.42876, 40.59396], [-122.4286, 40.59402], [-122.42819, 40.59405], [-122.4274, 40.59404], [-122.42698, 40.59402], [-122.42637, 40.59378], [-122.42618, 40.59374], [-122.42582, 40.59375], [-122.4256, 40.59371], [-122.42559, 40.59348], [-122.42382, 40.5936], [-122.42381, 40.59349], [-122.42317, 40.59354], [-122.42136, 40.59325], [-122.41973, 40.59285], [-122.41606, 40.59256], [-122.41567, 40.59257], [-122.41185, 40.59203], [-122.40652, 40.59262], [-122.40609, 40.59264], [-122.40583, 40.59269], [-122.40551, 40.59266], [-122.40513, 40.59269], [-122.40465, 40.59265], [-122.40437, 40.5927], [-122.40404, 40.59261], [-122.40368, 40.5926], [-122.40335, 40.59263], [-122.40326, 40.59266], [-122.40315, 40.59267], [-122.40174, 40.59266], [-122.40149, 40.5927], [-122.40124, 40.59269], [-122.4011, 40.59271], [-122.40094, 40.59276], [-122.40077, 40.59276], [-122.40062, 40.5928], [-122.40043, 40.59279], [-122.40024, 40.5928], [-122.40021, 40.59243], [-122.40014, 40.59203], [-122.40003, 40.59164], [-122.39988, 40.59126], [-122.3997, 40.59089], [-122.39947, 40.59048], [-122.39975, 40.59076], [-122.40186, 40.59146], [-122.40187, 40.59144], [-122.40158, 40.59106], [-122.40244, 40.59134], [-122.40363, 40.59167], [-122.40481, 40.59189], [-122.40568, 40.59201], [-122.40718, 40.59204], [-122.40809, 40.59202], [-122.40889, 40.59203], [-122.40983, 40.59197], [-122.41041, 40.59195], [-122.41113, 40.59196], [-122.41189, 40.592], [-122.41792, 40.59243], [-122.42105, 40.59268], [-122.42227, 40.59282], [-122.42435, 40.59317], [-122.42493, 40.59324], [-122.42623, 40.59328], [-122.4272, 40.59329], [-122.42755, 40.59328], [-122.42807, 40.59324], [-122.42841, 40.5932], [-122.4297, 40.59294], [-122.43025, 40.59288], [-122.43188, 40.59284], [-122.43308, 40.5928], [-122.43427, 40.59278], [-122.43486, 40.5928], [-122.43562, 40.59291], [-122.43592, 40.59298], [-122.43616, 40.59306], [-122.4364, 40.59316], [-122.43666, 40.59329], [-122.4369, 40.59311], [-122.43731, 40.59309], [-122.43764, 40.5929], [-122.43825, 40.59319], [-122.43866, 40.59343], [-122.43901, 40.59367], [-122.43932, 40.59391], [-122.43959, 40.59415], [-122.43984, 40.5944], [-122.44107, 40.59583], [-122.44122, 40.59577], [-122.44223, 40.59697], [-122.4441, 40.59908], [-122.44434, 40.59948], [-122.44457, 40.59996], [-122.44466, 40.60043]]]} Open Access 1 15704 Sacramento River South Trailhead 24773 1268 Redding, City of 403 City 2 City Agency 2 http://reddingrecreation.org/ City 2 1268 Redding, City of 397 City 2 City Agency 2   Shasta 27 98.815 Sacramento River South Trailhead   None 773  

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