public void TestContextRowsBoroughAndSBA()
{
object indicatorId = 201;
int borough = 3; // Manhattan
int subbourough = 308; // Central Harlem
NycResultsWithMetadata results = NychanisHelper.Query(indicatorId, NycResolutionType.CensusTract, NycTimeframeType.Year, 1999, 2009,
borough, subbourough, 0, SortType.Asc, -1, -1);
Assert.IsNotNull(results.ContextRows, "Context rows should be populated.");
Assert.AreEqual(3, results.ContextRows.Count, "Should have a context row.");
Assert.AreEqual("New York City", results.ContextRows[0][0], "Should be a context row for NY (city).");
Assert.AreEqual("Manhattan", results.ContextRows[1][0], "Should be a context row for Manhattan (borough).");
Assert.AreEqual("Central Harlem", results.ContextRows[2][0], "Should be a context row for Central Harlem (SBA).");
}
public void TestBasicGet()
{
object indicatorId = 10;
NycResultsWithMetadata results =
NychanisHelper.Query(indicatorId, NycResolutionType.Borough, NycTimeframeType.Year, 1970, 2020);
DumpResults(results);
Assert.AreEqual(5, results.TotalResults, "Wrong value for TotalResults.");
Assert.AreEqual(results.TotalResults, results.Values.Count, "Number of values didn't match TotalResults.");
Assert.AreEqual("Housing Units", results.Indicator, "Results claimed to be for the wrong indicator.");
Assert.AreEqual(NycResolutionType.Borough.ToString(), results.Resolution, "Results claimed to be for the wrong resolution.");
Assert.AreEqual(2009, results.MaxYear, "Results claimed to end at the wrong year.");
Assert.AreEqual(2000, results.MinYear, "Results claimed to start at the wrong year.");
Assert.AreEqual(7, results.Attrs.Count, "Wrong number of columns (cols = years)");
}
public void TestGetWithYearGaps()
{
object indicatorId = 1;
NycResultsWithMetadata results =
NychanisHelper.Query(indicatorId, NycResolutionType.Borough, NycTimeframeType.Year, 1970, 2020);
DumpResults(results);
Assert.AreEqual(5, results.TotalResults, "Wrong value for TotalResults.");
Assert.AreEqual(results.TotalResults, results.Values.Count, "Number of values didn't match TotalResults.");
Assert.AreEqual("Condominiums, Owner Occupied or For Sale", results.Indicator, "Results claimed to be for the wrong indicator.");
Assert.AreEqual(NycResolutionType.Borough.ToString(), results.Resolution, "Results claimed to be for the wrong resolution.");
Assert.AreEqual(2008, results.MaxYear, "Results claimed to end at the wrong year.");
Assert.AreEqual(2002, results.MinYear, "Results claimed to start at the wrong year.");
// There should just be the area column, then 2002, 2005, and 2008.
Assert.AreEqual(4, results.Attrs.Count, "Wrong number of columns (cols = years)");
}
public void TestMapLayersNoScope()
{
object indicatorId = 201;
NycResultsWithMetadata results = NychanisHelper.Query(indicatorId, NycResolutionType.CensusTract, NycTimeframeType.Year, 2005, 2008,
null, null, 0, SortType.Asc, -1, -1);
Assert.IsNotNull(results.MapInfo, "Map stuff should be populated.");
Assert.AreEqual(results.MapInfo.Server, "http://207.245.89.220:8080/geoserver/wms", "Wrong map server URL.");
Assert.IsNotNull(results.MapInfo.Layers, "Should have a list of layers.");
Assert.AreEqual(4, results.MapInfo.Layers.Count, "Wrong number of layers: " + StringHelper.Join(results.MapInfo.Layers));
Assert.AreEqual("2005", results.MapInfo.Layers[0].Name, "Wrong name for layer 0.");
Assert.IsNull(results.MapInfo.Layers[0].Config, "Should NOT have a config for layer 0");
Assert.AreEqual("2006", results.MapInfo.Layers[1].Name, "Wrong name for layer 1.");
Assert.IsNotNull(results.MapInfo.Layers[1].Config, "Should have a config for layer 1");
string sld = (string)results.MapInfo.Layers[1].Config["SLD"];
Assert.IsNotNull(sld, "Should have an SLD for layer 1");
Assert.AreEqual("http://localhost/pdp/handlers/NychanisSldHandler.ashx?indicator=201&resolution=CensusTract&time=201",
sld, "Wrong SLD URL for layer 1");
string layerName = (string)results.MapInfo.Layers[1].Config["layers"];
Assert.IsNotNull(layerName, "Should have a layer for layer 1");
Assert.AreEqual("fc:census_tracts", layerName, "Wrong layer name for layer 1");
Assert.AreEqual("2007", results.MapInfo.Layers[2].Name, "Wrong name for layer 2.");
Assert.IsNotNull(results.MapInfo.Layers[2].Config, "Should have a config for layer 2");
sld = (string)results.MapInfo.Layers[2].Config["SLD"];
Assert.IsNotNull(sld, "Should have an SLD for layer 2");
Assert.AreEqual("http://localhost/pdp/handlers/NychanisSldHandler.ashx?indicator=201&resolution=CensusTract&time=206",
sld, "Wrong SLD URL for layer 2");
layerName = (string)results.MapInfo.Layers[1].Config["layers"];
Assert.IsNotNull(layerName, "Should have a layer for layer 2");
Assert.AreEqual("fc:census_tracts", layerName, "Wrong layer name for layer 2");
Assert.AreEqual("2008", results.MapInfo.Layers[3].Name, "Wrong name for layer 3.");
Assert.IsNotNull(results.MapInfo.Layers[3].Config, "Should have a config for layer 3");
sld = (string)results.MapInfo.Layers[3].Config["SLD"];
Assert.IsNotNull(sld, "Should have an SLD for layer 3");
Assert.AreEqual("http://localhost/pdp/handlers/NychanisSldHandler.ashx?indicator=201&resolution=CensusTract&time=211",
sld, "Wrong SLD URL for layer 3");
layerName = (string)results.MapInfo.Layers[3].Config["layers"];
Assert.IsNotNull(layerName, "Should have a layer for layer 3");
Assert.AreEqual("fc:census_tracts", layerName, "Wrong layer name for layer 3");
}
public void TestMapLayersBoroughAndSBA()
{
object indicatorId = 201;
int borough = 3; // Manhattan
int subbourough = 308; // Central Harlem
NycResultsWithMetadata results = NychanisHelper.Query(indicatorId, NycResolutionType.CensusTract, NycTimeframeType.Year, 2005, 2008,
borough, subbourough, 0, SortType.Asc, -1, -1);
Assert.IsNotNull(results.MapInfo, "Map stuff should be populated.");
Assert.AreEqual(results.MapInfo.Server, "http://207.245.89.220:8080/geoserver/wms", "Wrong map server URL.");
Assert.IsNotNull(results.MapInfo.Layers, "Should have a list of layers.");
Assert.AreEqual(4, results.MapInfo.Layers.Count, "Wrong number of layers: " + StringHelper.Join(results.MapInfo.Layers));
string sld = (string)results.MapInfo.Layers[3].Config["SLD"];
Assert.IsNotNull(sld, "Should have an SLD for layer 3");
Assert.AreEqual("http://localhost/pdp/handlers/NychanisSldHandler.ashx?indicator=201&resolution=CensusTract&time=211&borough=3&subborough=308",
sld, "Wrong SLD URL for layer 3");
string layerName = (string)results.MapInfo.Layers[3].Config["layers"];
Assert.IsNotNull(layerName, "Should have a layer for layer 3");
Assert.AreEqual("fc:census_tracts", layerName, "Wrong layer name for layer 3");
}
public void TestPaging()
{
object indicatorId = 10;
int numPerPage = 10;
// Note that page numbering is 1-based.
NycResultsWithMetadata page1 = NychanisHelper.Query(indicatorId, NycResolutionType.SubBorough, NycTimeframeType.Year, 1999, 2009, null, null, 0, SortType.Asc, numPerPage, 1);
NycResultsWithMetadata page2 = NychanisHelper.Query(indicatorId, NycResolutionType.SubBorough, NycTimeframeType.Year, 1999, 2009, null, null, 0, SortType.Asc, numPerPage, 2);
NycResultsWithMetadata page5 = NychanisHelper.Query(indicatorId, NycResolutionType.SubBorough, NycTimeframeType.Year, 1999, 2009, null, null, 0, SortType.Asc, numPerPage, 5);
// Should be the same number regardless of the page, but they shouldn't be the same.
Assert.AreEqual(numPerPage, page1.Values.Count, "Wrong number of results for page 1.");
Assert.AreEqual(numPerPage, page2.Values.Count, "Wrong number of results for page 2.");
Assert.AreEqual(numPerPage, page5.Values.Count, "Wrong number of results for page 5.");
Assert.AreNotEqual(page1.Values[0][1], page2.Values[0][1], "Page 1 and 2 had the same first object.");
Assert.AreNotEqual(page1.Values[0][1], page5.Values[0][1], "Page 1 and 50 had the same first object.");
Assert.AreNotEqual(page2.Values[0][1], page5.Values[0][1], "Page 2 and 50 had the same first object.");
Assert.Greater(page1.TotalResults, numPerPage, "Total results should have been higher than what is returned on page 1.");
Assert.Greater(page2.TotalResults, numPerPage, "Total results should have been higher than what is returned on page 2.");
Assert.Greater(page5.TotalResults, numPerPage, "Total results should have been higher than what is returned on page 50.");
}