20210219 13032600 1.0 FALSE Buildings_2017_Clip1 002 900437.501003 934752.937621 624256.312491 661796.965756 1 5.577 Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Connecticut_FIPS_0600_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.6'><WKT>PROJCS["NAD_1983_StatePlane_Connecticut_FIPS_0600_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",999999.999996],PARAMETER["False_Northing",499999.999998],PARAMETER["Central_Meridian",-72.75],PARAMETER["Standard_Parallel_1",41.2],PARAMETER["Standard_Parallel_2",41.86666666666667],PARAMETER["Latitude_Of_Origin",40.83333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2234]]</WKT><XOrigin>-119756300</XOrigin><YOrigin>-96342500</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.003280833333333</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102656</WKID><LatestWKID>2234</LatestWKID></ProjectedCoordinateSystem> 20210219 13010500 20210219 13010500 150000000 5000 ItemDescription Item Description Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9270 Buildings_2017_Clip1 1 -73.112213 -72.986998 41.277145 41.173788 To represent the avaialble assessor data on buildings and to create a link to individual buildings for permitting purposes Buildings <DIV STYLE="text-align:Left;">In the table is a field called "VNS_BID", it is used to create a link to the Vision database table "CONSTRVIEW", the table that holds all the construction data for structures. Features that do not have BID number do not have data associated in the CONSTRVIEW table, they may be outbuildings or apartments or other structures. These structures will have the account number and parcel ID of the underlying parcel. All condominium accounts have duplicate BID numbers, it's a fault in the data but does't impact outcomes in any significant way.Other important fields to note:"TYPE" is a code field developed by the fire department for their use"FIREUNIT" is a code used to assign map panel numbers for internal use at the fire department"VNS_BLD_NUM" is used to identify which structure belongs to which assessor record in instances where 1 account number is related to multiple buildings. The field TOT_NUM is the total number of structures for that specific acount. This data was manually checked and entered by extracting a subset of data from the CONSTRVIEW table of all records that had a BLD_NUM greater than 1. Using the online vision database, deeds, and available maps, each building number was verified. This was necessary to create the link to the create BID (Building ID) number in the CONSTRVIEW table."REM_ACCT_NUM" is the assessor's account - if the structure is one of many buildings on a parcel the primary building (BLDNUM 1) will hold the account information. "Parcel Account" is the account number for the underlying parcel. In most cases these numbers will be the same. The important exception to note is when there are many different owners on a parcel, such as in the case of a condo complex."VNS_PID" is the parcel identification number that correlates to VisionDirections to populate Building Attributes:<OL><LI>Go to <A href="NEGeo</A>and copy the access database: NEGEO_MILFORD_DATA.mdb. Replace the existing copy in <A href="Tables</A></LI><LI>Within that same folder open the database <A href="CREATE_BUILDING.mdb">CREATE_BUILDING</A>. Run the query qry_Clear_Table to delete all the existing records.</LI><LI>Then, right click and copy the query qry_Make_BLDG and paste it into the NEGEO database. Run the query within the NEGEO database. Close the NEGEO database.</LI><LI>You can now use the table BLDG to populate the building shapefile table.</LI></OL><DIV><DIV></DIV></DIV></DIV> File Geodatabase Feature Class 5.577 dataset EPSG 5.3(9.0.0) 0 Simple FALSE 0 TRUE FALSE Buildings_2017_Clip1 Feature Class 0 OBJECTID OBJECTID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 0 0 0 Feature geometry. Esri Coordinates defining the features. Shape_Leng SHAPE_LENG Double 8 0 0 REM_ACCT_N REM_ACCT_N String 20 0 0 ADDRESS ADDRESS String 50 0 0 NAME NAME String 50 0 0 TYPE TYPE Double 8 0 0 TYPE_DECR TYPE_DECR String 25 0 0 FIRE_UNIT FIRE_UNIT String 8 0 0 COM_SUB COM_SUB String 50 0 0 VNS_BLD_NU VNS_BLD_NU Double 8 0 0 TOT_COUNT TOT_COUNT Double 8 0 0 ADDR ADDR String 10 0 0 STREET STREET String 40 0 0 SFHA SFHA String 20 0 0 BLDG_UNIT BLDG_UNIT String 10 0 0 PAR_ACCT PAR_ACCT String 20 0 0 REM_PRCL_L REM_PRCL_L String 50 0 0 SOURCE SOURCE String 50 0 0 LINK1 LINK1 String 75 0 0 LINK2 LINK2 String 75 0 0 LINK3 LINK3 String 75 0 0 VNS_BID VNS_BID Double 8 0 0 VNS_PID VNS_PID Double 8 0 0 JOIN_BID JOIN_BID String 15 0 0 created_us CREATED_US String 254 0 0 created_da CREATED_DA Date 8 0 0 last_edite LAST_EDITE String 254 0 0 last_edi_1 LAST_EDI_1 Date 8 0 0 Year_Built YEAR_BUILT Double 8 0 0 Grade GRADE String 4 0 0 Grade_Desc GRADE_DESC String 14 0 0 Heat_Fuel HEAT_FUEL String 14 0 0 Shape_Length Shape_Length Double 8 0 0 Length of feature in internal units. Esri Positive real numbers that are automatically generated. Shape_Area Shape_Area Double 8 0 0 Area of feature in internal units squared. Esri Positive real numbers that are automatically generated. 20210219