Re: Philadelphia - Street Poles Data

[OpenData Philly]

David,

I think this street pole dataset represents the active street poles in the city (but not signs) and it is updated on an ongoing basis (the UP_DATE field has values from 1997 to 2019). It represents many different pole types.

The codes for the pole types are available in the metadata record at: https://metadata.phila.gov/#home/datasetdetails/555f8135f15fcb6c6ed4413a/representationdetails/5571b1c4e4fb1d91393c2183/?view_287_page=2

Additional metadata is at https://metadata.phila.gov/#home/datasetdetails/555f8135f15fcb6c6ed4413a/representationdetails/5571b1c4e4fb1d91393c2183/

Best regards,

Robert

--------------------

Robert Cheetham

Azavea

OpenDataPhilly is an online catalog that organizes to more than 350 data sets, applications, and APIs related to the Philadelphia region. It is a collaboration between the City of Philadelphia, Azavea, and members of the Philadelphia civic technology community. Visit us at http://www.opendataphilly.org and begin transforming your city. 

Ask questions: OpenDataPhilly mailing list.

Twitter: @opendataphilly. 

On Fri, Feb 7, 2020 at 10:18 AM David Pritchard <davidpr...@tamu.edu> wrote:

Hi, 

Can you please forward this to the appropriate persoN?

I was wondering if you could tell me a little more about variables in the Philadelphia Street poles data located here:https://www.opendataphilly.org/dataset/street-poles

1. I've guessed that the X and Y column refer to the lat/long of pole placement and Pole Date refers to when it was installed. Is this correct? 
2. Is this the full set of pole placements in Philadelphia for the time frame or is it some subset?
3. Does it include just lighted poles or others like road signs, etc.?
4. Are these just new lighted pole placements, meaning before the placement there was no light pole there, or could they also be representing replacements? Is there a way to distinguish the two?

Please let me know if you have any questions. 

Thank you, 

David

                                                                                                               

David Pritchard

PhD Student in Economics

Texas A&M University

davidpr...@tamu.edu

[Robert Cheetham]

David,

I don't know the answer, but there is a contact email address in the metadata record, and you could potentially reach out to them.

Best regards,

Robert

On Mon, Feb 10, 2020 at 11:20 AM David Pritchard <davidpr...@tamu.edu> wrote:

Thanks Robert, do we know if POLE_DATE or UP_DATE represent the dates that the poles were actually put in the ground and activated, or do they just represent when the were entered in the excel file?
 

[Adam Eyring]

Hi all,

I'm a newbie to working with opendataphilly. I was looking at options for GIS software on opendataphilly.org and until I figure which program to use, I've been doing plots in Google Maps. opendataphilly data can be downloaded, adjusted with some code (I use Python and R) to ensure addresses include street/city/zip (or lat/long if provided), and uploaded as a CSV to Google Maps for an instant plot of all the locations, with each point clickable to read the name of the location. This personalized map can then be shared with others. Is this something that can be listed as an option on opendataphilly?

Thanks for a great resource of City information!

Adam

 

--
You received this message because you are subscribed to the Google Groups "Open Data Philly" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendataphill...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/opendataphilly/CAJ0DAC88k1WXqoq_JTjXq6tFxcDoQQ%2BgwEMfMNBbbVJu14WQtQ%40mail.gmail.com.

[Robert Cheetham]

Adam,

Thanks for your feedback on the Resources page. I've gone through edited all of the resource page links, adding and removing several items, including Google Maps.

Regards,

Robert

------------------

Robert Cheetham

Azavea  |  990 Spring Garden St, 5th Floor, Philadelphia, PA 19123
chee...@azavea.com  | T 215.701.7713 
Web azavea.com  |  Blog azavea.com/blog  |  Twitter @rcheetham  and @azavea

Azavea is a B Corporation - we advance the state-of-the-art in geospatial technology 

and apply it for civic, social, and environmental impact. Join us.

-----------------

To view this discussion on the web visit https://groups.google.com/d/msgid/opendataphilly/CAPStRW-h%3D4GgBgjGOJXDYMtx1oeSRRp4EEgy-p1j3Lw3Nn%2BgDw%40mail.gmail.com.