units_with_maps

Table actions

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

37 rows where COUNTY = 10, DES_TP = 2 and MNG_AGENCY = 356

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Temecula, City of · 37 ✖

DES_TP 1

  • Local Park · 37 ✖

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
1402 1402 1401 {"type": "Polygon", "coordinates": [[[-117.08454, 33.47208], [-117.0844, 33.47245], [-117.0842, 33.47242], [-117.08399, 33.47242], [-117.08296, 33.47253], [-117.08286, 33.47192], [-117.0832, 33.47194], [-117.08362, 33.47192], [-117.084, 33.47187], [-117.08447, 33.47176], [-117.08454, 33.47208]]]} Open Access 1 24672 Pablo Apis Park 23288 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 2.311 Pablo Apis Park 0 Local Park 2 4
2514 2514 2513 {"type": "Polygon", "coordinates": [[[-117.14777, 33.48896], [-117.14754, 33.48901], [-117.1464, 33.48571], [-117.14663, 33.48566], [-117.14777, 33.48896]]]} Open Access 1 19949 Rotary Park 24698 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 2.063 Rotary Park 0 Local Park 2 4
2850 2850 2849 {"type": "Polygon", "coordinates": [[[-117.13628, 33.53783], [-117.1363, 33.53802], [-117.13629, 33.53814], [-117.13615, 33.53855], [-117.13606, 33.53872], [-117.13577, 33.53862], [-117.13556, 33.53846], [-117.13547, 33.53844], [-117.13542, 33.53845], [-117.13535, 33.53849], [-117.13532, 33.53853], [-117.13532, 33.53858], [-117.13521, 33.53864], [-117.13517, 33.53863], [-117.1351, 33.53885], [-117.13473, 33.53879], [-117.13436, 33.53867], [-117.13439, 33.5383], [-117.13445, 33.53824], [-117.13628, 33.53783]]]} Open Access 1 22139 Nicholas Road Park 22746 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 2.913 Nicholas Road Park 0 Local Park 2 4
2851 2851 2850 {"type": "Polygon", "coordinates": [[[-117.13417, 33.5384], [-117.13414, 33.53866], [-117.13392, 33.5387], [-117.13353, 33.53869], [-117.13336, 33.53866], [-117.1325, 33.5387], [-117.13407, 33.53834], [-117.13417, 33.5384]]]} Open Access 1 22140 Voorburg Park 27197 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 0.728 Voorburg Park 0 Local Park 2 4
2939 2939 2938 {"type": "Polygon", "coordinates": [[[-117.11174, 33.54046], [-117.11064, 33.54088], [-117.11044, 33.54051], [-117.11037, 33.5403], [-117.11029, 33.54023], [-117.11017, 33.5402], [-117.10995, 33.54022], [-117.10945, 33.54022], [-117.1094, 33.54018], [-117.10941, 33.54007], [-117.10945, 33.53995], [-117.1102, 33.53848], [-117.1105, 33.53856], [-117.11048, 33.53876], [-117.1105, 33.53919], [-117.11049, 33.53969], [-117.11064, 33.53993], [-117.11174, 33.54046]]]} Open Access 1 19942 Riverton Park 24461 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 4.979 Riverton Park 0 Local Park 2 4
3059 3059 3058 {"type": "Polygon", "coordinates": [[[-117.15257, 33.54356], [-117.15135, 33.5445], [-117.15049, 33.54371], [-117.1517, 33.54277], [-117.15257, 33.54356]]]} Open Access 1 24680 Winchester Creek Park 27617 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 4.498 Winchester Creek Park 0 Local Park 2 4
3398 3398 3397 {"type": "Polygon", "coordinates": [[[-117.09041, 33.45956], [-117.08996, 33.45999], [-117.08989, 33.46], [-117.08897, 33.45931], [-117.08964, 33.45898], [-117.09041, 33.45956]]]} Open Access 1 24673 Paseo Gallante Park 23497 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 1.822 Paseo Gallante Park 0 Local Park 2 4
4132 4132 4131 {"type": "Polygon", "coordinates": [[[-117.07627, 33.4742], [-117.07537, 33.47446], [-117.07523, 33.47432], [-117.07478, 33.47396], [-117.07499, 33.47382], [-117.07522, 33.47371], [-117.07546, 33.47361], [-117.07588, 33.47347], [-117.07599, 33.47351], [-117.07627, 33.4742]]]} Open Access 1 47167 Stephen Linen Jr. Memorial Park 30852 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2 http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/StephenLinenJrMemorialPark.htm Riverside 10 2.187 Stephen Linen Jr. Memorial Park 0 Local Park 2 4
4133 4133 4132 {"type": "Polygon", "coordinates": [[[-117.10489, 33.52993], [-117.10489, 33.52993], [-117.10464, 33.5314], [-117.10454, 33.53111], [-117.10447, 33.53097], [-117.10391, 33.53015], [-117.10394, 33.53007], [-117.10426, 33.52989], [-117.10456, 33.52969], [-117.10484, 33.52947], [-117.1049, 33.52951], [-117.10493, 33.52956], [-117.10492, 33.5296], [-117.10487, 33.52967], [-117.10489, 33.5297], [-117.10483, 33.52975], [-117.10481, 33.52981], [-117.10483, 33.52988], [-117.10489, 33.52993]]]} Open Access 1 47168 Serena Hills Park 30855 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2 http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/SerenaHillsPark.htm Riverside 10 2.237 Serena Hills Park 0 Local Park 2 4
10707 10707 10706 {"type": "Polygon", "coordinates": [[[-117.11049, 33.47644], [-117.11016, 33.47649], [-117.10983, 33.47658], [-117.10978, 33.47649], [-117.10973, 33.47622], [-117.10966, 33.47605], [-117.11027, 33.47583], [-117.11049, 33.47644]]]} Open Access 1 19945 John Magee Park 20454 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 1.004 John Magee Park 0 Local Park 2 4
10727 10727 10726 {"type": "Polygon", "coordinates": [[[-117.12176, 33.51628], [-117.12161, 33.51668], [-117.12156, 33.51689], [-117.12153, 33.5171], [-117.12152, 33.51731], [-117.12153, 33.51752], [-117.12166, 33.51861], [-117.12166, 33.51883], [-117.1216, 33.51921], [-117.12154, 33.51939], [-117.12138, 33.51971], [-117.12105, 33.52013], [-117.12081, 33.52035], [-117.12045, 33.52058], [-117.12027, 33.51798], [-117.12028, 33.51762], [-117.12038, 33.51558], [-117.12172, 33.51621], [-117.12176, 33.51628]]]} Open Access 1 19943 Veterans Park 27053 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 13.721 Veterans Park 0 Local Park 2 4
10730 10730 10729 {"type": "Polygon", "coordinates": [[[-117.11883, 33.47183], [-117.11881, 33.47215], [-117.11854, 33.47215], [-117.11859, 33.47236], [-117.11831, 33.47245], [-117.11803, 33.47263], [-117.11786, 33.47257], [-117.11659, 33.47255], [-117.11712, 33.4707], [-117.11736, 33.47089], [-117.11786, 33.4712], [-117.11811, 33.47138], [-117.11835, 33.47165], [-117.11847, 33.47191], [-117.11877, 33.47183], [-117.11883, 33.47183]]]} Open Access 1 19947 Pala Community Park 23324 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 6.204 Pala Community Park 0 Local Park 2 4
11337 11337 11336 {"type": "Polygon", "coordinates": [[[-117.14724, 33.50857], [-117.14673, 33.50922], [-117.14464, 33.51176], [-117.14419, 33.51166], [-117.14335, 33.51155], [-117.14327, 33.5087], [-117.14724, 33.50857]]]} Open Access 1 22138 Margarita Community Park 21804 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 20.371 Margarita Community Park 0 Local Park 2 4
11351 11351 11350 {"type": "Polygon", "coordinates": [[[-117.10801, 33.46849], [-117.10772, 33.46877], [-117.10777, 33.46892], [-117.10753, 33.4688], [-117.10734, 33.46872], [-117.10704, 33.46862], [-117.10696, 33.4686], [-117.10693, 33.46872], [-117.10732, 33.46885], [-117.10764, 33.469], [-117.10757, 33.46905], [-117.10746, 33.46925], [-117.10715, 33.46966], [-117.10693, 33.46989], [-117.1067, 33.4697], [-117.1064, 33.46989], [-117.10623, 33.46997], [-117.10552, 33.47017], [-117.10529, 33.47014], [-117.10436, 33.46922], [-117.10495, 33.46856], [-117.10552, 33.46853], [-117.1059, 33.46854], [-117.10626, 33.46858], [-117.10662, 33.46864], [-117.10662, 33.46862], [-117.10627, 33.46816], [-117.10631, 33.4681], [-117.10696, 33.46824], [-117.1073, 33.46834], [-117.10762, 33.46841], [-117.1078, 33.46848], [-117.10801, 33.46849]]]} Open Access 1 22133 Kent Hintergardt Park 20618 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 10.603 Kent Hintergardt Park 0 Local Park 2 4
11354 11354 11353 {"type": "MultiPolygon", "coordinates": [[[[-117.11599, 33.46106], [-117.11574, 33.46129], [-117.11556, 33.46115], [-117.11541, 33.46097], [-117.11535, 33.46094], [-117.11528, 33.46094], [-117.11525, 33.46092], [-117.11581, 33.4604], [-117.11594, 33.4605], [-117.1159, 33.46055], [-117.1159, 33.46061], [-117.11593, 33.46067], [-117.11597, 33.46071], [-117.11577, 33.4609], [-117.11599, 33.46106]]], [[[-117.11583, 33.46164], [-117.11582, 33.4617], [-117.11559, 33.46182], [-117.1155, 33.46171], [-117.11575, 33.46154], [-117.11583, 33.46164]]], [[[-117.1169, 33.46281], [-117.11663, 33.46291], [-117.1164, 33.46307], [-117.11633, 33.46307], [-117.11625, 33.46301], [-117.11649, 33.46273], [-117.11645, 33.46267], [-117.11623, 33.46263], [-117.11609, 33.46256], [-117.1159, 33.46244], [-117.1157, 33.46211], [-117.11561, 33.46201], [-117.11591, 33.46184], [-117.11597, 33.46186], [-117.11624, 33.4623], [-117.1163, 33.46233], [-117.11636, 33.46234], [-117.11647, 33.4623], [-117.11674, 33.46255], [-117.11681, 33.46253], [-117.1169, 33.46281]]], [[[-117.1174, 33.46295], [-117.11732, 33.46333], [-117.11706, 33.46324], [-117.11694, 33.46328], [-117.11684, 33.46334], [-117.11662, 33.46312], [-117.11679, 33.46302], [-117.11699, 33.46296], [-117.1172, 33.46294], [-117.1174, 33.46295]]]]} Open Access 1 22135 Loma Linda Park 21404 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 2.824 Loma Linda Park 0 Local Park 2 4
11355 11355 11354 {"type": "Polygon", "coordinates": [[[-117.15188, 33.49686], [-117.15163, 33.49762], [-117.15159, 33.4976], [-117.15143, 33.49804], [-117.15136, 33.49802], [-117.15092, 33.49756], [-117.15013, 33.49809], [-117.15002, 33.49794], [-117.15099, 33.4971], [-117.15102, 33.49711], [-117.15113, 33.49701], [-117.15094, 33.49684], [-117.15137, 33.49681], [-117.15137, 33.49683], [-117.15167, 33.49683], [-117.15188, 33.49686]]]} Open Access 1 22136 Sam Hicks Monument Park 24817 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 2.612 Sam Hicks Monument Park 0 Local Park 2 4
12000 12000 11999 {"type": "Polygon", "coordinates": [[[-117.11583, 33.50748], [-117.11567, 33.50773], [-117.11554, 33.50786], [-117.11541, 33.50795], [-117.11516, 33.50761], [-117.11542, 33.50749], [-117.11557, 33.50746], [-117.11583, 33.50748]]]} Open Access 1 24660 Bahia Vista Park 15757 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 0.448 Bahia Vista Park 0 Local Park 2 4
12001 12001 12000 {"type": "Polygon", "coordinates": [[[-117.07232, 33.49361], [-117.07254, 33.49376], [-117.07268, 33.49391], [-117.0728, 33.49405], [-117.07282, 33.49416], [-117.07282, 33.49428], [-117.0727, 33.49468], [-117.07266, 33.49507], [-117.07261, 33.49514], [-117.0725, 33.49519], [-117.07242, 33.49519], [-117.07234, 33.49515], [-117.07199, 33.49485], [-117.07171, 33.49426], [-117.07232, 33.49361]]]} Open Access 1 24661 Butterfield Stage Park 16610 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 2.798 Butterfield Stage Park 0 Local Park 2 4
12002 12002 12001 {"type": "Polygon", "coordinates": [[[-117.07528, 33.4991], [-117.07508, 33.49922], [-117.07485, 33.49926], [-117.07477, 33.49928], [-117.07472, 33.49934], [-117.07471, 33.49943], [-117.07466, 33.49937], [-117.07456, 33.4991], [-117.07455, 33.49897], [-117.07444, 33.49883], [-117.07437, 33.49867], [-117.07419, 33.49838], [-117.0741, 33.49817], [-117.07404, 33.49763], [-117.07405, 33.49747], [-117.07413, 33.49735], [-117.07447, 33.49703], [-117.07482, 33.49778], [-117.07483, 33.4979], [-117.07478, 33.49807], [-117.07479, 33.49817], [-117.07528, 33.4991]]]} Open Access 1 24663 Crown Hill Park 17836 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 3.554 Crown Hill Park 0 Local Park 2 4
12003 12003 12002 {"type": "Polygon", "coordinates": [[[-117.16228, 33.53348], [-117.16196, 33.53361], [-117.16192, 33.53368], [-117.16186, 33.53367], [-117.16178, 33.53369], [-117.16159, 33.5339], [-117.16119, 33.53413], [-117.16087, 33.53437], [-117.16082, 33.53437], [-117.16047, 33.5341], [-117.1602, 33.53392], [-117.15983, 33.53373], [-117.15956, 33.53364], [-117.15923, 33.53355], [-117.15881, 33.53349], [-117.15846, 33.53347], [-117.1581, 33.53348], [-117.15805, 33.53342], [-117.158, 33.53308], [-117.15795, 33.53289], [-117.15786, 33.53272], [-117.1577, 33.53248], [-117.15764, 33.53236], [-117.1576, 33.53218], [-117.15761, 33.53199], [-117.15771, 33.53184], [-117.15772, 33.53173], [-117.15782, 33.53171], [-117.15803, 33.53138], [-117.15884, 33.53175], [-117.15922, 33.53188], [-117.15974, 33.53197], [-117.1604, 33.53201], [-117.16064, 33.53206], [-117.16088, 33.53213], [-117.16125, 33.53228], [-117.16128, 33.53237], [-117.16155, 33.53251], [-117.1616, 33.53245], [-117.16184, 33.53253], [-117.16207, 33.53258], [-117.16212, 33.53263], [-117.16213, 33.53284], [-117.16217, 33.53307], [-117.16228, 33.53348]]]} Open Access 1 24664 Harveston Community Park 19726 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 19.649 Harveston Community Park 0 Local Park 2 4

Next page

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