units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, DES_TP = 3, MNG_AGENCY = 78 and SUID_NMA = 32992

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Rancho Simi Recreation and Park District · 1 ✖

DES_TP 1

  • Local Recreation Area · 1 ✖

ACCESS_TYP 1

  • Restricted 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
15657 15657 15656 {"type": "MultiPolygon", "coordinates": [[[[-118.68934, 34.28971], [-118.68908, 34.28982], [-118.68888, 34.28999], [-118.68859, 34.29019], [-118.68794, 34.2908], [-118.68765, 34.29118], [-118.68704, 34.29168], [-118.68663, 34.29223], [-118.68643, 34.29236], [-118.68622, 34.29243], [-118.68598, 34.29246], [-118.68572, 34.29244], [-118.68461, 34.29194], [-118.68445, 34.29177], [-118.68442, 34.29155], [-118.68444, 34.29087], [-118.68461, 34.29039], [-118.68517, 34.29001], [-118.68555, 34.2896], [-118.68587, 34.28962], [-118.68634, 34.28973], [-118.68707, 34.28971], [-118.6877, 34.28926], [-118.68801, 34.28909], [-118.68812, 34.28922], [-118.68824, 34.28916], [-118.68836, 34.28906], [-118.68854, 34.28918], [-118.68885, 34.28932], [-118.68902, 34.28941], [-118.68919, 34.28955], [-118.68934, 34.28971]]], [[[-118.69728, 34.29277], [-118.69727, 34.2928], [-118.69687, 34.29267], [-118.69635, 34.2933], [-118.69631, 34.29329], [-118.69622, 34.29345], [-118.69601, 34.29371], [-118.69572, 34.29411], [-118.69548, 34.29453], [-118.69541, 34.29457], [-118.69535, 34.29468], [-118.69538, 34.29474], [-118.69532, 34.29481], [-118.69529, 34.29488], [-118.69529, 34.29493], [-118.6951, 34.29552], [-118.695, 34.29571], [-118.69488, 34.29584], [-118.69485, 34.2959], [-118.69484, 34.29598], [-118.69489, 34.29612], [-118.69489, 34.29636], [-118.69498, 34.29691], [-118.69611, 34.29865], [-118.69605, 34.29868], [-118.69605, 34.29869], [-118.69619, 34.29883], [-118.69622, 34.29882], [-118.69653, 34.29931], [-118.69648, 34.29935], [-118.69593, 34.29904], [-118.69585, 34.29915], [-118.69593, 34.29942], [-118.69589, 34.29955], [-118.69583, 34.29969], [-118.69577, 34.30037], [-118.69589, 34.30039], [-118.69585, 34.30072], [-118.69372, 34.30072], [-118.69396, 34.30183], [-118.6937, 34.30188], [-118.69367, 34.3018], [-118.69341, 34.30185], [-118.69341, 34.30193], [-118.69333, 34.30194], [-118.69306, 34.30195], [-118.69279, 34.30193], [-118.69251, 34.30188], [-118.69227, 34.30182], [-118.69201, 34.30171], [-118.69179, 34.30159], [-118.69161, 34.30146], [-118.69146, 34.30134], [-118.69145, 34.30134], [-118.69122, 34.30108], [-118.69104, 34.30076], [-118.69097, 34.30058], [-118.69093, 34.3004], [-118.6909, 34.30019], [-118.69092, 34.2999], [-118.69096, 34.29971], [-118.69123, 34.29884], [-118.69127, 34.29862], [-118.69128, 34.29842], [-118.69128, 34.29821], [-118.69125, 34.29799], [-118.69118, 34.29774], [-118.69108, 34.29747], [-118.69086, 34.29709], [-118.69087, 34.29707], [-118.69059, 34.29676], [-118.68992, 34.29622], [-118.68965, 34.29594], [-118.68945, 34.29575], [-118.6892, 34.29557], [-118.68881, 34.29533], [-118.68879, 34.29529], [-118.68881, 34.29526], [-118.68884, 34.29522], [-118.68896, 34.29515], [-118.68901, 34.29508], [-118.68903, 34.29499], [-118.68901, 34.29489], [-118.68894, 34.29482], [-118.6887, 34.29466], [-118.68821, 34.29422], [-118.68846, 34.29401], [-118.68785, 34.29348], [-118.68779, 34.29348], [-118.68783, 34.29342], [-118.68793, 34.29342], [-118.68806, 34.29333], [-118.6882, 34.29285], [-118.68818, 34.29262], [-118.68797, 34.29232], [-118.68824, 34.29207], [-118.68881, 34.29163], [-118.68881, 34.29161], [-118.68877, 34.29158], [-118.6888, 34.29156], [-118.68885, 34.29159], [-118.68929, 34.29111], [-118.68955, 34.29093], [-118.68988, 34.29096], [-118.69047, 34.29096], [-118.69171, 34.29034], [-118.69208, 34.28988], [-118.69181, 34.28948], [-118.6913, 34.28931], [-118.69044, 34.28934], [-118.68973, 34.28953], [-118.68954, 34.28962], [-118.68953, 34.28969], [-118.6894, 34.28951], [-118.6892, 34.28934], [-118.68899, 34.2892], [-118.68861, 34.28903], [-118.68846, 34.28892], [-118.68834, 34.28881], [-118.6881, 34.28847], [-118.68919, 34.28793], [-118.68937, 34.28787], [-118.68927, 34.28761], [-118.68943, 34.28759], [-118.69069, 34.28758], [-118.69091, 34.28754], [-118.69114, 34.28744], [-118.69133, 34.28728], [-118.69147, 34.28708], [-118.69152, 34.28688], [-118.69152, 34.28641], [-118.69157, 34.28636], [-118.69487, 34.28636], [-118.69487, 34.28664], [-118.69497, 34.28678], [-118.69526, 34.28696], [-118.69589, 34.28727], [-118.69636, 34.28758], [-118.69697, 34.28806], [-118.69699, 34.28807], [-118.697, 34.28827], [-118.69659, 34.29067], [-118.69659, 34.29095], [-118.69661, 34.2912], [-118.69693, 34.29249], [-118.6969, 34.29264], [-118.69728, 34.29277]]]]} Restricted Access 2 824 Simi Hills Golf Course 32992 2118 Rancho Simi Recreation and Park District 80 Special District 4 Recreation/Parks District 4 http://www.rsrpd.org/ Special District 4 2118 Rancho Simi Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Ventura 8 250.429 Simi Hills GC 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]);