Map data

Data structures used to store map data in the frontend and the database

Component data coming into the app from the DB

{
    "project_component_id": 9,
    "component_id": 5,
    "description": null,
    "moped_components": {
        "component_name": "Bike Box",
        "component_subtype": null,
        "feature_layer": {
            "internal_table": "feature_intersections",
            "__typename": "feature_layers"
        },
        "line_representation": false,
        "moped_subcomponents": [],
        "__typename": "moped_components"
    },
    "moped_proj_components_subcomponents": [],
    "feature_street_segments": [],
    "feature_intersections": [
        {
            "id": 5,
            "geometry": {
                "type": "MultiPoint",
                "crs": {
                    "type": "name",
                    "properties": {
                        "name": "urn:ogc:def:crs:EPSG::4326"
                    }
                },
                "coordinates": [
                    [
                        -97.747659,
                        30.32262
                    ]
                ]
            },
            "source_layer": "ATD_ADMIN.CTN_Intersections",
            "intersection_id": 5155989,
            "component_id": 9,
            "__typename": "feature_intersections"
        },
        {
            "id": 6,
            "geometry": {
                "type": "MultiPoint",
                "crs": {
                    "type": "name",
                    "properties": {
                        "name": "urn:ogc:def:crs:EPSG::4326"
                    }
                },
                "coordinates": [
                    [
                        -97.748264,
                        30.321573
                    ]
                ]
            },
            "source_layer": "ATD_ADMIN.CTN_Intersections",
            "intersection_id": 5155903,
            "component_id": 9,
            "__typename": "feature_intersections"
        }
    ],
    "feature_signals": [],
    "feature_drawn_lines": [],
    "feature_drawn_points": [],
    "__typename": "moped_proj_components"
}

Feature data coming into the app from feature tables

LineString component

{
    "id": 448,
    "geometry": {
        "type": "MultiLineString",
        "crs": {
            "type": "name",
            "properties": {
                "name": "urn:ogc:def:crs:EPSG::4326"
            }
        },
        "coordinates": [
            [
                [
                    -97.741932,
                    30.281738
                ],
                [
                    -97.742695,
                    30.281955
                ]
            ]
        ]
    },
    "source_layer": "ATD_ADMIN.CTN",
    "ctn_segment_id": 151651,
    "component_id": 2286,
    "__typename": "feature_street_segments"
}

Point component

{
    "id": 5,
    "geometry": {
        "type": "MultiPoint",
        "crs": {
            "type": "name",
            "properties": {
                "name": "urn:ogc:def:crs:EPSG::4326"
            }
        },
        "coordinates": [
            [
                -97.747659,
                30.32262
            ]
        ]
    },
    "source_layer": "ATD_ADMIN.CTN_Intersections",
    "intersection_id": 5155989,
    "component_id": 9,
    "__typename": "feature_intersections"
}

Signal (Pedestrian Hybrid Beacon or Traffic) component

{
    "id": 4,
    "geometry": {
        "type": "MultiPoint",
        "crs": {
            "type": "name",
            "properties": {
                "name": "urn:ogc:def:crs:EPSG::4326"
            }
        },
        "coordinates": [
            [
                -97.751935,
                30.25894
            ]
        ]
    },
    "component_id": 6,
    "location_name": "600 BLK BARTON SPRINGS RD (Town Lake Center)",
    "signal_id": 4004,
    "signal_type": "PHB",
    "knack_id": "5817c0e1e052e0422be6cc94",
    "__typename": "feature_signals"
}

Data prepared to insert into the database

LineString component

{
    "description": "this is a test",
    "component_id": 7,
    "name": "Bike Lane",
    "project_id": "227",
    "moped_proj_components_subcomponents": {
        "data": [
            {
                "subcomponent_id": 10
            }
        ]
    },
    "feature_street_segments": {
        "data": [
            {
                "full_street_name": "SPEEDWAY",
                "ctn_segment_id": 145038,
                "from_address_min": 3000,
                "to_address_max": 3017,
                "line_type": "On-Street",
                "source_layer": "ATD_ADMIN.CTN",
                "geography": {
                    "type": "MultiLineString",
                    "coordinates": [
                        [
                            [
                                -97.736033,
                                30.293182
                            ],
                            [
                                -97.735195,
                                30.293913
                            ]
                        ]
                    ]
                }
            },
            {
                "full_street_name": "SPEEDWAY",
                "ctn_segment_id": 150902,
                "from_address_min": 2700,
                "to_address_max": 2911,
                "line_type": "On-Street",
                "source_layer": "ATD_ADMIN.CTN",
                "geography": {
                    "type": "MultiLineString",
                    "coordinates": [
                        [
                            [
                                -97.73659,
                                30.291658
                            ],
                            [
                                -97.736578,
                                30.292475
                            ],
                            [
                                -97.736525,
                                30.29268
                            ],
                            [
                                -97.736033,
                                30.293182
                            ]
                        ]
                    ]
                }
            },
            {
                "full_street_name": "SPEEDWAY",
                "ctn_segment_id": 146832,
                "from_address_min": 2600,
                "to_address_max": 2634,
                "line_type": "On-Street",
                "source_layer": "ATD_ADMIN.CTN",
                "geography": {
                    "type": "MultiLineString",
                    "coordinates": [
                        [
                            [
                                -97.736814,
                                30.289463
                            ],
                            [
                                -97.736686,
                                30.290535
                            ],
                            [
                                -97.73659,
                                30.291658
                            ]
                        ]
                    ]
                }
            }
        ]
    },
    "feature_drawn_lines": {
        "data": []
    },
    "feature_drawn_points": {
        "data": []
    },
    "feature_signals": {
        "data": []
    }
}

Point component

{
    "description": null,
    "component_id": 5,
    "name": "Bike Box",
    "project_id": "227",
    "moped_proj_components_subcomponents": {
        "data": []
    },
    "feature_intersections": {
        "data": [
            {
                "intersection_id": 5155989,
                "source_layer": "ATD_ADMIN.CTN_Intersections",
                "geography": {
                    "type": "MultiPoint",
                    "coordinates": [
                        [
                            -97.747659,
                            30.32262
                        ]
                    ]
                }
            },
            {
                "intersection_id": 5155903,
                "source_layer": "ATD_ADMIN.CTN_Intersections",
                "geography": {
                    "type": "MultiPoint",
                    "coordinates": [
                        [
                            -97.748264,
                            30.321573
                        ]
                    ]
                }
            }
        ]
    },
    "feature_drawn_lines": {
        "data": []
    },
    "feature_drawn_points": {
        "data": []
    },
    "feature_signals": {
        "data": []
    }
}

Signal (Pedestrian Hybrid Beacon or Traffic) component

{
    "geography": {
        "type": "MultiPoint",
        "crs": {
            "type": "name",
            "properties": {
                "name": "urn:ogc:def:crs:EPSG::4326"
            }
        },
        "coordinates": [
            [
                -97.751935,
                30.25894
            ]
        ]
    },
    "knack_id": "5817c0e1e052e0422be6cc94",
    "location_name": "600 BLK BARTON SPRINGS RD (Town Lake Center)",
    "signal_type": "PHB",
    "signal_id": 4004,
    "component_id": 6
}