calands: units_with_maps: 6 rows where DES_TP = 3, GAP_STS = 4 and MNG

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

6 rows where DES_TP = 3, GAP_STS = 4 and MNG_AGENCY = 19

Search:

descending

This data as json, copyable, CSV (advanced)

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	COUNTY	ACRES	LABEL_NAME	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	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	Local Recreation Area 3	4
5941	5941	5940	{"type": "Polygon", "coordinates": [[[-117.87624, 33.74536], [-117.87445, 33.74536], [-117.87444, 33.74444], [-117.8755, 33.74444], [-117.87551, 33.74454], [-117.87624, 33.74455], [-117.87624, 33.74536]]]}	Open Access 1	565	Tennis Center	26244	1316	Santa Ana, City of 19	City 2	City Agency 2	http://www.santa-ana.org/parks/	City 2	1316	Santa Ana, City of 19	City 2	City Agency 2	Orange 3	3.988	Tennis Ctr.	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	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	Local Recreation Area 3	4
16258	16258	16257	{"type": "Polygon", "coordinates": [[[-117.86265, 33.7479], [-117.86231, 33.7479], [-117.86231, 33.74722], [-117.86264, 33.74722], [-117.86265, 33.7479]]]}	Open Access 1	45062	Familias Corazones Verdes Park and Community Center	32567	1316	Santa Ana, City of 19	City 2	City Agency 2	http://www.santa-ana.org/parks/	City 2	1316	Santa Ana, City of 19	City 2	City Agency 2	Orange 3	0.573	Familias Corazones Verdes Park and Community Ctr.	Local Recreation Area 3	4

Advanced export

JSON shape: default, array, newline-delimited

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