units_with_maps

Table actions

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

3 rows where COUNTY = 4, DES_TP = 2 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 3 ✖

DES_TP 1

  • Local Park · 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
11859 11859 11858 {"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.02055, 33.23769], [-117.02067, 33.23715], [-117.02219, 33.23726], [-117.02227, 33.23694], [-117.02375, 33.23685]]]} Open Access 1 24307 Adams Community Park 15259 2267 Valley Center Parks and Recreation 994 Special District 4 Recreation/Parks District 4 http://www.valleycenterparks.com/ Special District 4 2267 Valley Center Parks and Recreation 957 Special District 4 Recreation/Parks District 4 http://valleycenterparks.com/adams-park.html San Diego 4 40.858 Adams Community Park 0 Local Park 2 4
14811 14811 14810 {"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.02066, 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 45230 Cole Grade Park 17488 2267 Valley Center Parks and Recreation 994 Special District 4 Recreation/Parks District 4 http://www.valleycenterparks.com/ Special District 4 2267 Valley Center Parks and Recreation 957 Special District 4 Recreation/Parks District 4 http://valleycenterparks.com/sports.html San Diego 4 8.076 Cole Grade Park 0 Local Park 2 4
14813 14813 14812 {"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.03783, 33.22024], [-117.03783, 33.21859], [-117.0394, 33.21861]]]} Open Access 1 45229 Valley Center Community Park 26785 2267 Valley Center Parks and Recreation 994 Special District 4 Recreation/Parks District 4 http://www.valleycenterparks.com/ Special District 4 2267 Valley Center Parks and Recreation 957 Special District 4 Recreation/Parks District 4   San Diego 4 20.768 Valley Ctr. Community Park 0 Local Park 2 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]);