Tag Info

Hot answers tagged


Assuming you are using geography type which I am guessing from geog name, query to find all census blocks within 1609 meters ~ 1 mile) of parcel denoted by key '12345'. SELECT census_blocks.* FROM census_blocks INNER JOIN parcels ON ST_DWithin(census_blocks.geog, parcels.geog, 1609) WHERE parcels.parcel_id = '12345';


The following approach requires you to have an Advance license: Convert your polygons to lines using the Feature To Line tool Identify the distance from your centroid point to the line using the Generate Near Table tool These two steps can be wrapped up in a model.


Within the the Generate Near Table (Analysis) tool select GEODESIC as your method. This finds the shortest line along the ellipsoid surface of the earth rather than the planar surface of a projection. This is appropriate when working with large areas like the entire continental US. ArcGIS Resource and Image Source


If you need to use the road distance as the cost of travel, then you would indeed need to use Network Analyst if you are using ArcGIS and want to take advantage of the restrictions imposed on the roads in the network dataset (one-way, turns, etc.). The solver you would need for this is OD Cost Matrix. You basically need to generate a matrix where each point ...


100% agree with @Fetzer, this is LR task, can be bulky though. Try this field calculator expression to find X of new point. def getXY (point, id, d2add): mxd = arcpy.mapping.MapDocument("CURRENT") lyr=arcpy.mapping.ListLayers(mxd,"LINES")[0] q='"ITEMID"=%s%s%s' %(r"'",id,"'") with arcpy.da.SearchCursor(lyr,"Shape@",q) as cursor: for row in ...

Only top voted, non community-wiki answers of a minimum length are eligible