Pinned Loading

1. GeoDBToText GeoDBToText Public

   The GeoDBToText ArcGIS Python script tool exports each feature class in a geodatabase to human and machine text (pipe separated values/WKT, ESRI JSON) file formats.

   Python 1

2. SQL: Select points that fall within ... SQL: Select points that fall within a polygon

   1

   -- SQL Server 2008R2, there are better functions in later versions of Sql Server such as STContains()

   2

   SELECT Animals.GroupNumber

   3

   FROM LegacyUnits INNER JOIN

   4

   Animals ON LegacyUnits.PolygonFeature.STIntersects(Animals.Location) = 1

   5

3. YBLO-Observation-Protocol-ObsProt YBLO-Observation-Protocol-ObsProt Public

   The NPS Yellow-billed loons monitoring program relies on NPS Park Observer software for field data collection. The software relies on an observation protocol (.obsprot) file to define what data is …

   1 1

4. ArcPy: Access feature class data ArcPy: Access feature class data

   1

   import arcpy

   2

   import numpy

   3

   input = r"C:\Work\Waypoints.shp"

   4

   arr = arcpy.da.FeatureClassToNumPyArray(input, ('ident', 'Latitude', 'Longitude'))

   5

   for row in arr:

5. Describe SQL Server Tables Describe SQL Server Tables

   1

   -- Table descriptions

   2

   SELECT DISTINCT u.name + '.' + t.name AS [Table], td.value AS TableDescription

   3

   FROM         sys.sysobjects AS t INNER JOIN

   4

                         sys.sysusers AS u ON u.uid = t.uid LEFT OUTER JOIN

   5

                         sys.extended_properties AS td ON td.major_id = t.id AND td.minor_id = 0 AND td.name = 'MS_Description' INNER JOIN

6. TrimbleGeoDBToDatabase TrimbleGeoDBToDatabase Public

   Shallow Lakes Monitoring: Trimble Geodatabase to Database Import Tool

   Python 1