units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, AGNCY_NAME = 319 and MNG_AGENCY = 78

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP

MNG_AGENCY 1

  • Rancho Simi Recreation and Park District · 1 ✖

ACCESS_TYP 1

  • Open Access · 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
16074 16074 16073 {"type": "MultiPolygon", "coordinates": [[[[-118.7612, 34.15938], [-118.76095, 34.15967], [-118.76079, 34.15964], [-118.76019, 34.15956], [-118.76026, 34.15926], [-118.7602, 34.15894], [-118.75993, 34.15859], [-118.75947, 34.15828], [-118.7594, 34.1581], [-118.75933, 34.15771], [-118.75928, 34.15754], [-118.75913, 34.15724], [-118.7587, 34.1572], [-118.75815, 34.1572], [-118.75822, 34.15701], [-118.75818, 34.15698], [-118.75808, 34.15683], [-118.75806, 34.15666], [-118.75818, 34.15629], [-118.75888, 34.1563], [-118.75976, 34.15687], [-118.76107, 34.15873], [-118.7612, 34.15938]]], [[[-118.76954, 34.16551], [-118.76926, 34.16565], [-118.76899, 34.16554], [-118.76889, 34.16553], [-118.76868, 34.16556], [-118.76863, 34.16555], [-118.76848, 34.16557], [-118.76841, 34.16556], [-118.76817, 34.16586], [-118.76799, 34.16599], [-118.76781, 34.166], [-118.76685, 34.16618], [-118.76644, 34.16634], [-118.76606, 34.16631], [-118.76585, 34.1662], [-118.76521, 34.16592], [-118.76502, 34.16579], [-118.76443, 34.1657], [-118.76439, 34.16573], [-118.76408, 34.16558], [-118.76362, 34.16544], [-118.76321, 34.16525], [-118.76316, 34.16528], [-118.76309, 34.16546], [-118.76269, 34.16613], [-118.76236, 34.1664], [-118.76182, 34.16606], [-118.76212, 34.1658], [-118.76224, 34.16563], [-118.76245, 34.16527], [-118.76213, 34.16503], [-118.7621, 34.16502], [-118.7621, 34.16483], [-118.76209, 34.16468], [-118.76203, 34.16451], [-118.76189, 34.16429], [-118.7618, 34.16419], [-118.7613, 34.16381], [-118.76117, 34.16368], [-118.76108, 34.16358], [-118.76096, 34.16339], [-118.76085, 34.16318], [-118.7608, 34.16301], [-118.76076, 34.16283], [-118.76075, 34.16253], [-118.76082, 34.16216], [-118.76084, 34.16194], [-118.76082, 34.1617], [-118.76075, 34.16127], [-118.76061, 34.16085], [-118.76039, 34.16045], [-118.76026, 34.16029], [-118.7602, 34.16015], [-118.76017, 34.16006], [-118.76017, 34.15992], [-118.76019, 34.15978], [-118.76026, 34.15975], [-118.76079, 34.15982], [-118.76089, 34.15984], [-118.76091, 34.16037], [-118.76164, 34.16078], [-118.76173, 34.16089], [-118.76171, 34.16096], [-118.76177, 34.16102], [-118.76175, 34.16138], [-118.76183, 34.16158], [-118.7618, 34.16167], [-118.76162, 34.16197], [-118.76155, 34.16235], [-118.762, 34.16281], [-118.76257, 34.16261], [-118.76264, 34.16269], [-118.7627, 34.16271], [-118.7627, 34.16275], [-118.76321, 34.16279], [-118.76362, 34.16247], [-118.76366, 34.16279], [-118.76312, 34.16302], [-118.76311, 34.1631], [-118.76282, 34.16307], [-118.76254, 34.16309], [-118.76234, 34.16317], [-118.76219, 34.16331], [-118.76217, 34.16347], [-118.76232, 34.16356], [-118.76289, 34.1642], [-118.76304, 34.16427], [-118.76319, 34.16427], [-118.76332, 34.16425], [-118.76346, 34.16436], [-118.76389, 34.16474], [-118.76401, 34.16478], [-118.76428, 34.16508], [-118.76446, 34.16516], [-118.76463, 34.1652], [-118.76483, 34.1652], [-118.76513, 34.16517], [-118.76531, 34.16522], [-118.76542, 34.1653], [-118.7657, 34.16522], [-118.76613, 34.16548], [-118.76666, 34.16553], [-118.76692, 34.16544], [-118.76727, 34.16553], [-118.76754, 34.16553], [-118.76782, 34.16535], [-118.76801, 34.1651], [-118.76808, 34.16483], [-118.76809, 34.16455], [-118.76838, 34.16452], [-118.7687, 34.16432], [-118.7687, 34.16437], [-118.7688, 34.1644], [-118.76873, 34.16468], [-118.76869, 34.16477], [-118.76876, 34.16491], [-118.76893, 34.16506], [-118.7692, 34.16504], [-118.76954, 34.16551]]], [[[-118.76255, 34.1681], [-118.76176, 34.16809], [-118.76187, 34.16771], [-118.76174, 34.16744], [-118.7613, 34.16689], [-118.76124, 34.16679], [-118.76124, 34.16673], [-118.76128, 34.16655], [-118.76166, 34.16619], [-118.76187, 34.1663], [-118.76221, 34.16652], [-118.76196, 34.16673], [-118.76251, 34.16755], [-118.76248, 34.16781], [-118.76255, 34.1681]]]]} Open Access 1 7085 Medea Creek Open Space 32643 1000 Agoura Hills, City of 319 City 2 City Agency 2 http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities City 2 2118 Rancho Simi Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Los Angeles 6 42.16 Medea Creek OS 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]);