units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 1 and LABEL_NAME = "Argonaut Park"

This data as json, copyable, CSV (advanced)

These facets timed out: ACCESS_TYP

DES_TP 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
6983 6983 6982 {"type": "Polygon", "coordinates": [[[-121.23921, 38.55639], [-121.23932, 38.5566], [-121.23943, 38.55694], [-121.23949, 38.55728], [-121.23948, 38.55731], [-121.23944, 38.55734], [-121.2391, 38.55736], [-121.23686, 38.55732], [-121.23682, 38.55731], [-121.2368, 38.55729], [-121.2368, 38.5567], [-121.23679, 38.55666], [-121.23676, 38.55663], [-121.23683, 38.55659], [-121.23683, 38.55631], [-121.23921, 38.55639]]]} Open Access 1 47556 Argonaut Park 31273 2193 Cordova Recreation and Park District 307 Special District 4 Recreation/Parks District 4 http://www.crpd.com/ Special District 4 2193 Cordova Recreation and Park District 304 Special District 4 Recreation/Parks District 4 http://crpd.com/parks/argonaut-park/ Sacramento 41 6.115 Argonaut Park 0 Local Park 2 4
12904 12904 12903 {"type": "MultiPolygon", "coordinates": [[[[-117.725, 33.59028], [-117.72482, 33.59056], [-117.72451, 33.59114], [-117.72312, 33.5907], [-117.72315, 33.59061], [-117.72311, 33.59052], [-117.72305, 33.59048], [-117.72294, 33.59044], [-117.72254, 33.59042], [-117.72212, 33.5905], [-117.72003, 33.59055], [-117.71996, 33.59028], [-117.71989, 33.58994], [-117.71985, 33.58983], [-117.71975, 33.58962], [-117.72181, 33.58964], [-117.72183, 33.5896], [-117.72184, 33.58944], [-117.72182, 33.58937], [-117.72173, 33.58925], [-117.72181, 33.58916], [-117.7221, 33.58931], [-117.72246, 33.58947], [-117.72272, 33.58955], [-117.72297, 33.58968], [-117.7236, 33.58986], [-117.72478, 33.59017], [-117.72497, 33.59023], [-117.725, 33.59028]]], [[[-117.72826, 33.5939], [-117.72825, 33.594], [-117.7282, 33.59402], [-117.72822, 33.59391], [-117.72757, 33.59294], [-117.72728, 33.5925], [-117.72697, 33.59208], [-117.72658, 33.59159], [-117.72631, 33.59175], [-117.72471, 33.59121], [-117.72521, 33.59037], [-117.72528, 33.59036], [-117.72574, 33.59058], [-117.72593, 33.59069], [-117.72612, 33.59082], [-117.72644, 33.5911], [-117.72665, 33.59132], [-117.72689, 33.59163], [-117.72728, 33.59233], [-117.72766, 33.59292], [-117.72783, 33.59324], [-117.72826, 33.5939]]]]} Open Access 1 30358 Argonaut Park 15581 1004 Aliso Viejo, City of 758 City 2 City Agency 2 http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 City 2 1004 Aliso Viejo, City of 743 City 2 City Agency 2   Orange 3 16.456 Argonaut Park 0 Local Park 2 4
14274 14274 14273 {"type": "Polygon", "coordinates": [[[-121.50527, 38.51694], [-121.50526, 38.51771], [-121.50495, 38.51773], [-121.50492, 38.51813], [-121.5048, 38.51819], [-121.50397, 38.51815], [-121.50311, 38.51796], [-121.50321, 38.5176], [-121.50323, 38.51723], [-121.50436, 38.51724], [-121.50438, 38.5169], [-121.50527, 38.51694]]]} Open Access 1 44200 Argonaut Park 15582 1287 Sacramento, City of 541 City 2 City Agency 2 http://portal.cityofsacramento.org/ParksandRec City 2 1287 Sacramento, City of 534 City 2 City Agency 2   Sacramento 41 4.779 Argonaut 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]);