Construcción y explotación de un almacén de datos para el análisis de información inmobiliaria

L'objectiu fonamental d'aquest TFC és la creació i posada en funcionament d'un magatzem de dades, partint de la informació procedent de bases de dades transaccionals.

Construcció i explotaciód'un magatzem de dades per a l'anàlisid'informació immobiliària

Per encàrrec d'una empresa immobiliària s'ha construït un magatzem de dades a partir d'un fitxer en format text amb els registres de 92.555 immobles amb la finalitat de, mitjançant consultes sobre aquestes dades utilitzant eines OLAP, obtenir informació sobre el mercatimmobiliari.

Sistema de gestió de subhastes per a un portal Immobiliari

Desenvolupament de un sistema de gestió de subhastes per aun portal immobiliari i s¿engloba dintre de l¿àrea de Java Enterprise Edition.

Construcción de un almacén de datospara la empresa "Sostre per a tothom"

El projecte consisteix en el disseny i implementació d'un magatzem de dades per l'empresa immobiliària "Sostre per a tothom". La implementació es realitzarà sobre el producte Oracle Discoverer.

Desenvolupament d’un nou component de gestió de clients i facturació d’una immobiliària per Joomla

Disseny i implementació d’ una aplicació per incorporar noves funcionalitats a la gestió de propietats immobles. En els últims anys, el lloguer d’apartaments i cases ha augmentat el seu volum de reserves a través d’Internet, i és per això, que moltes empreses del sector han dedicat molts esforços en potenciar aquest canal i fer tots els tràmits a través de la xarxa. L’hivern del 2009 l’empresa a qui va dirigida aquest projecte, va decidir fer aquest salt i irrompre a Internet. En aquell moment es van plantejar diferents opcions per a la gestió d’immobles: fer una aplicació totalment nova i a mida, comprar una aplicació ja feta a empreses especialitzades o adaptar una aplicació gratuïta a les necessitats de l’empresa. Analitzats amb detall els tres casos, es va decidir implementar la tercera opció ja que satisfeia les necessitats de l’empresa i amb modificacions o adaptacions aconseguiria el resultat esperat. L’aplicació gratuïta és el “com-property” i la seva posada en marxa va ser en dos mesos

Social spending and demographics: The role of public policies in the intergenerational redistribution of income. Empirical evidence from Spain and Catalonia

The demographic shift underway in Southern Europe requires a revision of some of the fundamental principles of the traditional welfare state. We analyze the evolution of several aspects of welfare and social expenditure over the last two decades. We find that in the context of the present demographic changes and real estate boom current social and pension policy leads to a new distribution of benefits and burdens which is highly intergenerationally unequal. We argue for a revised definition of public policy based on Musgrave's proposition as a possible rule for an intergenerationally fair distribution.

Notary Pocketbook

The responsibilities of an Iowa Notary Public are critical to the legal, business, financial and real estate communities and should be taken seri- ously. This pocketbook is designed to assist Iowa notary publics as they perform their duties.

Market and institutional determinants in the regulation of conveyancers

Demand for law professionals in the conveyancing of property is decreasing because of market and institutional changes. On the market side, many transactions feature large, well-known parties and standardized transactions, which make professionals less effective or necessary for protecting the parties to private contracts. On the institutional side, public titling makes it possible to dispense with a broadening set of their former functions. Recording of deeds made professionals redundant as depositories of deeds and reduced demand for them to design title guarantees. Effective registration of rights increasingly substitutes professionals for detecting title conflicts with third parties and gathering their consent. Market changes undermine the information asymmetry rationale for regulating conveyancing, while institutional changes facilitate liberalizing not only conduct but also license regulations. These arguments are supported here by disentangling the logic of titling systems and presenting empirical evidence from the European and USA markets.

The role of title insurance under recording and registration

This article outlines a transaction cost theory of title insurance andanalyses the role it plays in countries with recording and registrationof land titles. Title insurance indemnifies real estate right holdersfor losses caused by pre-existing title defects that are unknown whenthe policy is issued. It emerged to complement the errors and omissions insurance of professionals examining title quality. Poor organizationof public records led title insurers in the USA to integrate titleexamination and settlement services. Their residual claimant statusmotivates insurers to screen, cure and avoid title defects. Firmsintroducing title insurance abroad produce little information on titlequality, however. Their policies are instead issued on a casualty basis,complementing and enforcing the professional liability of conveyancers.Future development in markets with land registration is uncertainbecause of adverse selection, competitive reactions from establishedconveyancers and the ability of larger banks to self-insure title risks.

Property enforcement as organized consent

This article develops and tests a theory of the institutions that makeproperty rights viable, ensuring their enforcement, mobilizing thecollateral value of assets and promoting growth. In contrast tocontractual rights, property rights are enforced in rem, being affectedonly with the consent of the right holder. This ensures enforcement butis costly when multiple, potentially colliding rights are held in thesame asset. Different institutions reduce the cost of gathering consentsto overcome this trade-off of enforcement benefits for consent costs:recording of deeds with title insurance, registration of rights and evena regimen of purely private transactions. All three provide functionallysimilar services, but their relative performance varies with the numberof transactions, the risk of political opportunism and regulatoryconsistency. The analysis also shows the rationality of allowingcompetition in the preparation and support of private contractswhile requiring territorial monopoly in recording and registrationactivities, this to ensure independence and protect third parties.

Social spending and demographics: The role of public policies in the intergenerational redistribution of income. Empirical evidence from Spain and Catalonia

The demographic shift underway in Southern Europe requires a revision of some of thefundamental principles of the traditional welfare state. We analyze the evolution of several aspects of welfare and social expenditure over the last two decades. We find that in the context of the present demographic changes and real estate boom current social and pension policy leads to a new distribution of benefits and burdens which is highly intergenerationally unequal. We argue for a revised definition of public policy based on Musgrave's proposition as a possible rule for an intergenerationally fair distribution.

Iowa Brownfield Reuse Guide, September 15, 2008

Brownfield sites come in all shapes and sizes, from vacated industrial sites to a single building plagued with asbestos materials. Brownfield sites are found in both urban and rural settings and present challenges that make the cleanup and redevelopment of these sites unique as compared with other real estate projects.

Spatial planning to the test of property rights in Switzerland : an innovative land management approach to coordinate spatial planning goals with property rights interests

In Switzerland, the land management regime is characterized by a liberal attitude towards the institution of property rights, which is guaranteed by the Constitution. Under the present Swiss constitutional arrangement, authorities (municipalities) are required to take into account landowners' interests when implementing their spatial planning policy. In other words, the institution of property rights cannot be restricted easily in order to implement zoning plans and planning projects. This situation causes many problems. One of them is the gap between the way land is really used by the landowners and the way land should be used based on zoning plans. In fact, zoning plans only describe how landowners should use their property. There is no sufficient provision for handling cases where the use is not in accordance with zoning plans. In particular, landowners may not be expropriated for a non-conforming use of the land. This situation often leads to the opening of new building areas in greenfields and urban sprawl, which is in contradiction with the goals set into the Federal Law on Spatial Planning. In order to identify legal strategies of intervention to solve the problem, our paper is structured into three main parts. Firstly, we make a short description of the Swiss land management regime. Then, we focus on an innovative land management approach designed to implement zoning plans in accordance with property rights. Finally, we present a case study that shows the usefulness of the presented land management approach in practice. We develop three main results. Firstly, the land management approach brings a mechanism to involve landowners in planning projects. Coordination principle between spatial planning goals and landowners' interests is the cornerstone of all the process. Secondly, the land use is improved both in terms of space and time. Finally, the institution of property rights is not challenged, since there is no expropriation and the market stays free.

Guidance Document for Executive Order Number 17, March 25, 2010

Executive Order 17, signed by Governor Chester J. Culver on September 25, 2009, emphasizes revitalization of historic properties and cultural and entertainment districts and also supports safe and healthy work places, sustainable design and cost effective use of state resources. Specifically, the Executive Order requires that State entities managing or leasing real estate on behalf of the State shall give priority to the needs of public entities and the populations they serve consistent with the cost effective use of state revenues. It also indicates that existing resources and facilities shall be used where adequate, cost competitive and appropriate for efficient and effective current state operations.

Faire la ville juste : une analyse "in itinere" de la maîtrise publique d'ouvrage du projet urbain Carré de Soie (métropole lyonnaise)

Dans certaines portions des agglomérations (poches de pauvreté de centre-ville, couronnes suburbaines dégradées, espaces périurbains sans aménité), un cumul entre des inégalités sociales (pauvreté, chômage, etc.) et environnementales (exposition au bruit, aux risques industriels, etc.) peut être observé. La persistance de ces inégalités croisées dans le temps indique une tendance de fond : la capacité d'accéder à un cadre de vie de qualité n'est pas équitablement partagée parmi les individus. Ce constat interroge : comment se créent ces inégalités ? Comment infléchir cette tendance et faire la ville plus juste ?¦Apporter des réponses à cette problématique nécessite d'identifier les facteurs de causalités qui entrent en jeu dans le système de (re)production des inégalités urbaines. Le fonctionnement des marchés foncier et immobilier, la « tyrannie des petites décisions » et les politiques publiques à incidence spatiale sont principalement impliqués. Ces dernières, agissant sur tous les éléments du système, sont placées au coeur de ce travail. On va ainsi s'intéresser précisément à la manière dont les collectivités publiques pilotent la production de la ville contemporaine, en portant l'attention sur la maîtrise publique d'ouvrage (MPO) des grands projets urbains.¦Poser la question de la justice dans la fabrique de la ville implique également de questionner les référentiels normatifs de l'action publique : à quelle conception de la justice celle-ci doit- elle obéir? Quatre perspectives (radicale, substantialiste, procédurale et intégrative) sont caractérisées, chacune se traduisant par des principes d'action différenciés. Une méthodologie hybride - empruntant à la sociologie des organisations et à l'analyse des politiques publiques - vient clore le volet théorique, proposant par un détour métaphorique d'appréhender le projet urbain comme une pièce de théâtre dont le déroulement dépend du jeu d'acteurs.¦Cette méthodologie est utilisée dans le volet empirique de la recherche, qui consiste en une analyse de la MPO d'un projet urbain en cours dans la première couronne de l'agglomération lyonnaise : le Carré de Soie. Trois grands objectifs sont poursuivis : descriptif (reconstruire le scénario), analytique (évaluer la nature de la pièce : conte de fée, tragédie ou match d'improvisation ?) et prescriptif (tirer la morale de l'histoire). La description de la MPO montre le déploiement successif de quatre stratégies de pilotage, dont les implications sur les temporalités, le contenu du projet (programmes, morphologies) et les financements publics vont être déterminantes. Sur la base de l'analyse, plusieurs recommandations peuvent être formulées - importance de l'anticipation et de l'articulation entre planification et stratégie foncière notamment - pour permettre à la sphère publique de dominer le jeu et d'assurer la production de justice par le projet urbain (réalisation puis entretien des équipements et espaces publics, financement de logements de qualité à destination d'un large éventail de populations, etc.). Plus généralement, un décalage problématique peut être souligné entre les territoires stratégiques pour le développement de l'agglomération et les capacités de portage limitées des communes concernées. Ce déficit plaide pour le renforcement des capacités d'investissement de la structure intercommunale.¦La seule logique du marché (foncier, immobilier) mène à la polarisation sociale et à la production d'inégalités urbaines. Faire la ville juste nécessite une forte volonté des collectivités publiques, laquelle doit se traduire aussi bien dans l'ambition affichée - une juste hiérarchisation des priorités dans le développement urbain - que dans son opérationnalisation - une juste maîtrise publique d'ouvrage des projets urbains.¦Inner-city neighborhoods, poor outskirts, and peri-urban spaces with no amenities usually suffer from social and environmental inequalities, such as poverty, unemployment, and exposure to noise and industrial hazards. The observed persistence of these inequalities over time points to an underlying trend - namely, that access to proper living conditions is fundamentally unequal, thus eliciting the question of how such inequalities are effected and how this trend can be reversed so as to build a more equitable city.¦Providing answers to such questions requires that the causal factors at play within the system of (re)production of urban inequalities be identified. Real estate markets, "micromotives and macrobehavior", and public policies that bear on space are mostly involved. The latter are central in that they act on all the elements of the system. This thesis therefore focuses on the way public authorities shape the production of contemporary cities, by studying the public project ownership of major urban projects.¦The study of justice within the urban fabric also implies that the normative frames of reference of public action be questioned: what conception of justice should public action refer to? This thesis examines four perspectives (radical, substantialist, procedural, and integrative) each of which results in different principles of action. This theoretical part is concluded by a hybrid methodology that draws from sociology of organizations and public policy analysis and that suggests that the urban project may be understood as a play, whose outcome hinges on the actors' acting.¦This methodology is applied to the empirical analysis of the public project ownership of an ongoing urban project in the Lyon first-ring suburbs: the Carré de Soie. Three main objectives are pursued: descriptive (reconstructing the scenario), analytical (assessing the nature of the play - fairy tale, tragedy or improvisation match), and prescriptive (drawing the moral of the story). The description of the public project ownership shows the successive deployment of four control strategies, whose implications on deadlines, project content (programs, morphologies), and public funding are significant. Building on the analysis, several recommendations can be made to allow the public sphere to control the process and ensure the urban project produces equity (most notably, anticipation and articulation of planning and real- estate strategy, as well as provision and maintenance of equipment and public spaces, funding of quality housing for a wide range of populations, etc.). More generally, a gap can be highlighted between those territories that are strategic to the development of the agglomeration and the limited resources of the municipalities involved. This deficit calls for strengthening the investment abilities of the intermunicipal structure.¦By itself, the real-estate market logic brings about social polarization and urban inequalities. Building an equitable city requires a strong will on the part of public authorities, a will that must be reflected both in the stated ambition - setting priorities of urban development equitably - and in its implementation managing urban public projects fairly.