steveoh

Spatial Filters

Introduction

Create a set of spatial filters based on OGC spatial functions.

Proposal

Example Objects

steveoh

[
  {
    "request_count": "9590125",
    "search_table": "sgid10.boundaries.municipalities"
  },
  {
    "request_count": "9509793",
    "search_table": "sgid10.location.zipplus4points"
  },
  {

steveoh

.shorten-sm {
  height: 50px;
  overflow: hidden;
  position: relative;
}

.shorten-sm:before {
  content: '';
  width: 100%;
  height: 100%;

steveoh

export default () => {
    const [active, setActive] = useState('agent');

    return (
        <div fluid className="filter-selector">
            <ButtonGroup>
                <Button color={active === 'agent' ? 'warning' : 'secondary'} onClick={() => setActive('agent')}>Agent</Button>
                <Button color={active === 'offender' ? 'warning' : 'secondary'} onClick={() => setActive('offender')}>Offender</Button>
                <Button color={active === 'location' ? 'warning' : 'secondary'} onClick={() => setActive('location')}>Location</Button>
                <Button color={active === 'date' ? 'warning' : 'secondary'} onClick={() => setActive('date')}>Date</Button>

steveoh

from pprint import pprint

import arcpy

arcpy.env.workspace = r'stage.sde'

output = {}

tables = []
for dirpath, dirnames, walked_tables in arcpy.da.Walk(datatype=['FeatureClass', 'Table']):

steveoh

SELECT
	cv_domain.value('DomainName[1]', 'nvarchar(50)') AS 'DomainName',
	coded_value.value('Code[1]','nvarchar(50)') AS 'Code',
	coded_value.value('Name[1]','nvarchar(50)') AS 'Value'
FROM
	sde.GDB_ITEMS AS items INNER JOIN sde.GDB_ITEMTYPES AS itemtypes ON
		items.Type = itemtypes.UUID
CROSS APPLY	
	items.Definition.nodes('/GPCodedValueDomain2/CodedValues/CodedValue') AS CodedValues(coded_value)
CROSS APPLY	

steveoh

var myDocs = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
            var arcGisProLocation = Path.Combine(myDocs, "ArcGIS", "AddIns", "ArcGISPro");

            var attribute = (GuidAttribute) _assembly.GetCustomAttributes(typeof(GuidAttribute), true)[0];
            var proAddinFolder = $"{{{attribute.Value}}}";

            var addinFolder = Path.Combine(arcGisProLocation, proAddinFolder);
            if (!Directory.Exists(addinFolder))
                return null;

steveoh

devsummit 2018

• maturaty dev summit. not many ground breaking features. more polish
• Machine learning and AI were big this year with the keynote being from microsoft and the introduction of a geovm in azure that can be provisioned.
• Some cool demo's on training models to understand data and then letting them predict the future or act on other data was pretty cool.
• https://jfkfiles2.azurewebsites.net/
• utah roads/crash data was used in the keynote

Geocoding

• 10.6 has a new geocoding engine but users can't create them until pro 2.2. around UC

steveoh

def replace_codes_with_values(feature_class, field_info, domain_info):
    field_domain_map = [(field, field.domain) for field in field_info if field.domain]
    fields = [field[0] for field in field_domain_map]
    field_names = [field.name for field in fields]
    domain_names = [domain[1] for domain in field_domain_map]

    domain_lookup = {}
    for name in domain_names:
        domain_lookup[name] = [domain for domain in domain_info if domain.name == name][0]

steveoh

var shape = (Polyline)row["Shape"];

var point = (MapPoint)GeometryEngine.Instance.Project(userClickGeometry, shape.SpatialReference);
var proximity = GeometryEngine.Instance.NearestPoint(shape, point);
var distance = proximity.Distance * 2;

var vertices = new List<Coordinate2D>
{
    new Coordinate2D(point),
    new Coordinate2D(proximity.Point),