Points of interest (POIs) in Jefferson County, Colorado.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Data Type: Dynamic. Vintage: Current. Editing in ASP generally occurs on a daily to weekly basis.</SPAN></P><P><SPAN>Points of interest include airports, amusement parks, campgrounds, cemeteries, colleges, community or neighborhood names, dams, event centers, fire stations, geologic features and sites, golf courses or golf clubs, government sites, historic sites, hospitals, lakes, malls, mills, mines, museums, nature centersm, sites on the national historic register, national forests, national wildlife refuges, picnic areas, parks, peaks, RTD park and rides (PNRs), post offices, recreational facilities and sites, scenic overlooks and viewpoints, schools, technology centers, trailheads, towers, visitor centers, wilderness areas, historic wildfires and sites with multiple or other varied characteristics of interest. Note that not all POI features are located within Jefferson County, Colorado.</SPAN></P><P><SPAN>Column POIUID is a numeric identifer unique to each point of interest feature. It is the 'business' key for this data and should be used for any tabular joins.</SPAN></P><P><SPAN>Column POITYPECODE is a four-character string which may be joined to the same column in the lookup (domain) table "POITypeCode" to yield a description of each code. To determine the description for POI codes, the syntax is per the following pseudo-SQL:</SPAN></P><P STYLE="text-indent:20;"><SPAN>SELECT poiuid, poiname, a.poitypecode, description poi_description </SPAN></P><P STYLE="text-indent:20;"><SPAN>FROM pointofinterest a, poitypecode b </SPAN></P><P STYLE="text-indent:20;"><SPAN>WHERE a.poitypecode = b.poitypecode </SPAN></P><P STYLE="text-indent:20;"><SPAN>ORDER BY &lt;column_choice&gt;</SPAN></P><P><SPAN>Column POINAME is the POI feature's name. This name will be found as a distinct record (column "Name") in the "Name" domain table. Multiple names may be associated with a POI, hence the bridge table "POIAndName" contains all point of interest (POIUID) and name (NAMEUID) associations. The "POIAndName" bridge table also carries a NAMEPRIORITY column where the value is '1' for the primary name associated with the POI feature and '2' for all secondary name associations. To determine all names associated with POI features, the syntax is per the following pseudo-SQL:</SPAN></P><P STYLE="text-indent:20;"><SPAN>SELECT a.poiuid, poitypecode, b.nameuid, name, namepriority </SPAN></P><P STYLE="text-indent:20;"><SPAN>FROM pointofinterest a, poiandname b, name c </SPAN></P><P STYLE="text-indent:20;"><SPAN>WHERE a.poiuid = b.poiuid AND b.nameuid = c.nameuid </SPAN></P><P STYLE="text-indent:20;"><SPAN>ORDER BY &lt;column_choice&gt;</SPAN></P><P><SPAN>Points of interest features may also associated with one or more addresses, but unlike names, do not directly carry an address on the feature. Instead, a join must be made to the "POIAndAddress" bridge table and the "MasterAddress" feature class to see all point of interest (POIUID) and address (ADNO) associations. To determine all addresses linked to POI features, the syntax is per the following pseudo-SQL:</SPAN></P><P STYLE="text-indent:20;"><SPAN>SELECT a.poiuid, poiname, b.adno, address </SPAN></P><P STYLE="text-indent:20;"><SPAN>FROM pointofinterest a, poiandaddress b, masteraddress c </SPAN></P><P STYLE="text-indent:20;"><SPAN>WHERE a.poiuid = b.poiuid AND b.adno = c.adno </SPAN></P><P STYLE="text-indent:20;"><SPAN>ORDER BY &lt;column_choice&gt;</SPAN></P><P><SPAN>The source production "PointOfInterest" feature class lives in the Address Street political (ASP) database and is maintained through the ASP Tools. The feature class lives in an enterprise SDE / Oracle database and is versioned with the "edits to base" option.</SPAN></P><P><SPAN>This data is pushed to SDEWHP via the "ASP to Warehouse" (ASP2WH) Python-based processing.</SPAN></P><P><SPAN>Data is in State Plane Grid Coordinates, Colorado Central Zone, NAD83.</SPAN></P></DIV></DIV></DIV>
[]
nan
nan
nan