Imports missing lat/long

Randy_Vick

Member
Premium Subscriber
Joined
May 13, 2017
Messages
55
Location
Suffolk, VA
For sometime I've noticed that when I import many conventional data using ProScan or FreeScan, lat/long information will be displayed as blank, or now 0.00.
I've depicted one incidence below.
1598716746730.png
 

ProScan

Software Provider
Premium Subscriber
Joined
Jul 2, 2006
Messages
4,445
Location
Ontario, Calif.
That's strange. This is what I see returned from the RRDB.
7693,Appomattox County,,,0
The lat & long are missing. They should appear before the 0 in the above.

RRDB reference
Code:
<xsd:complexType name="subcat">
<xsd:all>
<xsd:element name="scid" type="xsd:int"/>
<xsd:element name="scName" type="xsd:string"/>
<xsd:element name="lat" type="xsd:decimal"/>
<xsd:element name="lon" type="xsd:decimal"/>
<xsd:element name="range" type="xsd:decimal"/>
<xsd:element name="sids" type="tns:sids"/>
</xsd:all>
</xsd:complexType>
 

Randy_Vick

Member
Premium Subscriber
Joined
May 13, 2017
Messages
55
Location
Suffolk, VA
Yet when I had submitted, the database administrator identified " ... checked Appomattox County, under "Subcategory Menu" > "View Subcategory Details" and I'm showing location information. (It's the small triangle on the Appomattox database page.)"

Appomattox was an example. Below are what I identified this week. Anecdotally this only seems to occur with conventional systems.

VA
Appomattox County 37.402489 -78.792953
Carrolton Volunteer Fire Department 36.946815 -76.560508
Isle of Wight County 36.928892 -76.687470
Smithfield Town of 36.982371 -76.631066
Halifax County 36.694505 -78.928824
South Boston City of 36.698749 -78.901399
Henrico County of 37.505933 -77.332443
Chase City Town of 36.799309 -78.458331
Clarksville Town of 36.624030 -78.556945
La Crosse Town of 36.700144 -78.099719
Mecklenburg County of 36.642172 -78.384223
South Hill Town of 36.726532 -78.128886
Norfolk City of 36.850769 -76.285873
Poquoson City of 37.122366 -76.345777
Prince Edward County of 37.198289 -78.429719
Prince George County of 37.159305 -77.240515
Southampton County of 36.678851 -77.102490
Surry County of 37.118552 -76.872096
Sussex County of 36.905817 -77.240515
Waverly Town of 37.035984 -77.095243
Williamsburg City of 37.270702 -76.707457

NC
Chowan County 36.135413 -76.618166
Halifax County Towns/Cities 36.264676 -77.607787
Ahoskie 36.286822 -76.984681
Murfreesboro 36.442375 -77.098575
 

GTR8000

NYS Database Guy
Database Admin
Joined
Oct 4, 2007
Messages
9,058
Location
BEE00
If you take a look at the subcategory report for the Appomattox County subcategory, you'll notice that the geodata is (Inherited) from the county itself:


That's also why you see (County) on the subcategory details page:


There are several places we can enter geodata. For conventional frequencies, the geodata exists at both the County level as well as the Subcategory level. If you don't explicitly enter geodata at the subcategory level, it will automatically inherit the higher level, which is the county.

It appears that inherited geodata does not make its way into the API, which is probably why it's coming up as 0.
 
Last edited:

Randy_Vick

Member
Premium Subscriber
Joined
May 13, 2017
Messages
55
Location
Suffolk, VA
If you take a look at the subcategory report for the Appomattox County subcategory, you'll notice that the geodata is (Inherited) from the county itself:


That's also why you see (County) on the subcategory details page:


There are several places we can enter geodata. For conventional frequencies, the geodata exists at both the County level as well as the Subcategory level. If you don't explicitly enter geodata at the subcategory level, it will automatically inherit the higher level, which is the county.

It appears that inherited geodata does not make its way into the API, which is probably why it's coming up as 0.
So, should I be looking to RR to make modifications or software developers to make changes and do I need to do anything?

I will add that when experimenting, a favorites list imported from Sentinel has the lat/long data.
 
Top