Generating Queried CSV from shapefile using ArcGIS API for Python? The Next CEO of Stack OverflowReplacing ArcPy with ArcGIS API for Python?Iterate over ImageCollection returning pandas dataframe using earth engine & pythonCannot plot map on ArcGIS python API?Can ArcGIS Python API automate functionality provided in Web AppBuilder?ArcGIS API for Python Delete Multiple FeaturesAuthentication Error 499 using ArcGIS API for Python?How to search the folder's items in ArcGIS On Line using the ArcGIS API for PythonGetting Exent of Queried Results using ArcGIS Python API?Preserving data types when publishing to ArcGIS Online using ArcGIS Python API?How to update a hosted feature service on ArcGIS Online using the Python API for ArcGIS Pro?

What is the purpose of the Evocation wizard's Potent Cantrip feature?

In excess I'm lethal

How do scammers retract money, while you can’t?

Why has the US not been more assertive in confronting Russia in recent years?

Why does standard notation not preserve intervals (visually)

I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin

Which tube will fit a -(700 x 25c) wheel?

Non-deterministic sum of floats

Skipping indices in a product

How to invert MapIndexed on a ragged structure? How to construct a tree from rules?

How do we know the LHC results are robust?

Several mode to write the symbol of a vector

Between two walls

How did people program for Consoles with multiple CPUs?

How to solve a differential equation with a term to a power?

What does convergence in distribution "in the Gromov–Hausdorff" sense mean?

What happened in Rome, when the western empire "fell"?

Received an invoice from my ex-employer billing me for training; how to handle?

Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis

How do I go from 300 unfinished/half written blog posts, to published posts?

What does "Its cash flow is deeply negative" mean?

Preparing Indesign booklet with .psd graphics for print

How did the Bene Gesserit know how to make a Kwisatz Haderach?

Sending manuscript to multiple publishers



Generating Queried CSV from shapefile using ArcGIS API for Python?



The Next CEO of Stack OverflowReplacing ArcPy with ArcGIS API for Python?Iterate over ImageCollection returning pandas dataframe using earth engine & pythonCannot plot map on ArcGIS python API?Can ArcGIS Python API automate functionality provided in Web AppBuilder?ArcGIS API for Python Delete Multiple FeaturesAuthentication Error 499 using ArcGIS API for Python?How to search the folder's items in ArcGIS On Line using the ArcGIS API for PythonGetting Exent of Queried Results using ArcGIS Python API?Preserving data types when publishing to ArcGIS Online using ArcGIS Python API?How to update a hosted feature service on ArcGIS Online using the Python API for ArcGIS Pro?










0















I'm trying to create a csv from a query of a feature layer hosted in ArcGIS Online. The csv only needs to contain one field, where the query is met, geometry is not needed. I'm having issues getting the queried data moved into a dataframe and exported into a csv. From what I've read, you can use the SpatiallyEnabledDataframe to query and export data from a feature, but I'm getting stuck generating the dataframe.



from arcgis.gis import GIS
from arcgis.features import FeatureLayer
from arcgis.features import manage_data
from datetime import date, time
import pandas as pd
from arcgis.features import SpatialDataFrame

gis = GIS("https://------", username="---------", password="---------")
item_id='---------'
get = gis.content.get(item_id)
feeder = get.layers[0]

sdf = pd.DataFrame.spatial.from_layer(feeder)
df = feeder.query(where="feeder_status = 'Closed'").sdf
df.head()


This throws the following error: AttributeError: type object 'DataFrame' has no attribute 'spatial'



Is this error thrown because pandas is looking for the features geometry?










share|improve this question




























    0















    I'm trying to create a csv from a query of a feature layer hosted in ArcGIS Online. The csv only needs to contain one field, where the query is met, geometry is not needed. I'm having issues getting the queried data moved into a dataframe and exported into a csv. From what I've read, you can use the SpatiallyEnabledDataframe to query and export data from a feature, but I'm getting stuck generating the dataframe.



    from arcgis.gis import GIS
    from arcgis.features import FeatureLayer
    from arcgis.features import manage_data
    from datetime import date, time
    import pandas as pd
    from arcgis.features import SpatialDataFrame

    gis = GIS("https://------", username="---------", password="---------")
    item_id='---------'
    get = gis.content.get(item_id)
    feeder = get.layers[0]

    sdf = pd.DataFrame.spatial.from_layer(feeder)
    df = feeder.query(where="feeder_status = 'Closed'").sdf
    df.head()


    This throws the following error: AttributeError: type object 'DataFrame' has no attribute 'spatial'



    Is this error thrown because pandas is looking for the features geometry?










    share|improve this question


























      0












      0








      0








      I'm trying to create a csv from a query of a feature layer hosted in ArcGIS Online. The csv only needs to contain one field, where the query is met, geometry is not needed. I'm having issues getting the queried data moved into a dataframe and exported into a csv. From what I've read, you can use the SpatiallyEnabledDataframe to query and export data from a feature, but I'm getting stuck generating the dataframe.



      from arcgis.gis import GIS
      from arcgis.features import FeatureLayer
      from arcgis.features import manage_data
      from datetime import date, time
      import pandas as pd
      from arcgis.features import SpatialDataFrame

      gis = GIS("https://------", username="---------", password="---------")
      item_id='---------'
      get = gis.content.get(item_id)
      feeder = get.layers[0]

      sdf = pd.DataFrame.spatial.from_layer(feeder)
      df = feeder.query(where="feeder_status = 'Closed'").sdf
      df.head()


      This throws the following error: AttributeError: type object 'DataFrame' has no attribute 'spatial'



      Is this error thrown because pandas is looking for the features geometry?










      share|improve this question
















      I'm trying to create a csv from a query of a feature layer hosted in ArcGIS Online. The csv only needs to contain one field, where the query is met, geometry is not needed. I'm having issues getting the queried data moved into a dataframe and exported into a csv. From what I've read, you can use the SpatiallyEnabledDataframe to query and export data from a feature, but I'm getting stuck generating the dataframe.



      from arcgis.gis import GIS
      from arcgis.features import FeatureLayer
      from arcgis.features import manage_data
      from datetime import date, time
      import pandas as pd
      from arcgis.features import SpatialDataFrame

      gis = GIS("https://------", username="---------", password="---------")
      item_id='---------'
      get = gis.content.get(item_id)
      feeder = get.layers[0]

      sdf = pd.DataFrame.spatial.from_layer(feeder)
      df = feeder.query(where="feeder_status = 'Closed'").sdf
      df.head()


      This throws the following error: AttributeError: type object 'DataFrame' has no attribute 'spatial'



      Is this error thrown because pandas is looking for the features geometry?







      arcgis-online pandas arcgis-python-api






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited yesterday









      PolyGeo

      53.8k1781245




      53.8k1781245










      asked yesterday









      zemken12zemken12

      735




      735




















          1 Answer
          1






          active

          oldest

          votes


















          0














          I made it work by using Pandas dataframes. The code below explains how to connect to your content in AGOL, query a layer, and output it to your local drive with a timestamp name.



          #import relevant modules
          import csv, os,time,shutil
          from arcgis.gis import GIS
          import time
          import pandas as pd

          #connect and login to AGOL. Gets feeder summary layer.
          gis = GIS("https://YOUR_ENTERPRISE.maps.arcgis.com", username="ENTER USERNAME", password="ENTER PASSWORD")
          f= gis.content.get('CONTENT ID')

          #queryies content of interest
          sdf = f.layers[0].query(where="field_name = 'Yes'",
          out_fields='field_name',return_distinct_values=True).df
          sdf.field_name #tests actual output

          #exports the query to csv where field_name is 'Yes'. CSV name has a date/time timestamp

          timestr = time.strftime("%Y_%m_%d-%I_%M_%p")
          url = (r'C:Export_Location')
          export_name = str(url)+str("Yes_list.csv")
          sdf['field_name'].str.slice(start=3).to_csv(export_name,sep=',',index=False)





          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%2f317022%2fgenerating-queried-csv-from-shapefile-using-arcgis-api-for-python%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














            I made it work by using Pandas dataframes. The code below explains how to connect to your content in AGOL, query a layer, and output it to your local drive with a timestamp name.



            #import relevant modules
            import csv, os,time,shutil
            from arcgis.gis import GIS
            import time
            import pandas as pd

            #connect and login to AGOL. Gets feeder summary layer.
            gis = GIS("https://YOUR_ENTERPRISE.maps.arcgis.com", username="ENTER USERNAME", password="ENTER PASSWORD")
            f= gis.content.get('CONTENT ID')

            #queryies content of interest
            sdf = f.layers[0].query(where="field_name = 'Yes'",
            out_fields='field_name',return_distinct_values=True).df
            sdf.field_name #tests actual output

            #exports the query to csv where field_name is 'Yes'. CSV name has a date/time timestamp

            timestr = time.strftime("%Y_%m_%d-%I_%M_%p")
            url = (r'C:Export_Location')
            export_name = str(url)+str("Yes_list.csv")
            sdf['field_name'].str.slice(start=3).to_csv(export_name,sep=',',index=False)





            share|improve this answer



























              0














              I made it work by using Pandas dataframes. The code below explains how to connect to your content in AGOL, query a layer, and output it to your local drive with a timestamp name.



              #import relevant modules
              import csv, os,time,shutil
              from arcgis.gis import GIS
              import time
              import pandas as pd

              #connect and login to AGOL. Gets feeder summary layer.
              gis = GIS("https://YOUR_ENTERPRISE.maps.arcgis.com", username="ENTER USERNAME", password="ENTER PASSWORD")
              f= gis.content.get('CONTENT ID')

              #queryies content of interest
              sdf = f.layers[0].query(where="field_name = 'Yes'",
              out_fields='field_name',return_distinct_values=True).df
              sdf.field_name #tests actual output

              #exports the query to csv where field_name is 'Yes'. CSV name has a date/time timestamp

              timestr = time.strftime("%Y_%m_%d-%I_%M_%p")
              url = (r'C:Export_Location')
              export_name = str(url)+str("Yes_list.csv")
              sdf['field_name'].str.slice(start=3).to_csv(export_name,sep=',',index=False)





              share|improve this answer

























                0












                0








                0







                I made it work by using Pandas dataframes. The code below explains how to connect to your content in AGOL, query a layer, and output it to your local drive with a timestamp name.



                #import relevant modules
                import csv, os,time,shutil
                from arcgis.gis import GIS
                import time
                import pandas as pd

                #connect and login to AGOL. Gets feeder summary layer.
                gis = GIS("https://YOUR_ENTERPRISE.maps.arcgis.com", username="ENTER USERNAME", password="ENTER PASSWORD")
                f= gis.content.get('CONTENT ID')

                #queryies content of interest
                sdf = f.layers[0].query(where="field_name = 'Yes'",
                out_fields='field_name',return_distinct_values=True).df
                sdf.field_name #tests actual output

                #exports the query to csv where field_name is 'Yes'. CSV name has a date/time timestamp

                timestr = time.strftime("%Y_%m_%d-%I_%M_%p")
                url = (r'C:Export_Location')
                export_name = str(url)+str("Yes_list.csv")
                sdf['field_name'].str.slice(start=3).to_csv(export_name,sep=',',index=False)





                share|improve this answer













                I made it work by using Pandas dataframes. The code below explains how to connect to your content in AGOL, query a layer, and output it to your local drive with a timestamp name.



                #import relevant modules
                import csv, os,time,shutil
                from arcgis.gis import GIS
                import time
                import pandas as pd

                #connect and login to AGOL. Gets feeder summary layer.
                gis = GIS("https://YOUR_ENTERPRISE.maps.arcgis.com", username="ENTER USERNAME", password="ENTER PASSWORD")
                f= gis.content.get('CONTENT ID')

                #queryies content of interest
                sdf = f.layers[0].query(where="field_name = 'Yes'",
                out_fields='field_name',return_distinct_values=True).df
                sdf.field_name #tests actual output

                #exports the query to csv where field_name is 'Yes'. CSV name has a date/time timestamp

                timestr = time.strftime("%Y_%m_%d-%I_%M_%p")
                url = (r'C:Export_Location')
                export_name = str(url)+str("Yes_list.csv")
                sdf['field_name'].str.slice(start=3).to_csv(export_name,sep=',',index=False)






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 12 hours ago









                zemken12zemken12

                735




                735



























                    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%2f317022%2fgenerating-queried-csv-from-shapefile-using-arcgis-api-for-python%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