units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AGENCY = 301

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 2 ✖
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
7159 7159 7158 {"type": "MultiPolygon", "coordinates": [[[[-117.77221, 34.13306], [-117.77221, 34.13324], [-117.77211, 34.13356], [-117.77199, 34.13387], [-117.77147, 34.13453], [-117.77144, 34.13453], [-117.77106, 34.13558], [-117.77083, 34.13559], [-117.77075, 34.13557], [-117.77064, 34.13557], [-117.7707, 34.13539], [-117.77056, 34.13527], [-117.77048, 34.13527], [-117.77044, 34.13515], [-117.77044, 34.13508], [-117.77048, 34.13506], [-117.77053, 34.13491], [-117.77062, 34.13487], [-117.77066, 34.13483], [-117.77072, 34.13462], [-117.77075, 34.13458], [-117.77078, 34.13457], [-117.77081, 34.13449], [-117.77074, 34.1344], [-117.77074, 34.13433], [-117.77078, 34.13433], [-117.77081, 34.13424], [-117.77087, 34.13416], [-117.77087, 34.13376], [-117.77093, 34.13359], [-117.77095, 34.13359], [-117.771, 34.13348], [-117.77105, 34.13345], [-117.77107, 34.13328], [-117.77104, 34.13309], [-117.7711, 34.13311], [-117.77112, 34.13322], [-117.77112, 34.13338], [-117.7711, 34.13349], [-117.77104, 34.13363], [-117.77104, 34.13371], [-117.77099, 34.13373], [-117.771, 34.13414], [-117.77115, 34.13422], [-117.77152, 34.13381], [-117.77164, 34.13364], [-117.77173, 34.13324], [-117.77173, 34.13311], [-117.7713, 34.13309], [-117.77134, 34.13306], [-117.77221, 34.13306]]], [[[-117.77094, 34.13575], [-117.77088, 34.13603], [-117.77047, 34.13603], [-117.77055, 34.13594], [-117.77059, 34.13583], [-117.7706, 34.13579], [-117.77055, 34.13577], [-117.77057, 34.13573], [-117.77094, 34.13575]]], [[[-117.77532, 34.12952], [-117.7753, 34.12981], [-117.77523, 34.13014], [-117.7752, 34.13035], [-117.77512, 34.1306], [-117.77506, 34.13074], [-117.77496, 34.13091], [-117.77482, 34.1311], [-117.77468, 34.13124], [-117.7744, 34.13145], [-117.77412, 34.1316], [-117.77371, 34.13174], [-117.77341, 34.1318], [-117.77291, 34.13194], [-117.77277, 34.13205], [-117.77272, 34.13214], [-117.77258, 34.13247], [-117.77255, 34.13267], [-117.77249, 34.1329], [-117.77194, 34.13289], [-117.77195, 34.13261], [-117.77202, 34.1325], [-117.77206, 34.13233], [-117.77223, 34.13201], [-117.77235, 34.13184], [-117.7725, 34.13168], [-117.77294, 34.13157], [-117.77298, 34.13159], [-117.77317, 34.13155], [-117.77318, 34.13157], [-117.77341, 34.13152], [-117.77359, 34.13141], [-117.77381, 34.13135], [-117.77401, 34.13126], [-117.77404, 34.13127], [-117.77423, 34.13116], [-117.7744, 34.13103], [-117.77454, 34.13088], [-117.77466, 34.13073], [-117.77482, 34.1304], [-117.77487, 34.13007], [-117.77495, 34.12977], [-117.77497, 34.12944], [-117.77516, 34.12946], [-117.77532, 34.12952]]]]} Open Access 1 6800 Marshall Creek Open Space 21896 1162 La Verne, City of 305 City 2 City Agency 2 http://www.ci.la-verne.ca.us/index.php/residents/parks City 2 1162 La Verne, City of 301 City 2 City Agency 2   Los Angeles 6 9.299 Marshall Creek OS 0 Local Recreation Area 3 4
16050 16050 16049 {"type": "Polygon", "coordinates": [[[-117.75625, 34.14581], [-117.75608, 34.14612], [-117.75606, 34.1465], [-117.7559, 34.14671], [-117.75581, 34.14696], [-117.75576, 34.14718], [-117.75548, 34.14745], [-117.75534, 34.14782], [-117.75531, 34.14803], [-117.75533, 34.14808], [-117.7552, 34.14819], [-117.75524, 34.1484], [-117.75505, 34.14856], [-117.75487, 34.14857], [-117.75472, 34.14875], [-117.75482, 34.14892], [-117.75468, 34.1491], [-117.75476, 34.1493], [-117.75475, 34.14939], [-117.75466, 34.1496], [-117.75471, 34.14968], [-117.75464, 34.14969], [-117.75458, 34.14974], [-117.75457, 34.14983], [-117.75459, 34.14985], [-117.75438, 34.14997], [-117.75442, 34.15017], [-117.75466, 34.1503], [-117.75451, 34.15059], [-117.75447, 34.15064], [-117.75451, 34.15091], [-117.75458, 34.15112], [-117.75445, 34.15137], [-117.75433, 34.15133], [-117.75407, 34.15117], [-117.75396, 34.1511], [-117.75385, 34.15099], [-117.75392, 34.15094], [-117.75395, 34.15081], [-117.75387, 34.15066], [-117.75382, 34.1506], [-117.75382, 34.15048], [-117.75378, 34.15044], [-117.75373, 34.15045], [-117.75362, 34.15056], [-117.7536, 34.15065], [-117.75345, 34.1507], [-117.75345, 34.15073], [-117.75327, 34.1507], [-117.75307, 34.15074], [-117.75289, 34.15083], [-117.75266, 34.15101], [-117.7525, 34.15106], [-117.75235, 34.15105], [-117.75196, 34.15096], [-117.75076, 34.15095], [-117.75079, 34.15093], [-117.75273, 34.15092], [-117.75483, 34.1482], [-117.75553, 34.14714], [-117.75565, 34.14638], [-117.75574, 34.14624], [-117.75582, 34.1461], [-117.75587, 34.14597], [-117.75591, 34.14577], [-117.75625, 34.14581]]]} Open Access 1 6792 Lowell Brandt Open Space 21554 1162 La Verne, City of 305 City 2 City Agency 2 http://www.ci.la-verne.ca.us/index.php/residents/parks City 2 1162 La Verne, City of 301 City 2 City Agency 2   Los Angeles 6 8.271 Lowell Brandt 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]);