superunits_with_maps

Table actions

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

4 rows where ACCESS_TYP = 1 and LABEL_NAME = "Cabrillo Park"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open Access · 4 ✖
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
2460 2460 2459 {"type": "Polygon", "coordinates": [[[-122.02467, 37.55165], [-122.02422, 37.55191], [-122.02376, 37.5527], [-122.02171, 37.55163], [-122.02252, 37.55065], [-122.02256, 37.55064], [-122.02311, 37.55076], [-122.02333, 37.55084], [-122.02448, 37.55144], [-122.0246, 37.55153], [-122.02467, 37.55165]]]} Open Access 1 Cabrillo Park   16639 1113 Fremont, City of 376 City 2 City Agency 2 http://www.fremont.gov/316/Parks City 2 7.699 Cabrillo Park  
2461 2461 2460 {"type": "Polygon", "coordinates": [[[-119.20662, 34.21599], [-119.20634, 34.21712], [-119.2049, 34.21705], [-119.20492, 34.21565], [-119.20662, 34.21599]]]} Open Access 1 Cabrillo Park   16640 1237 Oxnard, City of 93 City 2 City Agency 2 https://www.oxnard.org/ City 2 5.093 Cabrillo Park  
2462 2462 2461 {"type": "MultiPolygon", "coordinates": [[[[-117.84058, 33.75267], [-117.84054, 33.75272], [-117.84047, 33.75273], [-117.84044, 33.75252], [-117.83967, 33.75251], [-117.83965, 33.75274], [-117.83956, 33.75274], [-117.83954, 33.75244], [-117.83902, 33.75243], [-117.839, 33.75072], [-117.84046, 33.75072], [-117.84048, 33.75096], [-117.84057, 33.75136], [-117.84058, 33.75267]]], [[[-117.84153, 33.75268], [-117.84151, 33.75272], [-117.84148, 33.75273], [-117.84092, 33.75273], [-117.84088, 33.75271], [-117.84086, 33.75268], [-117.84086, 33.75198], [-117.8411, 33.75196], [-117.84109, 33.75139], [-117.84084, 33.75137], [-117.84081, 33.75115], [-117.84077, 33.751], [-117.84074, 33.75073], [-117.8415, 33.75072], [-117.84153, 33.75268]]]]} Open Access 1 Cabrillo Park   16641 1316 Santa Ana, City of 19 City 2 City Agency 2 http://www.santa-ana.org/parks/ City 2 10.108 Cabrillo Park  
2463 2463 2462 {"type": "Polygon", "coordinates": [[[-117.67801, 34.10508], [-117.67693, 34.10509], [-117.67693, 34.10582], [-117.67475, 34.10583], [-117.67474, 34.10511], [-117.6744, 34.1051], [-117.67439, 34.10337], [-117.67801, 34.10336], [-117.67801, 34.10508]]]} Open Access 1 Cabrillo Park   16642 1363 Upland, City of 141 City 2 City Agency 2 http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp City 2 19.827 Cabrillo 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]);