Thank you
@Eric Blasenheim, that's a great tip to know.
I managed to select properties within 50 metres of the inputted coords.
http://mscvdcssa18:8080/rest/Spatial/FeatureService/tables/Moorabool/Data/vw_Property/features.json;attributes=PROP_PROPNUM,EZI_ADDRESS;?q=searchAtPoint&point=16077638.48,%20-4529792.03,EPSG:3857&tolerance=50%20m{
"type" : "FeatureCollection",
"features" : [
{
"type" : "Feature",
"properties" : {
"PROP_PROPNUM" : "375844",
"EZI_ADDRESS" : "16 DARLEY DRIVE DARLEY 3340",
"Distance" : 0
},
"geometry" : null,
"id" : 4238
},
{
"type" : "Feature",
"properties" : {
"PROP_PROPNUM" : "375842",
"EZI_ADDRESS" : "18 DARLEY DRIVE DARLEY 3340",
"Distance" : 17.07854915920817
},
"geometry" : null,
"id" : 4237
},
{
"type" : "Feature",
"properties" : {
"PROP_PROPNUM" : "375846",
"EZI_ADDRESS" : "14 DARLEY DRIVE DARLEY 3340",
"Distance" : 24.337148874299697
},
"geometry" : null,
"id" : 4239
},
{
"type" : "Feature",
"properties" : {
"PROP_PROPNUM" : "375758",
"EZI_ADDRESS" : "1 ANGLISS COURT DARLEY 3340",
"Distance" : 44.164477349217215
},
"geometry" : null,
"id" : 4249
},
{
"type" : "Feature",
"properties" : {
"PROP_PROPNUM" : "375756",
"EZI_ADDRESS" : "21 DARLEY DRIVE DARLEY 3340",
"Distance" : 44.310225595114595
},
"geometry" : null,
"id" : 4248
},
{
"type" : "Feature",
"properties" : {
"PROP_PROPNUM" : "375838",
"EZI_ADDRESS" : "20 DARLEY DRIVE DARLEY 3340",
"Distance" : 44.940739441362915
},
"geometry" : null,
"id" : 4236
},
{
"type" : "Feature",
"properties" : {
"PROP_PROPNUM" : "375770",
"EZI_ADDRESS" : "25 DARLEY DRIVE DARLEY 3340",
"Distance" : 48.13084456659673
},
"geometry" : null,
"id" : 4255
},
{
"type" : "Feature",
"properties" : {
"PROP_PROPNUM" : "375754",
"EZI_ADDRESS" : "19 DARLEY DRIVE DARLEY 3340",
"Distance" : 48.612007627349705
},
"geometry" : null,
"id" : 4247
}
],
"Metadata" : [
{
"name" : "PROP_PROPNUM",
"type" : "String"
},
{
"name" : "EZI_ADDRESS",
"type" : "String"
},
{
"name" : "Distance",
"type" : "Double"
}
]
}
------------------------------
Tim Warfe
GIS Officer
MOORABOOL SHIRE COUNCIL
------------------------------
Original Message:
Sent: 12-10-2019 15:58
From: Eric Blasenheim
Subject: My first Data flow Service (URL Assistance please)
Tim,
While learning how to create and use custom services is very important, I wanted to make sure you knew that Spectrum Spatial comes with a very full suite of spatial searching services out of the box. These all return GeoJSON which is the standard for spatial services in REST.
For example,
This query
http://<server:port>//rest/Spatial/FeatureService/tables/Samples/NamedTables/WorldcapTable/features.json;attributes=Capital,Cap_Pop;?q=searchAtPoint&point=-75.69812, 45.41117,EPSG:4326&tolerance=10%20mi
searches for data in the sample WorldcapTable for points within 10 miles of the input point.
The response returns the record, the distance and the table metadata associated with it.
{
"type": "FeatureCollection",
"features": [
{
"type": "Feature",
"properties": {
"Capital": "Ottawa",
"Cap_Pop": 920000.0,
"Distance": 3.435079155554653
},
"geometry": null,
"id": 143
}
],
"Metadata": [
{
"name": "Capital",
"type": "String"
},
{
"name": "Cap_Pop",
"type": "Decimal",
"fractionalDigits": 0,
"totalDigits": 8
},
{
"name": "Distance",
"type": "Double"
}
]
}
There are also POST versions for much more complicated queries. The documentation is here.
http://support.pb.com/help/spectrum/19.1/en/webhelp/Spatial/index.html#Spatial/source/Development/devguide/rest/feature.html
------------------------------
Eric Blasenheim
Spectrum Spatial Technical Product Manager
Troy, NY
Original Message:
Sent: 11-26-2019 23:39
From: Tim Warfe
Subject: My first Data flow Service (URL Assistance please)
Hi Guys,
I've just created a pretty simple service in Enterprise Designer.
X & Y Coords bring back some property details based on a spatial join. (Variables:- x,y)
The model works and I can get data results from "Management Studio" - Pictured below.
Question is how do I structure the url of the REST service to bring back a result also ??
http://mscvdcssa18:8080/rest/PointToPropTest?_wadl
------------------------------
Tim Warfe
GIS Officer
MOORABOOL SHIRE COUNCIL
------------------------------