units_with_maps

Table actions

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

8 rows where ACCESS_TYP = 1, DES_TP = 3, MNG_AGENCY = 156 and MNG_AG_ID = 2171

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 8 ✖
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
385 385 384 {"type": "Polygon", "coordinates": [[[-117.15388, 33.67064], [-117.15386, 33.67362], [-117.15375, 33.67366], [-117.15354, 33.67338], [-117.15342, 33.6733], [-117.15342, 33.67327], [-117.15317, 33.67312], [-117.15276, 33.67299], [-117.15275, 33.67297], [-117.15218, 33.67273], [-117.1521, 33.67268], [-117.15205, 33.67268], [-117.15209, 33.67232], [-117.15206, 33.67228], [-117.15172, 33.67207], [-117.15166, 33.67209], [-117.15161, 33.67209], [-117.15158, 33.67206], [-117.15137, 33.67206], [-117.15114, 33.67216], [-117.15096, 33.67243], [-117.15097, 33.67245], [-117.15093, 33.67262], [-117.15094, 33.67265], [-117.15089, 33.67283], [-117.15091, 33.67286], [-117.15091, 33.67306], [-117.15088, 33.67306], [-117.15083, 33.67326], [-117.15041, 33.67303], [-117.15016, 33.67299], [-117.14999, 33.67287], [-117.14973, 33.67259], [-117.14955, 33.67245], [-117.14936, 33.67232], [-117.14933, 33.67232], [-117.14914, 33.6722], [-117.14911, 33.6722], [-117.14903, 33.67215], [-117.14888, 33.67217], [-117.14849, 33.67226], [-117.1482, 33.67272], [-117.14817, 33.6727], [-117.14817, 33.67261], [-117.14814, 33.67256], [-117.1481, 33.67252], [-117.14802, 33.67247], [-117.14821, 33.67255], [-117.14865, 33.67182], [-117.14797, 33.67065], [-117.14945, 33.67065], [-117.14949, 33.67069], [-117.14974, 33.67069], [-117.14978, 33.67065], [-117.15154, 33.67065], [-117.15159, 33.67069], [-117.15184, 33.67069], [-117.15188, 33.67065], [-117.15388, 33.67064]]]} Open Access 1 48338 Lago Vista Sports Park 32901 2171 Valley-Wide Recreation and Park District 160 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/lago-vista-sports-park Riverside 10 28.451 Lago Vista Sports Park 0 Local Recreation Area 3 4
557 557 556 {"type": "Polygon", "coordinates": [[[-117.10253, 33.61115], [-117.1013, 33.61115], [-117.10128, 33.60911], [-117.10251, 33.60901], [-117.10253, 33.61115]]]} Open Access 1 48384 Pourroy Fields 32948 2171 Valley-Wide Recreation and Park District 160 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/pourroy-fields Riverside 10 6.552 Pourroy Fields 0 Local Recreation Area 3 4
6461 6461 6460 {"type": "Polygon", "coordinates": [[[-117.12666, 33.60337], [-117.12642, 33.60338], [-117.12634, 33.60344], [-117.12614, 33.60397], [-117.12609, 33.60403], [-117.126, 33.6041], [-117.12598, 33.60425], [-117.12589, 33.60441], [-117.12586, 33.6046], [-117.1258, 33.60466], [-117.1256, 33.60452], [-117.12526, 33.60422], [-117.1251, 33.60406], [-117.1251, 33.60402], [-117.12494, 33.60384], [-117.12488, 33.60381], [-117.12481, 33.60373], [-117.12455, 33.60333], [-117.12417, 33.60257], [-117.12433, 33.60226], [-117.12621, 33.60171], [-117.12635, 33.60165], [-117.12657, 33.60158], [-117.12657, 33.6023], [-117.12666, 33.60317], [-117.12666, 33.60337]]]} Open Access 1 48389 Spencer's Crossing Sports Park 32953 2171 Valley-Wide Recreation and Park District 160 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/spencer-s-crossing-sports-park Riverside 10 11.573 Spencer's Crossing Sports Park 0 Local Recreation Area 3 4
11842 11842 11841 {"type": "Polygon", "coordinates": [[[-116.89525, 33.7441], [-116.89337, 33.74412], [-116.89328, 33.74405], [-116.89328, 33.74281], [-116.89515, 33.74281], [-116.89518, 33.74327], [-116.89525, 33.74369], [-116.89525, 33.7441]]]} Open Access 1 48257 Valle Vista Community Center Park 32811 2171 Valley-Wide Recreation and Park District 160 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/valle-vista-community-center Riverside 10 6.351 Valle Vista Community Ctr. Park 0 Local Recreation Area 3 4
14072 14072 14071 {"type": "Polygon", "coordinates": [[[-117.16259, 33.65631], [-117.16258, 33.65695], [-117.16219, 33.65695], [-117.16219, 33.65684], [-117.16222, 33.65663], [-117.16219, 33.65655], [-117.16212, 33.65649], [-117.16201, 33.65647], [-117.16168, 33.65649], [-117.16168, 33.65618], [-117.16239, 33.65618], [-117.16247, 33.65627], [-117.16259, 33.65631]]]} Open Access 1 39109 Menifee South Tot Lot 22155 2171 Valley-Wide Recreation and Park District 160 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4   Riverside 10 1.114 Menifee South Tot Lot 0 Local Recreation Area 3 4
14089 14089 14088 {"type": "Polygon", "coordinates": [[[-117.13888, 33.74651], [-117.13887, 33.7486], [-117.1367, 33.74859], [-117.13669, 33.74665], [-117.13673, 33.74659], [-117.13697, 33.74659], [-117.13726, 33.74664], [-117.13732, 33.74663], [-117.13738, 33.74659], [-117.13741, 33.7465], [-117.13888, 33.74651]]]} Open Access 1 39121 Marion V. Ashley Community Center 21864 315 Riverside, County of 169 County 3 County Agency 3 http://www.rivcoparks.org/ County 3 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4   Riverside 10 11.364 Marion V. Ashley Community Ctr. 0 Local Recreation Area 3 4
14550 14550 14549 {"type": "Polygon", "coordinates": [[[-117.10104, 33.61814], [-117.10099, 33.61814], [-117.09946, 33.61994], [-117.09898, 33.61995], [-117.09889, 33.61989], [-117.09899, 33.61985], [-117.09924, 33.6196], [-117.09936, 33.61964], [-117.0994, 33.6196], [-117.09934, 33.61951], [-117.09946, 33.61938], [-117.09904, 33.61905], [-117.09888, 33.61919], [-117.09878, 33.61912], [-117.09873, 33.61915], [-117.09878, 33.61926], [-117.09857, 33.6194], [-117.0983, 33.6194], [-117.09822, 33.61937], [-117.09817, 33.61938], [-117.09814, 33.61941], [-117.09791, 33.61928], [-117.09793, 33.61925], [-117.09829, 33.61916], [-117.09853, 33.61889], [-117.09858, 33.61865], [-117.09868, 33.61843], [-117.09879, 33.61824], [-117.09903, 33.61795], [-117.09915, 33.61771], [-117.0992, 33.61745], [-117.09919, 33.61714], [-117.09914, 33.61694], [-117.09893, 33.61631], [-117.10101, 33.6163], [-117.10104, 33.61814]]]} Open Access 1 48276 Abelia Sports Park 32831 2171 Valley-Wide Recreation and Park District 160 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4   Riverside 10 15.608 Abelia Sports Park 0 Local Recreation Area 3 4
16254 16254 16253 {"type": "Polygon", "coordinates": [[[-117.10095, 33.60539], [-117.10052, 33.6054], [-117.10037, 33.60502], [-117.10047, 33.60497], [-117.10048, 33.60498], [-117.10095, 33.60502], [-117.10095, 33.60539]]]} Open Access 1 48330 Brookfield Open Space 32893 2171 Valley-Wide Recreation and Park District 160 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/brookfield-open-sp Riverside 10 0.518 Brookfield OS 0 Local Recreation Area 3 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]);