units_with_maps

Table actions

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

2 rows where GAP_STS = 2, MNG_AGENCY = 283 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 2 ✖

MNG_AGENCY 1

  • Rancho Palos Verdes, City of · 2 ✖

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
5417 5417 5416 {"type": "MultiPolygon", "coordinates": [[[[-118.33709, 33.72929], [-118.33709, 33.72933], [-118.33706, 33.72937], [-118.33698, 33.72937], [-118.33552, 33.72825], [-118.3353, 33.72811], [-118.33513, 33.72803], [-118.33489, 33.72795], [-118.33464, 33.72791], [-118.33423, 33.7279], [-118.33366, 33.72795], [-118.33299, 33.72807], [-118.33169, 33.72838], [-118.33133, 33.72849], [-118.33104, 33.72862], [-118.33071, 33.7288], [-118.33002, 33.7293], [-118.32984, 33.72941], [-118.32954, 33.72956], [-118.32891, 33.72984], [-118.32877, 33.72993], [-118.32871, 33.73001], [-118.32865, 33.73012], [-118.32864, 33.73018], [-118.32864, 33.73031], [-118.32871, 33.73046], [-118.32883, 33.73057], [-118.32894, 33.73063], [-118.32906, 33.73067], [-118.32925, 33.73068], [-118.32948, 33.73062], [-118.32968, 33.73055], [-118.32989, 33.73045], [-118.33007, 33.73034], [-118.33021, 33.73024], [-118.33042, 33.73005], [-118.33078, 33.72967], [-118.3309, 33.7296], [-118.33097, 33.72958], [-118.33107, 33.72958], [-118.33117, 33.7296], [-118.33123, 33.72964], [-118.33129, 33.72969], [-118.33133, 33.72977], [-118.33134, 33.72983], [-118.33134, 33.72991], [-118.3313, 33.72997], [-118.33111, 33.73018], [-118.33078, 33.73045], [-118.33054, 33.73061], [-118.33037, 33.7307], [-118.33, 33.73085], [-118.32929, 33.73105], [-118.32912, 33.73113], [-118.32903, 33.73122], [-118.32897, 33.73131], [-118.32895, 33.73139], [-118.32895, 33.73152], [-118.32899, 33.73161], [-118.32905, 33.73169], [-118.32915, 33.73178], [-118.32924, 33.73182], [-118.32938, 33.73186], [-118.32949, 33.73186], [-118.3297, 33.73181], [-118.33016, 33.73163], [-118.33046, 33.73149], [-118.33075, 33.73134], [-118.332, 33.73048], [-118.33212, 33.73043], [-118.33223, 33.73041], [-118.33237, 33.73041], [-118.33254, 33.73045], [-118.33287, 33.73205], [-118.33275, 33.73251], [-118.33232, 33.73322], [-118.33158, 33.73388], [-118.33155, 33.73394], [-118.33154, 33.73402], [-118.33154, 33.73408], [-118.33158, 33.73417], [-118.3308, 33.73338], [-118.32799, 33.73359], [-118.32843, 33.73171], [-118.32806, 33.73014], [-118.32959, 33.72756], [-118.33151, 33.72773], [-118.33174, 33.72774], [-118.33198, 33.72774], [-118.33239, 33.72769], [-118.33318, 33.72752], [-118.33362, 33.72747], [-118.33413, 33.72746], [-118.33466, 33.72753], [-118.33494, 33.7276], [-118.33529, 33.72772], [-118.33569, 33.7279], [-118.33603, 33.72813], [-118.33628, 33.72833], [-118.33648, 33.72854], [-118.33709, 33.72929]]], [[[-118.33738, 33.72985], [-118.33655, 33.73116], [-118.33584, 33.73219], [-118.33514, 33.73201], [-118.33474, 33.73216], [-118.33472, 33.73204], [-118.33469, 33.73193], [-118.33457, 33.73168], [-118.3344, 33.73148], [-118.334, 33.73114], [-118.33361, 33.73085], [-118.33324, 33.73063], [-118.33278, 33.7304], [-118.33256, 33.73031], [-118.33238, 33.73027], [-118.3322, 33.73028], [-118.33209, 33.7303], [-118.33191, 33.73036], [-118.33072, 33.73119], [-118.33045, 33.73134], [-118.32995, 33.73157], [-118.3295, 33.73172], [-118.32932, 33.7317], [-118.32925, 33.73167], [-118.32918, 33.73162], [-118.32913, 33.73153], [-118.32911, 33.73141], [-118.32915, 33.73132], [-118.32923, 33.73123], [-118.32931, 33.73119], [-118.32996, 33.73101], [-118.3303, 33.73088], [-118.33054, 33.73077], [-118.33089, 33.73056], [-118.3312, 33.73031], [-118.33134, 33.73017], [-118.33143, 33.73005], [-118.33149, 33.72996], [-118.33151, 33.72987], [-118.33149, 33.72975], [-118.33144, 33.72963], [-118.33135, 33.72954], [-118.33118, 33.72946], [-118.33109, 33.72944], [-118.33095, 33.72944], [-118.33083, 33.72947], [-118.33072, 33.72953], [-118.33024, 33.73002], [-118.33005, 33.73018], [-118.3298, 33.73034], [-118.32955, 33.73045], [-118.32922, 33.73054], [-118.32905, 33.73053], [-118.32895, 33.73048], [-118.32888, 33.73043], [-118.32883, 33.73035], [-118.32881, 33.73029], [-118.3288, 33.73018], [-118.32882, 33.73011], [-118.32888, 33.73003], [-118.32894, 33.72998], [-118.32972, 33.72963], [-118.32998, 33.7295], [-118.33088, 33.72888], [-118.3311, 33.72875], [-118.3313, 33.72865], [-118.33172, 33.72851], [-118.33304, 33.7282], [-118.3338, 33.72808], [-118.33435, 33.72803], [-118.33462, 33.72804], [-118.33481, 33.72807], [-118.33514, 33.72819], [-118.33534, 33.72829], [-118.33738, 33.72985]]]]} Open Access 1 5903 San Ramon Reserve 29399 1265 Rancho Palos Verdes, City of 265 City 2 City Agency 2 http://palosverdes.com/rpv/recreationparks/index.cfm City 2 1265 Rancho Palos Verdes, City of 283 City 2 City Agency 2   Los Angeles 6 94.383 San Ramon Reserve 0 Local Conservation Area 4 2
6976 6976 6975 {"type": "MultiPolygon", "coordinates": [[[[-118.41035, 33.74841], [-118.41035, 33.74845], [-118.41031, 33.74848], [-118.41029, 33.74855], [-118.41027, 33.74856], [-118.40994, 33.74855], [-118.40953, 33.74861], [-118.40882, 33.74886], [-118.40843, 33.74895], [-118.40794, 33.74912], [-118.40788, 33.74912], [-118.40786, 33.7491], [-118.40756, 33.74851], [-118.40749, 33.74832], [-118.40745, 33.74807], [-118.40745, 33.74766], [-118.40749, 33.74745], [-118.40758, 33.74719], [-118.40776, 33.74687], [-118.4079, 33.74686], [-118.40764, 33.74749], [-118.40761, 33.74783], [-118.40812, 33.74824], [-118.41011, 33.74801], [-118.41023, 33.74822], [-118.41032, 33.74833], [-118.41035, 33.74841]]], [[[-118.40858, 33.74902], [-118.4084, 33.74911], [-118.40801, 33.74925], [-118.40797, 33.74924], [-118.40799, 33.74921], [-118.40838, 33.74907], [-118.40857, 33.74901], [-118.40858, 33.74902]]], [[[-118.41324, 33.75711], [-118.41322, 33.75713], [-118.41298, 33.75716], [-118.41288, 33.75719], [-118.41274, 33.75725], [-118.41263, 33.75733], [-118.41255, 33.75733], [-118.41238, 33.75714], [-118.41202, 33.75671], [-118.41159, 33.75613], [-118.41113, 33.75537], [-118.40921, 33.75168], [-118.4092, 33.75161], [-118.40905, 33.75131], [-118.40898, 33.75124], [-118.4084, 33.75014], [-118.40802, 33.74941], [-118.40802, 33.74937], [-118.40805, 33.74934], [-118.40833, 33.74924], [-118.40862, 33.74912], [-118.40844, 33.74925], [-118.40914, 33.75013], [-118.41029, 33.7497], [-118.41046, 33.74938], [-118.41062, 33.74946], [-118.4107, 33.74952], [-118.4108, 33.74964], [-118.41087, 33.74979], [-118.41117, 33.75084], [-118.41122, 33.75141], [-118.41053, 33.75145], [-118.41058, 33.75232], [-118.41041, 33.75244], [-118.40988, 33.75265], [-118.41011, 33.7531], [-118.41018, 33.75312], [-118.41017, 33.75317], [-118.41019, 33.75323], [-118.41027, 33.75336], [-118.41044, 33.75375], [-118.41147, 33.7557], [-118.41152, 33.75578], [-118.41163, 33.7559], [-118.41179, 33.756], [-118.41233, 33.75623], [-118.41247, 33.75631], [-118.41262, 33.75644], [-118.41294, 33.75677], [-118.41318, 33.75695], [-118.41318, 33.757], [-118.41324, 33.75707], [-118.41324, 33.75711]]], [[[-118.41305, 33.75724], [-118.41285, 33.75733], [-118.41271, 33.75742], [-118.41267, 33.75741], [-118.41268, 33.75738], [-118.41286, 33.75728], [-118.41297, 33.75724], [-118.41305, 33.75724]]], [[[-118.41645, 33.75493], [-118.41613, 33.75541], [-118.41623, 33.75546], [-118.41622, 33.75549], [-118.41297, 33.75776], [-118.41275, 33.75755], [-118.41276, 33.75748], [-118.41287, 33.75741], [-118.41305, 33.75733], [-118.41323, 33.75728], [-118.41344, 33.75717], [-118.41456, 33.75639], [-118.41466, 33.7563], [-118.41479, 33.75615], [-118.41489, 33.75595], [-118.41494, 33.75578], [-118.41495, 33.75553], [-118.4149, 33.75533], [-118.41479, 33.75511], [-118.41468, 33.75498], [-118.41452, 33.75484], [-118.41428, 33.7547], [-118.4134, 33.75445], [-118.41311, 33.75432], [-118.41294, 33.75421], [-118.41279, 33.75409], [-118.41259, 33.75387], [-118.41241, 33.75352], [-118.41236, 33.75327], [-118.41235, 33.75308], [-118.41242, 33.75144], [-118.41242, 33.75116], [-118.41238, 33.7509], [-118.41231, 33.75062], [-118.41224, 33.75042], [-118.41203, 33.75002], [-118.41145, 33.74918], [-118.41129, 33.74902], [-118.41107, 33.74885], [-118.41077, 33.74869], [-118.41061, 33.74864], [-118.4106, 33.74861], [-118.4106, 33.74851], [-118.41054, 33.74843], [-118.41054, 33.74839], [-118.41049, 33.74828], [-118.41035, 33.74811], [-118.41035, 33.74808], [-118.41038, 33.74805], [-118.41096, 33.74791], [-118.41124, 33.74777], [-118.41144, 33.74759], [-118.41185, 33.74715], [-118.41188, 33.74711], [-118.41188, 33.74704], [-118.41185, 33.747], [-118.41192, 33.74694], [-118.41179, 33.74643], [-118.41338, 33.74626], [-118.41373, 33.74675], [-118.41379, 33.74716], [-118.41312, 33.74896], [-118.41313, 33.74952], [-118.41321, 33.74985], [-118.41337, 33.75009], [-118.41422, 33.75105], [-118.41458, 33.75135], [-118.41488, 33.7515], [-118.41507, 33.75131], [-118.41523, 33.75146], [-118.41489, 33.75164], [-118.41493, 33.75182], [-118.41475, 33.75184], [-118.41472, 33.75172], [-118.4147, 33.75171], [-118.41436, 33.75189], [-118.41393, 33.75227], [-118.4135, 33.75277], [-118.41353, 33.75323], [-118.41385, 33.75371], [-118.41439, 33.754], [-118.4148, 33.75407], [-118.41507, 33.75392], [-118.41512, 33.75367], [-118.41533, 33.75401], [-118.41561, 33.75394], [-118.4159, 33.75396], [-118.41611, 33.75426], [-118.41627, 33.75425], [-118.41616, 33.75479], [-118.41645, 33.75493]]]]} Open Access 1 5898 Vicente Bluffs Reserve 29401 1265 Rancho Palos Verdes, City of 265 City 2 City Agency 2 http://palosverdes.com/rpv/recreationparks/index.cfm City 2 1265 Rancho Palos Verdes, City of 283 City 2 City Agency 2   Los Angeles 6 70.035 Vicente Bluffs Reserve 0 Local Conservation Area 4 2

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