units_with_maps

Table actions

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

1 row where AGNCY_LEV = 2, DES_TP = 1379, MNG_AGENCY = 314 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • Walnut, City of · 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
16102 16102 16101 {"type": "MultiPolygon", "coordinates": [[[[-117.86535, 34.04871], [-117.86496, 34.04922], [-117.86467, 34.04926], [-117.86448, 34.04934], [-117.86433, 34.04938], [-117.86403, 34.04938], [-117.864, 34.0494], [-117.86401, 34.04944], [-117.86419, 34.04949], [-117.86436, 34.04951], [-117.86448, 34.0495], [-117.8646, 34.04945], [-117.86463, 34.04946], [-117.86459, 34.04953], [-117.86452, 34.04959], [-117.86439, 34.04964], [-117.86424, 34.04964], [-117.8641, 34.04961], [-117.86352, 34.04963], [-117.86346, 34.04961], [-117.8634, 34.04957], [-117.86329, 34.0493], [-117.86327, 34.04911], [-117.86328, 34.04898], [-117.86326, 34.04896], [-117.86322, 34.04896], [-117.86313, 34.04902], [-117.86294, 34.04907], [-117.86286, 34.04914], [-117.86282, 34.04921], [-117.86284, 34.04943], [-117.86289, 34.04966], [-117.86299, 34.04989], [-117.86336, 34.05045], [-117.86359, 34.05095], [-117.863, 34.0517], [-117.86156, 34.05093], [-117.8614, 34.05081], [-117.86129, 34.05069], [-117.8612, 34.05063], [-117.86113, 34.05061], [-117.861, 34.05061], [-117.86093, 34.05064], [-117.86081, 34.05072], [-117.86073, 34.05075], [-117.8606, 34.05075], [-117.86048, 34.0507], [-117.86098, 34.04984], [-117.86095, 34.04978], [-117.86025, 34.04907], [-117.86056, 34.04868], [-117.86092, 34.04846], [-117.86132, 34.04786], [-117.86131, 34.04782], [-117.86319, 34.04828], [-117.86337, 34.04863], [-117.86343, 34.04871], [-117.86431, 34.04866], [-117.86449, 34.04885], [-117.86492, 34.04883], [-117.86535, 34.04871]]], [[[-117.86443, 34.04949], [-117.8642, 34.04946], [-117.86403, 34.04941], [-117.86433, 34.04941], [-117.86453, 34.04935], [-117.86468, 34.04929], [-117.86492, 34.04926], [-117.86361, 34.05093], [-117.86347, 34.05059], [-117.86329, 34.05027], [-117.86303, 34.04988], [-117.86293, 34.04965], [-117.86287, 34.04943], [-117.86286, 34.04924], [-117.86287, 34.04918], [-117.86295, 34.0491], [-117.86314, 34.04905], [-117.86324, 34.04899], [-117.86323, 34.04914], [-117.86325, 34.04924], [-117.8633, 34.04943], [-117.86339, 34.0496], [-117.86345, 34.04964], [-117.86352, 34.04966], [-117.86409, 34.04963], [-117.86423, 34.04967], [-117.8644, 34.04967], [-117.86455, 34.0496], [-117.86462, 34.04954], [-117.86467, 34.04946], [-117.86464, 34.04942], [-117.86459, 34.04942], [-117.86443, 34.04949]]], [[[-117.86168, 34.05116], [-117.86097, 34.05087], [-117.86089, 34.05084], [-117.86103, 34.05075], [-117.86112, 34.05075], [-117.86142, 34.051], [-117.86168, 34.05116]]], [[[-117.86786, 34.04605], [-117.86758, 34.04621], [-117.86715, 34.0463], [-117.8669, 34.04642], [-117.86676, 34.04653], [-117.86667, 34.04669], [-117.86657, 34.04717], [-117.86634, 34.04747], [-117.86594, 34.04767], [-117.8659, 34.04771], [-117.86588, 34.04778], [-117.86594, 34.04797], [-117.86579, 34.04816], [-117.86542, 34.04761], [-117.86598, 34.04712], [-117.86618, 34.04665], [-117.86682, 34.0461], [-117.86786, 34.04605]]], [[[-117.86629, 34.04753], [-117.86596, 34.04794], [-117.86596, 34.04794], [-117.86592, 34.04781], [-117.86592, 34.04774], [-117.86594, 34.04771], [-117.86629, 34.04753]]], [[[-117.87163, 34.04832], [-117.86703, 34.0466], [-117.86662, 34.04712], [-117.86669, 34.04672], [-117.86674, 34.0466], [-117.86688, 34.04647], [-117.86716, 34.04633], [-117.86759, 34.04624], [-117.86786, 34.04608], [-117.86796, 34.04605], [-117.86808, 34.04605], [-117.86824, 34.04596], [-117.86855, 34.04589], [-117.86877, 34.04589], [-117.8694, 34.04611], [-117.86959, 34.04612], [-117.86975, 34.04608], [-117.86988, 34.04601], [-117.87008, 34.04583], [-117.87077, 34.04509], [-117.87163, 34.04832]]], [[[-117.87077, 34.04505], [-117.87006, 34.04581], [-117.86984, 34.046], [-117.86971, 34.04607], [-117.86958, 34.0461], [-117.86941, 34.04609], [-117.86873, 34.04586], [-117.86855, 34.04586], [-117.86832, 34.04591], [-117.86877, 34.04566], [-117.86982, 34.04577], [-117.87077, 34.04505]]]]} Open Access 1 12739 Walnut City Open Space Lands 27223 1370 Walnut, City of 317 City 2 City Agency 2 http://www.ci.walnut.ca.us/general.asp?id=135 City 2 1370 Walnut, City of 314 City 2 City Agency 2   Los Angeles 6 46.985 Walnut City OS Lands   None 1379  

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