Skip to content
View trkrgrcn's full-sized avatar
🏠
Working from home
🏠
Working from home
48 followers · 26 following

Block or report trkrgrcn

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
trkrgrcn/README.md

🚀 Hi there, I'm Türker! 👋

I am a Surveying Engineer and GIS Developer focused on building high-performance spatial systems and smart city solutions. I bridge the gap between geographic data and robust software engineering, primarily within the Linux ecosystem.

🛠️ Tech Stack & Expertise

Category Tools & Technologies
Languages C++ Python SQL
Geo-Spatial PostGIS QGIS GDAL
Infrastructure Linux Docker Git
Database PostgreSQL

🔭 Current Focus

  • 🏙️ Smart Cities: Developing scalable portal applications for modern urban management.
  • ⚙️ Performance: Mastering C++ for system-level programming and high-speed spatial algorithms.
  • 🐧 Systems: Deep-diving into Linux system administration and performance troubleshooting.
  • 👯 Collaboration: Looking to contribute to C++, PostgreSQL, or Open-Source GIS projects.

💬 Ask Me About

  • Database Optimization: Tuning PostgreSQL/PostGIS for massive spatial datasets.
  • Linux Admin: System troubleshooting, automation, and environment setup.
  • Modern Surveying: Integrating traditional engineering with modern software stacks.

📫 Reach Me At

⚡ Fun Fact

Approximately 80% of all data has a spatial component. I’m just here to make sure that 80% actually makes sense.

📊 My GitHub Statistics

Pinned Loading

  1. Using PostGIS in ABP Framework Using PostGIS in ABP Framework
    1 
     Configure<AbpDbContextOptions>(options =>
    2 
       {
    3 
            options.UseNpgsql(opt=>{
    4 
           opt.UseNetTopologySuite();
    5 
           });
  2. nginx conf file nginx conf file
    1 
    server {
    2 
        listen 443 ssl;
    3 
        server_name yourdomainname;
    4 
    
              
    
              
    
                5
                
        ssl_certificate /path/sslfile.crt;
    
              
    
          
    
    
    
  
    

    3. 

      

  3. 
  
    
    
    
      
    
        
        Postgresql Backup Restore  Postgresql Backup Restore      
    

          
    
              
    
                1
                
    Backup
    
              
    
              
    
                2
                
    PGPASSWORD="yourpassword" pg_dump -h hostip -U postgres -d databsename -f backupfile
    
              
    
              
    
                3
                
    
              
    
              
    
                4
                
    Restore
    
              
    
              
    
                5
                
    PGPASSWORD='yourpassword' psql -U postgres -h hostip -p port -d databasename -f backupfile
    
              
    
          
    
    
    
  
    

    4. 

      

  4. 
  
    
    
    
      
    
        
        ubuntu service examplefile for .netC...  ubuntu service examplefile for .netCore       
    

          
    
              
    
                1
                
    [Unit]
    
              
    
              
    
                2
                
    Description= Service Name
    
              
    
              
    
                3
                
    After=network.target
    
              
    
              
    
                4
                
    
              
    
              
    
                5
                
    [Service]
    
              
    
          
    
    
    
  
    

    5. 

      
  5. 
  
    
    
    
      
    
        
    
            
          nvim-config  nvim-config          Public
        
    
      
    


      
    
        
      
    

      
    
          
  
  Lua


      
    
    
    
  
    

    6.