calands: units_with_maps: 14 rows where DES_TP = 2, LAYER = 2 and MNG

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

14 rows where DES_TP = 2, LAYER = 2 and MNG_AGENCY = 283

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
919	919	918	{"type": "Polygon", "coordinates": [[[-118.38471, 33.79138], [-118.38421, 33.79343], [-118.38302, 33.79322], [-118.38246, 33.79346], [-118.38205, 33.79352], [-118.3809, 33.79344], [-118.38105, 33.7925], [-118.38199, 33.79161], [-118.3827, 33.79105], [-118.38287, 33.79081], [-118.38308, 33.79089], [-118.38329, 33.79094], [-118.38324, 33.79115], [-118.38471, 33.79138]]]}	Open Access 1	5880	Grandview Park	19429	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2	http://ca-ranchopalosverdes.civicplus.com/Facilities/Facility/Details/Grandview-Park-8	Los Angeles 6	17.262	Grandview Park	0	Local Park 2	4
2253	2253	2252	{"type": "Polygon", "coordinates": [[[-118.3828, 33.77156], [-118.38193, 33.77172], [-118.3819, 33.7714], [-118.38267, 33.77126], [-118.38273, 33.7713], [-118.3828, 33.77156]]]}	Open Access 1	5927	Wallace Ranch Park	27219	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2		Los Angeles 6	0.693	Wallace Ranch Park	0	Local Park 2	4
6959	6959	6958	{"type": "Polygon", "coordinates": [[[-118.39689, 33.76706], [-118.39591, 33.76763], [-118.39558, 33.76778], [-118.39532, 33.76786], [-118.39491, 33.76796], [-118.39345, 33.76813], [-118.39319, 33.76817], [-118.39292, 33.76823], [-118.39157, 33.76864], [-118.3913, 33.76801], [-118.39112, 33.76748], [-118.39104, 33.76711], [-118.39099, 33.76677], [-118.39098, 33.76652], [-118.39102, 33.76649], [-118.39117, 33.76649], [-118.39149, 33.76644], [-118.39279, 33.76599], [-118.39297, 33.76595], [-118.39392, 33.76578], [-118.3942, 33.76576], [-118.39532, 33.76574], [-118.39549, 33.76577], [-118.39565, 33.76581], [-118.39587, 33.7659], [-118.39604, 33.76601], [-118.39616, 33.7661], [-118.39633, 33.76628], [-118.39689, 33.76706]]]}	Open Access 1	5863	Fred Hesse Jr. Community Park	19075	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2		Los Angeles 6	28.717	Fred Hesse Jr. Community Park	0	Local Park 2	4
6960	6960	6959	{"type": "Polygon", "coordinates": [[[-118.39574, 33.74968], [-118.39504, 33.75018], [-118.39476, 33.75079], [-118.39507, 33.75161], [-118.39555, 33.75184], [-118.39546, 33.75197], [-118.39539, 33.752], [-118.39527, 33.75195], [-118.39353, 33.7514], [-118.39332, 33.75131], [-118.39314, 33.75119], [-118.39291, 33.75099], [-118.39281, 33.75086], [-118.39267, 33.7506], [-118.39262, 33.75035], [-118.39261, 33.7502], [-118.39265, 33.74997], [-118.39451, 33.74985], [-118.39551, 33.74935], [-118.39574, 33.74968]]]}	Open Access 1	5865	Robert E. Ryan Community Park	24485	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2	http://ca-ranchopalosverdes.civicplus.com/Facilities/Facility/Details/Robert-E-Ryan-Community-Park-17	Los Angeles 6	10.135	Robert E. Ryan Community Park	0	Local Park 2	4
6964	6964	6963	{"type": "Polygon", "coordinates": [[[-118.39237, 33.74063], [-118.39224, 33.74067], [-118.39187, 33.74074], [-118.39139, 33.74079], [-118.39149, 33.73999], [-118.3917, 33.73999], [-118.39193, 33.73996], [-118.39211, 33.74028], [-118.39237, 33.74063]]]}	Open Access 1	5868	Frank A. Vanderlip Sr. Park	19048	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2	http://ca-ranchopalosverdes.civicplus.com/Facilities/Facility/Details/Frank-A-Vanderlip-Park-6	Los Angeles 6	1.365	Frank A. Vanderlip Sr. Park	0	Local Park 2	4
6972	6972	6971	{"type": "Polygon", "coordinates": [[[-118.36949, 33.75652], [-118.3692, 33.75695], [-118.36896, 33.75701], [-118.36862, 33.75753], [-118.36857, 33.75768], [-118.36824, 33.75816], [-118.36775, 33.75784], [-118.3679, 33.75783], [-118.36806, 33.75765], [-118.36821, 33.75626], [-118.36842, 33.75611], [-118.36924, 33.75631], [-118.36949, 33.75652]]]}	Open Access 1	5876	Del Cerro Park	18025	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2		Los Angeles 6	3.967	Del Cerro Park	0	Local Park 2	4
6998	6998	6997	{"type": "Polygon", "coordinates": [[[-118.33726, 33.76392], [-118.33613, 33.76428], [-118.3361, 33.76416], [-118.33608, 33.76399], [-118.3361, 33.76396], [-118.33697, 33.7636], [-118.33726, 33.76392]]]}	Open Access 1	5937	Martingale Trailhead Park	21928	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2	http://ca-ranchopalosverdes.civicplus.com/Facilities/Facility/Details/Martingale-Trailhead-Park-11	Los Angeles 6	0.969	Martingale Trailhead Park	0	Local Park 2	4
7001	7001	7000	{"type": "Polygon", "coordinates": [[[-118.40368, 33.77234], [-118.40368, 33.7725], [-118.40331, 33.7725], [-118.40326, 33.77253], [-118.40326, 33.77231], [-118.40331, 33.77234], [-118.40368, 33.77234]]]}	Open Access 1	5940	Clovercliff Park	17440	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2	http://ca-ranchopalosverdes.civicplus.com/Facilities/Facility/Details/Clovercliff-Park-2	Los Angeles 6	0.177	Clovercliff Park	0	Local Park 2	4
7027	7027	7026	{"type": "MultiPolygon", "coordinates": [[[[-118.38329, 33.74488], [-118.38315, 33.74489], [-118.38294, 33.74485], [-118.38222, 33.74461], [-118.38115, 33.74421], [-118.38005, 33.74376], [-118.37905, 33.74332], [-118.37857, 33.74313], [-118.37857, 33.7431], [-118.3788, 33.74316], [-118.37926, 33.74331], [-118.37949, 33.74343], [-118.38065, 33.74391], [-118.38235, 33.74457], [-118.38328, 33.74485], [-118.38329, 33.74488]]], [[[-118.38673, 33.74537], [-118.38671, 33.7454], [-118.38656, 33.7454], [-118.38635, 33.74536], [-118.38546, 33.74527], [-118.38414, 33.74512], [-118.38375, 33.74505], [-118.38368, 33.74502], [-118.38373, 33.74499], [-118.38452, 33.74507], [-118.38592, 33.74526], [-118.38636, 33.74529], [-118.38673, 33.74537]]], [[[-118.39135, 33.74487], [-118.39131, 33.74491], [-118.39016, 33.74528], [-118.38972, 33.74537], [-118.38896, 33.74547], [-118.38819, 33.74551], [-118.38753, 33.74551], [-118.38709, 33.74548], [-118.38695, 33.74545], [-118.38692, 33.7454], [-118.3883, 33.7454], [-118.38898, 33.74536], [-118.38977, 33.74525], [-118.39018, 33.74518], [-118.39059, 33.74506], [-118.39128, 33.74484], [-118.39132, 33.74483], [-118.39135, 33.74487]]], [[[-118.39643, 33.7431], [-118.39515, 33.74361], [-118.39305, 33.74435], [-118.3917, 33.74481], [-118.3916, 33.74483], [-118.39157, 33.7448], [-118.39171, 33.74474], [-118.39181, 33.74467], [-118.39643, 33.74304], [-118.39643, 33.7431]]], [[[-118.40884, 33.74303], [-118.40875, 33.74303], [-118.4085, 33.74288], [-118.40823, 33.74274], [-118.40775, 33.74259], [-118.40708, 33.74244], [-118.40633, 33.74239], [-118.40528, 33.7424], [-118.4048, 33.74236], [-118.40426, 33.74225], [-118.40358, 33.74208], [-118.40254, 33.74174], [-118.40215, 33.74165], [-118.40167, 33.74159], [-118.40134, 33.74159], [-118.40069, 33.74168], [-118.40006, 33.74187], [-118.39853, 33.74242], [-118.39673, 33.74302], [-118.39665, 33.743], [-118.39707, 33.74283], [-118.39717, 33.74277], [-118.3986, 33.74229], [-118.40009, 33.74176], [-118.40066, 33.74158], [-118.40113, 33.74149], [-118.40143, 33.74147], [-118.40177, 33.74147], [-118.40254, 33.7416], [-118.40371, 33.74197], [-118.40435, 33.74216], [-118.40486, 33.74227], [-118.40531, 33.74231], [-118.40636, 33.74231], [-118.40698, 33.74235], [-118.40741, 33.7424], [-118.40793, 33.74255], [-118.40835, 33.74272], [-118.40864, 33.74286], [-118.40884, 33.74303]]], [[[-118.40899, 33.74318], [-118.40914, 33.74336], [-118.40934, 33.7437], [-118.40944, 33.74405], [-118.40946, 33.74428], [-118.40934, 33.74483], [-118.40907, 33.74529], [-118.40758, 33.74691], [-118.40744, 33.74721], [-118.40735, 33.74754], [-118.4073, 33.74804], [-118.40728, 33.74813], [-118.40725, 33.74815], [-118.40721, 33.74812], [-118.40719, 33.74784], [-118.40723, 33.74752], [-118.40731, 33.74718], [-118.40745, 33.74691], [-118.40771, 33.74658], [-118.40897, 33.74525], [-118.40911, 33.74503], [-118.40927, 33.74471], [-118.40933, 33.74446], [-118.40935, 33.7442], [-118.40932, 33.744], [-118.40921, 33.74369], [-118.40904, 33.74338], [-118.4089, 33.74319], [-118.40892, 33.74316], [-118.40899, 33.74318]]], [[[-118.40891, 33.75149], [-118.40882, 33.75149], [-118.40872, 33.75129], [-118.4083, 33.75056], [-118.40819, 33.75033], [-118.40776, 33.74954], [-118.40781, 33.74952], [-118.40789, 33.74952], [-118.40828, 33.7503], [-118.40841, 33.75047], [-118.40891, 33.75149]]], [[[-118.41135, 33.75611], [-118.4113, 33.75612], [-118.41126, 33.75609], [-118.41097, 33.75561], [-118.40965, 33.75312], [-118.40896, 33.75176], [-118.40903, 33.75176], [-118.4092, 33.752], [-118.41016, 33.7538], [-118.41095, 33.75533], [-118.41112, 33.7556], [-118.41135, 33.75611]]], [[[-118.41472, 33.76181], [-118.41462, 33.76181], [-118.41465, 33.76146], [-118.41461, 33.76101], [-118.41458, 33.7609], [-118.41447, 33.76019], [-118.4144, 33.75994], [-118.41424, 33.75957], [-118.4141, 33.75928], [-118.41379, 33.75889], [-118.41284, 33.75802], [-118.41224, 33.75741], [-118.41171, 33.75677], [-118.4115, 33.75649], [-118.41142, 33.75633], [-118.41149, 33.75631], [-118.41155, 33.75635], [-118.41174, 33.75663], [-118.41186, 33.75674], [-118.41284, 33.75784], [-118.4139, 33.75884], [-118.41423, 33.75924], [-118.41455, 33.7599], [-118.41461, 33.76015], [-118.41467, 33.76048], [-118.41473, 33.76135], [-118.41474, 33.76176], [-118.41472, 33.76181]]], [[[-118.41473, 33.76201], [-118.41475, 33.7621], [-118.41471, 33.76246], [-118.41464, 33.7628], [-118.41448, 33.76283], [-118.41456, 33.76242], [-118.41459, 33.76197], [-118.4147, 33.76198], [-118.41473, 33.76201]]]]}	Open Access 1	5978	Rancho Palos Verdes City Parkland	24161	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2		Los Angeles 6	13.5	Rancho Palos Verdes City Parkland	0	Local Park 2	4
15193	15193	15192	{"type": "Polygon", "coordinates": [[[-118.34724, 33.73252], [-118.34723, 33.73268], [-118.34719, 33.73291], [-118.34716, 33.73295], [-118.34713, 33.73297], [-118.34707, 33.73296], [-118.34695, 33.73289], [-118.34662, 33.73264], [-118.34667, 33.73262], [-118.34686, 33.73259], [-118.34706, 33.73252], [-118.34724, 33.73252]]]}	Open Access 1	46066	Vista Catalina Park	29408	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2	http://www.rpvca.gov	Los Angeles 6	0.422	Vista Catalina Park	0	Local Park 2	4
15194	15194	15193	{"type": "Polygon", "coordinates": [[[-118.34923, 33.73354], [-118.3483, 33.73341], [-118.34781, 33.73329], [-118.34746, 33.73316], [-118.34743, 33.73313], [-118.34742, 33.73309], [-118.3475, 33.73261], [-118.34753, 33.73262], [-118.34758, 33.73274], [-118.34766, 33.73282], [-118.34832, 33.73296], [-118.34841, 33.7331], [-118.34858, 33.73317], [-118.34878, 33.73322], [-118.34923, 33.73354]]]}	Open Access 1	46067	Marilyn Ryan Sunset Point Park	29409	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2	http://www.rpvca.gov	Los Angeles 6	1.503	Marilyn Ryan Sunset Point Park	0	Local Park 2	4
15195	15195	15194	{"type": "Polygon", "coordinates": [[[-118.35166, 33.72821], [-118.35162, 33.72828], [-118.35092, 33.72867], [-118.35065, 33.72905], [-118.35037, 33.72927], [-118.35019, 33.72949], [-118.34935, 33.72917], [-118.34924, 33.72895], [-118.34917, 33.72875], [-118.34911, 33.72873], [-118.34935, 33.72841], [-118.3494, 33.72843], [-118.34952, 33.72853], [-118.34961, 33.72845], [-118.34982, 33.72831], [-118.35009, 33.72826], [-118.35043, 33.72827], [-118.35069, 33.72809], [-118.35086, 33.7279], [-118.3515, 33.72813], [-118.35166, 33.72821]]]}	Open Access 1	46068	Founders Park	29410	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2	http://www.rpvca.gov	Los Angeles 6	4.797	Founders Park	2007	Local Park 2	4
15199	15199	15198	{"type": "Polygon", "coordinates": [[[-118.35317, 33.72904], [-118.35277, 33.72926], [-118.35248, 33.729], [-118.35223, 33.72849], [-118.35225, 33.72804], [-118.35247, 33.728], [-118.35262, 33.72822], [-118.35265, 33.72827], [-118.35269, 33.72845], [-118.35278, 33.7286], [-118.35286, 33.72869], [-118.35294, 33.72886], [-118.35304, 33.7289], [-118.35317, 33.72904]]]}	Open Access 1	46076	Rancho Palos Verdes Beach	29416	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2	http://www.rpvca.gov	Los Angeles 6	1.395	Rancho Palos Verdes Beach	0	Local Park 2	4
15202	15202	15201	{"type": "Polygon", "coordinates": [[[-118.36291, 33.74101], [-118.36226, 33.74149], [-118.36219, 33.74153], [-118.36209, 33.74152], [-118.36185, 33.74174], [-118.36172, 33.74183], [-118.36049, 33.74264], [-118.36037, 33.74271], [-118.36009, 33.74282], [-118.35993, 33.74286], [-118.3599, 33.74268], [-118.35989, 33.74249], [-118.36001, 33.74045], [-118.36009, 33.7404], [-118.36045, 33.74054], [-118.3608, 33.74065], [-118.36132, 33.74078], [-118.36291, 33.74101]]]}	Open Access 1	46082	Gateway Park	29425	1265	Rancho Palos Verdes, City of 265	City 2	City Agency 2	http://palosverdes.com/rpv/recreationparks/index.cfm	City 2	1265	Rancho Palos Verdes, City of 283	City 2	City Agency 2		Los Angeles 6	9.456	Gateway Park	0	Local Park 2	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]);