units_with_maps

Table actions

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

1 row where DES_TP = 2, MNG_AGENCY = 163 and UNIT_NAME = "Colony Park"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Bernardino, City of · 1 ✖

DES_TP 1

  • Local Park · 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
6580 6580 6579 {"type": "MultiPolygon", "coordinates": [[[[-117.28503, 34.0554], [-117.28467, 34.05546], [-117.28482, 34.05627], [-117.28427, 34.05627], [-117.28413, 34.05594], [-117.28402, 34.05594], [-117.28399, 34.05589], [-117.28393, 34.05585], [-117.28396, 34.05577], [-117.28395, 34.05553], [-117.28379, 34.05553], [-117.28377, 34.05512], [-117.28369, 34.05497], [-117.28345, 34.05497], [-117.28353, 34.05489], [-117.28356, 34.05484], [-117.28356, 34.05477], [-117.28352, 34.05473], [-117.28357, 34.05463], [-117.28353, 34.05445], [-117.28334, 34.05445], [-117.28308, 34.05455], [-117.28294, 34.05468], [-117.28292, 34.0546], [-117.28285, 34.05445], [-117.28268, 34.05419], [-117.28248, 34.05396], [-117.28233, 34.05396], [-117.2825, 34.05372], [-117.28275, 34.05388], [-117.28284, 34.05371], [-117.28295, 34.05343], [-117.28304, 34.0533], [-117.28338, 34.05349], [-117.2836, 34.05356], [-117.28389, 34.05361], [-117.28424, 34.05362], [-117.28422, 34.05426], [-117.28427, 34.05447], [-117.28458, 34.05521], [-117.28492, 34.05512], [-117.28503, 34.0554]]], [[[-117.28434, 34.05269], [-117.28402, 34.05276], [-117.2842, 34.05338], [-117.28388, 34.05337], [-117.28357, 34.05329], [-117.28344, 34.05323], [-117.28252, 34.05273], [-117.2825, 34.0527], [-117.28251, 34.05266], [-117.28267, 34.0525], [-117.28275, 34.05237], [-117.28278, 34.05227], [-117.28279, 34.05215], [-117.28276, 34.05201], [-117.28241, 34.05107], [-117.28304, 34.05093], [-117.28289, 34.05125], [-117.28301, 34.0515], [-117.28384, 34.05244], [-117.28411, 34.05229], [-117.28426, 34.05248], [-117.28434, 34.05269]]], [[[-117.28676, 34.05233], [-117.28644, 34.05233], [-117.28643, 34.05235], [-117.28612, 34.05236], [-117.28609, 34.0524], [-117.28602, 34.05239], [-117.28595, 34.0524], [-117.28592, 34.05236], [-117.2853, 34.05236], [-117.28523, 34.05234], [-117.28516, 34.05235], [-117.2851, 34.05239], [-117.28473, 34.05239], [-117.28472, 34.0524], [-117.28482, 34.05257], [-117.28447, 34.05264], [-117.28442, 34.05248], [-117.28431, 34.05232], [-117.2848, 34.05211], [-117.28485, 34.05218], [-117.28509, 34.05209], [-117.28516, 34.05215], [-117.28523, 34.05217], [-117.28532, 34.05216], [-117.28535, 34.0522], [-117.28564, 34.05219], [-117.28565, 34.05209], [-117.28594, 34.05208], [-117.28598, 34.05202], [-117.28604, 34.05203], [-117.28611, 34.05201], [-117.28616, 34.05208], [-117.28675, 34.05208], [-117.28676, 34.05233]]], [[[-117.28676, 34.05721], [-117.28651, 34.05721], [-117.28563, 34.05748], [-117.28542, 34.05761], [-117.28568, 34.05779], [-117.28565, 34.05789], [-117.28561, 34.05792], [-117.28509, 34.05791], [-117.28466, 34.05786], [-117.28472, 34.05776], [-117.28457, 34.05748], [-117.28451, 34.05747], [-117.28452, 34.05741], [-117.2845, 34.05737], [-117.28441, 34.05731], [-117.28441, 34.05714], [-117.28432, 34.05644], [-117.2849, 34.05644], [-117.2849, 34.05675], [-117.28498, 34.05698], [-117.28522, 34.05713], [-117.28676, 34.05713], [-117.28676, 34.05721]]], [[[-117.28661, 34.05513], [-117.28644, 34.05534], [-117.28607, 34.05534], [-117.28601, 34.0553], [-117.28596, 34.05528], [-117.28585, 34.0553], [-117.28545, 34.0553], [-117.28543, 34.05527], [-117.28513, 34.05527], [-117.28507, 34.05512], [-117.28548, 34.05501], [-117.28583, 34.05501], [-117.28587, 34.05494], [-117.28596, 34.05495], [-117.28605, 34.05491], [-117.28643, 34.05491], [-117.28643, 34.05496], [-117.28661, 34.05513]]]]} Open Access 1 3910 Colony Park 17538 1293 San Bernardino, City of 167 City 2 City Agency 2 http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp City 2 1293 San Bernardino, City of 163 City 2 City Agency 2   San Bernardino 22 19.109 Colony Park 0 Local Park 2 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]);