units_with_maps

Table actions

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

40 rows where AGNCY_TYP = 2, DES_TP = 2 and MNG_AGENCY = 63

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

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
170 170 169 {"type": "Polygon", "coordinates": [[[-117.58627, 33.90811], [-117.58528, 33.90901], [-117.58385, 33.90792], [-117.58354, 33.90818], [-117.5835, 33.90816], [-117.58331, 33.90801], [-117.58316, 33.90784], [-117.5829, 33.90754], [-117.58289, 33.90749], [-117.58296, 33.90754], [-117.58312, 33.90759], [-117.58324, 33.90761], [-117.5834, 33.90761], [-117.58342, 33.90763], [-117.58365, 33.90757], [-117.58376, 33.90752], [-117.58409, 33.90744], [-117.58489, 33.90781], [-117.58627, 33.90811]]]} Open Access 1 453 Fairview Park 18816 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 5.215 Fairview Park 0 Local Park 2 4
253 253 252 {"type": "Polygon", "coordinates": [[[-117.6439, 33.87882], [-117.64373, 33.87913], [-117.64378, 33.8793], [-117.64325, 33.8791], [-117.64291, 33.87813], [-117.64282, 33.87707], [-117.64245, 33.87673], [-117.64226, 33.87545], [-117.64241, 33.87503], [-117.6425, 33.87503], [-117.6428, 33.87538], [-117.64305, 33.87624], [-117.64304, 33.87702], [-117.6435, 33.87842], [-117.64387, 33.8787], [-117.6439, 33.87882]]]} Open Access 1 703 Fresno Park 19112 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 5.323 Fresno Park 0 Local Park 2 4
600 600 599 {"type": "Polygon", "coordinates": [[[-117.57342, 33.86906], [-117.57322, 33.87045], [-117.57284, 33.87041], [-117.57283, 33.87039], [-117.57278, 33.8704], [-117.57229, 33.87035], [-117.5725, 33.86899], [-117.57299, 33.86904], [-117.57299, 33.86906], [-117.57303, 33.86907], [-117.57305, 33.86902], [-117.57342, 33.86906]]]} Open Access 1 2051 Husted Park 20160 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 3.286 Husted Park 0 Local Park 2 4
625 625 624 {"type": "Polygon", "coordinates": [[[-117.55597, 33.83411], [-117.55531, 33.83547], [-117.55479, 33.83646], [-117.55375, 33.83618], [-117.55329, 33.83601], [-117.55276, 33.83579], [-117.55424, 33.83354], [-117.55458, 33.83373], [-117.55476, 33.83382], [-117.55496, 33.83389], [-117.55532, 33.834], [-117.55597, 33.83411]]]} Open Access 1 2399 Jameson Park 20356 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 13.04 Jameson Park 0 Local Park 2 4
664 664 663 {"type": "Polygon", "coordinates": [[[-117.59945, 33.85865], [-117.59934, 33.85933], [-117.59747, 33.85914], [-117.59758, 33.85844], [-117.59802, 33.85852], [-117.59872, 33.8586], [-117.59945, 33.85865]]]} Open Access 1 5052 Mangular Park 21745 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 3.259 Mangular Park 0 Local Park 2 4
852 852 851 {"type": "Polygon", "coordinates": [[[-117.60221, 33.86687], [-117.60181, 33.86723], [-117.60156, 33.86749], [-117.60079, 33.86818], [-117.60075, 33.86793], [-117.60069, 33.86782], [-117.59982, 33.86689], [-117.59977, 33.86682], [-117.59967, 33.86657], [-117.59954, 33.86639], [-117.59934, 33.86623], [-117.59908, 33.86608], [-117.59894, 33.86592], [-117.59888, 33.86578], [-117.59885, 33.86567], [-117.59885, 33.86552], [-117.5989, 33.8653], [-117.59892, 33.8651], [-117.59891, 33.86486], [-117.59884, 33.86457], [-117.59876, 33.86435], [-117.59882, 33.8643], [-117.60221, 33.86687]]]} Open Access 1 5511 Brentwood Park 16357 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 13.042 Brentwood Park 0 Local Park 2 4
1078 1078 1077 {"type": "Polygon", "coordinates": [[[-117.57751, 33.84415], [-117.57745, 33.84458], [-117.57741, 33.84466], [-117.57731, 33.84478], [-117.57728, 33.84484], [-117.57731, 33.84492], [-117.57738, 33.84498], [-117.57734, 33.8453], [-117.57585, 33.84516], [-117.57613, 33.84334], [-117.57618, 33.84334], [-117.57617, 33.84345], [-117.57612, 33.84363], [-117.57612, 33.84368], [-117.57618, 33.84379], [-117.57626, 33.84383], [-117.57623, 33.84413], [-117.57666, 33.84413], [-117.5769, 33.8441], [-117.57751, 33.84415]]]} Open Access 1 5668 Heritage Park 19846 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 4.401 Heritage Park 0 Local Park 2 4
1375 1375 1374 {"type": "Polygon", "coordinates": [[[-117.60688, 33.85681], [-117.60632, 33.85768], [-117.60592, 33.85751], [-117.60571, 33.85789], [-117.60568, 33.85771], [-117.60539, 33.85751], [-117.60642, 33.85657], [-117.60688, 33.85681]]]} Open Access 1 8355 Border Park 16280 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 2.094 Border Park 0 Local Park 2 4
1419 1419 1418 {"type": "Polygon", "coordinates": [[[-117.52089, 33.89504], [-117.52051, 33.89526], [-117.52025, 33.89543], [-117.52003, 33.89563], [-117.51988, 33.89583], [-117.51963, 33.89603], [-117.51946, 33.8964], [-117.51944, 33.89665], [-117.51935, 33.89664], [-117.51924, 33.89664], [-117.51907, 33.89657], [-117.51879, 33.89672], [-117.51866, 33.89672], [-117.5168, 33.89447], [-117.51733, 33.89416], [-117.51738, 33.89416], [-117.51743, 33.89419], [-117.51752, 33.89414], [-117.51753, 33.89413], [-117.51749, 33.89408], [-117.51896, 33.8931], [-117.51901, 33.89309], [-117.51907, 33.89312], [-117.51956, 33.89371], [-117.51962, 33.89368], [-117.51969, 33.89383], [-117.51992, 33.89385], [-117.52065, 33.89474], [-117.52068, 33.89484], [-117.5208, 33.89492], [-117.52089, 33.89504]]]} Open Access 1 8979 Promenade Community Park 24015 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 19.689 Promenade Community Park 0 Local Park 2 4
1444 1444 1443 {"type": "Polygon", "coordinates": [[[-117.5709, 33.87806], [-117.57077, 33.87892], [-117.56973, 33.8788], [-117.56987, 33.87795], [-117.5709, 33.87806]]]} Open Access 1 12506 Sheridan Park 25392 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 2.287 Sheridan Park 0 Local Park 2 4
1539 1539 1538 {"type": "Polygon", "coordinates": [[[-117.53832, 33.81273], [-117.53832, 33.81364], [-117.53826, 33.81383], [-117.53798, 33.81379], [-117.53768, 33.8138], [-117.53741, 33.81385], [-117.53711, 33.81395], [-117.53707, 33.81395], [-117.53677, 33.81359], [-117.53649, 33.81331], [-117.5365, 33.81326], [-117.53675, 33.81299], [-117.53689, 33.8128], [-117.53703, 33.81256], [-117.5371, 33.81243], [-117.53832, 33.81273]]]} Open Access 1 12958 Spyglass Park 25759 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 5.013 Spyglass Park 0 Local Park 2 4
1662 1662 1661 {"type": "Polygon", "coordinates": [[[-117.58127, 33.8523], [-117.58105, 33.85375], [-117.57845, 33.85277], [-117.57858, 33.85185], [-117.57868, 33.85158], [-117.57872, 33.85157], [-117.57878, 33.85138], [-117.58127, 33.8523]]]} Open Access 1 12566 Buena Vista Neighborhood Park 16490 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 9.968 Buena Vista Neighborhood Park 0 Local Park 2 4
2544 2544 2543 {"type": "Polygon", "coordinates": [[[-117.6095, 33.88962], [-117.6076, 33.89127], [-117.6075, 33.8913], [-117.60728, 33.8913], [-117.60713, 33.89124], [-117.60607, 33.8904], [-117.60678, 33.89012], [-117.60849, 33.88948], [-117.60898, 33.88928], [-117.60903, 33.88925], [-117.60907, 33.88926], [-117.6095, 33.88962]]]} Open Access 1 17788 Clearwater Park 17416 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 7.81 Clearwater Park 0 Local Park 2 4
2652 2652 2651 {"type": "Polygon", "coordinates": [[[-117.57659, 33.88504], [-117.57659, 33.88504], [-117.57652, 33.88547], [-117.57638, 33.88542], [-117.57645, 33.88499], [-117.57659, 33.88504]]]} Open Access 1 18124 Contreras Park 17609 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 0.162 Contreras Park 0 Local Park 2 4
2700 2700 2699 {"type": "Polygon", "coordinates": [[[-117.53678, 33.88883], [-117.53627, 33.89037], [-117.53499, 33.89006], [-117.53552, 33.88853], [-117.53678, 33.88883]]]} Open Access 1 18283 Cresta Verde Park 17804 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 5.334 Cresta Verde Park 0 Local Park 2 4
2867 2867 2866 {"type": "Polygon", "coordinates": [[[-117.53403, 33.81452], [-117.53381, 33.8147], [-117.53285, 33.81636], [-117.53282, 33.81686], [-117.53209, 33.81689], [-117.53207, 33.81691], [-117.53166, 33.81689], [-117.53138, 33.81684], [-117.5312, 33.81679], [-117.53061, 33.81651], [-117.53073, 33.81636], [-117.53088, 33.81612], [-117.53106, 33.81571], [-117.53112, 33.81549], [-117.53118, 33.81518], [-117.5312, 33.81496], [-117.5312, 33.81465], [-117.53124, 33.81462], [-117.53374, 33.81438], [-117.53375, 33.81446], [-117.53381, 33.81452], [-117.53403, 33.81452]]]} Open Access 1 18848 Eagle Glen Community Park 18338 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 13.491 Eagle Glen Community Park 0 Local Park 2 4
5268 5268 5267 {"type": "Polygon", "coordinates": [[[-117.54184, 33.89563], [-117.5395, 33.8956], [-117.53951, 33.89539], [-117.53954, 33.89522], [-117.53962, 33.89503], [-117.53972, 33.89488], [-117.53985, 33.89475], [-117.54183, 33.89475], [-117.54184, 33.89563]]]} Open Access 1 47378 Village Park 31101 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2 http://www.discovercoronadwp.com/parkmaint/parks/village-park.html Riverside 10 4.922 Village Park 0 Local Park 2 4
5275 5275 5274 {"type": "Polygon", "coordinates": [[[-117.56206, 33.8703], [-117.562, 33.87064], [-117.56159, 33.87059], [-117.56181, 33.87043], [-117.56206, 33.8703]]]} Open Access 1 2579 Joy Park 20509 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 0.193 Joy Park 0 Local Park 2 4
5370 5370 5369 {"type": "MultiPolygon", "coordinates": [[[[-117.58559, 33.86101], [-117.58543, 33.86198], [-117.58517, 33.8638], [-117.58405, 33.86369], [-117.58408, 33.86366], [-117.58427, 33.86229], [-117.58268, 33.86215], [-117.58293, 33.86072], [-117.58559, 33.86101]]], [[[-117.58666, 33.86138], [-117.58649, 33.86245], [-117.5863, 33.8639], [-117.58547, 33.86381], [-117.58544, 33.86377], [-117.58568, 33.86217], [-117.58583, 33.8613], [-117.58666, 33.86138]]]]} Open Access 1 5695 Lincoln Park 21262 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 19.187 Lincoln Park 0 Local Park 2 4
5572 5572 5571 {"type": "Polygon", "coordinates": [[[-117.55856, 33.87575], [-117.5572, 33.87574], [-117.5572, 33.8763], [-117.55352, 33.8763], [-117.55351, 33.8759], [-117.55342, 33.8759], [-117.55343, 33.87542], [-117.55341, 33.87468], [-117.55718, 33.87468], [-117.5572, 33.87518], [-117.55855, 33.8752], [-117.55856, 33.87575]]]} Open Access 1 47375 City Park 31099 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 17.348 City 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]);