units_with_maps

Table actions

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

6 rows where MNG_AGENCY = 587 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 6 ✖

MNG_AGENCY 1

  • Lemon Grove, City of · 6 ✖

DES_TP 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
3213 3213 3212 {"type": "Polygon", "coordinates": [[[-117.03335, 32.72505], [-117.03297, 32.7252], [-117.03229, 32.72585], [-117.03192, 32.726], [-117.03191, 32.72554], [-117.032, 32.72548], [-117.03193, 32.72537], [-117.03191, 32.72537], [-117.0319, 32.72401], [-117.03216, 32.72422], [-117.03216, 32.72404], [-117.03212, 32.724], [-117.0321, 32.72396], [-117.03212, 32.7239], [-117.03221, 32.72385], [-117.03243, 32.72387], [-117.03307, 32.72452], [-117.03335, 32.72505]]]} Open Access 1 376 Monterey Heights Park 22420 1173 Lemon Grove, City of 597 City 2 City Agency 2 http://www.lemongrove.ca.gov/departments/community-services/parks-197 City 2 1173 Lemon Grove, City of 587 City 2 City Agency 2   San Diego 4 4.805 Monterey Heights Park 0 Local Park 2 4
5523 5523 5522 {"type": "Polygon", "coordinates": [[[-117.02514, 32.74441], [-117.02509, 32.74543], [-117.02463, 32.74543], [-117.02461, 32.74547], [-117.02455, 32.74547], [-117.02456, 32.74509], [-117.02482, 32.74508], [-117.02485, 32.7444], [-117.02514, 32.74441]]]} Open Access 1 387 Kunkel Park 20731 1173 Lemon Grove, City of 597 City 2 City Agency 2 http://www.lemongrove.ca.gov/departments/community-services/parks-197 City 2 1173 Lemon Grove, City of 587 City 2 City Agency 2 http://www.lemongrove.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/34/71 San Diego 4 1.0 Kunkel Park 0 Local Park 2 4
5913 5913 5912 {"type": "Polygon", "coordinates": [[[-117.02345, 32.72902], [-117.0234, 32.73032], [-117.02275, 32.73034], [-117.0227, 32.73175], [-117.02202, 32.73176], [-117.02207, 32.72943], [-117.02273, 32.72942], [-117.02274, 32.72902], [-117.02345, 32.72902]]]} Open Access 1 370 Lemon Grove Park 21151 1173 Lemon Grove, City of 597 City 2 City Agency 2 http://www.lemongrove.ca.gov/departments/community-services/parks-197 City 2 1173 Lemon Grove, City of 587 City 2 City Agency 2 http://www.lemongrove.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/40/71 San Diego 4 6.433 Lemon Grove Park 0 Local Park 2 4
5915 5915 5914 {"type": "Polygon", "coordinates": [[[-117.04609, 32.73064], [-117.04571, 32.73065], [-117.04574, 32.73083], [-117.0456, 32.73083], [-117.04563, 32.731], [-117.04578, 32.73101], [-117.04589, 32.7315], [-117.04559, 32.7315], [-117.04558, 32.73148], [-117.04444, 32.73149], [-117.04398, 32.7301], [-117.04599, 32.73007], [-117.04609, 32.73064]]]} Open Access 1 371 Berry Street Park 16034 1173 Lemon Grove, City of 597 City 2 City Agency 2 http://www.lemongrove.ca.gov/departments/community-services/parks-197 City 2 1173 Lemon Grove, City of 587 City 2 City Agency 2 http://www.lemongrove.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/30/71 San Diego 4 6.008 Berry Street Park 0 Local Park 2 4
12453 12453 12452 {"type": "Polygon", "coordinates": [[[-117.03207, 32.73998], [-117.03207, 32.74041], [-117.03161, 32.74041], [-117.03162, 32.74024], [-117.03164, 32.74023], [-117.03165, 32.73992], [-117.03127, 32.73991], [-117.03127, 32.73983], [-117.03125, 32.73982], [-117.03126, 32.73967], [-117.03193, 32.73967], [-117.03194, 32.73962], [-117.03207, 32.73962], [-117.03207, 32.73998]]]} Open Access 1 28090 Civic Center Park 17359 1173 Lemon Grove, City of 597 City 2 City Agency 2 http://www.lemongrove.ca.gov/departments/community-services/parks-197 City 2 1173 Lemon Grove, City of 587 City 2 City Agency 2 http://www.lemongrove.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/36/71 San Diego 4 1.083 Civic Ctr. Park 0 Local Park 2 4
13058 13058 13057 {"type": "Polygon", "coordinates": [[[-117.02984, 32.73907], [-117.02982, 32.73946], [-117.02952, 32.73946], [-117.02952, 32.73932], [-117.02951, 32.73931], [-117.02953, 32.7391], [-117.02958, 32.73907], [-117.02984, 32.73907]]]} Open Access 1 34917 Firefighters Park 18910 1173 Lemon Grove, City of 597 City 2 City Agency 2 http://www.lemongrove.ca.gov/departments/community-services/parks-197 City 2 1173 Lemon Grove, City of 587 City 2 City Agency 2 http://www.lemongrove.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/38/71 San Diego 4 0.313 Firefighters 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]);