Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <pre><code>$polygon-&gt;polygon-&gt;geometry-&gt;coordinates[0] </code></pre> <p>or</p> <pre><code>$polygon['polygon']['geometry']['coordinates'][0] </code></pre> <p>what you have is a multidimensional array/object not sure which its being output to when decoded in your case as it appears you have a class doing it I would have just used json_decode, but anyway. Yea from the looks of it, polygon is the main object, then in it is geometry which is an object that has type and coordinates, and then coordinates has multiple objects/arrays in it.</p> <p>the above samples if I typed them right will show the first set of coordinates in that object. Of course you could run it through a loop ie:</p> <p>In the case that it is an object assuming your Class decodes as an object and not an array. Not exactly sure what <code>$polygon = CJSON::decode($str,true);</code> does. But if its anything like <code>json_decode()</code> then you should be all set.</p> <p>This is my method of breaking down the object as you present here, its worth noting you may want to check counts, and see if the object is set first, or if the property exists in the object to prevent other means of the code breaking down the road. But what I have here is just pure example at its core, it will server its purpose though. But will not error handle which is why I say you may want to elaborate further on it doing those checks.</p> <p>Anyway heres my code:</p> <pre><code>&lt;?php $str = '{"polygon":{"type":"Feature","properties":[],"geometry":{"type":"Polygon","coordinates":[[[-7302732.4720101,6527844.6333235],[-3193477.8319711,6606116.1502766],[-5111129.9973226,5001550.0527375],[-6637424.5779086,4884142.7773079],[-7772361.5737289,5158093.0866438],[-7302732.4720101,6527844.6333235]]]},"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:OGC:1.3:CRS84"}}}}'; $polygon = json_decode($str); echo'&lt;pre&gt;';print_r($polygon);echo'&lt;/pre&gt;'; $set = 1; foreach($polygon-&gt;polygon-&gt;geometry-&gt;coordinates[0] as $coordinates) { echo 'Set '.$set.': ';$set++; echo $coordinates[0].','.$coordinates[1].'&lt;br&gt;'; } ?&gt; </code></pre> <p>see it in action <a href="http://7pz.net/geojson-parse.php" rel="nofollow">http://7pz.net/geojson-parse.php</a> (scroll to the bottom)</p>
    singulars
    1. This table or related slice is empty.
    1. POparse GeoJson String in PHP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USchris
    1. USchris
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POparse GeoJson String in PHP
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI think I messed up my loop, may have been better to do a while loop or a for loop for the first one but, Im just trying to express concept.
      singulars
      1. PO
      1. USchris
    2. COThanks for your reply.After hours i check your reply code because i first use @ Rodgers and Hammertime and i get error in my code and try to debug code and search! but after hours i use your reply and see all things is OK.Very Thanks
      singulars
      1. PO
      1. USuser1344766
    3. COI use this `ode and get error `$polygon['polygon`]['geometry']['coordinates'][0]` and `['polygon']` makes error in this code!.Why `['polygon']` doesn't work in this code!.I can't use var_dump in yii framework to get $polygon structure.How you can get structure of it.Please help me about it.Thnaks
      singulars
      1. PO
      1. USuser1344766
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload