units_with_maps

Table actions

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

5 rows where AGNCY_TYP = 2, DES_TP = 3 and MNG_AGENCY = 283

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Rancho Palos Verdes, City of · 5 ✖

DES_TP 1

  • Local Recreation Area · 5 ✖

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
6978 6978 6977 {"type": "MultiPolygon", "coordinates": [[[[-118.35169, 33.74196], [-118.35158, 33.7421], [-118.35041, 33.74148], [-118.35002, 33.74125], [-118.34981, 33.7411], [-118.34954, 33.74088], [-118.34923, 33.74059], [-118.34901, 33.74034], [-118.34871, 33.73993], [-118.34834, 33.73929], [-118.3485, 33.73922], [-118.34851, 33.73921], [-118.34751, 33.7375], [-118.34744, 33.73735], [-118.34737, 33.73716], [-118.34735, 33.73702], [-118.34734, 33.73679], [-118.34738, 33.73657], [-118.34747, 33.73636], [-118.34765, 33.73603], [-118.34784, 33.73609], [-118.34773, 33.73626], [-118.34795, 33.73638], [-118.34797, 33.73646], [-118.34804, 33.73653], [-118.34809, 33.73656], [-118.34834, 33.73666], [-118.34913, 33.73711], [-118.34899, 33.73721], [-118.34911, 33.73758], [-118.35052, 33.73841], [-118.34852, 33.73921], [-118.3488, 33.73971], [-118.34898, 33.73999], [-118.34917, 33.74025], [-118.34933, 33.74043], [-118.34961, 33.7407], [-118.35, 33.74101], [-118.35035, 33.74124], [-118.35061, 33.74139], [-118.35169, 33.74196]]], [[[-118.35293, 33.74028], [-118.35284, 33.74042], [-118.35277, 33.74039], [-118.35271, 33.74039], [-118.35266, 33.74042], [-118.35158, 33.74177], [-118.35157, 33.74182], [-118.35159, 33.74184], [-118.35146, 33.74177], [-118.35259, 33.74037], [-118.35263, 33.74031], [-118.35262, 33.74021], [-118.35276, 33.7402], [-118.35293, 33.74028]]]]} Open Access 1 5902 Ladera Linda Park and Community Center 20821 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 13.508 Ladera Linda Park and Community Ctr. 0 Local Recreation Area 3 4
11434 11434 11433 {"type": "Polygon", "coordinates": [[[-118.39308, 33.73871], [-118.39302, 33.73914], [-118.39258, 33.73958], [-118.39228, 33.73979], [-118.39188, 33.73985], [-118.39193, 33.73996], [-118.3917, 33.73999], [-118.39149, 33.73999], [-118.39149, 33.73989], [-118.39062, 33.73999], [-118.38998, 33.73991], [-118.38985, 33.74094], [-118.38954, 33.74094], [-118.38946, 33.74095], [-118.38934, 33.74004], [-118.38932, 33.73996], [-118.38926, 33.73953], [-118.38949, 33.73948], [-118.38986, 33.73951], [-118.3903, 33.73963], [-118.39117, 33.73967], [-118.39154, 33.73965], [-118.39187, 33.73959], [-118.39228, 33.7394], [-118.39286, 33.73897], [-118.39287, 33.73854], [-118.39308, 33.73871]]]} Open Access 1 48124 Vanderlip Park Trail 32633 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 4.827 Vanderlip Park Trail 0 Local Recreation Area 3 4
16779 16779 16778 {"type": "MultiPolygon", "coordinates": [[[[-118.32475, 33.74883], [-118.32465, 33.7489], [-118.32454, 33.74882], [-118.32438, 33.74875], [-118.32449, 33.74865], [-118.32454, 33.74862], [-118.32462, 33.74873], [-118.32475, 33.74883]]], [[[-118.32527, 33.75293], [-118.32507, 33.7532], [-118.32498, 33.75321], [-118.32519, 33.75293], [-118.32518, 33.7529], [-118.32492, 33.75276], [-118.32495, 33.7527], [-118.32524, 33.75286], [-118.32527, 33.75293]]]]} Open Access 1 5904 Miraleste Recreation and Parks District 29420 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 0.225 Miraleste Rec. and Parks District 0 Local Recreation Area 3 4
16938 16938 16937 {"type": "Polygon", "coordinates": [[[-118.40727, 33.74693], [-118.40415, 33.74728], [-118.40425, 33.74668], [-118.40424, 33.74646], [-118.40419, 33.74619], [-118.40407, 33.74593], [-118.40391, 33.74569], [-118.40382, 33.74559], [-118.40355, 33.74538], [-118.40333, 33.74525], [-118.40309, 33.74516], [-118.40271, 33.74509], [-118.40243, 33.74507], [-118.40188, 33.74509], [-118.40135, 33.74514], [-118.40094, 33.74521], [-118.40069, 33.74423], [-118.4007, 33.74281], [-118.4021, 33.74179], [-118.40213, 33.74179], [-118.40216, 33.74179], [-118.40217, 33.74181], [-118.40247, 33.7419], [-118.40249, 33.7418], [-118.40405, 33.74228], [-118.40445, 33.74237], [-118.40486, 33.74244], [-118.40537, 33.74248], [-118.40658, 33.74247], [-118.40686, 33.74249], [-118.40719, 33.74254], [-118.40784, 33.74271], [-118.40829, 33.74291], [-118.40851, 33.74307], [-118.40876, 33.74331], [-118.40896, 33.74359], [-118.40903, 33.74374], [-118.40909, 33.74393], [-118.40913, 33.74413], [-118.40913, 33.74443], [-118.40908, 33.74469], [-118.40901, 33.74488], [-118.40882, 33.7452], [-118.40754, 33.74656], [-118.40727, 33.74693]], [[-118.40698, 33.74517], [-118.40711, 33.7453], [-118.40842, 33.74444], [-118.40821, 33.74415], [-118.40751, 33.74409], [-118.4064, 33.7442], [-118.4062, 33.74433], [-118.40644, 33.7446], [-118.40645, 33.74521], [-118.40675, 33.74523], [-118.40689, 33.74518], [-118.40693, 33.74513], [-118.40698, 33.74517]]]} Open Access 1 5899 Point Vicente Park and Civic Center 23868 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 72.776 Point Vicente Park and Civic Ctr. 0 Local Recreation Area 3 4
17048 17048 17047 {"type": "Polygon", "coordinates": [[[-118.41338, 33.74626], [-118.41322, 33.74627], [-118.40776, 33.74687], [-118.40791, 33.7467], [-118.40907, 33.74548], [-118.40922, 33.74528], [-118.40941, 33.74493], [-118.40945, 33.74479], [-118.40949, 33.74479], [-118.41043, 33.74285], [-118.411, 33.74311], [-118.41123, 33.74353], [-118.41138, 33.74367], [-118.41169, 33.74396], [-118.41217, 33.74425], [-118.41234, 33.74446], [-118.41232, 33.74459], [-118.41269, 33.74525], [-118.41338, 33.74626]]]} Open Access 1 46085 Point Vicente Interpretive Center 29431 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 26.518 Point Vicente Interpretive Ctr. 0 Local Recreation Area 3 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]);