units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1 and LABEL_NAME = "Abalone Cove Shoreline Park"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

ACCESS_TYP 1

  • Open Access · 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
6965 6965 6964 {"type": "Polygon", "coordinates": [[[-118.38377, 33.74401], [-118.38366, 33.74409], [-118.3835, 33.74426], [-118.3834, 33.74443], [-118.38334, 33.7446], [-118.3833, 33.74463], [-118.38324, 33.74463], [-118.38251, 33.7444], [-118.37928, 33.74319], [-118.37858, 33.74294], [-118.37828, 33.74288], [-118.37797, 33.74285], [-118.37712, 33.74285], [-118.37695, 33.74283], [-118.37658, 33.74276], [-118.37633, 33.74268], [-118.3761, 33.74258], [-118.37428, 33.74166], [-118.37409, 33.74153], [-118.37449, 33.74144], [-118.37474, 33.74131], [-118.37495, 33.74111], [-118.37536, 33.74104], [-118.37533, 33.7409], [-118.37528, 33.74087], [-118.37526, 33.74091], [-118.3752, 33.74094], [-118.3751, 33.74093], [-118.37492, 33.74081], [-118.37475, 33.74072], [-118.37464, 33.74071], [-118.37456, 33.74076], [-118.37453, 33.74082], [-118.37453, 33.74102], [-118.37447, 33.74111], [-118.3742, 33.74101], [-118.37411, 33.74094], [-118.37392, 33.74063], [-118.3739, 33.74052], [-118.37392, 33.74039], [-118.3739, 33.74035], [-118.37378, 33.74035], [-118.37343, 33.74055], [-118.37317, 33.74027], [-118.37291, 33.74006], [-118.37262, 33.73987], [-118.37235, 33.73974], [-118.37207, 33.73963], [-118.37182, 33.73956], [-118.37155, 33.7395], [-118.37156, 33.73948], [-118.37151, 33.73946], [-118.37121, 33.7394], [-118.37073, 33.73936], [-118.37024, 33.73937], [-118.36993, 33.73941], [-118.36963, 33.73948], [-118.36924, 33.73961], [-118.36902, 33.73971], [-118.36872, 33.73989], [-118.3689, 33.73931], [-118.36868, 33.73908], [-118.36863, 33.73839], [-118.36869, 33.73753], [-118.36885, 33.7361], [-118.36885, 33.73633], [-118.36893, 33.73611], [-118.36965, 33.73615], [-118.36948, 33.73631], [-118.36949, 33.73632], [-118.36991, 33.73612], [-118.36997, 33.73637], [-118.36973, 33.73687], [-118.36989, 33.73695], [-118.36967, 33.73698], [-118.36968, 33.73791], [-118.37035, 33.73841], [-118.37076, 33.73858], [-118.3716, 33.7386], [-118.37177, 33.73868], [-118.37251, 33.73854], [-118.37288, 33.73836], [-118.37312, 33.73783], [-118.37366, 33.73737], [-118.37336, 33.73691], [-118.37356, 33.7366], [-118.37423, 33.73684], [-118.37407, 33.73705], [-118.37407, 33.73707], [-118.37461, 33.73683], [-118.37524, 33.73706], [-118.37536, 33.73783], [-118.3751, 33.7381], [-118.37496, 33.73871], [-118.37518, 33.73935], [-118.37541, 33.73961], [-118.3758, 33.73995], [-118.37656, 33.74047], [-118.37683, 33.7406], [-118.37719, 33.74067], [-118.37847, 33.74133], [-118.38012, 33.74196], [-118.38062, 33.7421], [-118.3814, 33.74223], [-118.38195, 33.74227], [-118.38281, 33.74211], [-118.38301, 33.7429], [-118.38305, 33.74333], [-118.38377, 33.74401]]]} Open Access 1 5869 Abalone Cove Shoreline Park 29496 1265 Rancho Palos Verdes, City of 265 City 2 City Agency 2 http://palosverdes.com/rpv/recreationparks/index.cfm City 2 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 79.019 Abalone Cove Shoreline 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]);