units_with_maps

Table actions

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

25 rows where ACCESS_TYP = 1 and LABEL_NAME = "Veterans Park"

This data as json, copyable, CSV (advanced)

DES_TP 1

ACCESS_TYP 1

  • Open Access · 25 ✖
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
292 292 291 {"type": "Polygon", "coordinates": [[[-117.74983, 33.98171], [-117.74983, 33.98173], [-117.74917, 33.98211], [-117.7487, 33.98234], [-117.74822, 33.9825], [-117.74765, 33.98266], [-117.74706, 33.98292], [-117.74679, 33.98308], [-117.74653, 33.98325], [-117.74634, 33.98341], [-117.74612, 33.98362], [-117.7458, 33.98398], [-117.74576, 33.984], [-117.74571, 33.98399], [-117.74532, 33.98373], [-117.74293, 33.9821], [-117.74291, 33.98201], [-117.74313, 33.98179], [-117.74377, 33.98124], [-117.74408, 33.98175], [-117.74983, 33.98171]]]} Open Access 1 47368 Veterans Park 31090 1054 Chino Hills, City of 119 City 2 City Agency 2 http://www.chinohills.org/index.aspx?nid=364 City 2 1054 Chino Hills, City of 116 City 2 City Agency 2 https://www.chinohills.org/index.aspx?NID=1083 San Bernardino 22 20.038 Veterans Park 0 Local Park 2 4
713 713 712 {"type": "Polygon", "coordinates": [[[-120.37829, 36.76067], [-120.37707, 36.76066], [-120.37707, 36.76016], [-120.37826, 36.76016], [-120.37829, 36.76067]]]} Open Access 1 4089 Veterans Park 27047 1201 Mendota, City of 243 City 2 City Agency 2 http://www.thecityofmendota.com/ City 2 1201 Mendota, City of 239 City 2 City Agency 2   Fresno 9 1.495 Veterans Park 0 Local Park 2 4
1623 1623 1622 {"type": "MultiPolygon", "coordinates": [[[[-121.76002, 37.62547], [-121.75891, 37.62692], [-121.75782, 37.62729], [-121.7578, 37.62944], [-121.75603, 37.62944], [-121.75664, 37.62567], [-121.75676, 37.62564], [-121.75689, 37.62563], [-121.75801, 37.62572], [-121.75818, 37.62571], [-121.75834, 37.62568], [-121.75847, 37.62564], [-121.75886, 37.62539], [-121.75908, 37.62537], [-121.75959, 37.62536], [-121.75981, 37.62539], [-121.76002, 37.62547]]], [[[-121.76102, 37.62522], [-121.76058, 37.62534], [-121.75976, 37.62497], [-121.75962, 37.62497], [-121.75926, 37.62501], [-121.759, 37.62509], [-121.75884, 37.62516], [-121.75851, 37.62537], [-121.7584, 37.62541], [-121.75689, 37.62534], [-121.7567, 37.62535], [-121.75686, 37.62434], [-121.75799, 37.62352], [-121.76017, 37.6241], [-121.76102, 37.62522]]]]} Open Access 1 12392 Veterans Park 27055 2062 Livermore Area Recreation and Park District 394 Special District 4 Recreation/Parks District 4 http://www.larpd.dst.ca.us/ Special District 4 2062 Livermore Area Recreation and Park District 388 Special District 4 Recreation/Parks District 4   Alameda 17 32.099 Veterans Park 0 Local Park 2 4
1664 1664 1663 {"type": "Polygon", "coordinates": [[[-117.66247, 33.50051], [-117.66214, 33.5005], [-117.66213, 33.50023], [-117.66244, 33.50023], [-117.66247, 33.50051]]]} Open Access 1 12572 Veterans Park 27049 1305 San Juan Capistrano, City of 92 City 2 City Agency 2 http://www.sanjuancapistrano.org/ City 2 1305 San Juan Capistrano, City of 90 City 2 City Agency 2   Orange 3 0.221 Veterans Park 0 Local Park 2 4
1954 1954 1953 {"type": "Polygon", "coordinates": [[[-118.31255, 33.79028], [-118.31254, 33.79061], [-118.31223, 33.79061], [-118.31231, 33.79039], [-118.31239, 33.79027], [-118.31255, 33.79028]]]} Open Access 1 6049 Veterans Park 27044 1182 Lomita, City of 461 City 2 City Agency 2 http://www.lomita.com/cityhall/government/parksrec/index.cfm City 2 1182 Lomita, City of 454 City 2 City Agency 2   Los Angeles 6 0.213 Veterans Park 0 Local Park 2 4
2037 2037 2036 {"type": "Polygon", "coordinates": [[[-120.57652, 37.35744], [-120.57649, 37.36043], [-120.57413, 37.36044], [-120.57417, 37.35745], [-120.57652, 37.35744]]]} Open Access 1 17077 Veterans Park 27037 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 17.116 Veterans Park 0 Local Park 2 4
3387 3387 3386 {"type": "Polygon", "coordinates": [[[-118.00047, 33.89374], [-118.00045, 33.89377], [-118.00016, 33.8936], [-118.00012, 33.89349], [-118.00029, 33.89322], [-118.00031, 33.89322], [-118.00047, 33.89374]]]} Open Access 1 20590 Veterans Park 29945 1158 La Mirada, City of 326 City 2 City Agency 2 http://www.cityoflamirada.org/index.aspx?page=58 City 2 1158 La Mirada, City of 323 City 2 City Agency 2   Los Angeles 6 0.237 Veterans Park 0 Local Park 2 4
3554 3554 3553 {"type": "MultiPolygon", "coordinates": [[[[-122.70254, 38.32202], [-122.70201, 38.32213], [-122.70186, 38.32157], [-122.70192, 38.32147], [-122.702, 38.32145], [-122.70214, 38.32149], [-122.70254, 38.32202]]], [[[-122.70361, 38.32353], [-122.70356, 38.32361], [-122.70331, 38.32364], [-122.70263, 38.32311], [-122.70274, 38.32308], [-122.70314, 38.32282], [-122.70361, 38.32353]]]]} Open Access 1 8520 Veterans Park 27040 1072 Cotati, City of 356 City 2 City Agency 2 http://www.ci.cotati.ca.us/ City 2 1072 Cotati, City of 353 City 2 City Agency 2   Sonoma 16 1.495 Veterans Park 0 Local Park 2 4
4917 4917 4916 {"type": "Polygon", "coordinates": [[[-117.82853, 33.89184], [-117.82817, 33.89197], [-117.828, 33.89201], [-117.82759, 33.89206], [-117.82747, 33.89209], [-117.82732, 33.89215], [-117.82719, 33.89224], [-117.82688, 33.89253], [-117.82632, 33.89311], [-117.82612, 33.89323], [-117.82593, 33.89329], [-117.82571, 33.8933], [-117.82521, 33.89324], [-117.82534, 33.89321], [-117.82536, 33.89213], [-117.82549, 33.89178], [-117.8255, 33.89028], [-117.82852, 33.89025], [-117.82853, 33.89184]], [[-117.82741, 33.89046], [-117.82742, 33.89038], [-117.82737, 33.89037], [-117.82737, 33.89045], [-117.82741, 33.89046]]]} Open Access 1 47363 Veterans Park 31086 1384 Yorba Linda, City of 64 City 2 City Agency 2 http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services City 2 1384 Yorba Linda, City of 62 City 2 City Agency 2   Orange 3 17.975 Veterans Park 0 Local Park 2 4
5932 5932 5931 {"type": "Polygon", "coordinates": [[[-117.11641, 32.57702], [-117.1164, 32.57838], [-117.11598, 32.57839], [-117.11596, 32.57945], [-117.11578, 32.57946], [-117.11577, 32.58012], [-117.11487, 32.58012], [-117.1149, 32.57837], [-117.11543, 32.57837], [-117.11543, 32.57668], [-117.116, 32.57668], [-117.11601, 32.57702], [-117.11641, 32.57702]]]} Open Access 1 433 Veterans Park 27043 1143 Imperial Beach, City of 630 City 2 City Agency 2 http://www.imperialbeachca.gov/index.asp?Type=B_BASIC&SEC={9F232DF8-5366-4BA2-A4B8-8795196F6D81} City 2 1143 Imperial Beach, City of 619 City 2 City Agency 2 http://www.imperialbeachca.gov/index.asp?Type=B_BASIC&SEC={8813F723-7B3E-4608-89EF-0641B56A76A0} San Diego 4 8.487 Veterans Park 0 Local Park 2 4
6467 6467 6466 {"type": "Polygon", "coordinates": [[[-116.98167, 33.93103], [-116.98167, 33.93103], [-116.98149, 33.93126], [-116.98149, 33.93103], [-116.98167, 33.93103]]]} Open Access 1 39054 Veterans Park 27054 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 0.051 Veterans Park 0 Local Park 2 4
6925 6925 6924 {"type": "Polygon", "coordinates": [[[-118.40385, 34.01188], [-118.40381, 34.01194], [-118.40348, 34.01233], [-118.40257, 34.01348], [-118.4025, 34.01355], [-118.40247, 34.01355], [-118.40106, 34.0121], [-118.40102, 34.01202], [-118.40208, 34.01063], [-118.40218, 34.01051], [-118.40221, 34.0105], [-118.40366, 34.01169], [-118.40385, 34.01185], [-118.40385, 34.01188]]]} Open Access 1 5819 Veterans Park 27041 1075 Culver City, City of 18 City 2 City Agency 2 http://www.culvercity.org/Home/Government/PRCS City 2 1075 Culver City, City of 18 City 2 City Agency 2   Los Angeles 6 11.254 Veterans Park 0 Local Park 2 4
6926 6926 6925 {"type": "Polygon", "coordinates": [[[-117.3237, 34.05663], [-117.32365, 34.05787], [-117.32332, 34.05783], [-117.32332, 34.05954], [-117.32168, 34.05931], [-117.32168, 34.05665], [-117.3237, 34.05663]]]} Open Access 1 5820 Veterans Park 27039 1062 Colton, City of 166 City 2 City Agency 2 http://www.ci.colton.ca.us/index.aspx?NID=136 City 2 1062 Colton, City of 162 City 2 City Agency 2   San Bernardino 22 12.608 Veterans Park 0 Local Park 2 4
7060 7060 7059 {"type": "Polygon", "coordinates": [[[-118.39016, 33.83762], [-118.3901, 33.83809], [-118.39011, 33.83828], [-118.38943, 33.8384], [-118.38927, 33.83835], [-118.38905, 33.83822], [-118.38874, 33.8381], [-118.38848, 33.83805], [-118.38825, 33.83803], [-118.3882, 33.83799], [-118.3882, 33.83797], [-118.38822, 33.83796], [-118.38818, 33.83755], [-118.38853, 33.83753], [-118.38853, 33.83748], [-118.38861, 33.83736], [-118.38858, 33.83687], [-118.38873, 33.83674], [-118.38844, 33.83659], [-118.38857, 33.83643], [-118.38878, 33.83623], [-118.38948, 33.83623], [-118.38949, 33.83646], [-118.38952, 33.83644], [-118.38956, 33.83627], [-118.38974, 33.83628], [-118.38984, 33.83639], [-118.38996, 33.83657], [-118.39003, 33.83675], [-118.39016, 33.83762]], [[-118.3886, 33.8377], [-118.38858, 33.83767], [-118.3883, 33.83774], [-118.38837, 33.8379], [-118.38843, 33.83798], [-118.38868, 33.83786], [-118.3886, 33.8377]]]} Open Access 1 6058 Veterans Park 27048 1270 Redondo Beach, City of 246 City 2 City Agency 2 http://www.redondo.org City 2 1270 Redondo Beach, City of 242 City 2 City Agency 2   Los Angeles 6 7.833 Veterans Park 0 Local Park 2 4
7350 7350 7349 {"type": "Polygon", "coordinates": [[[-118.19306, 33.80927], [-118.19306, 33.8111], [-118.19251, 33.81108], [-118.19251, 33.8112], [-118.19208, 33.81133], [-118.1906, 33.80809], [-118.19282, 33.80809], [-118.19281, 33.80926], [-118.19306, 33.80927]]]} Open Access 1 6672 Veterans Park 27045 1184 Long Beach, City of 298 City 2 City Agency 2 http://www.longbeach.gov/park/default.asp City 2 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 13.027 Veterans Park 0 Local Park 2 4
8742 8742 8741 {"type": "Polygon", "coordinates": [[[-122.35871, 38.39761], [-122.35871, 38.39767], [-122.35865, 38.39772], [-122.35811, 38.39792], [-122.35807, 38.39793], [-122.35799, 38.39791], [-122.35792, 38.39787], [-122.35784, 38.39777], [-122.35623, 38.39547], [-122.35621, 38.39542], [-122.35622, 38.39539], [-122.35627, 38.39535], [-122.35632, 38.39535], [-122.3564, 38.39542], [-122.35871, 38.39761]]]} Open Access 1 14194 Veterans Park 27051 1385 Yountville, Town of 730 City 2 City Agency 2 http://www.townofyountville.com/index.aspx?page=88 City 2 1385 Yountville, Town of 714 City 2 City Agency 2   Napa 11 3.625 Veterans Park 0 Local Park 2 4
9074 9074 9073 {"type": "Polygon", "coordinates": [[[-118.1768, 33.97511], [-118.17654, 33.97677], [-118.17578, 33.97669], [-118.17603, 33.97503], [-118.1768, 33.97511]]]} Open Access 1 15020 Veterans Park 27038 1022 Bell, City of 336 City 2 City Agency 2 http://www.cityofbell.org/?navid=118 City 2 1022 Bell, City of 333 City 2 City Agency 2   Los Angeles 6 3.254 Veterans Park 0 Local Park 2 4
9595 9595 9594 {"type": "Polygon", "coordinates": [[[-121.60752, 39.13829], [-121.60735, 39.13835], [-121.60706, 39.13815], [-121.60737, 39.13805], [-121.60752, 39.13829]]]} Open Access 1 16136 Veterans Park 27052 1386 Yuba City, City of 441 City 2 City Agency 2 http://www.yubacity.net/city-services/parks-and-recreation.html City 2 1386 Yuba City, City of 435 City 2 City Agency 2   Sutter 47 0.169 Veterans 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
10890 10890 10889 {"type": "Polygon", "coordinates": [[[-121.59502, 39.14086], [-121.5938, 39.14097], [-121.59368, 39.14007], [-121.59489, 39.13998], [-121.59502, 39.14086]]]} Open Access 1 20792 Veterans Park 27046 1199 Marysville, City of 539 City 2 City Agency 2 http://www.marysville.ca.us/index.php/city-services/parks-facilities City 2 1199 Marysville, City of 532 City 2 City Agency 2   Yuba 25 2.601 Veterans 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]);