units_with_maps

Table actions

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

33 rows where COUNTY = 10 and MNG_AGENCY = 218

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Jacinto, City of · 33 ✖

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
614 614 613 {"type": "Polygon", "coordinates": [[[-117.00547, 33.78338], [-117.00547, 33.78397], [-117.00477, 33.78398], [-117.00477, 33.78368], [-117.00472, 33.78364], [-117.00476, 33.78359], [-117.00478, 33.78353], [-117.00475, 33.78336], [-117.00522, 33.78336], [-117.00547, 33.78338]]]} Open Access 1 48399 Parkside Village 32966 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304572 Riverside 10 1.101 Parkside Village   None 60  
2940 2940 2939 {"type": "Polygon", "coordinates": [[[-116.9599, 33.78116], [-116.9599, 33.78189], [-116.95989, 33.78191], [-116.95986, 33.78192], [-116.95894, 33.78192], [-116.95894, 33.78116], [-116.9599, 33.78116]]]} Open Access 1 19957 Hofmann Park 32965 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2   Riverside 10 1.866 Hofmann Park 0 Local Park 2 4
3758 3758 3757 {"type": "MultiPolygon", "coordinates": [[[[-116.98153, 33.77753], [-116.98137, 33.77744], [-116.98119, 33.77737], [-116.981, 33.77733], [-116.98078, 33.77731], [-116.98075, 33.77726], [-116.98075, 33.77705], [-116.98097, 33.77713], [-116.98116, 33.77724], [-116.98153, 33.77753]]], [[[-116.98447, 33.78005], [-116.98386, 33.78005], [-116.9838, 33.78003], [-116.98378, 33.77999], [-116.98377, 33.7797], [-116.98375, 33.77957], [-116.98368, 33.77941], [-116.98355, 33.77922], [-116.98416, 33.77972], [-116.98447, 33.78005]]], [[[-116.98632, 33.77936], [-116.98628, 33.77942], [-116.98594, 33.77947], [-116.98594, 33.77914], [-116.98508, 33.77914], [-116.98507, 33.77777], [-116.98565, 33.77777], [-116.98566, 33.77785], [-116.98607, 33.77785], [-116.98609, 33.77888], [-116.98614, 33.77907], [-116.98632, 33.77936]]]]} Open Access 1 34898 Lynden Trail Park 21608 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2   Riverside 10 4.615 Lynden Trail Park 0 Local Park 2 4
3759 3759 3758 {"type": "Polygon", "coordinates": [[[-116.99361, 33.78554], [-116.99306, 33.78554], [-116.99289, 33.78542], [-116.9927, 33.78531], [-116.9924, 33.78518], [-116.99218, 33.78511], [-116.99217, 33.78509], [-116.99089, 33.78477], [-116.99087, 33.78479], [-116.98953, 33.78445], [-116.98952, 33.78232], [-116.98959, 33.78225], [-116.98983, 33.78225], [-116.98988, 33.78229], [-116.98988, 33.78255], [-116.9899, 33.78269], [-116.99017, 33.7837], [-116.99023, 33.78384], [-116.99037, 33.78404], [-116.99056, 33.78422], [-116.99068, 33.78431], [-116.9909, 33.78442], [-116.99125, 33.78452], [-116.99116, 33.7848], [-116.99224, 33.78506], [-116.99257, 33.78518], [-116.99259, 33.78518], [-116.99264, 33.78521], [-116.9927, 33.78523], [-116.99271, 33.78526], [-116.99296, 33.78541], [-116.99361, 33.78541], [-116.99361, 33.78554]]]} Open Access 1 34899 Bolander Park 16236 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2   Riverside 10 4.841 Bolander Park 0 Local Park 2 4
3842 3842 3841 {"type": "Polygon", "coordinates": [[[-117.01532, 33.78362], [-117.0139, 33.78363], [-117.01408, 33.7834], [-117.01418, 33.78331], [-117.01424, 33.78315], [-117.01446, 33.78269], [-117.0146, 33.78223], [-117.01465, 33.78198], [-117.01467, 33.78168], [-117.01467, 33.78078], [-117.0147, 33.78058], [-117.01466, 33.78048], [-117.01466, 33.78011], [-117.01522, 33.78011], [-117.01529, 33.78017], [-117.01532, 33.78362]]]} Open Access 1 45431 Catalpa Park 28229 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html Riverside 10 6.935 Catalpa Park 0 Local Park 2 4
3844 3844 3843 {"type": "Polygon", "coordinates": [[[-116.96921, 33.78085], [-116.96805, 33.78184], [-116.96692, 33.78091], [-116.96758, 33.78035], [-116.9692, 33.78035], [-116.96921, 33.78085]]]} Open Access 1 45450 Francisco Estudillo Heritage Park 28249 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html Riverside 10 5.384 Francisco Estudillo Heritage Park 0 Local Park 2 4
3976 3976 3975 {"type": "Polygon", "coordinates": [[[-116.94659, 33.76477], [-116.94658, 33.76514], [-116.94648, 33.76514], [-116.94647, 33.76484], [-116.94577, 33.76473], [-116.9458, 33.76466], [-116.94623, 33.76474], [-116.94659, 33.76477]]]} Open Access 1 48843 Rsi Park 33563 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 https://www.sanjacintoca.gov/community/parks_facilities/parks/r_s_i_park Riverside 10 0.23 Rsi Park 0 Local Park 2 4
4295 4295 4294 {"type": "Polygon", "coordinates": [[[-116.9907, 33.78992], [-116.98963, 33.78993], [-116.98956, 33.78986], [-116.98955, 33.78958], [-116.99016, 33.78958], [-116.99017, 33.78952], [-116.99033, 33.78964], [-116.9907, 33.78964], [-116.9907, 33.78992]]]} Open Access 1 45439 Stallions Crossings 28232 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html Riverside 10 0.94 Stallions Crossings   None 376  
4323 4323 4322 {"type": "Polygon", "coordinates": [[[-117.01978, 33.78361], [-117.01948, 33.78361], [-117.0194, 33.78364], [-117.01932, 33.78356], [-117.0192, 33.78352], [-117.01898, 33.78355], [-117.01865, 33.78354], [-117.0186, 33.7835], [-117.01861, 33.78297], [-117.01866, 33.78293], [-117.01896, 33.78293], [-117.01917, 33.78296], [-117.01926, 33.78295], [-117.01933, 33.78291], [-117.01935, 33.78292], [-117.01977, 33.78292], [-117.01978, 33.78361]]]} Open Access 1 45432 Terrazzo Park 28228 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html Riverside 10 1.882 Terrazzo Park 0 Local Park 2 4
4324 4324 4323 {"type": "Polygon", "coordinates": [[[-117.00334, 33.7746], [-117.00259, 33.7746], [-117.00259, 33.77419], [-117.00281, 33.77421], [-117.00289, 33.77419], [-117.00295, 33.77414], [-117.00302, 33.77419], [-117.00333, 33.77419], [-117.00334, 33.7746]]]} Open Access 1 45436 Solana II Park 28230 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html Riverside 10 0.776 Solana II Park 0 Local Park 2 4
4455 4455 4454 {"type": "Polygon", "coordinates": [[[-116.92363, 33.76592], [-116.92305, 33.7664], [-116.92281, 33.76619], [-116.92324, 33.76594], [-116.9234, 33.76582], [-116.92352, 33.76583], [-116.92363, 33.76592]]]} Open Access 1 48395 Belicia Park 32960 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304452 Riverside 10 0.472 Belicia Park 0 Local Park 2 4
4550 4550 4549 {"type": "Polygon", "coordinates": [[[-116.96087, 33.7857], [-116.9601, 33.7857], [-116.9601, 33.78506], [-116.96035, 33.78527], [-116.96087, 33.7857]]]} Open Access 1 24659 Druding Park 18276 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2   Riverside 10 0.63 Druding Park 0 Local Park 2 4
4792 4792 4791 {"type": "Polygon", "coordinates": [[[-116.96266, 33.79047], [-116.96174, 33.79124], [-116.96034, 33.79008], [-116.96121, 33.78934], [-116.96266, 33.79047]]]} Open Access 1 48267 Sallee Park 32819 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2   Riverside 10 5.326 Sallee Park 0 Local Park 2 4
4816 4816 4815 {"type": "Polygon", "coordinates": [[[-117.01983, 33.78712], [-117.01846, 33.78712], [-117.01837, 33.78705], [-117.01838, 33.78608], [-117.01843, 33.78604], [-117.019, 33.78604], [-117.01925, 33.78607], [-117.01936, 33.78603], [-117.01943, 33.78595], [-117.01981, 33.78608], [-117.01983, 33.78712]]]} Open Access 1 48837 Unknown park - San Jacinto, City of 33557 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2   Riverside 10 3.986   0 Local Other or Unknown 14 4
4841 4841 4840 {"type": "Polygon", "coordinates": [[[-116.95082, 33.76272], [-116.95023, 33.76243], [-116.95039, 33.76233], [-116.95042, 33.76227], [-116.95043, 33.76223], [-116.95039, 33.76215], [-116.94999, 33.76177], [-116.95014, 33.76153], [-116.95081, 33.76152], [-116.95082, 33.76272]]]} Open Access 1 48398 Hafliger Park 32964 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304536 Riverside 10 1.6 Hafliger Park 0 Local Park 2 4
5627 5627 5626 {"type": "MultiPolygon", "coordinates": [[[[-116.99518, 33.78996], [-116.99517, 33.79002], [-116.99479, 33.79022], [-116.99456, 33.78993], [-116.99375, 33.79008], [-116.99374, 33.78929], [-116.99403, 33.78928], [-116.99432, 33.7892], [-116.99449, 33.78959], [-116.99484, 33.78947], [-116.99493, 33.78961], [-116.99518, 33.78996]]], [[[-116.99698, 33.79061], [-116.99687, 33.79067], [-116.99675, 33.79077], [-116.99657, 33.79097], [-116.99628, 33.79097], [-116.99585, 33.79054], [-116.99511, 33.78955], [-116.99499, 33.78932], [-116.99493, 33.78906], [-116.99493, 33.78803], [-116.99698, 33.79061]]]]} Open Access 1 45438 Sandelwood Park 28231 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html Riverside 10 7.842 Sandelwood Park 0 Local Park 2 4
13923 13923 13922 {"type": "MultiPolygon", "coordinates": [[[[-116.93123, 33.79803], [-116.93092, 33.79811], [-116.93094, 33.79821], [-116.931, 33.79833], [-116.93119, 33.79858], [-116.93115, 33.79861], [-116.93049, 33.79779], [-116.9302, 33.79793], [-116.93018, 33.79789], [-116.93046, 33.79774], [-116.93028, 33.79746], [-116.93018, 33.79727], [-116.93001, 33.79686], [-116.92972, 33.79579], [-116.92996, 33.7958], [-116.93001, 33.79586], [-116.93, 33.79598], [-116.92994, 33.79617], [-116.92998, 33.79626], [-116.93007, 33.79632], [-116.93005, 33.79662], [-116.93029, 33.79664], [-116.93039, 33.79668], [-116.93048, 33.79673], [-116.93053, 33.79681], [-116.93066, 33.79711], [-116.93074, 33.79732], [-116.93081, 33.79763], [-116.93086, 33.79795], [-116.93121, 33.79793], [-116.93123, 33.79803]]], [[[-116.93157, 33.79599], [-116.93105, 33.7962], [-116.93088, 33.79609], [-116.93074, 33.79602], [-116.93059, 33.79597], [-116.93031, 33.79591], [-116.93023, 33.79618], [-116.9302, 33.79618], [-116.93014, 33.79611], [-116.93017, 33.79587], [-116.93025, 33.79582], [-116.93148, 33.79593], [-116.93155, 33.79597], [-116.93157, 33.79599]]]]} Open Access 1 48838 Soboba Springs Park 33558 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://sanjacintoca.hosted.civiclive.com/community/parks_facilities/parks/soboba_springs_park Riverside 10 2.944 Soboba Springs Park 0 Local Park 2 4
14877 14877 14876 {"type": "Polygon", "coordinates": [[[-116.989, 33.7964], [-116.98899, 33.79696], [-116.98805, 33.79697], [-116.988, 33.79693], [-116.98799, 33.7964], [-116.989, 33.7964]]]} Open Access 1 45444 Daniel Najera Park 28235 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html Riverside 10 1.438 Daniel Najera Park 0 Local Park 2 4
14886 14886 14885 {"type": "Polygon", "coordinates": [[[-116.9851, 33.79461], [-116.98504, 33.79466], [-116.98414, 33.79467], [-116.98411, 33.79447], [-116.98399, 33.79416], [-116.98396, 33.79397], [-116.98397, 33.79371], [-116.98405, 33.79342], [-116.9841, 33.79318], [-116.98412, 33.79277], [-116.98509, 33.79277], [-116.9851, 33.79461]]]} Open Access 1 45443 Warneke Park 28236 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html Riverside 10 5.012 Warneke Park 0 Local Park 2 4
14888 14888 14887 {"type": "Polygon", "coordinates": [[[-117.02407, 33.78613], [-117.02397, 33.78608], [-117.02257, 33.7863], [-117.02248, 33.78627], [-117.0225, 33.78621], [-117.02249, 33.78616], [-117.02242, 33.78598], [-117.02228, 33.7854], [-117.02231, 33.78535], [-117.0225, 33.78532], [-117.02327, 33.78531], [-117.0235, 33.78533], [-117.02359, 33.78531], [-117.02366, 33.78527], [-117.02375, 33.78533], [-117.02405, 33.78533], [-117.02407, 33.78613]]]} Open Access 1 45433 Tamarisk Park 28227 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html Riverside 10 3.725 Tamarisk 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]);