units_with_maps

Table actions

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

1 row where ACRES = "2255.223", DES_TP = 2 and MNG_AGENCY = 27

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Mountains Recreation and Conservation Authority · 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
16321 16321 16320 {"type": "MultiPolygon", "coordinates": [[[[-118.60322, 34.29097], [-118.60322, 34.29117], [-118.60289, 34.29117], [-118.60289, 34.29097], [-118.60322, 34.29097]]], [[[-118.62363, 34.30476], [-118.61925, 34.30478], [-118.61906, 34.30007], [-118.62344, 34.30007], [-118.62363, 34.30476]]], [[[-118.63625, 34.3355], [-118.63213, 34.33544], [-118.63227, 34.34286], [-118.6264, 34.34308], [-118.62646, 34.34651], [-118.62352, 34.34658], [-118.6233, 34.34319], [-118.62354, 34.3353], [-118.62347, 34.33179], [-118.60645, 34.332], [-118.60635, 34.32843], [-118.60631, 34.32392], [-118.60591, 34.32391], [-118.60233, 34.32393], [-118.60223, 34.32031], [-118.60626, 34.3203], [-118.60618, 34.31319], [-118.59365, 34.31321], [-118.59359, 34.30953], [-118.60192, 34.30957], [-118.60178, 34.30241], [-118.59753, 34.30234], [-118.59745, 34.2991], [-118.59818, 34.2995], [-118.59895, 34.30037], [-118.60019, 34.30079], [-118.60115, 34.30136], [-118.60115, 34.30172], [-118.60176, 34.30173], [-118.60172, 34.29885], [-118.60598, 34.29885], [-118.60594, 34.29533], [-118.59291, 34.29526], [-118.5931, 34.29467], [-118.59311, 34.29454], [-118.59299, 34.29416], [-118.59299, 34.29404], [-118.59302, 34.2938], [-118.59301, 34.29365], [-118.59294, 34.29351], [-118.59277, 34.29329], [-118.59281, 34.29327], [-118.593, 34.29325], [-118.59353, 34.2934], [-118.59398, 34.29296], [-118.59336, 34.29015], [-118.59338, 34.28933], [-118.59191, 34.28934], [-118.59196, 34.28922], [-118.5915, 34.28857], [-118.59172, 34.28814], [-118.59165, 34.28736], [-118.59203, 34.28678], [-118.59139, 34.28607], [-118.59135, 34.28578], [-118.59728, 34.28578], [-118.59729, 34.28941], [-118.6016, 34.28942], [-118.60155, 34.29301], [-118.60263, 34.29301], [-118.60265, 34.29208], [-118.60319, 34.29208], [-118.60319, 34.29301], [-118.6059, 34.293], [-118.60594, 34.28937], [-118.61018, 34.28937], [-118.6101, 34.29302], [-118.6143, 34.29304], [-118.61462, 34.30007], [-118.606, 34.30008], [-118.6061, 34.30718], [-118.61052, 34.30718], [-118.61054, 34.3107], [-118.61491, 34.31068], [-118.61492, 34.31111], [-118.61927, 34.31109], [-118.61923, 34.31361], [-118.62356, 34.31359], [-118.62372, 34.30709], [-118.62365, 34.30535], [-118.62584, 34.30535], [-118.62591, 34.3071], [-118.62808, 34.30711], [-118.62793, 34.31414], [-118.6323, 34.31415], [-118.63214, 34.32116], [-118.62777, 34.32117], [-118.62777, 34.32827], [-118.63602, 34.32832], [-118.63625, 34.3355]], [[-118.61911, 34.32477], [-118.61911, 34.3283], [-118.6234, 34.32826], [-118.62339, 34.32118], [-118.61484, 34.32129], [-118.61483, 34.32482], [-118.61911, 34.32477]], [[-118.61145, 34.31362], [-118.61114, 34.31282], [-118.61128, 34.31227], [-118.61057, 34.31214], [-118.60993, 34.31138], [-118.60903, 34.31115], [-118.60701, 34.31115], [-118.60592, 34.31207], [-118.60592, 34.31293], [-118.6062, 34.31315], [-118.60668, 34.31315], [-118.60788, 34.31248], [-118.609, 34.31303], [-118.6104, 34.31348], [-118.61051, 34.3137], [-118.61115, 34.31403], [-118.61124, 34.3142], [-118.61169, 34.31406], [-118.6115, 34.31361], [-118.61145, 34.31362]]]]} Open Access 1 5332 Michael D. Antonovich Regional Park at Joughin Ranch 7184 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.lamountains.com/parks.asp?parkid=36 Los Angeles 6 2255.223 Michael D. Antonovich RP at Joughin Ranch 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]);