Example #1
0
 ToCSVLine(ref property_data _p)
 {
     return(_p.placeID + ',' +
            _p.categoryCode + "," +
            _p.address + "," +
            _p.marketValue + "," +
            _p.numberCondos + "," +
            _p.numberBedRooms + "," +
            _p.numberOfStories + "," +
            _p.taxableBuilding + "," +
            _p.taxableLand + "," +
            _p.totalArea + "," +
            _p.totalLivableArea + "," +
            _p.zone + "," +
            _p.lat + "," +
            _p.lng);
 }
Example #2
0
    private void ParseCSV(string _csvData, int _startingLine = 1)
    {
        string[] lines = _csvData.Split(new string[] { System.Environment.NewLine, "\n" }, System.StringSplitOptions.RemoveEmptyEntries);
        Debug.Assert(lines.Length > 0, "No lines could be found in the parsed data.");
        Debug.Assert(_startingLine < lines.Length, "Starting line cannot be larger than the total number of lines in the csv.");
        if (_startingLine < 1)
        {
            _startingLine = 1;
        }

        string pattern   = ",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)";
        Regex  CSVParser = new Regex(pattern);


        int placeIdI = -1, categoryCodeI = -1, addressI = -1, marketValueI = -1,
            numberCondosI = -1, numberOfBedroomsI = -1, numberStoriesI = -1, taxableBuildingI = -1,
            taxableLandI = -1, totalAreaI = -1, totalLivableAreaI = -1, zoningI = -1, latI = -1, lngI = -1;

        string line0 = lines[0];

        string[] fields0 = CSVParser.Split(line0);
        for (int i = 0; i < fields0.Length; ++i)
        {
            switch (fields0[i])
            {
            case "placeId":
                placeIdI = i;
                break;

            case "category_code":
                categoryCodeI = i;
                break;

            case "location":
                addressI = i;
                break;

            case "market_value":
                marketValueI = i;
                break;

            case "number_condos":
                numberCondosI = i;
                break;

            case "number_of_bedrooms":
                numberOfBedroomsI = i;
                break;

            case "number_stories":
                numberStoriesI = i;
                break;

            case "taxable_building":
                taxableBuildingI = i;
                break;

            case "taxable_land":
                taxableLandI = i;
                break;

            case "total_area":
                totalAreaI = i;
                break;

            case "total_livable_area":
                totalLivableAreaI = i;
                break;

            case "zoning":
                zoningI = i;
                break;

            case "lat":
                latI = i;
                break;

            case "lng":
                lngI = i;
                break;
            }
        }

        for (int lineIndex = _startingLine;
             lineIndex < lines.Length;
             ++lineIndex)
        {
            string   line   = lines[lineIndex];
            string[] fields = line.Split(',');

            uint          placeId;
            property_data curr = new property_data();

            if (!uint.TryParse(fields[marketValueI], System.Globalization.NumberStyles.Float, null, out curr.marketValue))
            {
                Debug.LogError("Market Value was not parsed successfully\n" + fields[marketValueI]);
            }
            if (!byte.TryParse(fields[categoryCodeI], out curr.categoryCode))
            {
                Debug.LogError("Category Code was not parsed successfully\n" + fields[categoryCodeI]);
            }
            if (!uint.TryParse(fields[taxableBuildingI], System.Globalization.NumberStyles.Float, null, out curr.taxableBuilding))
            {
                Debug.LogError("Taxable Building was not parsed successfully\n" + fields[taxableBuildingI]);
            }
            if (!uint.TryParse(fields[taxableLandI], System.Globalization.NumberStyles.Float, null, out curr.taxableLand))
            {
                Debug.LogError("Taxable Land was not parsed successfully\n" + fields[taxableLandI]);
            }
            if (!double.TryParse(fields[latI], out curr.lat))
            {
                Debug.LogError("Lat was not parsed successfully\n" + fields[latI]);
            }
            if (!double.TryParse(fields[lngI], out curr.lng))
            {
                Debug.LogError("Lng was not parsed successfully\n" + fields[latI]);
            }
            if (!uint.TryParse(fields[placeIdI], System.Globalization.NumberStyles.Integer, null, out placeId))
            {
                Debug.LogError("PlaceId was not parsed successfully\n" + fields[placeIdI]);
            }
            if (!uint.TryParse(fields[totalAreaI], System.Globalization.NumberStyles.Integer, null, out curr.totalArea))
            {
                Debug.LogError("Total Area was not parsed successfully\n" + fields[totalAreaI]);
            }
            if (!uint.TryParse(fields[totalLivableAreaI], System.Globalization.NumberStyles.Integer, null, out curr.totalLivableArea))
            {
                Debug.LogError("Total Livable Area was not parsed successfully\n" + fields[totalLivableAreaI]);
            }
            if (!ushort.TryParse(fields[numberCondosI], System.Globalization.NumberStyles.Integer, null, out curr.numberCondos))
            {
                Debug.LogError("Number of Condos was not parsed successfully\n" + fields[numberCondosI]);
            }
            if (!ushort.TryParse(fields[numberStoriesI], System.Globalization.NumberStyles.Integer, null, out curr.numberOfStories))
            {
                Debug.LogError("Number of Stories was not parsed successfully\n" + fields[numberStoriesI]);
            }
            if (!ushort.TryParse(fields[numberOfBedroomsI], System.Globalization.NumberStyles.Integer, null, out curr.numberBedRooms))
            {
                Debug.LogError("Number of Bedrooms was not parsed successfully\n" + fields[numberOfBedroomsI]);
            }
            curr.placeID = placeId;
            curr.zone    = PropertyData.GetZoningByte(fields[zoningI]);
            curr.address = fields[addressI];

            if (placeIdToPropertyData.ContainsKey(placeId.ToString()))
            {
                //Debug.LogError(placeId + " ALREADY EXISTS IN THE DICT!");
                property_data data = placeIdToPropertyData[placeId.ToString()];
                data.marketValue     += curr.marketValue;
                data.taxableBuilding += curr.taxableBuilding;
                data.taxableLand     += curr.taxableLand;
                placeIdToPropertyData[placeId.ToString()] = data;
            }
            else
            {
                listOfAddressesKnown.Add(curr.address);
                listOfKnownPlaceIds.Add(curr.placeID);
                placeIdToPropertyData.Add(curr.placeID.ToString(), curr);
            }
        }
        OnDataFinishedReading?.Invoke();
    }