superunits_with_maps

Table actions

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

3 rows where ACCESS_TYP = 1, MNG_AGENCY = 957 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 3 ✖

MNG_AGENCY 1

  • Valley Center Parks and Recreation · 3 ✖

ACCESS_TYP 1

  • Open Access · 3 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
1411 1411 1410 {"type": "Polygon", "coordinates": [[[-117.02375, 33.23685], [-117.02356, 33.2408], [-117.0235, 33.24085], [-117.01947, 33.24142], [-117.01954, 33.24036], [-117.01953, 33.24028], [-117.0196, 33.23816], [-117.01959, 33.23767], [-117.02054, 33.23769], [-117.02067, 33.23715], [-117.02218, 33.23726], [-117.02227, 33.23694], [-117.02375, 33.23685]]]} Open Access 1 Adams Community Park http://valleycenterparks.com/adams-park.html 15259 2267 Valley Center Parks and Recreation 957 Special District 4 Recreation/Parks District 4 http://www.valleycenterparks.com/ Special District 4 40.864 Adams Community Park  
3077 3077 3076 {"type": "MultiPolygon", "coordinates": [[[[-117.02211, 33.23255], [-117.02184, 33.23287], [-117.02177, 33.233], [-117.02172, 33.23315], [-117.0217, 33.23329], [-117.02169, 33.2336], [-117.02172, 33.2337], [-117.02181, 33.23381], [-117.01978, 33.23376], [-117.01982, 33.23259], [-117.02065, 33.23255], [-117.02067, 33.23262], [-117.02211, 33.23255]]], [[[-117.02398, 33.234], [-117.02394, 33.23465], [-117.02277, 33.23459], [-117.0228, 33.23394], [-117.02398, 33.234]]]]} Open Access 1 Cole Grade Park http://valleycenterparks.com/sports.html 17488 2267 Valley Center Parks and Recreation 957 Special District 4 Recreation/Parks District 4 http://www.valleycenterparks.com/ Special District 4 8.076 Cole Grade Park  
10627 10627 10626 {"type": "Polygon", "coordinates": [[[-117.0394, 33.21861], [-117.03938, 33.22118], [-117.03939, 33.22214], [-117.03705, 33.22216], [-117.03693, 33.22215], [-117.03682, 33.22181], [-117.0364, 33.22099], [-117.03616, 33.2206], [-117.03524, 33.2202], [-117.03611, 33.22021], [-117.0362, 33.22038], [-117.03782, 33.22024], [-117.03783, 33.21859], [-117.0394, 33.21861]]]} Open Access 1 Valley Center Community Park   26785 2267 Valley Center Parks and Recreation 957 Special District 4 Recreation/Parks District 4 http://www.valleycenterparks.com/ Special District 4 20.783 Valley Ctr. Community Park  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);