units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, MNG_AGENCY = 9, MNG_AG_TYP = 2 and UNIT_NAME = "Arana Gulch"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • Santa Cruz, City of · 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
8651 8651 8650 {"type": "Polygon", "coordinates": [[[-122.00352, 36.97672], [-122.00349, 36.9767], [-122.00345, 36.97669], [-122.00143, 36.97676], [-122.00143, 36.9768], [-122.00135, 36.97681], [-122.00097, 36.97674], [-122.00083, 36.9766], [-122.00067, 36.9764], [-122.00068, 36.97634], [-122.00061, 36.97633], [-122.0002, 36.97608], [-122.00016, 36.97607], [-121.99929, 36.97705], [-121.99976, 36.97735], [-121.99928, 36.97796], [-121.99894, 36.97942], [-121.99876, 36.97914], [-121.99716, 36.97975], [-121.99786, 36.98139], [-121.99756, 36.98151], [-121.99766, 36.98175], [-121.99729, 36.98179], [-121.9969, 36.98173], [-121.99653, 36.98186], [-121.99634, 36.98152], [-121.99609, 36.9815], [-121.99594, 36.98168], [-121.99572, 36.98215], [-121.995, 36.98232], [-121.99482, 36.98217], [-121.99446, 36.98273], [-121.99437, 36.98294], [-121.99454, 36.98314], [-121.99414, 36.98273], [-121.99435, 36.98244], [-121.99461, 36.98219], [-121.99485, 36.98202], [-121.99526, 36.98179], [-121.99541, 36.98169], [-121.99554, 36.98158], [-121.99567, 36.98143], [-121.99581, 36.98119], [-121.99588, 36.98095], [-121.99589, 36.98083], [-121.99588, 36.98076], [-121.9958, 36.98054], [-121.99575, 36.98045], [-121.99562, 36.98029], [-121.99545, 36.98015], [-121.99532, 36.98008], [-121.99512, 36.97999], [-121.9948, 36.9798], [-121.99456, 36.97969], [-121.9943, 36.97961], [-121.99396, 36.97954], [-121.99372, 36.97951], [-121.99341, 36.97951], [-121.99254, 36.97942], [-121.99245, 36.97924], [-121.99244, 36.97915], [-121.99244, 36.97905], [-121.99248, 36.97895], [-121.99253, 36.97885], [-121.9926, 36.97877], [-121.99284, 36.97871], [-121.99317, 36.97867], [-121.99356, 36.97869], [-121.9939, 36.97876], [-121.99433, 36.97892], [-121.99453, 36.97895], [-121.99471, 36.97894], [-121.99488, 36.97889], [-121.99502, 36.97883], [-121.99513, 36.97876], [-121.99517, 36.97859], [-121.99517, 36.97837], [-121.99524, 36.97812], [-121.99501, 36.97802], [-121.99523, 36.97759], [-121.9951, 36.97763], [-121.99496, 36.97764], [-121.99484, 36.97763], [-121.99466, 36.97759], [-121.99457, 36.97754], [-121.99452, 36.97748], [-121.9945, 36.97741], [-121.99452, 36.97733], [-121.99458, 36.97725], [-121.99468, 36.9772], [-121.99506, 36.97719], [-121.99535, 36.97715], [-121.99545, 36.9771], [-121.99554, 36.97702], [-121.9956, 36.97693], [-121.99562, 36.97685], [-121.99564, 36.97649], [-121.99572, 36.9762], [-121.99567, 36.97596], [-121.99566, 36.97575], [-121.9957, 36.97557], [-121.99579, 36.9754], [-121.99589, 36.97527], [-121.996, 36.97515], [-121.99617, 36.97503], [-121.99634, 36.97494], [-121.99652, 36.97476], [-121.99661, 36.97458], [-121.99668, 36.97432], [-121.99673, 36.97418], [-121.9968, 36.97407], [-121.99692, 36.97392], [-121.99708, 36.97378], [-121.99722, 36.97369], [-121.99739, 36.97361], [-121.99761, 36.97354], [-121.99775, 36.97351], [-121.99776, 36.97363], [-121.9978, 36.97379], [-121.99782, 36.97379], [-121.99803, 36.97424], [-121.99828, 36.9747], [-121.99862, 36.97512], [-121.99869, 36.97518], [-121.99941, 36.97431], [-121.99953, 36.97382], [-121.99994, 36.97321], [-122.00014, 36.9732], [-122.00076, 36.97355], [-122.00098, 36.97327], [-122.00129, 36.97349], [-122.00162, 36.97518], [-122.00141, 36.97631], [-122.00152, 36.97632], [-122.00164, 36.97635], [-122.00176, 36.97644], [-122.00139, 36.97647], [-122.00137, 36.97654], [-122.00139, 36.97662], [-122.00246, 36.97659], [-122.00256, 36.97654], [-122.00259, 36.97645], [-122.00291, 36.97641], [-122.00295, 36.97657], [-122.00347, 36.97655], [-122.00352, 36.97672]]]} Open Access 1 13862 Arana Gulch 15553 1320 Santa Cruz, City of 9 City 2 City Agency 2 http://www.cityofsantacruz.com/departments/parks-recreation City 2 1320 Santa Cruz, City of 9 City 2 City Agency 2   Santa Cruz 5 81.713 Arana Gulch 0 None 724  

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