Texas State Parks - Reservable Facilities Data Collection

Jeremy Nobles, Jennifer Estes, Michael Potts - Texas Parks and Wildlife Department

Transcript

1. Texas State Parks: Reservable Facili4es Data Collec4on (RFDC) Jennifer Estes, GISP Jeremy Nobles, GISP Michael PoFs, GISP TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
2. What is a reservable facility? Any facility in the Texas State Park system that is available for public use through reserva4ons. Screened Shelters Cabins Group Facili4es Day Use Facili4es Campsites TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
3. •  Current system allows for only site-standard reserva4ons •  Future system (late 2017) will allow for site- specific reserva4on capabili'es. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
4. Site-standard vs. Site-specific Site-standard: reserve a type of site; first-come, first- served basis upon arrival. Site-specific: reserve a specific site before arrival. –  Campsite #55 TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
5. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
6. 44 of 175 sites (facili4es) 44 of 9,016 in all of Texas State Parks Lake Livingston State Park Interac've Web Map TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
7. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
8. Goals for every reservable facility 1.  Acquire accurate loca4on 2.  Populate aFributes by following consistent data collec4on methodology 3.  Capture photos TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
9. Three Phase Project I – Exis4ng Data Consolida4on II – Missing Data Request III – Data Collec4on and Confirma4on TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
10. Phase I – Exis4ng Data Consolida4on 1.  Current Reserva'on System DB –  9016 records –  Aspa4al –  Oracle 2.  ArcSDE Feature Classes –  Mostly accurate spa4al informa4on –  SQL Server –  Lots of <Nulls> 3.  State Parks Webpages –  Non-Spa4al –  Web data in HTML •  Disconnected from Reserva4on System data TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) Current Reserva'on System DB ArcSDE Feature Classes State Parks Webpages Reservable Facili'es 2.0
11. Phase I – Exis4ng Data Consolida4on 1.  Current Reserva4on System DB –  9016 records –  Aspa4al –  Oracle 2.  ArcSDE Feature Classes –  Mostly accurate spa4al informa4on –  SQL Server –  Lots of <Nulls> 3.  State Parks Webpages –  Non-Spa4al –  Web data in HTML •  Disconnected from Reserva4on System data TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) Current Reserva'on System DB ArcSDE Feature Classes State Parks Webpages Reservable Facili'es 2.0
12. Phase I – Exis4ng Data Consolida4on 1.  Current Reserva4on System DB –  9016 records –  Aspa4al –  Oracle 2.  ArcSDE Feature Classes –  Mostly accurate spa4al informa4on –  SQL Server –  Lots of <Nulls> 3.  State Parks Webpages –  Non-Spa4al –  Web data in HTML •  Disconnected from Reserva4on System data TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) Current Reserva'on System DB ArcSDE Feature Classes State Parks Webpages Reservable Facili'es 2.0
13. Overlap Between Datasets Data Source 1: •  Current Reserva'on System DB –  Oracle –  Aspa4al –  Redundant design –  Unique aFributes: •  Site capacity •  Camping equipment •  Amperage •  Facility name or number Current Reserva'on System DB State Parks Webpages ArcSDE Feature Classes TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
14. •  Data from Reserva4on System Oracle DB (Figure above) –  21 records to represent 1 facility –  65,534 records for 9,016 facili4es Park Name Campground Name Property Type Site Type Site Name Equipment Site Type Capacity Quan 4ty Local Sites Ada Flag Electric Flag Water Flag Sewer Flag Smoking Flag Pet Flag Web Avail Flag Cc Avail Flag Local Avail Flag Taxable Flag Loop Name DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 1 Tent 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 2 Tents 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Car/Truck/Van 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 25 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 30 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 35 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 40 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer Less Than 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 25 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 30 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 35 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 40 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome Less Than 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 25 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 30 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 35 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 40 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up Less Than 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
15. •  Bloated Data – 65,534 records for 9,016 sites – Due to Equipment Type Park Name Campground Name Property Type Site Type Site Name Equipment Site Type Capacity Quan 4ty Local Sites Ada Flag Electric Flag Water Flag Sewer Flag Smoking Flag Pet Flag Web Avail Flag Cc Avail Flag Local Avail Flag Taxable Flag Loop Name DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 1 Tent 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 2 Tents 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Car/Truck/Van 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 25 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 30 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 35 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 40 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer Less Than 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 25 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 30 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 35 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 40 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome Less Than 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 25 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 30 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 35 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 40 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up Less Than 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
16. Park Name Campground Name Property Type Site Type Site Name Equipment Site Type Capacity Quan 4ty Local Sites Ada Flag Electric Flag Water Flag Sewer Flag Smoking Flag Pet Flag Web Avail Flag Cc Avail Flag Local Avail Flag Taxable Flag Loop Name DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 1 Tent 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 2 Tents 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Car/Truck/Van 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 25 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 30 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 35 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer 40 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Finh Wheel/Travel Trailer Less Than 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 25 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 30 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 35 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome 40 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Motorhome Less Than 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 25 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 30 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 35 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up 40 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA DINOSAUR VALLEY SP DINOSAUR VALLEY CAMPSITES Campsite ELECTRIC & WATER CAMPSITE 30AMP 01 Pop Up Less Than 20 n 8 45 2 N Y Y N A Y Y Y Y No ELECTRIC AREA •  Useful info is in Site Type –  494 unique Site Types –  Reduced to 19 Example Site Types with Equivalents TASCATE 2-PRIMITIVE WALKIN = PRIMITIVE WALK IN CAMPSITE WINDMILL BACKPACK-HIKE IN CAMPSITES = RIVER BACKPACK-HIKE IN CAMPSITES ELEC&WATER EQUESTRIAN 20/30 AMP = ELEC&WATER/EQUESTRIAN 30AMP SHELTER REGULAR = SHELTER PREMIUM-LAKESIDE #110-LODGE 1 DOUBLE BED = #115 - LODGE 1 DOUBLE BED TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
17. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
18. Reserva'on System Site Type Facility Type ACC SHELTER W/AMENITIES TAXABLE Screened Shelter CABIN-15 PERSON Cabin CEDAR GROVE-WATER ONLY CAMPSITE Campsite LARGE TRAILER AREA-ELECTRIC & WATER CAMPSITE 50AMP Campsite LARGE TRAILER AREA-SEWER,ELECT&WATER HOST 50AMP Campsite OAK GROVE-SEWER,ELECT&WATER 30AMP Campsite PECAN GROVE-ELECTRIC & WATER CAMPSITE 20FT 50AMP Campsite PECAN GROVE-ELECTRIC & WATER CAMPSITE 25FT 50AMP Campsite PECAN GROVE-ELECTRIC & WATER TENT ONLY 50AMP Campsite PECAN GROVE-SEWER,ELECT&WATER HOST 50AMP Campsite SHELTER AREA-GROUP REC HALL Recrea'on Hall SHELTER REGULAR Screened Shelter SHELTER W/AMENITIES TAXABLE Screened Shelter WAGON CIRCLE-GROUP REC HALL Recrea'on Hall WAGON CIRCLE-GROUP TRAILER AREA 50AMP Campsite WAGON CIRCLE-SEWER,ELECT&WATER PREMIUM 50AMP Campsite ELECTRIC & WATER CAMPSITE 20/30/50 AMP Campsite ELECTRIC & WATER CAMPSITE 20/30AMP Campsite GROUP PICNIC PAVILION 1 Pavilion SEWER,ELECT&WATER 20/30 AMP Campsite SEWER,ELECT&WATER 20/30/50 AMP Campsite ELECTRIC & WATER CAMPSITE 20/30 AMP Campsite ELECTRIC&WATER W/CABLETV 20/30/50 AMP Campsite GROUP CAMPSITE Campsite GROUP MEETING HALL Mee'ng Hall ROOMS - 1 KING BED Lodge ROOMS - 3 QUEEN BEDS Lodge WATER ONLY CAMPSITE Campsite ARENOSA-PRIMITIVE PREMIUM Campsite AUDITORIUM Auditorium CONTRABANDO WEST-PRIMITIVE NO AMENITIES Campsite GRASSY BANKS-PRIMITIVE NO AMENITIES Campsite GRASSY BANKS-PRIMITIVE PREMIUM Campsite LA CUESTA-RV SITES Campsite LOWER MADERA CANYON-PRIMITIVE PREMIUM Campsite MADERA CANYON-PRIMITIVE NO AMENITIES Campsite SEWER,ELECT&WATER 20/50 AMP Campsite UPPER MADERA CANYON-PRIMITIVE PREMIUM Campsite CABIN 1 - 5 PERSON Cabin CABIN 10 - 4 PERSON Cabin CABIN 11 - 3 PERSON Cabin CABIN 12 - 8 PERSON Cabin TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) Facility Type Abbrev Facility Type AM Amphitheater AU Auditorium BR Barracks BH Bunkhouse CB Cabin CS Campsite DH Dining Hall GM Gymnasium HT Hotel LG Lodge MH Mee4ng Hall MC Mini-Cabin MT Motel PV Pavilion PA Picnic Area RH Recrea4on Hall SS Screened Shelter YA Youth Area YT Yurt
19. Overlap Between Datasets Data Source 2: •  ArcSDE Feature Classes –  Campsites feature class •  6,242 –  Buildings and Structures feature class •  3,751 •  Not all are reservable –  Unique aFributes: •  Loca4on (some4mes inaccurate) •  Shade shelter •  Picnic table •  Tentpad –  Many <Null> values Current Reserva4on System DB State Parks Webpages ArcSDE Feature Classes TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
20. Crea4ng the Missing 2,917 Facili4es •  Overflow sites –  Designated to a parking lot or field •  Beach camping –  Designated to the beach •  Primi4ve trail camping –  Designated to a specified distance from the trail •  Individual rooms in a Lodge –  Designated to a building TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
21. Auto-Generated Facili4es at McKinney Falls State Park HQ TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) Imagery Source: Google
22. Upda4ng the Data from the Comforts of the Office •  Loca4on from satellite imagery –  Works best in West Texas –  East Texas typically has too many trees •  Limited aFribute verifica4on –  Satellite imagery –  Google StreetView (limited coverage) Lake Casa Blanca Interna4onal State Park Lake Livingston State Park Imagery Source: Google TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
23. Overlap Between Datasets Data Source 3: •  State Parks Webpages (HTML) –  Aspa4al –  Decentralized –  Accurate as park staff want it to be –  Easily accessible on a per park basis –  Used to fill in the holes manually Current Reserva4on System DB State Parks Webpages ArcSDE Feature Classes TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
24. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
25. Current Reserva'on System DB ArcSDE Feature Classes State Parks Webpages Reservable Facili'es 2.0 Develop Schema •  Easily queried •  Mul4ple rounds of mee4ngs with stakeholders •  Tracking 70 aFributes Park Facility ID Waist-High Grill Loca'on Code Lantern Post Public Name Fire Ring Park Name Sewer Facility Comments Equestrian Facility Internal Facility Comments Pets Allowed Facility Status Parking Spur Length Facility Type Parking Spur Width Facility Name or Number Parking Surface Loop Name Parking Obstruc'ons Horizontal (Road To Facility) Maximum Occupancy Parking Obstruc'ons Ver'cal Facility Rental Period Lockable Door Accessible for Mobility Impaired Sink Electricity Indoor Bathroom Amperage Ceiling Fan Water Air Condi'oning Internet Hea'ng Cable Television Coffeemaker Motorcycle Allowed Dishes Cookware Utensils Car Allowed Dishwasher Van Allowed Refrigerator Truck Allowed Stove Top TravelTrlr Allowed Oven Motorhome Allowed Microwave Bus Allowed Twin Bed Maximum Vehicle Capacity Full Bed Facility Access Method Queen Bed Tent Allowed King Bed Tent Pad Size 1 Bunkbed Tent Pad Size 2 Sleeper Sofa Tent Pad Size 3 Linens Tent Pad Size 4 Towels Natural Shade Indoor Fireplace Shade Shelter La'tude Picnic Table Longitude TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
26. Development of the Primary Key •  Park Facility ID (PFID) – Unique, human-readable alphanumeric string – Key to relate Current Reserva'on System data to ArcSDE Feature Classes – Photos can be related to facili'es using PFID •  Background photo is named “P090CS50_FX01.jpg” TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) P090CS50
27. Park Facility ID (PFID) •  Loca'on Code •  Facility Type Abbrevia'on •  Facility Name TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) P090 CS 50 Number 50 Campsite McKinney Falls
28. Normaliza4on •  Make all the available data fit into the new database •  Cleanup of human-induced problems – “Walk-In” – “walk-in” – “walkin” – “Walk In” – “Walk in” – “Walk-In ” – “ Walk-In” “Walk-In” Combine TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
29. Domains •  Limit valid values – Increase data integrity – Pick lists across all ESRI products TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
30. Phase I – Exis4ng Data Consolida4on •  Scrape/Harvest/Mine •  Normalize •  Consolidate TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) Current Reserva'on System DB ArcSDE Feature Classes State Parks Webpages Reservable Facili'es 2.0
31. Phase II—Data Request •  In the end, we produced the most complete and detailed database of reservable facili4es. •  It was also the one with the most holes. •  Why not request park staff to fill in the holes? TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
32. Park Staff Are Sent Spreadsheets •  Database split by park – 93 Parks – Data valida4on enforcement •  Pick lists •  Numeric ranges •  Field character lengths TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) Database Park 1 Park 2 Park 3 Park 4
33. Park Staff Fill Out Spreadsheets •  76% response rate •  All missing aFributes measured •  Every other value ground-truthed TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) Park 1 Park 2 Park 3 Park 4 Database
34. Publishing Project •  ArcGIS Online – Disconnected edi4ng •  ArcGIS Desktop •  Collector – Web interface – Dashboard TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
35. Using Collector for ArcGIS TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
36. Verified AFribute •  Verified (Green) •  Unvisited (Yellow) •  Revisit (Red) –  Need photos –  Need measurements –  Need photos and measurements TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
37. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
38. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
39. Importance of Developing Instruc4ons •  Data collec'on •  AFribute Defini4ons •  Photo renaming TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
40. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) Importance of Developing Instruc4ons •  Data collec4on •  Alribute Defini'ons •  Photo renaming
41. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) •  Data collec4on •  AFribute Defini4ons •  Photo renaming Importance of Developing Instruc4ons
42. Planning for Field Work •  June 2015-Field Test at McKinney Falls SP – Collector in AGO, domains, aFributes – Photos •  How many needed? •  Device photo? – Es4mated 4me per site type •  Campsite = 5 minutes •  Dining Hall, Cabin, Others = 10 m TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
43. Work Flow for a Typical Campsite: -Photos -Verify AFributes and Loca4on -Measurements: parking spur, tent pad TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
44. Office Planning •  Field 4me per site type •  Travel 4me to park •  Grouped parks for work (2/3/4 night trips; #staff) TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
45. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
46. •  Occupancy reports: – Palo Duro Canyon SP for Tuesday, June 14th – Report created on Monday, June 6th TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
47. •  Coordinated with Infrastructure Division on planned/on going construc4on projects Bridge work at Caddo Lake SP TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
48. •  Scheduling conflicts: – Weather, Flooding, Wildfires – Visitors, Spring Break, Holidays – Other office du4es – Personal schedules TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) Guadalupe River SP-June 2015 Palmelo SP-May 2015
49. •  Parks currently closed: 10/24/2016 Lake Somerville-Nails and Birch Creek Units; Lake Whitney; SFA •  Other parks are s4ll recovering and rebuilding from past flooding events TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
50. •  Logis4cs: – Availability of: •  Vehicles •  Equipment •  Lodging – Events at parks Summer Camp at McKinney Falls SP TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
51. Field Work •  Supplies: – iPhone 6+, iPad – Cameras, SD cards, extra baFeries – BaFery supply & many cables – Measuring wheels – Paper maps TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
52. Photos •  Cabins: 10-20 per facility -inside and outside photos •  Campsites: 4 – 10 photos •  Renaming Photos: -protocol for renaming photos -sonware (Bulk Rename U4lity) -folder structure TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
53. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
54. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
55. Stats •  Stats: –  Staff field hours: 1,700+ –  Miles driven: 20,900+ –  # of pictures taken: 39,000+ –  Total GB photo storage: 373+ –  Fitbit Stats: •  at Garner SP: 19,334 steps; 8.29 miles •  at Ray Roberts Lake SP: 15,931 steps; 6.83 miles TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
56. •  Photos: Working TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
57. •  Photos: Facili4es TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
58. •  Photos: Wildlife TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
59. •  Photos: Scenic Goose Island SP-Big Tree Mustang Island SP Lake Bob Sandlin SP Mar4n Dies Jr. SP Bastrop SP Colorado Bend SP PalmeFo SP Garner SP Possum Kingdom SP Cooper Lake SP South Sulphur Unit TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
60. Wrap-up/Lessons Learned •  Texas is a BIG state! TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
61. •  Training, training, training –  Protocols/Procedures •  Field Data Collec4on Instruc4ons •  AFribute Defini4ons •  Facility Photo Naming Standards –  Consistency is key •  Communica4on –  With team –  With park staff •  Data clean-up before star4ng field work TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
62. •  Not everyone is a professional photographer TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
63. Project Status •  How many parks len? – As of today, 1 park: Cedar Hill State Park •  How many revisits iden4fied? – Need photos and/or measurements – ~20% TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
64. What Next? •  Maintenance applica4ons – Data and photos •  Publish REST endpoint to provide data feeds – Poten4ally the new reserva4on system – Facility management system •  Public Viewer…coming soon TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
65. Credits •  PGR Manager - Chris Beckcom •  SP Business Management Staff –  Including SP Data Management Team •  SP Web Team –  Cynthia Pickens, Sasha Kodet, and Phil Plata •  Park Staff & Park Hosts TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
66. Thank you. Any ques4ons? TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)