我需要帮助提取奇怪的json数据格式PHP

I need help getting data from a file that was formatted not how I'm used to getting data from. I included a screenshot of what the data looks like. I need the grab the coordinates array but every time I call a new for loop its going into the properties array.

I have attached my code so you can see where I am at. I have to be close because i'm getting arrays within arrays but can't figure out how to access that array's data.

$json_data = file_get_contents('rebar.txt');
$json = json_decode($json_data, true);


foreach($json as $key => $value)
{
    echo $key;
    //var_dump($value);
    //echo "<br>";
    foreach ($value as $key1 => $value1)
    {
        echo "<pre>";
        print_r($value1);
        echo "</pre>";
    }
}

Edit - Included some non-formatted JSON

{"type":"FeatureCollection","crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:OGC:1.3:CRS84"}},"features":[{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.345588,15.575967]},"properties":{"id":"219089-27","tag_id":27,"label":"Flooded / Damaged Building","tagger_id":4566274,"type_id":1955,"score":"0.922085","agreement":10,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/f3f7fc0f7e68d702803e170bd77da45d.jpg","timestamp":"2017-10-11T13:01:46.493Z","overlay_id":60435,"acquisition_date":"2017-09-22T20:55:04.632Z","sensor":"WV02","catalog_id":null,"map_id":6360}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.348517,15.590673]},"properties":{"id":"219089-62","tag_id":62,"label":"Flooded / Damaged Building","tagger_id":4566274,"type_id":1955,"score":"1.000000","agreement":31,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/b4b26d171c1767d244a1be66b0fe3663.jpg","timestamp":"2017-10-11T13:01:39.090Z","overlay_id":60435,"acquisition_date":"2017-09-22T20:55:04.632Z","sensor":"WV02","catalog_id":null,"map_id":1780}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.342107,15.592311]},"properties":{"id":"219089-164","tag_id":164,"label":"Flooded / Damaged Building","tagger_id":4566274,"type_id":1955,"score":"1.000000","agreement":19,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/0451894861f5da83539ce5baa3b61193.jpg","timestamp":"2017-10-11T13:01:38.683Z","overlay_id":60435,"acquisition_date":"2017-09-22T20:55:04.632Z","sensor":"WV02","catalog_id":null,"map_id":4801}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.341098,15.591505]},"properties":{"id":"219089-175","tag_id":175,"label":"Flooded / Damaged Building","tagger_id":4566274,"type_id":1955,"score":"1.000000","agreement":37,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/03eaeb046b60e6ad307f23112f8e28e9.jpg","timestamp":"2017-10-11T13:01:46.131Z","overlay_id":60435,"acquisition_date":"2017-09-22T20:55:04.632Z","sensor":"WV02","catalog_id":null,"map_id":4801}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.342911,15.586736]},"properties":{"id":"219089-220","tag_id":220,"label":"Flooded / Damaged Building","tagger_id":4566274,"type_id":1955,"score":"1.000000","agreement":25,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/c544b3bda7730c941472bdabc7157629.jpg","timestamp":"2017-10-11T13:01:39.090Z","overlay_id":60435,"acquisition_date":"2017-09-22T20:55:04.632Z","sensor":"WV02","catalog_id":null,"map_id":329}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.422756,15.456392]},"properties":{"id":"219089-265","tag_id":265,"label":"Flooded / Damaged Building","tagger_id":2349740,"type_id":1955,"score":"1.000000","agreement":18,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/712d3036d5f5ee905f113628dbf9041c.jpg","timestamp":"2017-10-11T13:01:40.743Z","overlay_id":60436,"acquisition_date":"2017-09-22T20:54:08.270Z","sensor":"WV02","catalog_id":null,"map_id":10752}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.431474,15.45027]},"properties":{"id":"219089-292","tag_id":292,"label":"Flooded / Damaged Building","tagger_id":2349740,"type_id":1955,"score":"1.000000","agreement":36,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/073cd0784ce01deb2832873a2122f932.jpg","timestamp":"2017-10-11T13:01:43.774Z","overlay_id":60436,"acquisition_date":"2017-09-22T20:54:08.270Z","sensor":"WV02","catalog_id":null,"map_id":11840}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.341822,15.42342]},"properties":{"id":"219089-350","tag_id":350,"label":"Flooded / Damaged Building","tagger_id":4566274,"type_id":1955,"score":"0.999627","agreement":10,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/66aece472f8df238c0189f046294f23e.jpg","timestamp":"2017-10-11T13:01:42.648Z","overlay_id":60435,"acquisition_date":"2017-09-22T20:55:04.632Z","sensor":"WV02","catalog_id":null,"map_id":6977}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.27985,15.245364]},"properties":{"id":"219089-359","tag_id":359,"label":"Flooded / Damaged Building","tagger_id":8742443,"type_id":1955,"score":"0.948370","agreement":14,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/2a6eca4e52c24340836293c603edcd8b.jpg","timestamp":"2017-10-11T13:01:47.215Z","overlay_id":60435,"acquisition_date":"2017-09-22T20:55:04.632Z","sensor":"WV02","catalog_id":null,"map_id":6275}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.341597,15.414789]},"properties":{"id":"219089-384","tag_id":384,"label":"Flooded / Damaged Building","tagger_id":4566274,"type_id":1955,"score":"0.999990","agreement":13,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/1600490d7e9efa3d573aea9c516cf2e0.jpg","timestamp":"2017-10-11T13:01:42.648Z","overlay_id":60435,"acquisition_date":"2017-09-22T20:55:04.632Z","sensor":"WV02","catalog_id":null,"map_id":331}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.286416,15.249546]},"properties":{"id":"219089-391","tag_id":391,"label":"Flooded / Damaged Building","tagger_id":8742443,"type_id":1955,"score":"1.000000","agreement":16,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/0236f434f9c1716e2c1d30d33ad9f2e1.jpg","timestamp":"2017-10-11T13:01:39.090Z","overlay_id":60435,"acquisition_date":"2017-09-22T20:55:04.632Z","sensor":"WV02","catalog_id":null,"map_id":2385}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.266836,15.255911]},"properties":{"id":"219089-502","tag_id":502,"label":"Flooded / Damaged Building","tagger_id":8742443,"type_id":1955,"score":"0.999998","agreement":17,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/fe282a4d1637391286ebf0b84d09a338.jpg","timestamp":"2017-10-11T13:01:40.308Z","overlay_id":60435,"acquisition_date":"2017-09-22T20:55:04.632Z","sensor":"WV02","catalog_id":null,"map_id":7221}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.441969,15.438861]},"properties":{"id":"219089-538","tag_id":538,"label":"Flooded / Damaged Building","tagger_id":22905241,"type_id":1955,"score":"1.000000","agreement":43,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/4f7a4e20b5a91821c2b3e65fe42819d1.jpg","timestamp":"2017-10-11T13:01:42.648Z","overlay_id":60436,"acquisition_date":"2017-09-22T20:54:08.270Z","sensor":"WV02","catalog_id":null,"map_id":12697}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.35683,15.322064]},"properties":{"id":"219089-560","tag_id":560,"label":"Flooded / Damaged Building","tagger_id":8742443,"type_id":1955,"score":"1.000000","agreement":40,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/76cc2ac0de044ca01eae9139df1b6037.jpg","timestamp":"2017-10-11T13:01:42.278Z","overlay_id":60435,"acquisition_date":"2017-09-22T20:55:04.632Z","sensor":"WV02","catalog_id":null,"map_id":1985}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-61.43742,15.443101]},"properties":{"id":"219089-609","tag_id":609,"label":"Flooded / Damaged Building","tagger_id":22905241,"type_id":1955,"score":"1.000000","agreement":19,"chip_size":null,"chip_url":"https://s3.amazonaws.com/explorationlab/chips/61d31afeb10a49faa72537c1f7a7b0d1.jpg","timestamp":"2017-10-11T13:01:41.129Z","overlay_id":60436,"acquisition_date":"2017-09-22T20:54:08.270Z","sensor":"WV02","catalog_id":null,"map_id":8083}}

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
doutuohan6606 2019-02-15 01:39
关注
The coordinates are nested inside the geometry element. You don't need a nested loop, just index them directly.

foreach ($value as $key => $value1) { $coordinates = $value1['geometry']['coordinates']; echo "<pre>"; print_r($key); echo " "; print_r($coordinates); echo "</pre>"; }
本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

我需要帮助提取奇怪的json数据格式PHP php
2019-02-15 01:23

回答 1 已采纳 The coordinates are nested inside the geometry element. You don't need a nested loop, just index t
PHP - 从JSON中提取数据 json php
2017-06-08 00:06

回答 2 已采纳 Iterate the $data array, and set the key of a new element in the array to the tag element, and it'
php 取json数据 php
2022-04-09 19:24

回答 1 已采纳多个遍历获取就行了 <meta charset="utf-8"> <?php $s='{"code":200,"data":{"vod_play_list":[{"player_
php如何提取json类型的数据,我如何从PHP中提取JSON数据？
2021-04-22 04:58

weixin_39734020的博客 JSON不是数组，对象或数据结构。 JSON是一种基于文本的序列化格式 – 所以一个花哨的string，但仍然只是一个string。使用json_decode()在PHP中对其进行解码。$data = json_decode($json);其中你可能会发现：标量：...
从JSON php curl中提取数据：json_decode无法正常工作 json php
2018-10-18 19:25

回答 1 已采纳 Buoyed by your answers - @Andreas and @YvesLeBorg, I redid the code and got what I want. I am putt
从PHP日志文件中提取Json数据并添加新列 json php
2016-05-26 06:55

回答 2 已采纳 You need these i think. $json = '{"hint_data":{"locations":["AXQDAP____8AAAAABwAAABEAAAAYAAAAIwIA
使用PHP从MySQL服务器中提取数据以JSON格式显示 json mysql php
2014-08-03 22:44

回答 1 已采纳 First of all this part of your code is not necessary $con=mysqli_connect("localhost", "username",
在php中怎么解析json数据,php解析json数据
2021-04-30 05:23

李必达的博客在我们使用编程语言的时候，对于数据的格式会出现不能直接使用的情况，所以就会有解析的操作。在php中有专门解析json的函数，那就是json_decode()。想要进一步的运用这个函数，我们还需要对它的函数概念、语法、参数...
使用php从JSON数组中提取数据 json php
2016-04-11 16:48

回答 3 已采纳 After the encoding and decoding your $xmltovar is like this: Array ( [Entry] => Array
从json格式中提取特定数据 json mysql php
2014-12-19 15:53

回答 3 已采纳 Put your json in a variable $str for example, than you can access the items : $json = json_decode
如何从php中的json输出中提取数据 json php
2015-09-17 16:44

回答 1 已采纳 You can use file_get_contents to download from the URL. Then use json_decode to parse the JSON int
php获取到的json数据如何处理_如何使用PHP从JSON提取数据？
2021-03-22 22:12

金刚汤圆的博客 JSON不是数组，对象或数据结构。JSON是基于文本的序列化格式，因此是花哨的字符串，但仍然只是字符串。使用解码PHPjson_decode()。$data = json_decode($json);在其中您可能会发现：标量：strings，ints，floats和...
在Php中从Json中提取数据 json php
2016-01-14 13:32

回答 3 已采纳 I hope you are looking for this, its very simple example by using json_decode(): $string = '{"sea
PHP如何返回json数据
2021-12-29 21:37

全智能时代的博客 php返回json,xml,JSONP等格式的数据 1、返回json数据： header('Content-Type:application/json; charset=utf-8'); $arr=array('a'=>1,'b'=>2); exit(json_encode($data)); 注意：如果不加header直接...
php查询数据输出json,PHP中把数据库查询结果输出为json格式
2021-05-08 16:28

weixin_39652810的博客获取一个表单字段中多条数据并转化为json格式如图需要获取下面两个li标签里面的数据,然后传给后台:而后台接收的数据格式是json的,所以需要把两个li里面的信息转化为以下格式的. {recieverName:小红,recieverPhone:...
没有解决我的问题, 去提问

悬赏问题

¥20 机器学习能否像多层线性模型一样处理嵌套数据
¥20 西门子S7-Graph,S7-300，梯形图
¥50 用易语言http 访问不了网页
¥50 safari浏览器fetch提交数据后数据丢失问题
¥15 matlab不知道怎么改，求解答！！
¥15 永磁直线电机的电流环pi调不出来
¥15 用stata实现聚类的代码
¥15 请问paddlehub能支持移动端开发吗？在Android studio上该如何部署？
¥20 docker里部署springboot项目，访问不到扬声器
¥15 netty整合springboot之后自动重连失效

我需要帮助提取奇怪的json数据格式PHP

1条回答 默认 最新

悬赏问题

1条回答默认最新