Template:Bridge Data fetch: Difference between revisions
From Indian River Lagoon Project
(Created page with "<!-- Cargo database Links --> [[Bridge_Data_Table{{!}}View Bridge Data Table]] {{!}} [[Bridge_Data{{!}}View Bridge Data Page]] <!-- Fetch the Data --> <!-- {{#get_web_data: u...") |
mNo edit summary |
||
| Line 2: | Line 2: | ||
[[Bridge_Data_Table{{!}}View Bridge Data Table]] {{!}} [[Bridge_Data{{!}}View Bridge Data Page]] | [[Bridge_Data_Table{{!}}View Bridge Data Table]] {{!}} [[Bridge_Data{{!}}View Bridge Data Page]] | ||
<!-- Fetch the Data --> | This template uses Extension:externaldata to fetch data from a url via json. Then it sends the data to Template:Bridge_Data_store which creates the Cargo table and stores the fetched data. | ||
Edit this template for instructions. | |||
<!-- | |||
Uncomment the two code sections below to fetch new data. Caution: This will dump the current data. if you need to keep the old table, use PHPAdmin to back it up before uncommenting this page. | |||
Click Preview to start the data fetch and store process. This may take a minute depending on the data size. | |||
***Make sure to RECOMMENT the code sections before saving this file or it will overwrite the data every time it is viewed.*** | |||
--> | |||
<!-- **Fetch the Data** --> | |||
<!-- | <!-- | ||
{{#get_web_data: | {{#get_web_data: | ||
| Line 9: | Line 21: | ||
|data=ObjectID=objectid,Status=status,Date=date,County_003=county_code_003,Place_004=place_code_004,Route_005d=route_number_005d,Direction_005e=direction_005e,Features_006a=features_desc_006a,Critical_006b=critical_facility_006b,Facility_007=facility_carried_007,Number_008=structure_number_008,Location_009=location_009,Latitude_016=lat_016,Longitude_017=long_017,Owner_022=owner_022,Built_027=year_built_027,Lanes_028a=traffic_lanes_on_028a,Traffic_029=adt_029,Traffic_Year_030=year_adt_030,Service_On_042a=service_on_042a,Service_Under_042b=service_und_042b,Kind_043a=structure_kind_043a,Type_043b=structure_type_043b,Length_049=structure_len_mt_049,Width_052=deck_width_mt_052,Deck_058=deck_cond_058,Superstructure_059=superstructure_cond_059,Substructure_060=substructure_cond_060,Channel_061=channel_cond_061,Culvert_062=culvert_cond_062,Inspect_Date_090=date_of_inspect_090,Direction_102=traffic_direction_102,Rebuilt_106=year_reconstructed_106,Deck_Type_107=deck_structure_type_107,Scour_113=scour_critical_113,Future_114=future_adt_114,Future_Year_115=year_of_future_adt_115,Clearance_116=min_nav_clr_mt_116 }} | |data=ObjectID=objectid,Status=status,Date=date,County_003=county_code_003,Place_004=place_code_004,Route_005d=route_number_005d,Direction_005e=direction_005e,Features_006a=features_desc_006a,Critical_006b=critical_facility_006b,Facility_007=facility_carried_007,Number_008=structure_number_008,Location_009=location_009,Latitude_016=lat_016,Longitude_017=long_017,Owner_022=owner_022,Built_027=year_built_027,Lanes_028a=traffic_lanes_on_028a,Traffic_029=adt_029,Traffic_Year_030=year_adt_030,Service_On_042a=service_on_042a,Service_Under_042b=service_und_042b,Kind_043a=structure_kind_043a,Type_043b=structure_type_043b,Length_049=structure_len_mt_049,Width_052=deck_width_mt_052,Deck_058=deck_cond_058,Superstructure_059=superstructure_cond_059,Substructure_060=substructure_cond_060,Channel_061=channel_cond_061,Culvert_062=culvert_cond_062,Inspect_Date_090=date_of_inspect_090,Direction_102=traffic_direction_102,Rebuilt_106=year_reconstructed_106,Deck_Type_107=deck_structure_type_107,Scour_113=scour_critical_113,Future_114=future_adt_114,Future_Year_115=year_of_future_adt_115,Clearance_116=min_nav_clr_mt_116 }} | ||
--> | --> | ||
<!-- Store Fetched Data --> | |||
<!-- **Store Fetched Data** --> | |||
<!-- Uncomment below to store the fetched data. Caution: Uncommenting this will dump the table's current data. --> | |||
<!-- | <!-- | ||
{{#display_external_table:template=Bridge_Data_store|data= | {{#display_external_table:template=Bridge_Data_store|data= | ||
ObjectID=ObjectID,Status=Status,Date=Date,County_003=County_003,Place_004=Place_004,Route_005d=Route_005d,Direction_005e=Direction_005e,Features_006a=Features_006a,Critical_006b=Critical_006b,Facility_007=Facility_007,Number_008=Number_008,Location_009=Location_009,Latitude_016=Latitude_016,Longitude_017=Longitude_017,Owner_022=Owner_022,Built_027=Built_027,Lanes_028a=Lanes_028a,Traffic_029=Traffic_029,Traffic_Year_030=Traffic_Year_030,Service_On_042a=Service_On_042a,Service_Under_042b=Service_Under_042b,Kind_043a=Kind_043a,Type_043b=Type_043b,Length_049=Length_049,Width_052=Width_052,Deck_058=Deck_058,Superstructure_059=Superstructure_059,Substructure_060=Substructure_060,Channel_061=Channel_061,Culvert_062=Culvert_062,Inspect_Date_090=Inspect_Date_090,Direction_102=Direction_102,Rebuilt_106=Rebuilt_106,Deck_Type_107=Deck_Type_107,Scour_113=Scour_113,Future_114=Future_114,Future_Year_115=Future_Year_115,Clearance_116=Clearance_116 }} | ObjectID=ObjectID,Status=Status,Date=Date,County_003=County_003,Place_004=Place_004,Route_005d=Route_005d,Direction_005e=Direction_005e,Features_006a=Features_006a,Critical_006b=Critical_006b,Facility_007=Facility_007,Number_008=Number_008,Location_009=Location_009,Latitude_016=Latitude_016,Longitude_017=Longitude_017,Owner_022=Owner_022,Built_027=Built_027,Lanes_028a=Lanes_028a,Traffic_029=Traffic_029,Traffic_Year_030=Traffic_Year_030,Service_On_042a=Service_On_042a,Service_Under_042b=Service_Under_042b,Kind_043a=Kind_043a,Type_043b=Type_043b,Length_049=Length_049,Width_052=Width_052,Deck_058=Deck_058,Superstructure_059=Superstructure_059,Substructure_060=Substructure_060,Channel_061=Channel_061,Culvert_062=Culvert_062,Inspect_Date_090=Inspect_Date_090,Direction_102=Direction_102,Rebuilt_106=Rebuilt_106,Deck_Type_107=Deck_Type_107,Scour_113=Scour_113,Future_114=Future_114,Future_Year_115=Future_Year_115,Clearance_116=Clearance_116 }} | ||
--> | |||
<!-- | |||
Click Preview to start the data fetch and store process. This may take a minute depending on the data size. | |||
***Make sure to RECOMMENT the above code before saving this page or it will overwrite the data every time its is viewed. | |||
--> | --> | ||
Latest revision as of 17:56, November 11, 2020
View Bridge Data Table | View Bridge Data Page
This template uses Extension:externaldata to fetch data from a url via json. Then it sends the data to Template:Bridge_Data_store which creates the Cargo table and stores the fetched data.
Edit this template for instructions.
