search

Spatio-Temporal-Lab / start-db-achive

GNU General Public License v3.0
15 stars 9 forks source link

向路网表插入数据报错 #239

Closed ihongyang closed 2 years ago

ihongyang commented 2 years ago

CREATE TABLE road (rsid integer, rs roadsegment);

SELECT st_rs_fromGeoJSON('{"type":"Feature","properties":{"endId":2,"level":6,"startId":1,"rsId":1,"speedLimit":30.0,"lengthInMeter":120.0,"direction":1},"geometry":{"type":"LineString","coordinates":[[111.37939453125,54.00776876193478],[116.3671875,53.05442186546102]]}}');

insert into table road values (1, st_rs_fromGeoJSON('{"type":"Feature","properties":{"endId":2,"level":6,"startId":1,"rsId":1,"speedLimit":30.0,"lengthInMeter":120.0,"direction":1},"geometry":{"type":"LineString","coordinates":[[111.37939453125,54.00776876193478],[116.3671875,53.05442186546102]]}}'));

image