units_with_maps

Table actions

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

1 row where DES_TP = 14, LAYER = 2 and MNG_AGENCY = 297

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

DES_TP 1

  • Local Other or Unknown · 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
5653 5653 5652 {"type": "MultiPolygon", "coordinates": [[[[-117.89005, 34.16595], [-117.88775, 34.16722], [-117.88764, 34.16709], [-117.88749, 34.16698], [-117.88708, 34.16659], [-117.88698, 34.16655], [-117.88689, 34.16653], [-117.88675, 34.16653], [-117.88667, 34.16655], [-117.88625, 34.16672], [-117.88602, 34.16689], [-117.88573, 34.16723], [-117.88558, 34.16751], [-117.88554, 34.16767], [-117.8855, 34.16813], [-117.88554, 34.16826], [-117.88566, 34.16844], [-117.88574, 34.16867], [-117.88588, 34.16897], [-117.88613, 34.1694], [-117.88621, 34.16984], [-117.88623, 34.1701], [-117.88617, 34.17039], [-117.88613, 34.1707], [-117.88603, 34.17095], [-117.88588, 34.17111], [-117.88567, 34.17129], [-117.88529, 34.17166], [-117.88523, 34.17179], [-117.88514, 34.17211], [-117.87297, 34.17211], [-117.87246, 34.16507], [-117.88806, 34.16511], [-117.88808, 34.16594], [-117.89005, 34.16595]]], [[[-117.89007, 34.1702], [-117.89007, 34.17102], [-117.8899, 34.17093], [-117.88961, 34.17125], [-117.88901, 34.17091], [-117.88883, 34.17084], [-117.88857, 34.17079], [-117.88827, 34.17079], [-117.88802, 34.17085], [-117.88778, 34.17095], [-117.88762, 34.17107], [-117.88712, 34.1707], [-117.88699, 34.17082], [-117.88688, 34.17095], [-117.88673, 34.17119], [-117.88654, 34.17181], [-117.88638, 34.17211], [-117.88534, 34.17211], [-117.88545, 34.17174], [-117.88553, 34.17169], [-117.88582, 34.17139], [-117.88603, 34.17122], [-117.88621, 34.17102], [-117.88624, 34.17093], [-117.88632, 34.17074], [-117.88636, 34.1704], [-117.88642, 34.1701], [-117.88641, 34.16983], [-117.88633, 34.16936], [-117.88606, 34.16891], [-117.88586, 34.16845], [-117.88572, 34.1682], [-117.8857, 34.16808], [-117.88575, 34.16765], [-117.88584, 34.16741], [-117.88595, 34.16726], [-117.88623, 34.16694], [-117.88635, 34.16686], [-117.88644, 34.16681], [-117.88678, 34.16669], [-117.88691, 34.1667], [-117.88701, 34.16675], [-117.88734, 34.1671], [-117.88751, 34.16722], [-117.88757, 34.16728], [-117.88783, 34.1677], [-117.88812, 34.16801], [-117.88819, 34.16814], [-117.88823, 34.16827], [-117.88832, 34.16845], [-117.88974, 34.1701], [-117.89007, 34.1702]]], [[[-117.89007, 34.17212], [-117.89007, 34.17212], [-117.8878, 34.17211], [-117.88791, 34.17183], [-117.88795, 34.17163], [-117.88802, 34.1715], [-117.88816, 34.17139], [-117.88826, 34.17135], [-117.88835, 34.17134], [-117.88851, 34.17133], [-117.88866, 34.17138], [-117.88974, 34.17198], [-117.89007, 34.17208], [-117.89007, 34.17212]]], [[[-117.89007, 34.17002], [-117.88986, 34.16996], [-117.88854, 34.16846], [-117.88847, 34.16834], [-117.88842, 34.16824], [-117.8884, 34.16814], [-117.88832, 34.16798], [-117.888, 34.16762], [-117.88789, 34.16744], [-117.88792, 34.16729], [-117.89005, 34.16611], [-117.89007, 34.17002]]], [[[-117.90541, 34.15784], [-117.9054, 34.15837], [-117.90455, 34.15824], [-117.90433, 34.15825], [-117.90415, 34.15832], [-117.90399, 34.15843], [-117.90366, 34.15842], [-117.90326, 34.15845], [-117.90308, 34.15848], [-117.90126, 34.1589], [-117.90099, 34.159], [-117.90059, 34.15916], [-117.89892, 34.16013], [-117.89881, 34.16017], [-117.89842, 34.16046], [-117.89818, 34.16074], [-117.89733, 34.16194], [-117.89668, 34.16145], [-117.8966, 34.16153], [-117.8966, 34.15994], [-117.8961, 34.16015], [-117.89459, 34.16034], [-117.89442, 34.16033], [-117.89427, 34.16025], [-117.89397, 34.16011], [-117.89372, 34.16003], [-117.89325, 34.15994], [-117.89276, 34.15977], [-117.89264, 34.15949], [-117.89224, 34.15922], [-117.89127, 34.15925], [-117.89005, 34.15966], [-117.89005, 34.15775], [-117.90541, 34.15784]]], [[[-117.90541, 34.1585], [-117.9054, 34.15879], [-117.90479, 34.15856], [-117.90458, 34.15851], [-117.90421, 34.15845], [-117.90436, 34.15839], [-117.90454, 34.15837], [-117.90541, 34.1585]]], [[[-117.90754, 34.15881], [-117.90753, 34.15953], [-117.9071, 34.15944], [-117.90649, 34.15922], [-117.90649, 34.15867], [-117.90754, 34.15881]]], [[[-117.90755, 34.15786], [-117.90754, 34.15868], [-117.90649, 34.15852], [-117.9065, 34.15785], [-117.90755, 34.15786]]]]} Open Access 1 12548 Unnamed site - Pasadena, City of 32659 1246 Pasadena, City of 301 City 2 City Agency 2 http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ City 2 1246 Pasadena, City of 297 City 2 City Agency 2   Los Angeles 6 363.946   0 Local Other or Unknown 14 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]);