# Sources

### Records

---

<table border="1" id="bkmrk-record-source-files-" style="border-collapse: collapse; width: 100%; border-width: 0px;"><colgroup><col style="width: 31.2602%;"></col><col style="width: 68.7398%;"></col></colgroup><tbody><tr><td style="border-width: 0px;">[![image.png](https://wiki.sumnersd.org/uploads/images/gallery/2023-11/scaled-1680-/eWNvkfdjULVuRzmi-image.png)](https://wiki.sumnersd.org/uploads/images/gallery/2023-11/eWNvkfdjULVuRzmi-image.png)</td><td style="vertical-align: top; border-width: 0px;">Record source files are a JSON formatted array of objects with each object containing at minimum a `lat` and `lng` key. Each record is attached to a marker which is placed on the map according to the latitude (`lat`) and longitude (`lng`) keys. Any other arbitrary properties and values can be included in each record.

```json
[
  {
    "First Name":"John",
    "Last Name":"Smith",
	...
    "lat":"47.204935",
    "lng":"-122.237967"
  },
  {
    "First Name":"Jane",
	"Last Name":"Doe",
    ...
    "lat":"47.204157",
	"lng":"-122.231124"
  }
]
```

</td></tr></tbody></table>

Skyward typically exports data in CSV format, however there are many free online tools which can convert CSV files to JSON. The Technology Services department can perform bulk geocoding of addresses if needed.

<table border="1" id="bkmrk-csv-json-first-name%2C" style="border-collapse: collapse; width: 100%; height: 59.5938px;"><colgroup><col style="width: 50%;"></col><col style="width: 50%;"></col></colgroup><tbody><tr style="height: 29.7969px;"><td style="height: 29.7969px; background-color: rgb(236, 240, 241);">**CSV**</td><td style="height: 29.7969px; background-color: rgb(236, 240, 241);">**JSON**</td></tr><tr style="height: 29.7969px;"><td style="height: 29.7969px;">```csv
First Name,Last Name,lat,lng
John,Smith,47.204935,-122.237967
Jane,Doe,47.204157,-122.231124
```

</td><td style="height: 29.7969px;">```JSON
[
  {
    "First Name":"John",
    "Last Name":"Smith",
    "lat":"47.204935",
    "lng":"-122.237967"
  },
  {
    "First Name":"Jane",
	"Last Name":"Doe",
    "lat":"47.204157",
	"lng":"-122.231124"
  }
]
```

</td></tr></tbody></table>

###   


### GeoJSON

---

<table border="1" id="bkmrk-a-geojson-source-is-" style="border-collapse: collapse; width: 100%; border-width: 0px;"><colgroup><col style="width: 32.6544%;"></col><col style="width: 67.4692%;"></col></colgroup><tbody><tr><td style="border-width: 0px;">[![image.png](https://wiki.sumnersd.org/uploads/images/gallery/2023-11/scaled-1680-/NUn8zOrtOSddPnlf-image.png)](https://wiki.sumnersd.org/uploads/images/gallery/2023-11/NUn8zOrtOSddPnlf-image.png)</td><td style="vertical-align: top; border-width: 0px;">A GeoJSON source is a file which defines geospatial features (*e.g school boundaries*) in the [GeoJSON format](https://en.wikipedia.org/wiki/GeoJSON). A repository of optimized SBLSD boundary files can be downloaded from [github.com/sblsd/gis](https://github.com/sblsd/gis).</td></tr></tbody></table>