units_with_maps

Table actions

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

1 row where AGNCY_TYP = 1, LABEL_NAME = "Prado RP" and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

These facets timed out: ACCESS_TYP, MNG_AGENCY

MNG_AG_TYP 1

  • County Agency · 1 ✖

DES_TP 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
16340 16340 16339 {"type": "MultiPolygon", "coordinates": [[[[-117.6664, 33.93913], [-117.66482, 33.93912], [-117.66308, 33.93745], [-117.66057, 33.93495], [-117.65676, 33.93497], [-117.65664, 33.93484], [-117.6577, 33.93194], [-117.66023, 33.93195], [-117.66035, 33.93204], [-117.6604, 33.9323], [-117.66086, 33.93285], [-117.66136, 33.9333], [-117.66165, 33.9335], [-117.66216, 33.9341], [-117.66247, 33.93525], [-117.66309, 33.93548], [-117.66308, 33.93716], [-117.66469, 33.93718], [-117.66521, 33.93789], [-117.6654, 33.93813], [-117.6664, 33.93913]]], [[[-117.67181, 33.94502], [-117.6718, 33.94627], [-117.66839, 33.94626], [-117.66809, 33.9459], [-117.66689, 33.94268], [-117.6699, 33.9427], [-117.6701, 33.94292], [-117.67034, 33.94332], [-117.67067, 33.94358], [-117.67105, 33.94403], [-117.67129, 33.94439], [-117.67164, 33.94476], [-117.67181, 33.94502]]], [[[-117.65508, 33.93913], [-117.6565, 33.93524], [-117.65671, 33.93511], [-117.6605, 33.93509], [-117.66307, 33.9377], [-117.66454, 33.93911], [-117.66306, 33.93911], [-117.66304, 33.94185], [-117.66612, 33.94145], [-117.66618, 33.94161], [-117.66629, 33.94159], [-117.66731, 33.9444], [-117.66789, 33.94593], [-117.66815, 33.94626], [-117.66817, 33.94626], [-117.66969, 33.94802], [-117.66298, 33.94983], [-117.66297, 33.94656], [-117.66296, 33.94655], [-117.66278, 33.94988], [-117.65744, 33.95133], [-117.65748, 33.94787], [-117.65784, 33.94786], [-117.65805, 33.94622], [-117.65484, 33.9462], [-117.65476, 33.94966], [-117.65125, 33.94963], [-117.65135, 33.94931], [-117.65256, 33.9462], [-117.65255, 33.94619], [-117.6525, 33.94619], [-117.65492, 33.93955], [-117.65506, 33.93917], [-117.65508, 33.93913]]], [[[-117.66683, 33.95388], [-117.66257, 33.9539], [-117.66256, 33.95392], [-117.6582, 33.95395], [-117.65817, 33.9513], [-117.66189, 33.9503], [-117.66251, 33.95029], [-117.66252, 33.95027], [-117.66449, 33.95027], [-117.66682, 33.95291], [-117.66683, 33.95388]]], [[[-117.65679, 33.93193], [-117.65572, 33.93485], [-117.65552, 33.93498], [-117.65555, 33.93512], [-117.65566, 33.93525], [-117.65168, 33.94617], [-117.65173, 33.94618], [-117.6506, 33.94911], [-117.65067, 33.94914], [-117.65051, 33.94963], [-117.64604, 33.94961], [-117.64604, 33.9513], [-117.64559, 33.95145], [-117.6435, 33.95068], [-117.64283, 33.95091], [-117.64222, 33.95125], [-117.64114, 33.95147], [-117.64077, 33.9521], [-117.64039, 33.95259], [-117.63979, 33.95316], [-117.63913, 33.95348], [-117.63889, 33.95415], [-117.6385, 33.95449], [-117.63798, 33.95399], [-117.63766, 33.95352], [-117.63758, 33.95322], [-117.63777, 33.95293], [-117.63801, 33.95268], [-117.6383, 33.95213], [-117.63866, 33.95181], [-117.63951, 33.95063], [-117.63974, 33.94992], [-117.63992, 33.94958], [-117.64063, 33.94878], [-117.64073, 33.9482], [-117.64103, 33.94736], [-117.64145, 33.94713], [-117.64176, 33.94705], [-117.64201, 33.94684], [-117.64228, 33.94647], [-117.64231, 33.94569], [-117.64196, 33.9452], [-117.64161, 33.94489], [-117.64129, 33.94479], [-117.64377, 33.94336], [-117.64599, 33.94346], [-117.64599, 33.94021], [-117.63971, 33.94], [-117.63971, 33.93961], [-117.63331, 33.93958], [-117.63346, 33.93118], [-117.6288, 33.93123], [-117.62881, 33.93135], [-117.6333, 33.93132], [-117.63323, 33.93536], [-117.62098, 33.93536], [-117.62167, 33.93416], [-117.62208, 33.93371], [-117.62262, 33.93338], [-117.62293, 33.93327], [-117.62418, 33.93238], [-117.62463, 33.93132], [-117.62461, 33.93099], [-117.62434, 33.9307], [-117.62401, 33.93047], [-117.62325, 33.9302], [-117.62253, 33.92987], [-117.62228, 33.92966], [-117.62527, 33.92659], [-117.63215, 33.92645], [-117.63212, 33.9245], [-117.65515, 33.92486], [-117.65531, 33.92521], [-117.65519, 33.93015], [-117.65517, 33.93191], [-117.65679, 33.93193]]], [[[-117.67131, 33.9593], [-117.66704, 33.95933], [-117.66699, 33.95388], [-117.66767, 33.95388], [-117.6713, 33.958], [-117.67131, 33.9593]]], [[[-117.67941, 33.96241], [-117.67861, 33.96236], [-117.67863, 33.96284], [-117.6784, 33.96334], [-117.67836, 33.96367], [-117.67802, 33.96419], [-117.67797, 33.96433], [-117.67746, 33.96463], [-117.6771, 33.96421], [-117.67701, 33.96404], [-117.67727, 33.96348], [-117.6771, 33.96252], [-117.6768, 33.96222], [-117.67631, 33.96189], [-117.67616, 33.96142], [-117.67561, 33.96106], [-117.67544, 33.9611], [-117.67517, 33.96132], [-117.67466, 33.96083], [-117.67411, 33.96075], [-117.67412, 33.96046], [-117.67392, 33.96015], [-117.67333, 33.96003], [-117.66421, 33.94967], [-117.66985, 33.94815], [-117.67702, 33.95364], [-117.67327, 33.95592], [-117.67354, 33.95699], [-117.67429, 33.95766], [-117.6739, 33.95841], [-117.67438, 33.95864], [-117.67462, 33.95873], [-117.67481, 33.95998], [-117.67531, 33.9602], [-117.67571, 33.96078], [-117.67644, 33.96096], [-117.67698, 33.96152], [-117.67797, 33.96158], [-117.67941, 33.96241]]]]} Open Access 1 8883 Prado Regional Park 13583 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 318 San Bernardino, County of 363 County 3 County Agency 3 http://cms.sbcounty.gov/parks/Parks/PradoRegionalPark.aspx San Bernardino 22 2110.592 Prado RP 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]);