Joining attributes by location error when finding polygons within district boundaries?Sum of attributes in Spatial join when polygons cross boundaries in ArcMap?Update Join Attributes by LocationClip and spatial join of hydrology polygon layer with district layer using ArcPy?Adding spatial information to a table, using spatial join but getting null columnsUsing “Join Attributes by Location” to perform spatial join of layer with joined data on dissolved layerHow to join attributes by location for more than one located feature in QGIS?Join attributes by location very slow on QGIS 3.0Spatial joins with no common fields?How to use “Merge vector layers” in QGIS using Geopackages as output with FIDs duplicatedJoining 2 layers by location doesn't join desired fields from attributes tables

A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?

Adding span tags within wp_list_pages list items

How to find program name(s) of an installed package?

Why Is Death Allowed In the Matrix?

Why can't I see bouncing of a switch on an oscilloscope?

Mage Armor with Defense fighting style (for Adventurers League bladeslinger)

Why are 150k or 200k jobs considered good when there are 300k+ births a month?

Why, historically, did Gödel think CH was false?

What do three bars across the stem of a note mean?

Approximately how much travel time was saved by the opening of the Suez Canal in 1869?

What do "features" mean/refer to in this sentence?

Is a conference paper whose proceedings will be published in IEEE Xplore counted as a publication?

Why "Having chlorophyll without photosynthesis is actually very dangerous" and "like living with a bomb"?

Why doesn't H₄O²⁺ exist?

Theorems that impeded progress

Why was the small council so happy for Tyrion to become the Master of Coin?

What's the output of a record cartridge playing an out-of-speed record

How does strength of boric acid solution increase in presence of salicylic acid?

Prove that NP is closed under karp reduction?

Modeling an IP Address

Can I ask the recruiters in my resume to put the reason why I am rejected?

Pattern match does not work in bash script

How old can references or sources in a thesis be?

Characters won't fit in table



Joining attributes by location error when finding polygons within district boundaries?


Sum of attributes in Spatial join when polygons cross boundaries in ArcMap?Update Join Attributes by LocationClip and spatial join of hydrology polygon layer with district layer using ArcPy?Adding spatial information to a table, using spatial join but getting null columnsUsing “Join Attributes by Location” to perform spatial join of layer with joined data on dissolved layerHow to join attributes by location for more than one located feature in QGIS?Join attributes by location very slow on QGIS 3.0Spatial joins with no common fields?How to use “Merge vector layers” in QGIS using Geopackages as output with FIDs duplicatedJoining 2 layers by location doesn't join desired fields from attributes tables






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















I am using QGIS 3.5. I have a large shapefile (760 MB) with 1800 polygons representing different bird species ranges (download link)



I have a second shapefile with polygons of district boundaries (download link)



I have ensured the geometries are valid in both shapefiles and their CRS are equal. My goal is to identify the bird species present in each district. The output attribute table should include a column for the district ID (called c_code_11 in the data) of each district where the species exists.



I did a Join Attributes by Location with input layer as the species ranges and join layer as the district boundaries. I put 'intersects' and 'contains' as the geometric predicate, 'fields to add' as c_code_11 (the district ID), 'join type' as one-to-many, and then saved the joined layer as a shapefile to my local machine.



The output shapefile gets created on my computer, but at 3% completion, I get a list of errors saying the features could not be written to the shapefile. The process still runs to 100% completion (takes forever) and outputs a 4GB shapefile, but it is empty.



enter image description here



Any idea what is happening and how I can fix this?



Since the output shapefile is beyond the size limit, I re-ran the join attribute by location and saved the output as a GeoPackage. Now I am getting the following error.enter image description here










share|improve this question



















  • 3





    Try a different file format. You are hitting the shapefile size limit

    – JGH
    Apr 2 at 17:09











  • 1) Your downloaded files are not suitable for analysis, there are no additional files; 2) Break the main files into 2 - 3 equal areas and process them separately, then reassemble them into one ...

    – Cyril
    Apr 2 at 17:26











  • Sorry Cyril, I updated the download link -- it has all the files now.

    – mosquitonomics
    Apr 2 at 17:52











  • Try outputting to a temporary layer (this is the default output type). Then export the temporary layer to a permanent file. This will allow you to test different export formats without waiting for the algorithm to run each time.

    – csk
    Apr 2 at 19:34






  • 1





    Please always provide errors as text rather than pictures.

    – PolyGeo
    Apr 2 at 21:40

















1















I am using QGIS 3.5. I have a large shapefile (760 MB) with 1800 polygons representing different bird species ranges (download link)



I have a second shapefile with polygons of district boundaries (download link)



I have ensured the geometries are valid in both shapefiles and their CRS are equal. My goal is to identify the bird species present in each district. The output attribute table should include a column for the district ID (called c_code_11 in the data) of each district where the species exists.



I did a Join Attributes by Location with input layer as the species ranges and join layer as the district boundaries. I put 'intersects' and 'contains' as the geometric predicate, 'fields to add' as c_code_11 (the district ID), 'join type' as one-to-many, and then saved the joined layer as a shapefile to my local machine.



The output shapefile gets created on my computer, but at 3% completion, I get a list of errors saying the features could not be written to the shapefile. The process still runs to 100% completion (takes forever) and outputs a 4GB shapefile, but it is empty.



enter image description here



Any idea what is happening and how I can fix this?



Since the output shapefile is beyond the size limit, I re-ran the join attribute by location and saved the output as a GeoPackage. Now I am getting the following error.enter image description here










share|improve this question



















  • 3





    Try a different file format. You are hitting the shapefile size limit

    – JGH
    Apr 2 at 17:09











  • 1) Your downloaded files are not suitable for analysis, there are no additional files; 2) Break the main files into 2 - 3 equal areas and process them separately, then reassemble them into one ...

    – Cyril
    Apr 2 at 17:26











  • Sorry Cyril, I updated the download link -- it has all the files now.

    – mosquitonomics
    Apr 2 at 17:52











  • Try outputting to a temporary layer (this is the default output type). Then export the temporary layer to a permanent file. This will allow you to test different export formats without waiting for the algorithm to run each time.

    – csk
    Apr 2 at 19:34






  • 1





    Please always provide errors as text rather than pictures.

    – PolyGeo
    Apr 2 at 21:40













1












1








1








I am using QGIS 3.5. I have a large shapefile (760 MB) with 1800 polygons representing different bird species ranges (download link)



I have a second shapefile with polygons of district boundaries (download link)



I have ensured the geometries are valid in both shapefiles and their CRS are equal. My goal is to identify the bird species present in each district. The output attribute table should include a column for the district ID (called c_code_11 in the data) of each district where the species exists.



I did a Join Attributes by Location with input layer as the species ranges and join layer as the district boundaries. I put 'intersects' and 'contains' as the geometric predicate, 'fields to add' as c_code_11 (the district ID), 'join type' as one-to-many, and then saved the joined layer as a shapefile to my local machine.



The output shapefile gets created on my computer, but at 3% completion, I get a list of errors saying the features could not be written to the shapefile. The process still runs to 100% completion (takes forever) and outputs a 4GB shapefile, but it is empty.



enter image description here



Any idea what is happening and how I can fix this?



Since the output shapefile is beyond the size limit, I re-ran the join attribute by location and saved the output as a GeoPackage. Now I am getting the following error.enter image description here










share|improve this question
















I am using QGIS 3.5. I have a large shapefile (760 MB) with 1800 polygons representing different bird species ranges (download link)



I have a second shapefile with polygons of district boundaries (download link)



I have ensured the geometries are valid in both shapefiles and their CRS are equal. My goal is to identify the bird species present in each district. The output attribute table should include a column for the district ID (called c_code_11 in the data) of each district where the species exists.



I did a Join Attributes by Location with input layer as the species ranges and join layer as the district boundaries. I put 'intersects' and 'contains' as the geometric predicate, 'fields to add' as c_code_11 (the district ID), 'join type' as one-to-many, and then saved the joined layer as a shapefile to my local machine.



The output shapefile gets created on my computer, but at 3% completion, I get a list of errors saying the features could not be written to the shapefile. The process still runs to 100% completion (takes forever) and outputs a 4GB shapefile, but it is empty.



enter image description here



Any idea what is happening and how I can fix this?



Since the output shapefile is beyond the size limit, I re-ran the join attribute by location and saved the output as a GeoPackage. Now I am getting the following error.enter image description here







qgis-3 spatial-join






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Apr 2 at 21:39









PolyGeo

53.9k1781245




53.9k1781245










asked Apr 2 at 16:41









mosquitonomicsmosquitonomics

92




92







  • 3





    Try a different file format. You are hitting the shapefile size limit

    – JGH
    Apr 2 at 17:09











  • 1) Your downloaded files are not suitable for analysis, there are no additional files; 2) Break the main files into 2 - 3 equal areas and process them separately, then reassemble them into one ...

    – Cyril
    Apr 2 at 17:26











  • Sorry Cyril, I updated the download link -- it has all the files now.

    – mosquitonomics
    Apr 2 at 17:52











  • Try outputting to a temporary layer (this is the default output type). Then export the temporary layer to a permanent file. This will allow you to test different export formats without waiting for the algorithm to run each time.

    – csk
    Apr 2 at 19:34






  • 1





    Please always provide errors as text rather than pictures.

    – PolyGeo
    Apr 2 at 21:40












  • 3





    Try a different file format. You are hitting the shapefile size limit

    – JGH
    Apr 2 at 17:09











  • 1) Your downloaded files are not suitable for analysis, there are no additional files; 2) Break the main files into 2 - 3 equal areas and process them separately, then reassemble them into one ...

    – Cyril
    Apr 2 at 17:26











  • Sorry Cyril, I updated the download link -- it has all the files now.

    – mosquitonomics
    Apr 2 at 17:52











  • Try outputting to a temporary layer (this is the default output type). Then export the temporary layer to a permanent file. This will allow you to test different export formats without waiting for the algorithm to run each time.

    – csk
    Apr 2 at 19:34






  • 1





    Please always provide errors as text rather than pictures.

    – PolyGeo
    Apr 2 at 21:40







3




3





Try a different file format. You are hitting the shapefile size limit

– JGH
Apr 2 at 17:09





Try a different file format. You are hitting the shapefile size limit

– JGH
Apr 2 at 17:09













1) Your downloaded files are not suitable for analysis, there are no additional files; 2) Break the main files into 2 - 3 equal areas and process them separately, then reassemble them into one ...

– Cyril
Apr 2 at 17:26





1) Your downloaded files are not suitable for analysis, there are no additional files; 2) Break the main files into 2 - 3 equal areas and process them separately, then reassemble them into one ...

– Cyril
Apr 2 at 17:26













Sorry Cyril, I updated the download link -- it has all the files now.

– mosquitonomics
Apr 2 at 17:52





Sorry Cyril, I updated the download link -- it has all the files now.

– mosquitonomics
Apr 2 at 17:52













Try outputting to a temporary layer (this is the default output type). Then export the temporary layer to a permanent file. This will allow you to test different export formats without waiting for the algorithm to run each time.

– csk
Apr 2 at 19:34





Try outputting to a temporary layer (this is the default output type). Then export the temporary layer to a permanent file. This will allow you to test different export formats without waiting for the algorithm to run each time.

– csk
Apr 2 at 19:34




1




1





Please always provide errors as text rather than pictures.

– PolyGeo
Apr 2 at 21:40





Please always provide errors as text rather than pictures.

– PolyGeo
Apr 2 at 21:40










1 Answer
1






active

oldest

votes


















0














My verdict.



Your geodata is faulty, especially the file with the name india_botw, see the drawing close and no super GIS can work with them normally. Until the file is put in order, you will not be able to see success, in the future, try not to download corrupted large files, don't make me chase you all over india ...:-),



enter image description here



enter image description here



good luck ...






share|improve this answer

























    Your Answer








    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "79"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317531%2fjoining-attributes-by-location-error-when-finding-polygons-within-district-bound%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    My verdict.



    Your geodata is faulty, especially the file with the name india_botw, see the drawing close and no super GIS can work with them normally. Until the file is put in order, you will not be able to see success, in the future, try not to download corrupted large files, don't make me chase you all over india ...:-),



    enter image description here



    enter image description here



    good luck ...






    share|improve this answer





























      0














      My verdict.



      Your geodata is faulty, especially the file with the name india_botw, see the drawing close and no super GIS can work with them normally. Until the file is put in order, you will not be able to see success, in the future, try not to download corrupted large files, don't make me chase you all over india ...:-),



      enter image description here



      enter image description here



      good luck ...






      share|improve this answer



























        0












        0








        0







        My verdict.



        Your geodata is faulty, especially the file with the name india_botw, see the drawing close and no super GIS can work with them normally. Until the file is put in order, you will not be able to see success, in the future, try not to download corrupted large files, don't make me chase you all over india ...:-),



        enter image description here



        enter image description here



        good luck ...






        share|improve this answer















        My verdict.



        Your geodata is faulty, especially the file with the name india_botw, see the drawing close and no super GIS can work with them normally. Until the file is put in order, you will not be able to see success, in the future, try not to download corrupted large files, don't make me chase you all over india ...:-),



        enter image description here



        enter image description here



        good luck ...







        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited 2 days ago

























        answered Apr 3 at 19:55









        CyrilCyril

        1,0991216




        1,0991216



























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Geographic Information Systems Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317531%2fjoining-attributes-by-location-error-when-finding-polygons-within-district-bound%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            រឿង រ៉ូមេអូ និង ហ្ស៊ុយលីយេ សង្ខេបរឿង តួអង្គ បញ្ជីណែនាំ

            Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given

            Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221