units_with_maps

Table actions

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

3 rows where AGNCY_NAME = 149, DES_TP = 3 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 3 ✖

DES_TP 1

  • Local Recreation Area · 3 ✖

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
5079 5079 5078 {"type": "Polygon", "coordinates": [[[-119.01469, 34.22393], [-119.01462, 34.2239], [-119.01463, 34.22384], [-119.01461, 34.22379], [-119.01469, 34.22376], [-119.01469, 34.22393]]]} Open Access 1 15062 Pleasant Valley Recreation and Park District 23802 2113 Pleasant Valley Recreation and Park District 149 Special District 4 Recreation/Parks District 4 http://www.pvrpd.org/ Special District 4 2113 Pleasant Valley Recreation and Park District 145 Special District 4 Recreation/Parks District 4   Ventura 8 0.025 Pleasant Valley Rec. and Park District 0 Local Recreation Area 3 4
6383 6383 6382 {"type": "Polygon", "coordinates": [[[-119.0282, 34.21507], [-119.0282, 34.21519], [-119.02817, 34.21524], [-119.02776, 34.21535], [-119.02732, 34.2154], [-119.02622, 34.21542], [-119.02514, 34.21542], [-119.02397, 34.21533], [-119.01761, 34.21534], [-119.01763, 34.21524], [-119.01764, 34.21448], [-119.0177, 34.2143], [-119.01781, 34.21412], [-119.01794, 34.21399], [-119.01809, 34.21389], [-119.01903, 34.21345], [-119.01921, 34.21335], [-119.02238, 34.21332], [-119.02239, 34.21316], [-119.02246, 34.21317], [-119.02253, 34.21316], [-119.02254, 34.21318], [-119.02504, 34.21316], [-119.0251, 34.2132], [-119.02517, 34.21321], [-119.02525, 34.21319], [-119.02532, 34.21313], [-119.02817, 34.21311], [-119.02819, 34.2149], [-119.02816, 34.21499], [-119.0282, 34.21507]]]} Open Access 1 48374 Pleasant Valley Fields 32941 2113 Pleasant Valley Recreation and Park District 149 Special District 4 Recreation/Parks District 4 http://www.pvrpd.org/ Special District 4 2113 Pleasant Valley Recreation and Park District 145 Special District 4 Recreation/Parks District 4 http://www.pvrpd.org/parks/park_list/pleasant_valley_fields.asp Ventura 8 54.848 Pleasant Valley Fields 0 Local Recreation Area 3 4
17008 17008 17007 {"type": "MultiPolygon", "coordinates": [[[[-119.07806, 34.23628], [-119.07804, 34.23659], [-119.07787, 34.23722], [-119.07774, 34.23732], [-119.07769, 34.23731], [-119.07752, 34.23744], [-119.07748, 34.2374], [-119.07761, 34.23729], [-119.07779, 34.23724], [-119.07784, 34.2372], [-119.078, 34.23659], [-119.07802, 34.23628], [-119.07806, 34.23628]]], [[[-119.07825, 34.23856], [-119.07816, 34.23894], [-119.07672, 34.23911], [-119.0767, 34.23897], [-119.07671, 34.23882], [-119.07675, 34.23879], [-119.07685, 34.23834], [-119.07825, 34.23856]]], [[[-119.07634, 34.23901], [-119.07589, 34.23931], [-119.07579, 34.2394], [-119.07568, 34.23943], [-119.07559, 34.23947], [-119.07617, 34.2391], [-119.07634, 34.23901]]], [[[-119.07534, 34.23961], [-119.07509, 34.23983], [-119.07479, 34.24022], [-119.07451, 34.24043], [-119.0745, 34.24042], [-119.07527, 34.23965], [-119.07534, 34.23961]]]]} Open Access 1 48370 Los Posas Equestrian Center 32936 2113 Pleasant Valley Recreation and Park District 149 Special District 4 Recreation/Parks District 4 http://www.pvrpd.org/ Special District 4 2113 Pleasant Valley Recreation and Park District 145 Special District 4 Recreation/Parks District 4 http://www.pvrpd.org/parks/park_list/las_posas_equestrian_park.asp Ventura 8 2.391 Los Posas Equestrian Ctr. 0 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]);