units_with_maps

Table actions

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

6 rows where ACCESS_TYP = 1 and AGNCY_NAME = 51

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

DES_TP 1

ACCESS_TYP 1

  • Open Access · 6 ✖
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
118 118 117 {"type": "MultiPolygon", "coordinates": [[[[-117.08737, 32.68726], [-117.08735, 32.6873], [-117.08732, 32.68732], [-117.08474, 32.68803], [-117.08468, 32.68802], [-117.08463, 32.68799], [-117.08397, 32.68647], [-117.0868, 32.68568], [-117.08689, 32.68594], [-117.08688, 32.68599], [-117.08551, 32.68639], [-117.0855, 32.68641], [-117.08557, 32.68655], [-117.08691, 32.68616], [-117.08697, 32.68617], [-117.08701, 32.68621], [-117.08715, 32.68658], [-117.0871, 32.68666], [-117.08577, 32.68703], [-117.08576, 32.68704], [-117.08583, 32.68718], [-117.08719, 32.68681], [-117.08726, 32.68685], [-117.08731, 32.68699], [-117.08737, 32.68726]]], [[[-117.09053, 32.68616], [-117.09004, 32.68629], [-117.09002, 32.68627], [-117.08784, 32.68687], [-117.0879, 32.6872], [-117.08756, 32.68724], [-117.08754, 32.68708], [-117.08745, 32.68681], [-117.08694, 32.68547], [-117.08694, 32.68542], [-117.08697, 32.68539], [-117.08723, 32.68531], [-117.08882, 32.68486], [-117.08947, 32.68531], [-117.09053, 32.68616]]]]} Open Access 1 351 El Toyon Park 18547 1219 National City, City of 51 City 2 City Agency 2 http://www.ci.national-city.ca.us/index.aspx?page=152 City 2 1219 National City, City of 49 City 2 City Agency 2 http://www.nationalcityca.gov/city-government/community-services/facilities San Diego 4 22.811 El Toyon Park 0 Local Park 2 4
755 755 754 {"type": "Polygon", "coordinates": [[[-117.05925, 32.66148], [-117.05861, 32.66201], [-117.05845, 32.66216], [-117.05834, 32.6623], [-117.05743, 32.66206], [-117.05743, 32.66198], [-117.05862, 32.66127], [-117.05925, 32.66148]]]} Open Access 1 4945 Sweetwater Heights Park 31841 1219 National City, City of 51 City 2 City Agency 2 http://www.ci.national-city.ca.us/index.aspx?page=152 City 2 1219 National City, City of 49 City 2 City Agency 2 http://www.nationalcityca.gov/government/community-services/facilities San Diego 4 2.268 Sweetwater Heights Park 0 Local Park 2 4
3170 3170 3169 {"type": "Polygon", "coordinates": [[[-117.10708, 32.66324], [-117.10647, 32.66342], [-117.10689, 32.66448], [-117.1065, 32.66459], [-117.10666, 32.665], [-117.10616, 32.66513], [-117.1063, 32.66549], [-117.10541, 32.66574], [-117.10527, 32.66536], [-117.10579, 32.66424], [-117.1063, 32.663], [-117.10681, 32.66258], [-117.10708, 32.66324]]]} Open Access 1 26055 Paradise Creek Educational Park 31842 1219 National City, City of 51 City 2 City Agency 2 http://www.ci.national-city.ca.us/index.aspx?page=152 City 2 1219 National City, City of 49 City 2 City Agency 2 http://www.nationalcityca.gov/government/community-services/facilities San Diego 4 6.137 Paradise Creek Educational Park 0 Local Park 2 4
5950 5950 5949 {"type": "Polygon", "coordinates": [[[-117.10443, 32.67094], [-117.10436, 32.67192], [-117.10439, 32.67258], [-117.10161, 32.67338], [-117.10154, 32.67335], [-117.10123, 32.67259], [-117.10089, 32.67169], [-117.1011, 32.67163], [-117.10102, 32.6714], [-117.10117, 32.67136], [-117.10117, 32.67133], [-117.10137, 32.67127], [-117.10141, 32.67124], [-117.1015, 32.67121], [-117.10149, 32.67118], [-117.10159, 32.67115], [-117.1015, 32.67087], [-117.1014, 32.67077], [-117.10159, 32.67072], [-117.10157, 32.67063], [-117.10196, 32.67051], [-117.10182, 32.67016], [-117.10185, 32.67014], [-117.10175, 32.66989], [-117.10223, 32.66975], [-117.10217, 32.66961], [-117.1032, 32.66933], [-117.10345, 32.66999], [-117.10334, 32.67003], [-117.10333, 32.67004], [-117.1034, 32.67019], [-117.10352, 32.67016], [-117.10384, 32.67095], [-117.10439, 32.6708], [-117.10439, 32.67088], [-117.10443, 32.67094]]]} Open Access 1 515 Kimball Park 20643 1219 National City, City of 51 City 2 City Agency 2 http://www.ci.national-city.ca.us/index.aspx?page=152 City 2 1219 National City, City of 49 City 2 City Agency 2 http://www.nationalcityca.gov/city-government/community-services/facilities San Diego 4 23.388 Kimball Park 0 Local Park 2 4
8186 8186 8185 {"type": "Polygon", "coordinates": [[[-117.08492, 32.67018], [-117.0844, 32.67041], [-117.08447, 32.67064], [-117.08269, 32.67114], [-117.08246, 32.67052], [-117.08213, 32.66991], [-117.08194, 32.66941], [-117.08191, 32.66941], [-117.08161, 32.66862], [-117.08164, 32.6686], [-117.08155, 32.66834], [-117.08337, 32.66784], [-117.08329, 32.66763], [-117.08372, 32.6675], [-117.08384, 32.66761], [-117.08404, 32.66769], [-117.08422, 32.66784], [-117.08443, 32.66849], [-117.08427, 32.66906], [-117.08482, 32.66985], [-117.08489, 32.67002], [-117.08492, 32.67018]]]} Open Access 1 12402 Las Palmas Park 31839 1219 National City, City of 51 City 2 City Agency 2 http://www.ci.national-city.ca.us/index.aspx?page=152 City 2 1219 National City, City of 49 City 2 City Agency 2 http://www.nationalcityca.gov/government/community-services/facilities San Diego 4 19.244 Las Palmas Park 0 Local Park 2 4
9773 9773 9772 {"type": "Polygon", "coordinates": [[[-117.08652, 32.67007], [-117.08573, 32.67028], [-117.08584, 32.67017], [-117.08587, 32.6701], [-117.08587, 32.66994], [-117.08585, 32.66973], [-117.08582, 32.66962], [-117.08566, 32.66932], [-117.08549, 32.66885], [-117.08548, 32.6687], [-117.08549, 32.6686], [-117.08555, 32.6685], [-117.0856, 32.66846], [-117.08577, 32.66839], [-117.08586, 32.66839], [-117.08652, 32.67007]]]} Open Access 1 47892 Butterfly Park 31840 1219 National City, City of 51 City 2 City Agency 2 http://www.ci.national-city.ca.us/index.aspx?page=152 City 2 1219 National City, City of 49 City 2 City Agency 2   San Diego 4 2.413 Butterfly 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]);