1BEGIN; 2BEGIN 3SET client_min_messages TO NOTICE; 4SET 5-- q1 6SELECT pgr_createTopology('edge_table',0.001, clean := true); 7NOTICE: PROCESSING: 8NOTICE: pgr_createTopology('edge_table', 0.001, 'the_geom', 'id', 'source', 'target', rows_where := 'true', clean := t) 9NOTICE: Performing checks, please wait ..... 10NOTICE: Creating Topology, Please wait... 11NOTICE: -------------> TOPOLOGY CREATED FOR 18 edges 12NOTICE: Rows with NULL geometry or NULL id: 0 13NOTICE: Vertices table for table public.edge_table is: public.edge_table_vertices_pgr 14NOTICE: ---------------------------------------------- 15 pgr_createtopology 16-------------------- 17 OK 18(1 row) 19 20SELECT pgr_analyzeGraph('edge_table',0.001); 21NOTICE: PROCESSING: 22NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','true') 23NOTICE: Performing checks, please wait ... 24NOTICE: Analyzing for dead ends. Please wait... 25NOTICE: Analyzing for gaps. Please wait... 26NOTICE: Analyzing for isolated edges. Please wait... 27NOTICE: Analyzing for ring geometries. Please wait... 28NOTICE: Analyzing for intersections. Please wait... 29NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 30NOTICE: Isolated segments: 2 31NOTICE: Dead ends: 7 32NOTICE: Potential gaps found near dead ends: 1 33NOTICE: Intersections detected: 1 34NOTICE: Ring geometries: 0 35 pgr_analyzegraph 36------------------ 37 OK 38(1 row) 39 40-- q1.1 41-- q3 42SELECT pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target'); 43NOTICE: PROCESSING: 44NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','true') 45NOTICE: Performing checks, please wait ... 46NOTICE: Analyzing for dead ends. Please wait... 47NOTICE: Analyzing for gaps. Please wait... 48NOTICE: Analyzing for isolated edges. Please wait... 49NOTICE: Analyzing for ring geometries. Please wait... 50NOTICE: Analyzing for intersections. Please wait... 51NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 52NOTICE: Isolated segments: 2 53NOTICE: Dead ends: 7 54NOTICE: Potential gaps found near dead ends: 1 55NOTICE: Intersections detected: 1 56NOTICE: Ring geometries: 0 57 pgr_analyzegraph 58------------------ 59 OK 60(1 row) 61 62-- q3.1 63-- q5 64SELECT pgr_analyzeGraph('edge_table',0.001,'id','the_geom','source','target'); 65NOTICE: PROCESSING: 66NOTICE: pgr_analyzeGraph('edge_table',0.001,'id','the_geom','source','target','true') 67NOTICE: Performing checks, please wait ... 68NOTICE: Got function st_srid(bigint) does not exist 69NOTICE: ERROR: something went wrong when checking for SRID of id in table public.edge_table 70 pgr_analyzegraph 71------------------ 72 FAIL 73(1 row) 74 75-- q5.1 76-- q6 77SELECT pgr_analyzeGraph('edge_table',0.001,the_geom:='the_geom',id:='id',source:='source',target:='target'); 78NOTICE: PROCESSING: 79NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','true') 80NOTICE: Performing checks, please wait ... 81NOTICE: Analyzing for dead ends. Please wait... 82NOTICE: Analyzing for gaps. Please wait... 83NOTICE: Analyzing for isolated edges. Please wait... 84NOTICE: Analyzing for ring geometries. Please wait... 85NOTICE: Analyzing for intersections. Please wait... 86NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 87NOTICE: Isolated segments: 2 88NOTICE: Dead ends: 7 89NOTICE: Potential gaps found near dead ends: 1 90NOTICE: Intersections detected: 1 91NOTICE: Ring geometries: 0 92 pgr_analyzegraph 93------------------ 94 OK 95(1 row) 96 97-- q6.1 98-- q7 99SELECT pgr_analyzeGraph('edge_table',0.001,source:='source',id:='id',target:='target',the_geom:='the_geom'); 100NOTICE: PROCESSING: 101NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','true') 102NOTICE: Performing checks, please wait ... 103NOTICE: Analyzing for dead ends. Please wait... 104NOTICE: Analyzing for gaps. Please wait... 105NOTICE: Analyzing for isolated edges. Please wait... 106NOTICE: Analyzing for ring geometries. Please wait... 107NOTICE: Analyzing for intersections. Please wait... 108NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 109NOTICE: Isolated segments: 2 110NOTICE: Dead ends: 7 111NOTICE: Potential gaps found near dead ends: 1 112NOTICE: Intersections detected: 1 113NOTICE: Ring geometries: 0 114 pgr_analyzegraph 115------------------ 116 OK 117(1 row) 118 119-- q7.1 120-- q8. 121SELECT pgr_analyzeGraph('edge_table',0.001,source:='source'); 122NOTICE: PROCESSING: 123NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','true') 124NOTICE: Performing checks, please wait ... 125NOTICE: Analyzing for dead ends. Please wait... 126NOTICE: Analyzing for gaps. Please wait... 127NOTICE: Analyzing for isolated edges. Please wait... 128NOTICE: Analyzing for ring geometries. Please wait... 129NOTICE: Analyzing for intersections. Please wait... 130NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 131NOTICE: Isolated segments: 2 132NOTICE: Dead ends: 7 133NOTICE: Potential gaps found near dead ends: 1 134NOTICE: Intersections detected: 1 135NOTICE: Ring geometries: 0 136 pgr_analyzegraph 137------------------ 138 OK 139(1 row) 140 141-- q8.1 142-- q9 143SELECT pgr_analyzeGraph('edge_table',0.001,rows_where:='id < 10'); 144NOTICE: PROCESSING: 145NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','id < 10') 146NOTICE: Performing checks, please wait ... 147NOTICE: Analyzing for dead ends. Please wait... 148NOTICE: Analyzing for gaps. Please wait... 149NOTICE: Analyzing for isolated edges. Please wait... 150NOTICE: Analyzing for ring geometries. Please wait... 151NOTICE: Analyzing for intersections. Please wait... 152NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 153NOTICE: Isolated segments: 0 154NOTICE: Dead ends: 4 155NOTICE: Potential gaps found near dead ends: 0 156NOTICE: Intersections detected: 0 157NOTICE: Ring geometries: 0 158 pgr_analyzegraph 159------------------ 160 OK 161(1 row) 162 163-- q9.1 164-- q10 165SELECT pgr_analyzeGraph('edge_table',0.001,rows_where:='the_geom && (SELECT st_buffer(the_geom,0.05) FROM edge_table WHERE id=5)'); 166NOTICE: PROCESSING: 167NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','the_geom && (SELECT st_buffer(the_geom,0.05) FROM edge_table WHERE id=5)') 168NOTICE: Performing checks, please wait ... 169NOTICE: Analyzing for dead ends. Please wait... 170NOTICE: Analyzing for gaps. Please wait... 171NOTICE: Analyzing for isolated edges. Please wait... 172NOTICE: Analyzing for ring geometries. Please wait... 173NOTICE: Analyzing for intersections. Please wait... 174NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 175NOTICE: Isolated segments: 0 176NOTICE: Dead ends: 5 177NOTICE: Potential gaps found near dead ends: 0 178NOTICE: Intersections detected: 0 179NOTICE: Ring geometries: 0 180 pgr_analyzegraph 181------------------ 182 OK 183(1 row) 184 185-- q10.1 186-- q11 187CREATE TABLE otherTable AS (SELECT 100 AS gid, st_point(2.5,2.5) AS other_geom) ; 188SELECT 1 189SELECT pgr_analyzeGraph('edge_table',0.001,rows_where:='the_geom && (SELECT st_buffer(other_geom,1) FROM otherTable WHERE gid=100)'); 190NOTICE: PROCESSING: 191NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','the_geom && (SELECT st_buffer(other_geom,1) FROM otherTable WHERE gid=100)') 192NOTICE: Performing checks, please wait ... 193NOTICE: Analyzing for dead ends. Please wait... 194NOTICE: Analyzing for gaps. Please wait... 195NOTICE: Analyzing for isolated edges. Please wait... 196NOTICE: Analyzing for ring geometries. Please wait... 197NOTICE: Analyzing for intersections. Please wait... 198NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 199NOTICE: Isolated segments: 2 200NOTICE: Dead ends: 10 201NOTICE: Potential gaps found near dead ends: 1 202NOTICE: Intersections detected: 1 203NOTICE: Ring geometries: 0 204 pgr_analyzegraph 205------------------ 206 OK 207(1 row) 208 209-- q11.1 210-- q12 211CREATE TABLE mytable AS (SELECT id AS gid, source AS src ,target AS tgt , the_geom AS mygeom FROM edge_table); 212SELECT 18 213SELECT pgr_createTopology('mytable',0.001,'mygeom','gid','src','tgt', clean := true); 214NOTICE: PROCESSING: 215NOTICE: pgr_createTopology('mytable', 0.001, 'mygeom', 'gid', 'src', 'tgt', rows_where := 'true', clean := t) 216NOTICE: Performing checks, please wait ..... 217NOTICE: Creating Topology, Please wait... 218NOTICE: -------------> TOPOLOGY CREATED FOR 18 edges 219NOTICE: Rows with NULL geometry or NULL id: 0 220NOTICE: Vertices table for table public.mytable is: public.mytable_vertices_pgr 221NOTICE: ---------------------------------------------- 222 pgr_createtopology 223-------------------- 224 OK 225(1 row) 226 227-- q12.1 228-- q13 229SELECT pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt'); 230NOTICE: PROCESSING: 231NOTICE: pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt','true') 232NOTICE: Performing checks, please wait ... 233NOTICE: Analyzing for dead ends. Please wait... 234NOTICE: Analyzing for gaps. Please wait... 235NOTICE: Analyzing for isolated edges. Please wait... 236NOTICE: Analyzing for ring geometries. Please wait... 237NOTICE: Analyzing for intersections. Please wait... 238NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 239NOTICE: Isolated segments: 2 240NOTICE: Dead ends: 7 241NOTICE: Potential gaps found near dead ends: 1 242NOTICE: Intersections detected: 1 243NOTICE: Ring geometries: 0 244 pgr_analyzegraph 245------------------ 246 OK 247(1 row) 248 249-- q13.1 250-- q14 251SELECT pgr_analyzeGraph('mytable',0.0001,'gid','mygeom','src','tgt'); 252NOTICE: PROCESSING: 253NOTICE: pgr_analyzeGraph('mytable',0.0001,'gid','mygeom','src','tgt','true') 254NOTICE: Performing checks, please wait ... 255NOTICE: Got function st_srid(bigint) does not exist 256NOTICE: ERROR: something went wrong when checking for SRID of gid in table public.mytable 257 pgr_analyzegraph 258------------------ 259 FAIL 260(1 row) 261 262-- q14.1 263-- q15 264SELECT pgr_analyzeGraph('mytable',0.001,the_geom:='mygeom',id:='gid',source:='src',target:='tgt'); 265NOTICE: PROCESSING: 266NOTICE: pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt','true') 267NOTICE: Performing checks, please wait ... 268NOTICE: Analyzing for dead ends. Please wait... 269NOTICE: Analyzing for gaps. Please wait... 270NOTICE: Analyzing for isolated edges. Please wait... 271NOTICE: Analyzing for ring geometries. Please wait... 272NOTICE: Analyzing for intersections. Please wait... 273NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 274NOTICE: Isolated segments: 2 275NOTICE: Dead ends: 7 276NOTICE: Potential gaps found near dead ends: 1 277NOTICE: Intersections detected: 1 278NOTICE: Ring geometries: 0 279 pgr_analyzegraph 280------------------ 281 OK 282(1 row) 283 284-- q15.1 285-- q16 286SELECT pgr_analyzeGraph('mytable',0.001,source:='src',id:='gid',target:='tgt',the_geom:='mygeom'); 287NOTICE: PROCESSING: 288NOTICE: pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt','true') 289NOTICE: Performing checks, please wait ... 290NOTICE: Analyzing for dead ends. Please wait... 291NOTICE: Analyzing for gaps. Please wait... 292NOTICE: Analyzing for isolated edges. Please wait... 293NOTICE: Analyzing for ring geometries. Please wait... 294NOTICE: Analyzing for intersections. Please wait... 295NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 296NOTICE: Isolated segments: 2 297NOTICE: Dead ends: 7 298NOTICE: Potential gaps found near dead ends: 1 299NOTICE: Intersections detected: 1 300NOTICE: Ring geometries: 0 301 pgr_analyzegraph 302------------------ 303 OK 304(1 row) 305 306-- q16.1 307-- q17 308SELECT pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt',rows_where:='gid < 10'); 309NOTICE: PROCESSING: 310NOTICE: pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt','gid < 10') 311NOTICE: Performing checks, please wait ... 312NOTICE: Analyzing for dead ends. Please wait... 313NOTICE: Analyzing for gaps. Please wait... 314NOTICE: Analyzing for isolated edges. Please wait... 315NOTICE: Analyzing for ring geometries. Please wait... 316NOTICE: Analyzing for intersections. Please wait... 317NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 318NOTICE: Isolated segments: 0 319NOTICE: Dead ends: 4 320NOTICE: Potential gaps found near dead ends: 0 321NOTICE: Intersections detected: 0 322NOTICE: Ring geometries: 0 323 pgr_analyzegraph 324------------------ 325 OK 326(1 row) 327 328-- q17.1 329-- q18 330SELECT pgr_analyzeGraph('mytable',0.001,source:='src',id:='gid',target:='tgt',the_geom:='mygeom',rows_where:='gid < 10'); 331NOTICE: PROCESSING: 332NOTICE: pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt','gid < 10') 333NOTICE: Performing checks, please wait ... 334NOTICE: Analyzing for dead ends. Please wait... 335NOTICE: Analyzing for gaps. Please wait... 336NOTICE: Analyzing for isolated edges. Please wait... 337NOTICE: Analyzing for ring geometries. Please wait... 338NOTICE: Analyzing for intersections. Please wait... 339NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 340NOTICE: Isolated segments: 0 341NOTICE: Dead ends: 4 342NOTICE: Potential gaps found near dead ends: 0 343NOTICE: Intersections detected: 0 344NOTICE: Ring geometries: 0 345 pgr_analyzegraph 346------------------ 347 OK 348(1 row) 349 350-- q18.1 351-- q19 352SELECT pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt', 353 rows_where:='mygeom && (SELECT st_buffer(mygeom,1) FROM mytable WHERE gid=5)'); 354NOTICE: PROCESSING: 355NOTICE: pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt','mygeom && (SELECT st_buffer(mygeom,1) FROM mytable WHERE gid=5)') 356NOTICE: Performing checks, please wait ... 357NOTICE: Analyzing for dead ends. Please wait... 358NOTICE: Analyzing for gaps. Please wait... 359NOTICE: Analyzing for isolated edges. Please wait... 360NOTICE: Analyzing for ring geometries. Please wait... 361NOTICE: Analyzing for intersections. Please wait... 362NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 363NOTICE: Isolated segments: 1 364NOTICE: Dead ends: 5 365NOTICE: Potential gaps found near dead ends: 0 366NOTICE: Intersections detected: 1 367NOTICE: Ring geometries: 0 368 pgr_analyzegraph 369------------------ 370 OK 371(1 row) 372 373-- q19.1 374-- q20 375SELECT pgr_analyzeGraph('mytable',0.001,source:='src',id:='gid',target:='tgt',the_geom:='mygeom', 376 rows_where:='mygeom && (SELECT st_buffer(mygeom,1) FROM mytable WHERE gid=5)'); 377NOTICE: PROCESSING: 378NOTICE: pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt','mygeom && (SELECT st_buffer(mygeom,1) FROM mytable WHERE gid=5)') 379NOTICE: Performing checks, please wait ... 380NOTICE: Analyzing for dead ends. Please wait... 381NOTICE: Analyzing for gaps. Please wait... 382NOTICE: Analyzing for isolated edges. Please wait... 383NOTICE: Analyzing for ring geometries. Please wait... 384NOTICE: Analyzing for intersections. Please wait... 385NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 386NOTICE: Isolated segments: 1 387NOTICE: Dead ends: 5 388NOTICE: Potential gaps found near dead ends: 0 389NOTICE: Intersections detected: 1 390NOTICE: Ring geometries: 0 391 pgr_analyzegraph 392------------------ 393 OK 394(1 row) 395 396-- q20.1 397-- q21 398DROP TABLE IF EXISTS otherTable; 399DROP TABLE 400CREATE TABLE otherTable AS (SELECT 'myhouse'::text AS place, st_point(2.5,2.5) AS other_geom) ; 401SELECT 1 402SELECT pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt', 403 rows_where:='mygeom && (SELECT st_buffer(other_geom,1) FROM otherTable WHERE place='||quote_literal('myhouse')||')'); 404NOTICE: PROCESSING: 405NOTICE: pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt','mygeom && (SELECT st_buffer(other_geom,1) FROM otherTable WHERE place='myhouse')') 406NOTICE: Performing checks, please wait ... 407NOTICE: Analyzing for dead ends. Please wait... 408NOTICE: Analyzing for gaps. Please wait... 409NOTICE: Analyzing for isolated edges. Please wait... 410NOTICE: Analyzing for ring geometries. Please wait... 411NOTICE: Analyzing for intersections. Please wait... 412NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 413NOTICE: Isolated segments: 2 414NOTICE: Dead ends: 10 415NOTICE: Potential gaps found near dead ends: 1 416NOTICE: Intersections detected: 1 417NOTICE: Ring geometries: 0 418 pgr_analyzegraph 419------------------ 420 OK 421(1 row) 422 423-- q21.1 424-- q22 425SELECT pgr_analyzeGraph('mytable',0.001,source:='src',id:='gid',target:='tgt',the_geom:='mygeom', 426 rows_where:='mygeom && (SELECT st_buffer(other_geom,1) FROM otherTable WHERE place='||quote_literal('myhouse')||')'); 427NOTICE: PROCESSING: 428NOTICE: pgr_analyzeGraph('mytable',0.001,'mygeom','gid','src','tgt','mygeom && (SELECT st_buffer(other_geom,1) FROM otherTable WHERE place='myhouse')') 429NOTICE: Performing checks, please wait ... 430NOTICE: Analyzing for dead ends. Please wait... 431NOTICE: Analyzing for gaps. Please wait... 432NOTICE: Analyzing for isolated edges. Please wait... 433NOTICE: Analyzing for ring geometries. Please wait... 434NOTICE: Analyzing for intersections. Please wait... 435NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 436NOTICE: Isolated segments: 2 437NOTICE: Dead ends: 10 438NOTICE: Potential gaps found near dead ends: 1 439NOTICE: Intersections detected: 1 440NOTICE: Ring geometries: 0 441 pgr_analyzegraph 442------------------ 443 OK 444(1 row) 445 446-- q22.1 447-- q23 448SELECT pgr_createTopology('edge_table',0.001, clean := true); 449NOTICE: PROCESSING: 450NOTICE: pgr_createTopology('edge_table', 0.001, 'the_geom', 'id', 'source', 'target', rows_where := 'true', clean := t) 451NOTICE: Performing checks, please wait ..... 452NOTICE: Creating Topology, Please wait... 453NOTICE: -------------> TOPOLOGY CREATED FOR 18 edges 454NOTICE: Rows with NULL geometry or NULL id: 0 455NOTICE: Vertices table for table public.edge_table is: public.edge_table_vertices_pgr 456NOTICE: ---------------------------------------------- 457 pgr_createtopology 458-------------------- 459 OK 460(1 row) 461 462SELECT pgr_analyzeGraph('edge_table', 0.001); 463NOTICE: PROCESSING: 464NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','true') 465NOTICE: Performing checks, please wait ... 466NOTICE: Analyzing for dead ends. Please wait... 467NOTICE: Analyzing for gaps. Please wait... 468NOTICE: Analyzing for isolated edges. Please wait... 469NOTICE: Analyzing for ring geometries. Please wait... 470NOTICE: Analyzing for intersections. Please wait... 471NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 472NOTICE: Isolated segments: 2 473NOTICE: Dead ends: 7 474NOTICE: Potential gaps found near dead ends: 1 475NOTICE: Intersections detected: 1 476NOTICE: Ring geometries: 0 477 pgr_analyzegraph 478------------------ 479 OK 480(1 row) 481 482-- q23.1 483-- q24 484SELECT pgr_analyzeGraph('edge_table',0.001,rows_where:='id < 10'); 485NOTICE: PROCESSING: 486NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','id < 10') 487NOTICE: Performing checks, please wait ... 488NOTICE: Analyzing for dead ends. Please wait... 489NOTICE: Analyzing for gaps. Please wait... 490NOTICE: Analyzing for isolated edges. Please wait... 491NOTICE: Analyzing for ring geometries. Please wait... 492NOTICE: Analyzing for intersections. Please wait... 493NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 494NOTICE: Isolated segments: 0 495NOTICE: Dead ends: 4 496NOTICE: Potential gaps found near dead ends: 0 497NOTICE: Intersections detected: 0 498NOTICE: Ring geometries: 0 499 pgr_analyzegraph 500------------------ 501 OK 502(1 row) 503 504-- q24.1 505-- q25 506SELECT pgr_analyzeGraph('edge_table',0.001,rows_where:='id >= 10'); 507NOTICE: PROCESSING: 508NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','id >= 10') 509NOTICE: Performing checks, please wait ... 510NOTICE: Analyzing for dead ends. Please wait... 511NOTICE: Analyzing for gaps. Please wait... 512NOTICE: Analyzing for isolated edges. Please wait... 513NOTICE: Analyzing for ring geometries. Please wait... 514NOTICE: Analyzing for intersections. Please wait... 515NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 516NOTICE: Isolated segments: 2 517NOTICE: Dead ends: 8 518NOTICE: Potential gaps found near dead ends: 1 519NOTICE: Intersections detected: 1 520NOTICE: Ring geometries: 0 521 pgr_analyzegraph 522------------------ 523 OK 524(1 row) 525 526-- q25.1 527-- q26 528SELECT pgr_analyzeGraph('edge_table',0.001,rows_where:='id < 17'); 529NOTICE: PROCESSING: 530NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','id < 17') 531NOTICE: Performing checks, please wait ... 532NOTICE: Analyzing for dead ends. Please wait... 533NOTICE: Analyzing for gaps. Please wait... 534NOTICE: Analyzing for isolated edges. Please wait... 535NOTICE: Analyzing for ring geometries. Please wait... 536NOTICE: Analyzing for intersections. Please wait... 537NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 538NOTICE: Isolated segments: 0 539NOTICE: Dead ends: 3 540NOTICE: Potential gaps found near dead ends: 0 541NOTICE: Intersections detected: 0 542NOTICE: Ring geometries: 0 543 pgr_analyzegraph 544------------------ 545 OK 546(1 row) 547 548-- q26.1 549-- q27 550SELECT pgr_createTopology('edge_table', 0.001,rows_where:='id <17', clean := true); 551NOTICE: PROCESSING: 552NOTICE: pgr_createTopology('edge_table', 0.001, 'the_geom', 'id', 'source', 'target', rows_where := 'id <17', clean := t) 553NOTICE: Performing checks, please wait ..... 554NOTICE: Creating Topology, Please wait... 555NOTICE: -------------> TOPOLOGY CREATED FOR 16 edges 556NOTICE: Rows with NULL geometry or NULL id: 0 557NOTICE: Vertices table for table public.edge_table is: public.edge_table_vertices_pgr 558NOTICE: ---------------------------------------------- 559 pgr_createtopology 560-------------------- 561 OK 562(1 row) 563 564-- q27.1 565-- q28 566SELECT pgr_analyzeGraph('edge_table', 0.001); 567NOTICE: PROCESSING: 568NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','true') 569NOTICE: Performing checks, please wait ... 570NOTICE: Analyzing for dead ends. Please wait... 571NOTICE: Analyzing for gaps. Please wait... 572NOTICE: Analyzing for isolated edges. Please wait... 573NOTICE: Analyzing for ring geometries. Please wait... 574NOTICE: Analyzing for intersections. Please wait... 575NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES: 576NOTICE: Isolated segments: 0 577NOTICE: Dead ends: 3 578NOTICE: Potential gaps found near dead ends: 0 579NOTICE: Intersections detected: 0 580NOTICE: Ring geometries: 0 581 pgr_analyzegraph 582------------------ 583 OK 584(1 row) 585 586-- q28.1 587ROLLBACK; 588ROLLBACK 589