superunits_with_maps

Table actions

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

67 rows where MNG_AGENCY = 156 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • Recreation/Parks District · 67 ✖

MNG_AGENCY 1

  • Valley-Wide Recreation and Park District · 67 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
1014 1014 1013 {"type": "Polygon", "coordinates": [[[-117.15686, 33.69873], [-117.15685, 33.69915], [-117.1563, 33.69916], [-117.15626, 33.69919], [-117.15628, 33.69997], [-117.15634, 33.70003], [-117.15639, 33.70004], [-117.1564, 33.70034], [-117.15589, 33.70031], [-117.15545, 33.70012], [-117.15443, 33.69945], [-117.15435, 33.69919], [-117.15465, 33.69866], [-117.15483, 33.69828], [-117.15493, 33.69823], [-117.15632, 33.69856], [-117.15633, 33.69861], [-117.15637, 33.69863], [-117.15674, 33.69872], [-117.15686, 33.69873]]]} Open Access 1 Aldergate Park   15348 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 8.125 Aldergate Park  
1032 1032 1031 {"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 Valle Vista Community Center Park https://www.gorecreation.org/valle-vista-community-center 32811 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 6.349 Valle Vista Community Ctr. Park  
1036 1036 1035 {"type": "Polygon", "coordinates": [[[-117.0966, 33.59065], [-117.09652, 33.59071], [-117.09467, 33.59071], [-117.09467, 33.59033], [-117.09462, 33.59028], [-117.09464, 33.59021], [-117.09463, 33.59014], [-117.09458, 33.5901], [-117.09451, 33.59007], [-117.09451, 33.58973], [-117.0966, 33.58973], [-117.0966, 33.59065]]]} Open Access 1 Butterfield Park https://www.gorecreation.org/butterfield-park 32812 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 5.011 Butterfield Park  
1037 1037 1036 {"type": "Polygon", "coordinates": [[[-117.09164, 33.59241], [-117.09164, 33.59294], [-117.09127, 33.59294], [-117.09128, 33.59241], [-117.09164, 33.59241]]]} Open Access 1 Wagon Wheel Park https://www.gorecreation.org/wagon-wheel-pocket-park 32813 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 0.493 Wagon Wheel Park  
1043 1043 1042 {"type": "Polygon", "coordinates": [[[-117.09337, 33.59269], [-117.09337, 33.59287], [-117.09303, 33.59287], [-117.09303, 33.59269], [-117.09337, 33.59269]]]} Open Access 1 Northfield Park https://www.gorecreation.org/northfield-park 32814 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 0.152 Northfield Park  
1044 1044 1043 {"type": "Polygon", "coordinates": [[[-117.09722, 33.59201], [-117.09679, 33.59201], [-117.09676, 33.59226], [-117.09668, 33.59227], [-117.09652, 33.59204], [-117.09625, 33.59204], [-117.09621, 33.59183], [-117.09621, 33.59161], [-117.09646, 33.59165], [-117.09678, 33.59166], [-117.09722, 33.59161], [-117.09722, 33.59201]]]} Open Access 1 Adeline's Farm Park https://www.gorecreation.org/adeline-s-farm 32815 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 1.082 Adeline's Farm Park  
1054 1054 1053 {"type": "Polygon", "coordinates": [[[-116.99122, 33.70431], [-116.98836, 33.70483], [-116.98832, 33.70447], [-116.9881, 33.70417], [-116.98774, 33.70391], [-116.98732, 33.70372], [-116.98685, 33.70363], [-116.98649, 33.70367], [-116.98616, 33.70376], [-116.98571, 33.70384], [-116.98516, 33.70373], [-116.98444, 33.70319], [-116.98418, 33.70319], [-116.98331, 33.70296], [-116.98311, 33.70272], [-116.98287, 33.70237], [-116.98231, 33.70215], [-116.98164, 33.70201], [-116.98124, 33.70207], [-116.98106, 33.70207], [-116.98083, 33.70195], [-116.98095, 33.70139], [-116.98119, 33.70138], [-116.98148, 33.70133], [-116.98177, 33.70121], [-116.98204, 33.701], [-116.98228, 33.7007], [-116.98262, 33.6997], [-116.98616, 33.69994], [-116.98807, 33.70009], [-116.9889, 33.70009], [-116.98983, 33.69993], [-116.99006, 33.70029], [-116.99122, 33.70431]]]} Open Access 1 Diamond Valley Lake Community Park https://www.gorecreation.org/diamond-valley-lake-community-park 32828 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 83.3 Diamond Valley Lake Community Park  
1057 1057 1056 {"type": "Polygon", "coordinates": [[[-116.89403, 33.75911], [-116.89402, 33.7592], [-116.89372, 33.75945], [-116.89348, 33.75971], [-116.89336, 33.7599], [-116.89326, 33.7601], [-116.89319, 33.76013], [-116.89307, 33.7601], [-116.89305, 33.75874], [-116.8932, 33.75872], [-116.89319, 33.75788], [-116.89322, 33.75789], [-116.89332, 33.75814], [-116.89345, 33.75837], [-116.89366, 33.75869], [-116.89321, 33.75894], [-116.89321, 33.75896], [-116.89355, 33.75931], [-116.89398, 33.75906], [-116.89403, 33.75911]]]} Open Access 1 Valle Vista   32830 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2.049 Valle Vista  
1058 1058 1057 {"type": "Polygon", "coordinates": [[[-117.10104, 33.61814], [-117.10099, 33.61815], [-117.09946, 33.61994], [-117.09898, 33.61995], [-117.09889, 33.61989], [-117.09899, 33.61984], [-117.09924, 33.6196], [-117.09937, 33.61964], [-117.0994, 33.6196], [-117.09934, 33.61951], [-117.09945, 33.61938], [-117.09905, 33.61906], [-117.09888, 33.61919], [-117.09878, 33.61912], [-117.09874, 33.61914], [-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.61713], [-117.09914, 33.61694], [-117.09893, 33.61631], [-117.10101, 33.6163], [-117.10104, 33.61814]]]} Open Access 1 Abelia Sports Park   32831 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 15.617 Abelia Sports Park  
1059 1059 1058 {"type": "Polygon", "coordinates": [[[-116.96711, 33.7251], [-116.96673, 33.72511], [-116.96673, 33.72566], [-116.96295, 33.72571], [-116.96294, 33.7238], [-116.9636, 33.7238], [-116.96476, 33.72315], [-116.96711, 33.72285], [-116.96711, 33.7251]]]} Restricted Access 2 Echo Hills Golf Course   32829 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 25.115 Echo Hills GC  
1064 1064 1063 {"type": "Polygon", "coordinates": [[[-117.11078, 33.59922], [-117.11047, 33.59922], [-117.11042, 33.59918], [-117.11042, 33.59883], [-117.11047, 33.59863], [-117.11044, 33.59855], [-117.11077, 33.59833], [-117.11078, 33.59922]]]} Open Access 1 Avignon Park   32832 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 0.671 Avignon Park  
1132 1132 1131 {"type": "Polygon", "coordinates": [[[-117.12996, 33.61098], [-117.12958, 33.61131], [-117.12915, 33.61159], [-117.12869, 33.61184], [-117.12814, 33.61205], [-117.12717, 33.60728], [-117.12708, 33.60616], [-117.12737, 33.60655], [-117.1276, 33.60697], [-117.12776, 33.60736], [-117.12796, 33.60806], [-117.12807, 33.60837], [-117.12822, 33.60871], [-117.1284, 33.60904], [-117.12873, 33.60952], [-117.12905, 33.60992], [-117.12941, 33.61028], [-117.12991, 33.61069], [-117.12996, 33.61098]]]} Open Access 1 Heroes Park https://www.gorecreation.org/heroes-park 32898 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 14.343 Heroes Park  
1181 1181 1180 {"type": "Polygon", "coordinates": [[[-117.1072, 33.57315], [-117.10686, 33.57344], [-117.10669, 33.57327], [-117.10654, 33.57305], [-117.10656, 33.57299], [-117.10691, 33.5728], [-117.1072, 33.57315]]]} Open Access 1 Honey Pine Park https://www.gorecreation.org/honey-pine-park 32899 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 0.576 Honey Pine Park  
1182 1182 1181 {"type": "Polygon", "coordinates": [[[-117.11195, 33.60932], [-117.11169, 33.6096], [-117.11136, 33.6097], [-117.11115, 33.60931], [-117.11144, 33.60917], [-117.11189, 33.6092], [-117.1119, 33.60926], [-117.11195, 33.60932]]]} Open Access 1 Kona Park https://www.gorecreation.org/kona-park 32900 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 0.69 Kona Park  
1200 1200 1199 {"type": "Polygon", "coordinates": [[[-117.10295, 33.61494], [-117.10289, 33.61502], [-117.10284, 33.61516], [-117.10178, 33.61637], [-117.10172, 33.6164], [-117.10165, 33.61642], [-117.10128, 33.61638], [-117.10127, 33.6163], [-117.10121, 33.6163], [-117.10124, 33.61517], [-117.10122, 33.61452], [-117.10119, 33.61433], [-117.10114, 33.61419], [-117.10107, 33.61407], [-117.10076, 33.61419], [-117.10058, 33.6139], [-117.10062, 33.61381], [-117.10088, 33.61369], [-117.10141, 33.61349], [-117.10151, 33.61352], [-117.1018, 33.61394], [-117.10213, 33.61431], [-117.10251, 33.61463], [-117.10295, 33.61494]]]} Open Access 1 Brookfield Park https://www.gorecreation.org/brookfield-park 32890 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 8.254 Brookfield Park  
1202 1202 1201 {"type": "Polygon", "coordinates": [[[-117.10681, 33.57934], [-117.10568, 33.58036], [-117.1054, 33.58065], [-117.10534, 33.58066], [-117.10466, 33.58035], [-117.10443, 33.5802], [-117.10424, 33.58001], [-117.10415, 33.57986], [-117.1041, 33.57976], [-117.10486, 33.57954], [-117.10466, 33.57863], [-117.10506, 33.57859], [-117.10533, 33.57861], [-117.10559, 33.57865], [-117.10585, 33.57871], [-117.1061, 33.57881], [-117.10643, 33.57899], [-117.10681, 33.57929], [-117.10681, 33.57934]]]} Open Access 1 Crown Valley Park https://www.gorecreation.org/crown-valley-park 32894 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 8.008 Crown Valley Park  
1203 1203 1202 {"type": "Polygon", "coordinates": [[[-117.14273, 33.71059], [-117.14273, 33.71059], [-117.14015, 33.71058], [-117.1403, 33.71029], [-117.14052, 33.70999], [-117.14079, 33.70972], [-117.14111, 33.70949], [-117.14136, 33.70936], [-117.14176, 33.7092], [-117.14219, 33.70909], [-117.14264, 33.70905], [-117.14271, 33.70911], [-117.14273, 33.70959], [-117.14273, 33.71059]]]} Open Access 1 Discovery Park https://www.gorecreation.org/discovery 32895 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 7.305 Discovery Park  
1209 1209 1208 {"type": "Polygon", "coordinates": [[[-117.10627, 33.60302], [-117.10626, 33.60307], [-117.10592, 33.60338], [-117.10576, 33.60354], [-117.10416, 33.60291], [-117.10415, 33.60211], [-117.10504, 33.60211], [-117.1052, 33.60213], [-117.10535, 33.60218], [-117.10548, 33.60225], [-117.1056, 33.60233], [-117.10627, 33.60302]]]} Open Access 1 Emerald Park https://www.gorecreation.org/emerald-park 32896 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 5.022 Emerald Park  
1211 1211 1210 {"type": "Polygon", "coordinates": [[[-117.08558, 33.59306], [-117.08555, 33.59312], [-117.08555, 33.59329], [-117.08551, 33.59349], [-117.08543, 33.59368], [-117.08546, 33.59379], [-117.08528, 33.59388], [-117.08528, 33.59418], [-117.08394, 33.59423], [-117.08395, 33.59249], [-117.08487, 33.59316], [-117.08525, 33.59289], [-117.08558, 33.59306]]]} Open Access 1 Fieldview Park https://www.gorecreation.org/fieldview-park 32897 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 5.011 Fieldview Park  
1212 1212 1211 {"type": "Polygon", "coordinates": [[[-117.15388, 33.67064], [-117.15386, 33.67362], [-117.15375, 33.67366], [-117.15354, 33.67339], [-117.15343, 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.15208, 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.15113, 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.67307], [-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.14802, 33.67247], [-117.14822, 33.67254], [-117.14865, 33.67182], [-117.14797, 33.67065], [-117.14945, 33.67065], [-117.14949, 33.67069], [-117.14973, 33.67069], [-117.14978, 33.67065], [-117.15154, 33.67065], [-117.15159, 33.67069], [-117.15183, 33.67069], [-117.15188, 33.67065], [-117.15388, 33.67064]]]} Open Access 1 Lago Vista Sports Park https://www.gorecreation.org/lago-vista-sports-park 32901 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 28.463 Lago Vista Sports Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);