opendata

Joomla Templates and Joomla Extensions by JoomlaVision.Com

follow us

Data Feeds - APIs (5)

Thursday, 13 March 2014 08:47

Excel Batch Geocoder

Rate this item
(1 Vote)

Use Excel to tap into free geocoding resources on the web. Get up to 13,000 addresses free!

Monday, 30 July 2012 13:09

Elected Representatives API

Rate this item
(0 votes)

government icon        Elected Officials API

 

 


We have been playing with building an api that would accept map clicks and return back a list of electeds in Alameda County.

Here is a starting point for this api. So far, the api includes special districts like AC transit and BART as well as governments from House of Representatives down to city councilors. Here are some things I have discovered:

  1. There is no equivalent to FIPS codes for many of these districts.
  2. Elected officials should also have some sort of uniform identifier code.

 

Tell us what you think or how we could make the information more useful. I would like to figure some standard return for all elects.

Here is the endpoint. Go to the url to see what fields are available. Click query to use a form to explore different ways to grab the data.

http://209.119.63.162/InfoAlameda/rest/services/Projects/Representatives/MapServer/0

Here is some api documentation from ESRI (we use their server):

http://atlas.resources.ca.gov/ArcGIS/SDK/REST/index.html

Please submit if/how you use this api. It helps us make the case for open data.

Wednesday, 08 June 2011 12:58

New data on ArcGIS online

Rate this item
(0 votes)

arcgislogo

If you are an ArcGIS user, we recently published new data on ArcGIS Online. Search for it at arcgis.com with our handle, "usc_public."

The featured layer package shows 2010 census tracts within Alameda County displayed by majority ethnic group within each tract. In many census tracts, there is no racial group that comprises the true majority (over 50%) of the population in that tract. Therefore, we symbolized based on which group has plurality – which group represents the largest number. Look at the script for the field labeled "Most" to see how we did it.

 

Wednesday, 01 June 2011 14:31

Oakland Crime Reports API

Rate this item
(3 votes)

As part of our commitment to Open Data and to encourage others to analyse and use the data we manage, clean and curate we are making our crime reports database available publicly. If you are a coder, developer or hacker this is for you. If you're not technically inclined then we'd suggest you head on back to our Data Portal for more people friendly data. Or you can take a look at our analyses bases on these data in our partnership with the OPD here.

Oakland Police report data is generated from the Urban Strategies partnership with the Oakland Police Department. Cleaned and geocoded reports generally take one week to process, so data will be available up until the week prior. Crime report data is summarized by the week --Sunday - Saturday. Please note that the starting date is not always the Sunday of that week, but it represents the first instance of a report for that particular beat.

To obtain a layer of the boundaries for the community police beats, please go to:

Oakland Community Police Beats


////////////////////////////////////////////////////////////////////////////////////////////////////////////
Function Call: Get crime summary
Base URL: http://rest.infoalamedacounty.org/index.php/api/usc/crimeAggregate
Options:
• format-[xml,json,serialize,php,html,csv]
• stdate (YYYY-MM-DD)-beginning date for query
• beat:string-community police beats in Oakland

Example Return
http://rest.infoalamedacounty.org/index.php/api/rest/crimeAggregate/stdate/2011-03-02/beat/22x

<xml>
<item>
<start>2011-03-03</start>
<BEAT>22X</BEAT>
<Violence/>
<Property>5</Property>
<Homicide/>
<Assaults/>
<Robbery/>
<Burglary>3</Burglary>
<Rape/>
<Weapons/>
<Drugs/>
<Sex/>
</item>

 

Wednesday, 01 June 2011 10:31

Service Provider API (Reentry Focus)

Rate this item
(0 votes)

As part of our commitment to Open Data and to encourage efficiency in our partner agencies and nonprofits we are making our rich service provider database available as a data feed for use in whatever system, application or listing service you desire. If you are a coder, developer or hacker this is for you. If you're not technically inclined then we'd suggest you head on back to our Data Portal for more people friendly data. Or you can take a look at our web site that uses this data at www.alamedareentryservices.org.

 

The service provider directory contains listings for over 400 service providers, not just those providing specific reentry services but almost all providers in the county. This dataset was collated and quality checked over several months in 2010 and is a very comprehensive listing of social service providers in our county with rich details including service eligibility, opening hours, accessibility and more. Based on the type of service provided, the organizations are organized into general categories and then further divided into subcategories. To gain access to the  locations, the client needs to provide the category and subcategory names. Please note service provider locations may contain duplicates since most locations provide multiple services across several categories/subcategories.

*Red Options are Required

Default return format is xml


Function Call:Get service categories
BASE URL: http://rest.infoalamedacounty.org/index.php/api/reentry/servicegroup
Options:
• format-[xml,json,serialize,php,html,csv]
Example Return http://rest.infoalamedacounty.org/index.php/api/reentry/servicegroup

<xml>
<item>
<categoryID>1</categoryID>
<name>Housing</name>
</item>
<item>
<categoryID>2</categoryID>
<name>Legal</name>
</item>

////////////////////////////////////////////////////////////////////////////////////////////////////////////
Function Call: Get service subcategories
Base URL: http://rest.infoalamedacounty.org/index.php/api/reentry/services
Options:
• format-[xml,json,serialize,php,html,csv]
categoryID:Int
Example Return http://rest.infoalamedacounty.org/index.php/api/reentry/services/categoryID/1

<xml>
<item>
<name>Temporary/ Transitional Housing</name>
<definition>
Bridges the gap between emergency shelter and permanent affordable housing.
</definition>
</item>
<item>
<name>Emergency Shelter</name>
<definition>
Temporary housing on a night-by-night or week-by-week basis.
</definition>
</item>

////////////////////////////////////////////////////////////////////////////////////////////////////////////
Function Call: Get locations of service providers
Base URL: http://rest.infoalamedacounty.org/index.php/api/reentry/locations
Options:
• format-[xml,json,serialize,php,html,csv]
service:String
• miles:int- buffer distance from a point to gather services
• latitude:double- the latitude of the point to buffer
• longitude:double -the longitude of the point to buffer
Example Return:
http://rest.infoalamedacounty.org/index.php/api/reentry/locations/service/Emergency Shelter
<xml>
<item>
<name>Society of St. Vincent de Paul</name>
<address>675 23rd Street</address>
<city>Oakland</city>
<zip>94612</zip>
<phone>(510) 877-9218</phone>
<email/>
<latitude>37.813634</latitude>
<longitude>-122.273776</longitude>
<distance>13.700327155719</distance>
</item>
<item>
<name>Building Futures for Women and Children</name>
<address>1395 Bancroft Avenue</address>
<city>San Leandro</city>
<zip>94577</zip>
<phone>510- 357-0205</phone>
<email/>
<latitude>37.726391</latitude>
<longitude>-122.147672</longitude>
<distance>4.5485173567126</distance>
</item>

All we ask in return is that you tell us how you are using the API (so we can get funding to keep it going) and your ideas on how we can improve or expand the API.

Please refer to the attached document to get started.

Funded by:


akonadi ESRI grants
sff