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)
system (late 2017) will allow for site- specific reserva4on capabili'es. TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
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)
of Texas State Parks Lake Livingston State Park Interac've Web Map TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
Populate aFributes by following consistent data collec4on methodology 3. Capture photos TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
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
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
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
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)
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)
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)
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)
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
– 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)
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)
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)
(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)
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)
– 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
• 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
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)
– 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
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
(Red) – Need photos – Need measurements – Need photos and measurements TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
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)
– Other office du4es – Personal schedules TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR) Guadalupe River SP-June 2015 Palmelo SP-May 2015
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)
extra baFeries – BaFery supply & many cables – Measuring wheels – Paper maps TPWD | State Parks | Natural Resources Program | Planning & Geospa4al Resources (PGR)
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)
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)
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)
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)
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)
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)