units_with_maps

Table actions

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

2 rows where GAP_STS = 4, MNG_AGENCY = 675 and MNG_AG_TYP = 13

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • Water District · 2 ✖

MNG_AGENCY 1

  • Yuima Municipal Water District · 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
3798 3798 3797 {"type": "MultiPolygon", "coordinates": [[[[-116.9578, 33.32443], [-116.94941, 33.3289], [-116.94271, 33.33233], [-116.93544, 33.32958], [-116.92862, 33.32705], [-116.91095, 33.32034], [-116.90797, 33.31919], [-116.91534, 33.31418], [-116.92002, 33.31102], [-116.92765, 33.31311], [-116.92793, 33.31298], [-116.92835, 33.31273], [-116.92842, 33.31228], [-116.929, 33.31186], [-116.92931, 33.31159], [-116.92979, 33.31131], [-116.93077, 33.311], [-116.93042, 33.31167], [-116.92952, 33.31213], [-116.92917, 33.31283], [-116.92805, 33.31344], [-116.92704, 33.31409], [-116.92582, 33.31491], [-116.92483, 33.31573], [-116.92386, 33.31674], [-116.92361, 33.31727], [-116.92383, 33.31777], [-116.92675, 33.31811], [-116.93088, 33.31862], [-116.93485, 33.318], [-116.93823, 33.31644], [-116.93821, 33.31671], [-116.93823, 33.31709], [-116.9382, 33.31734], [-116.93815, 33.31744], [-116.93808, 33.31751], [-116.93778, 33.31765], [-116.93785, 33.31774], [-116.93818, 33.31759], [-116.93827, 33.31749], [-116.93832, 33.31739], [-116.93836, 33.31715], [-116.93834, 33.31671], [-116.93837, 33.31633], [-116.94031, 33.31541], [-116.94087, 33.31561], [-116.94023, 33.31693], [-116.94024, 33.31695], [-116.94325, 33.31647], [-116.94478, 33.31671], [-116.94578, 33.31681], [-116.94575, 33.31803], [-116.94491, 33.31761], [-116.94483, 33.31757], [-116.94482, 33.31758], [-116.94292, 33.32426], [-116.95073, 33.32383], [-116.9542, 33.32362], [-116.9578, 33.32443]]], [[[-116.92717, 33.31458], [-116.92717, 33.31471], [-116.927, 33.31471], [-116.927, 33.31458], [-116.92717, 33.31458]]]]} No Public Access 3 45133 YMWD Open Space 27772 2320 Yuima Municipal Water District 684 Special District 4 Water District 13 http://www.yuimamwd.com/ Special District 4 2320 Yuima Municipal Water District 675 Special District 4 Water District 13   San Diego 4 1090.211 YMWD OS 0 Local Recreation Area 3 4
6899 6899 6898 {"type": "Polygon", "coordinates": [[[-116.93928, 34.44363], [-116.93788, 34.44365], [-116.93784, 34.44316], [-116.9372, 34.44312], [-116.93715, 34.44215], [-116.93925, 34.4421], [-116.93928, 34.44363]]]} Open Access 1 5757 Pioneer Park 23739 318 San Bernardino, County of 368 County 3 County Agency 3 http://cms.sbcounty.gov/parks/Home.aspx County 3 2320 Yuima Municipal Water District 675 Special District 4 Water District 13   San Bernardino 22 7.116 Pioneer 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]);