title: Struggling to pull MultiPolygon coordinates from a GoeJson to sql
body: <pre><code>DECLARE @GeoJSON nvarchar(max) = N'
  
  {
  &quot;type&quot;: &quot;FeatureCollection&quot;,
  &quot;name&quot;: &quot;PARCELSGJSON&quot;,
  &quot;crs&quot;: { &quot;type&quot;: &quot;name&quot;, &quot;properties&quot;: { &quot;name&quot;: &quot;urn:ogc:def:crs:OGC:1.3:CRS84&quot; } },
  &quot;features&quot;: [
  { &quot;type&quot;: &quot;Feature&quot;, &quot;properties&quot;: { &quot;FEAT_ID&quot;: 857132, &quot;PROJECT&quot;: &quot;Lynnwood Glen&quot;, &quot;PLAN&quot;: &quot;Lynnwood Glen&quot;, &quot;LABEL&quot;: &quot;As-Built&quot;, &quot;PARCEL_ID&quot;: &quot;Lynwood Glen&quot;, &quot;PARCEL_ADD&quot;: &quot;82 Boskop St&quot;, &quot;PARCEL_NUM&quot;: null, &quot;VETRO_ID&quot;: &quot;5a116be1-8cf1-4ced-993b-cb8c9d3a37f4&quot; }, &quot;geometry&quot;: { &quot;type&quot;: &quot;MultiPolygon&quot;, &quot;coordinates&quot;: [ [ [ [ 28.284234881629544, -25.783047750866555 ], [ 28.284380408494947, -25.782618997236717 ], [ 28.28438063024387, -25.782618042934377 ], [ 28.2843833316984, -25.782610885990664 ], [ 28.285571614911216, -25.782903843033626 ], [ 28.285606453623799, -25.782988620904682 ], [ 28.285583645174082, -25.78303440473131 ], [ 28.284974540972176, -25.783124368393342 ], [ 28.284234881629544, -25.783047750866555 ] ] ] ] } },
  { &quot;type&quot;: &quot;Feature&quot;, &quot;properties&quot;: { &quot;FEAT_ID&quot;: 30, &quot;PROJECT&quot;: &quot;Lynnwood Glen&quot;, &quot;PLAN&quot;: &quot;Lynnwood Glen&quot;, &quot;LABEL&quot;: &quot;As-Built&quot;, &quot;PARCEL_ID&quot;: &quot;Lynwood Glen&quot;, &quot;PARCEL_ADD&quot;: &quot;74 Boskop St&quot;, &quot;PARCEL_NUM&quot;: null, &quot;VETRO_ID&quot;: &quot;7ef46505-fd64-498b-b4f1-b4fc5e46cc18&quot; }, &quot;geometry&quot;: { &quot;type&quot;: &quot;MultiPolygon&quot;, &quot;coordinates&quot;: [ [ [ [ 28.284234881629544, -25.783047750866555 ], [ 28.284028202246873, -25.78302626993689 ], [ 28.283147343885776, -25.782889305272555 ], [ 28.283380563845348, -25.782421203415211 ], [ 28.283464994347067, -25.782385689512676 ], [ 28.283466712923325, -25.78238490747491 ], [ 28.2843833316984, -25.782610885990664 ], [ 28.28438063024387, -25.782618042934377 ], [ 28.284380408494947, -25.782618997236717 ], [ 28.284234881629544, -25.783047750866555 ] ] ] ] } },
  { &quot;type&quot;: &quot;Feature&quot;, &quot;properties&quot;: { &quot;FEAT_ID&quot;: 883283, &quot;PROJECT&quot;: &quot;Bredasdorp&quot;, &quot;PLAN&quot;: &quot;South 1.1&quot;, &quot;LABEL&quot;: &quot;Planned&quot;, &quot;PARCEL_ID&quot;: null, &quot;PARCEL_ADD&quot;: &quot;52 Van Der Byl St, Bredasdorp, 7280, South Africa&quot;, &quot;PARCEL_NUM&quot;: null, &quot;VETRO_ID&quot;: &quot;eac361cb-9633-4c8f-b4f0-64a85708e75c&quot; }, &quot;geometry&quot;: { &quot;type&quot;: &quot;MultiPolygon&quot;, &quot;coordinates&quot;: [ [ [ [ 20.041907, -34.536852 ], [ 20.042036, -34.53669 ], [ 20.042165, -34.536528 ], [ 20.042272, -34.536583 ], [ 20.042539, -34.536728 ], [ 20.042312, -34.537068 ], [ 20.042041, -34.536923 ], [ 20.041907, -34.536852 ] ] ] ] } },
  { &quot;type&quot;: &quot;Feature&quot;, &quot;properties&quot;: { &quot;FEAT_ID&quot;: 883284, &quot;PROJECT&quot;: &quot;Bredasdorp&quot;, &quot;PLAN&quot;: &quot;West 1.1&quot;, &quot;LABEL&quot;: &quot;Planned&quot;, &quot;PARCEL_ID&quot;: null, &quot;PARCEL_ADD&quot;: &quot;8 Moreson St, Bredasdorp, 7280, South Africa&quot;, &quot;PARCEL_NUM&quot;: null, &quot;VETRO_ID&quot;: &quot;a404719a-fce1-4278-8edf-5d0ad66596d5&quot; }, &quot;geometry&quot;: { &quot;type&quot;: &quot;MultiPolygon&quot;, &quot;coordinates&quot;: [ [ [ [ 20.024234, -34.529027 ], [ 20.024496, -34.529158 ], [ 20.024559, -34.52919 ], [ 20.024403, -34.529406 ], [ 20.024077, -34.529243 ], [ 20.024234, -34.529027 ] ] ] ] } },
  { &quot;type&quot;: &quot;Feature&quot;, &quot;properties&quot;: { &quot;FEAT_ID&quot;: 883285, &quot;PROJECT&quot;: &quot;Bredasdorp&quot;, &quot;PLAN&quot;: &quot;West 1.1&quot;, &quot;LABEL&quot;: &quot;Planned&quot;, &quot;PARCEL_ID&quot;: null, &quot;PARCEL_ADD&quot;: &quot;7 Plantasie St, Bredasdorp, 7280, South Africa&quot;, &quot;PARCEL_NUM&quot;: null, &quot;VETRO_ID&quot;: &quot;d97c505d-176d-4cfc-9471-0db4f6cc8837&quot; }, &quot;geometry&quot;: { &quot;type&quot;: &quot;MultiPolygon&quot;, &quot;coordinates&quot;: [ [ [ [ 20.030428, -34.53447 ], [ 20.030966, -34.534063 ], [ 20.031338, -34.533782 ], [ 20.031995, -34.534153 ], [ 20.031812, -34.534345 ], [ 20.03159, -34.534581 ], [ 20.031182, -34.534992 ], [ 20.030428, -34.53447 ] ] ] ] } }
              ]
  }
  ' 
  
  SELECT 
       [FEAT_ID]
      ,[PROJECT]
      ,[LABEL]
      ,[PARCEL_ID]
      ,[PARCEL_ADD]
      ,[PARCEL_NUM]
      ,[VETRO_ID]
      ,[type] 
      ,coordinates
  INTO #TEMP
  FROM 
      OPENJSON(@GeoJSON, '$.features')
          WITH (
              [FEAT_ID] varchar(300) '$.properties.FEAT_ID',
              [PROJECT] varchar(300) '$.properties.PROJECT',
              [PLAN] varchar(300) '$.properties.PROJECT',
              [LABEL] varchar(300) '$.properties.LABEL',
              [PARCEL_ID] varchar(300) '$.properties.PARCEL_ID',
              [PARCEL_ADD] varchar(300) '$.properties.PARCEL_ADD',
              [PARCEL_NUM] varchar(300) '$.properties.PARCEL_NUM',
              [VETRO_ID] varchar(300) '$.properties.VETRO_ID',
              [type] Varchar(64) '$.geometry.type',
              [coordinates] varchar(300) '$.geometry.coordinates'
  
          ) as  GeoData
  
  Select * from #TEMP
  DROP table #temp
  </code></pre>
  <p>I Just want to be able to create a coordinates column within that temp table but no matter what I do the result is always a blank record. How do I access the multi polygon coordinates?</p>