units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, COUNTY = 6 and MNG_AGENCY = 289

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Palos Verdes Estates, City of · 1 ✖

DES_TP 1

ACCESS_TYP 1

  • Restricted 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
6996 6996 6995 {"type": "Polygon", "coordinates": [[[-118.38523, 33.79959], [-118.38522, 33.80151], [-118.38443, 33.80159], [-118.38352, 33.8016], [-118.38261, 33.80165], [-118.38171, 33.80173], [-118.38073, 33.80184], [-118.38, 33.80185], [-118.37929, 33.80181], [-118.37888, 33.80176], [-118.37748, 33.80149], [-118.37709, 33.80147], [-118.37577, 33.80148], [-118.37556, 33.80145], [-118.37535, 33.8014], [-118.37506, 33.80128], [-118.37444, 33.8009], [-118.37413, 33.80077], [-118.37303, 33.80049], [-118.37119, 33.80011], [-118.36992, 33.79979], [-118.36961, 33.79966], [-118.36941, 33.79953], [-118.36931, 33.79944], [-118.36912, 33.7992], [-118.369, 33.79895], [-118.36896, 33.79878], [-118.36893, 33.79857], [-118.36895, 33.7979], [-118.36894, 33.79757], [-118.36869, 33.79637], [-118.36868, 33.79617], [-118.36871, 33.796], [-118.3688, 33.79575], [-118.36887, 33.79561], [-118.36892, 33.79555], [-118.36904, 33.79543], [-118.36932, 33.7952], [-118.36951, 33.79508], [-118.36977, 33.79497], [-118.37001, 33.79492], [-118.37153, 33.7948], [-118.37173, 33.7948], [-118.37201, 33.79483], [-118.37259, 33.79493], [-118.37278, 33.79494], [-118.37624, 33.79506], [-118.37703, 33.79504], [-118.37749, 33.79499], [-118.37774, 33.79501], [-118.37787, 33.79506], [-118.37798, 33.79512], [-118.37919, 33.79616], [-118.37948, 33.79636], [-118.3797, 33.79647], [-118.37997, 33.79657], [-118.38047, 33.79666], [-118.38097, 33.79671], [-118.38202, 33.79672], [-118.38247, 33.79675], [-118.38274, 33.79678], [-118.3829, 33.79682], [-118.38303, 33.79689], [-118.38308, 33.79692], [-118.38306, 33.79708], [-118.38284, 33.79829], [-118.38282, 33.79837], [-118.38275, 33.79841], [-118.38267, 33.79852], [-118.38264, 33.79863], [-118.38265, 33.79871], [-118.3827, 33.79882], [-118.38277, 33.7989], [-118.38287, 33.79895], [-118.38304, 33.79899], [-118.38353, 33.79888], [-118.38369, 33.79888], [-118.38393, 33.79893], [-118.38413, 33.79904], [-118.38452, 33.79939], [-118.38468, 33.79951], [-118.38493, 33.79959], [-118.38514, 33.7996], [-118.38523, 33.79959]], [[-118.37105, 33.79608], [-118.37099, 33.79596], [-118.37086, 33.79601], [-118.37094, 33.79615], [-118.37105, 33.79608]], [[-118.37068, 33.79599], [-118.37087, 33.79592], [-118.37082, 33.79582], [-118.37061, 33.79587], [-118.37068, 33.79599]], [[-118.37741, 33.7953], [-118.37728, 33.79529], [-118.37722, 33.79531], [-118.37715, 33.79535], [-118.3771, 33.7954], [-118.37707, 33.79546], [-118.37706, 33.79554], [-118.37708, 33.79562], [-118.37715, 33.7957], [-118.37721, 33.79573], [-118.37731, 33.79576], [-118.37738, 33.79576], [-118.3775, 33.79572], [-118.3776, 33.79562], [-118.37762, 33.79556], [-118.37761, 33.79543], [-118.37754, 33.79535], [-118.37741, 33.7953]]]} Restricted Access 2 5934 Palos Verdes Golf Club and City Parkland 23372 1244 Palos Verdes Estates, City of 293 City 2 City Agency 2 http://www.pvestates.org/ City 2 1244 Palos Verdes Estates, City of 289 City 2 City Agency 2   Los Angeles 6 211.347 Palos Verdes Golf Club and City Parkland 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]);