units_with_maps

Table actions

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

5 rows where LAYER = 4, MNG_AGENCY = 19 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 5 ✖

MNG_AGENCY 1

  • Santa Ana, City of · 5 ✖

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
5739 5739 5738 {"type": "Polygon", "coordinates": [[[-117.86368, 33.71492], [-117.86366, 33.71591], [-117.86257, 33.71591], [-117.86257, 33.715], [-117.86248, 33.71499], [-117.86248, 33.71487], [-117.86359, 33.71488], [-117.86359, 33.71492], [-117.86368, 33.71492]]]} Restricted Access 2 47437 Monroe Elementary School Field 31153 2308 Santa Ana Unified School District 816 Special District 4 School District 14 http://www.sausd.us/site/default.aspx?PageID=1 Special District 4 1316 Santa Ana, City of 19 City 2 City Agency 2   Orange 3 2.918 Monroe Elementary School Field 0 Local Recreation Area 3 4
5740 5740 5739 {"type": "Polygon", "coordinates": [[[-117.90815, 33.749], [-117.90761, 33.74987], [-117.90711, 33.75063], [-117.9066, 33.75137], [-117.9061, 33.75206], [-117.90563, 33.75177], [-117.9056, 33.75179], [-117.90382, 33.75069], [-117.90435, 33.74984], [-117.90502, 33.75014], [-117.90503, 33.75021], [-117.90483, 33.75055], [-117.90576, 33.75095], [-117.90624, 33.75015], [-117.90651, 33.75028], [-117.90653, 33.75028], [-117.90651, 33.74904], [-117.90667, 33.74904], [-117.90668, 33.74906], [-117.90714, 33.74906], [-117.90715, 33.74901], [-117.90815, 33.749]]]} Restricted Access 2 47438 Spurgeon Intermediate School Field 31154 2308 Santa Ana Unified School District 816 Special District 4 School District 14 http://www.sausd.us/site/default.aspx?PageID=1 Special District 4 1316 Santa Ana, City of 19 City 2 City Agency 2   Orange 3 12.376 Spurgeon Intermediate School Field 0 Local Recreation Area 3 4
6328 6328 6327 {"type": "Polygon", "coordinates": [[[-117.89836, 33.72183], [-117.8983, 33.72317], [-117.89797, 33.72315], [-117.89796, 33.72316], [-117.89797, 33.72355], [-117.89832, 33.72355], [-117.89835, 33.72428], [-117.8943, 33.72425], [-117.8943, 33.72338], [-117.89435, 33.72295], [-117.89452, 33.72237], [-117.89471, 33.72195], [-117.89481, 33.72179], [-117.89488, 33.72177], [-117.89525, 33.72176], [-117.89683, 33.72176], [-117.897, 33.72177], [-117.89752, 33.72184], [-117.89836, 33.72183]]]} Restricted Access 2 47436 Valley High School Field 31152 2308 Santa Ana Unified School District 816 Special District 4 School District 14 http://www.sausd.us/site/default.aspx?PageID=1 Special District 4 1316 Santa Ana, City of 19 City 2 City Agency 2   Orange 3 24.28 Valley High School Field 0 Local Recreation Area 3 4
6335 6335 6334 {"type": "Polygon", "coordinates": [[[-117.91058, 33.72179], [-117.91047, 33.72176], [-117.91041, 33.72186], [-117.91048, 33.72189], [-117.91044, 33.72198], [-117.91045, 33.722], [-117.91032, 33.72232], [-117.91024, 33.72234], [-117.91017, 33.72238], [-117.91007, 33.72251], [-117.90997, 33.7225], [-117.90995, 33.72254], [-117.90986, 33.72251], [-117.90986, 33.72247], [-117.90977, 33.72248], [-117.9096, 33.72254], [-117.90953, 33.72264], [-117.90952, 33.72269], [-117.9094, 33.72266], [-117.90937, 33.72271], [-117.90927, 33.7227], [-117.90916, 33.72291], [-117.90914, 33.72327], [-117.90867, 33.72327], [-117.90855, 33.72329], [-117.90838, 33.72335], [-117.90792, 33.72336], [-117.90848, 33.72176], [-117.90871, 33.72179], [-117.90924, 33.72182], [-117.90951, 33.72176], [-117.90978, 33.72154], [-117.90996, 33.72132], [-117.91058, 33.72179]]]} Restricted Access 2 47439 Hector G. Godinez High School Field 31155 2308 Santa Ana Unified School District 816 Special District 4 School District 14 http://www.sausd.us/site/default.aspx?PageID=1 Special District 4 1316 Santa Ana, City of 19 City 2 City Agency 2   Orange 3 6.664 Hector G. Godinez High School Field 0 Local Recreation Area 3 4
14241 14241 14240 {"type": "Polygon", "coordinates": [[[-117.90149, 33.74169], [-117.90036, 33.7417], [-117.90037, 33.74], [-117.90142, 33.73999], [-117.90142, 33.7407], [-117.90149, 33.74074], [-117.90149, 33.74169]]]} Restricted Access 2 44131 Friendship Park 19123 2308 Santa Ana Unified School District 816 Special District 4 School District 14 http://www.sausd.us/site/default.aspx?PageID=1 Special District 4 1316 Santa Ana, City of 19 City 2 City Agency 2   Orange 3 4.747 Friendship Park 0 Local Park 2 4

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