calands: units_with_maps: 1 row where GAP_STS = 2 and MNG

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

1 row where GAP_STS = 2 and MNG_AGENCY = 886

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	PARK_URL	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
9413	9413	9412	{"type": "MultiPolygon", "coordinates": [[[[-118.15724, 33.79865], [-118.15735, 33.79866], [-118.15738, 33.79868], [-118.15739, 33.79872], [-118.15737, 33.79875], [-118.1572, 33.79889], [-118.15711, 33.79894], [-118.15658, 33.79909], [-118.15638, 33.7992], [-118.15631, 33.79919], [-118.15629, 33.79916], [-118.1564, 33.79915], [-118.15648, 33.79906], [-118.15653, 33.79896], [-118.15652, 33.79884], [-118.15649, 33.79877], [-118.15635, 33.79858], [-118.15611, 33.79832], [-118.15608, 33.79826], [-118.15607, 33.79818], [-118.15607, 33.79814], [-118.15612, 33.79806], [-118.15601, 33.79791], [-118.15601, 33.79786], [-118.15599, 33.79782], [-118.15594, 33.79778], [-118.15587, 33.79776], [-118.15602, 33.7973], [-118.15576, 33.79724], [-118.15574, 33.79726], [-118.15563, 33.79759], [-118.15553, 33.79771], [-118.1555, 33.79782], [-118.1555, 33.79789], [-118.15554, 33.79798], [-118.15552, 33.79809], [-118.15572, 33.79811], [-118.15572, 33.79814], [-118.15552, 33.79813], [-118.15551, 33.79827], [-118.15556, 33.79851], [-118.15559, 33.79858], [-118.15564, 33.79865], [-118.15582, 33.79878], [-118.15601, 33.79901], [-118.15599, 33.79903], [-118.15588, 33.7989], [-118.15556, 33.79866], [-118.15549, 33.79856], [-118.15541, 33.79835], [-118.15541, 33.79811], [-118.1552, 33.7981], [-118.1552, 33.79807], [-118.15541, 33.79807], [-118.15543, 33.79796], [-118.15543, 33.79771], [-118.15554, 33.79754], [-118.15555, 33.79747], [-118.15556, 33.79734], [-118.1555, 33.79733], [-118.1555, 33.79719], [-118.15646, 33.7972], [-118.15658, 33.79735], [-118.1566, 33.79741], [-118.1566, 33.79748], [-118.1565, 33.79736], [-118.15636, 33.79743], [-118.15628, 33.79748], [-118.15622, 33.79755], [-118.15619, 33.79763], [-118.15618, 33.79771], [-118.15622, 33.79787], [-118.15624, 33.79802], [-118.1563, 33.7982], [-118.15651, 33.79866], [-118.15673, 33.79859], [-118.15675, 33.79862], [-118.15655, 33.79871], [-118.15654, 33.79872], [-118.15671, 33.79892], [-118.15676, 33.79895], [-118.15681, 33.79895], [-118.15695, 33.79889], [-118.15713, 33.79888], [-118.15725, 33.79884], [-118.15727, 33.79879], [-118.15724, 33.79865]]], [[[-118.15759, 33.79826], [-118.15756, 33.79831], [-118.15739, 33.7983], [-118.15724, 33.79832], [-118.1572, 33.79827], [-118.15697, 33.79783], [-118.15686, 33.79786], [-118.15664, 33.79786], [-118.15672, 33.79769], [-118.1567, 33.79763], [-118.15665, 33.79759], [-118.15667, 33.79747], [-118.15666, 33.79738], [-118.1567, 33.79738], [-118.15689, 33.79765], [-118.15697, 33.79771], [-118.15719, 33.79806], [-118.15727, 33.79812], [-118.15759, 33.79826]]], [[[-118.1581, 33.80028], [-118.15797, 33.8005], [-118.15798, 33.80071], [-118.15784, 33.80071], [-118.15786, 33.80049], [-118.15794, 33.80023], [-118.15793, 33.80019], [-118.1579, 33.80017], [-118.15768, 33.80011], [-118.15732, 33.79992], [-118.15718, 33.7998], [-118.15704, 33.79967], [-118.15687, 33.79976], [-118.15685, 33.79973], [-118.15703, 33.79963], [-118.1569, 33.79936], [-118.15693, 33.79934], [-118.15687, 33.79914], [-118.15716, 33.79906], [-118.15722, 33.79908], [-118.15703, 33.79913], [-118.15699, 33.79919], [-118.15709, 33.79938], [-118.15712, 33.79951], [-118.15723, 33.79966], [-118.15733, 33.79977], [-118.1575, 33.79964], [-118.15754, 33.79967], [-118.15737, 33.7998], [-118.15737, 33.79981], [-118.15744, 33.79987], [-118.15769, 33.8], [-118.15802, 33.80006], [-118.1581, 33.80028]]]]}	Restricted Access 2	47823	Bixby Village HOA	31766	6118	Bixby Village Home Owner Association 913	Private 7	Home Owners Association 16	http://www.bixbyvillagehoa.com/page/28905~504318/Management-Contacts	Private 14	6118	Bixby Village Home Owner Association 886	Private 7	Home Owners Association 15		Los Angeles 6	3.135	Bixby Village HOA	0	Private Conservation 16	2

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