units_with_maps

Table actions

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

1 row where DES_TP = 1066 and MNG_AG_LEV = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

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
12236 12236 12235 {"type": "MultiPolygon", "coordinates": [[[[-117.15208, 33.96111], [-117.13868, 33.96101], [-117.12114, 33.96103], [-117.12139, 33.95827], [-117.12365, 33.95823], [-117.12402, 33.95508], [-117.12386, 33.95212], [-117.12521, 33.95207], [-117.12514, 33.9506], [-117.12533, 33.95058], [-117.12575, 33.95068], [-117.12624, 33.95073], [-117.12651, 33.95071], [-117.1267, 33.95066], [-117.12685, 33.95057], [-117.12694, 33.95049], [-117.12701, 33.9504], [-117.12707, 33.95027], [-117.12735, 33.95016], [-117.12751, 33.95008], [-117.12781, 33.94989], [-117.12803, 33.94981], [-117.12819, 33.9497], [-117.12832, 33.94954], [-117.12885, 33.94917], [-117.12919, 33.94902], [-117.12945, 33.94889], [-117.12967, 33.94872], [-117.12977, 33.94862], [-117.12994, 33.9484], [-117.13046, 33.94804], [-117.13031, 33.95387], [-117.13885, 33.9538], [-117.13904, 33.94658], [-117.14104, 33.94659], [-117.14104, 33.94657], [-117.14103, 33.94655], [-117.14308, 33.94655], [-117.14518, 33.94792], [-117.14426, 33.94939], [-117.14571, 33.95054], [-117.14573, 33.95053], [-117.14674, 33.94894], [-117.14706, 33.94915], [-117.14802, 33.95012], [-117.14752, 33.95344], [-117.14711, 33.95384], [-117.15091, 33.95386], [-117.15096, 33.95648], [-117.15208, 33.95648], [-117.15208, 33.96111]], [[-117.1432, 33.95743], [-117.14326, 33.95382], [-117.13886, 33.9538], [-117.13878, 33.95739], [-117.1432, 33.95743]]], [[[-117.1305, 33.94664], [-117.13047, 33.94772], [-117.13012, 33.9479], [-117.12995, 33.94802], [-117.12979, 33.94815], [-117.12972, 33.94824], [-117.12869, 33.94896], [-117.12847, 33.94907], [-117.12833, 33.94917], [-117.12809, 33.94938], [-117.12768, 33.94966], [-117.12741, 33.94968], [-117.12719, 33.94975], [-117.12707, 33.94982], [-117.12696, 33.94991], [-117.12684, 33.95008], [-117.12661, 33.95014], [-117.12514, 33.95035], [-117.12433, 33.95038], [-117.12414, 33.94668], [-117.1305, 33.94664]]], [[[-117.12668, 33.95037], [-117.1266, 33.95043], [-117.12646, 33.95047], [-117.12624, 33.95049], [-117.12599, 33.95047], [-117.12668, 33.95037]]]]} Open Access 1 25442 Riverside Clark 14801 2179 Western Riverside County Regional Conservation Authority 957 Special District 4 Open Space District 6 http://www.wrc-rca.org/ Special District 4 2179 Western Riverside County Regional Conservation Authority 927 Special District 4 Open Space District 6   Riverside 10 724.53 Riverside Clark   None 1066  

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]);