Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Table "public.reforma_opendata"
- Column | Type | Collation | Nullable | Default
- ---------------------------------+------------------------+-----------+----------+----------------------------------------------
- id | integer | | not null | nextval('reforma_opendata_id_seq'::regclass)
- id_ref | integer | | not null |
- management_organization_id | integer | | |
- region_id | character varying(40) | | not null |
- area_id | character varying(40) | | not null |
- city_id | character varying(40) | | not null |
- street_id | character varying(40) | | not null |
- houseguid | character varying(40) | | not null |
- built_year | smallint | | |
- exploitation_start_year | smallint | | |
- house_type | character varying(255) | | |
- is_alarm | character varying(3) | | |
- method_of_forming_overhaul_fund | character varying(255) | | |
- floor_count_max | smallint | | |
- floor_count_min | smallint | | |
- entrance_count | smallint | | |
- energy_efficiency | character varying(255) | | |
- elevators_count | smallint | | |
- quarters_count | smallint | | |
- living_quarters_count | smallint | | |
- unliving_quarters_count | smallint | | |
- area_total | double precision | | |
- area_residential | double precision | | |
- area_non_residential | double precision | | |
- area_common_property | double precision | | |
- area_land | double precision | | |
- parking_square | double precision | | |
- playground | smallint | | |
- sportsground | smallint | | |
- foundation_type | character varying(255) | | |
- floor_type | character varying(255) | | |
- wall_material | character varying(255) | | |
- basement_area | double precision | | |
- chute_type | character varying(255) | | |
- chute_count | smallint | | |
- electrical_type | character varying(255) | | |
- electrical_entries_count | smallint | | |
- heating_type | character varying(255) | | |
- hot_water_type | character varying(255) | | |
- cold_water_type | character varying(255) | | |
- sewerage_type | character varying(255) | | |
- sewerage_cesspools_volume | double precision | | |
- gas_type | character varying(255) | | |
- ventilation_type | character varying(255) | | |
- firefighting_type | character varying(255) | | |
- drainage_type | character varying(255) | | |
- project_type | text | | |
- other_beautification | text | | |
- address | text | | |
- fias_id | integer | | |
- geo_lat | double precision | | |
- geo_lon | double precision | | |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement