Master Facilities
The location of City of Philadelphia owned, leased or managed buildings, structures, properties and other fixed assets. The database includes point feature/records for properties or buildings for which the City has expended Capital Program funds. There are two primary uses for this feature class:1) Location of City facilities, operations, and fixed assets by status, city ownership or lease, and occupant.2) Location of Capital Program expenditures on either city owned or non-city owned buildings or properties (see 5-digit value in Site_Code field).Data DevelopmentThe database was compiled from 2011 through 2013 from multiple sources including the Budget Office’s financial management database (FAMIS), departmental fixed asset lists, GIS data layers on building and operating locations maintained by PWD, PPR, Police, Prisons, Fire, and PCPC and surveys conducted by PCPC of departments for the Mayor’s Task Force on City-owned Buildings (Spring 2012). Tabular records were geocoded and manually adjusted using aerial photography and Pictometry, and other reference layers including PWD parcels, street centerlines, and building footprints.Each record is attributed with a sequential, numeric identification number (Asset_ID).Developed in ArcGIS Desktop 10 in Esri geodatabase format. Select fields utilize geodatabase domains to populate cells with full text descriptions. Use of the layer outside of the Esri geodatabase will result in the appearance of one to three digit codes instead of full text descriptions in the following fields: Asset_Group1, Asset_Group2, Asset_Type, Asset_Subtype1, Asset_Subtype2, CityUse_Desc, Serving_Type, and Status.Each record is attributed with a sequential, numeric identification number (Asset_ID). Every building has only one Asset_ID, except in cases where distinct operations required separate tracking and identification. These instances include Police, Fire, Judiciary/District Attorney, garages and Street’s highway facilities, and Older Adult Centers. Where facilities share a building, each facility is assigned its own Asset_ID and Asset_Subtype values. The shared building relationship is cross-referenced in the SharedBldg_AssetID and ShareBldg_Note fields. Due to this condition, a summary of the Asset_Type = “B1” values requires the removal of duplicate records using the SharedBldg_AssetID field.Thematic Mapping The layer currently includes active and inactive assets. Users must ensure that they are evaluating active vs. inactive features using the Status field. The Status = “C” capital expenditure is reserved for PCPC analysis purposes.General mapping may occur using the Status = “A” for active sites and mapping by categories using the Asset_Subtype1 field.The Site_Code field may used to identify buildings and properties that have had (or can be allocated) funds from the City’s Capital Program and are also known as “Capital Facilities.”Key AttributesThis layer is currently under development. Verification of some attribute fields is underway. Accuracy of some field values is limited at this time. A data dictionary (.pdf) is available from PCPC (see contact information below) or from GSG’s internal web blog for City departments.StatusA - Active or currently in useI - Inactive or closed or shutteredC - Capital Investment (for PCPC analysis purposes)R - Review/TBD (to be determined upon further review). geodatabase coded domainAsset_IDUnique ID assigned to an asset by PCPCAsset_NameName of building, structure, land/site or equipmentSite_NameThe Asset_Name unless facility or site comprise more than one building, structure, equipment, etc. All assets are assigned the facility name (e.g., Police Academy has multiple buildings with individual asset names)Site_CodeThe Capital Program identification number to track expenditures and programming. Also known as the UserCode or Capital Code.SharedBldg_AssetIDTracks AssetIDs where two facilities share the same buildings. Limited to cases where individual departmental operations must be accounted as separate facilities regardless duplication in the Asset_Type = “B1” Building counts.Asset_TypeBasic categorization of asset as building, land, equipment, etc. Geodatabase coded domain.B1BuildingB2EquipmentB3LandB4StructureB5Parking LotB6PierB8OtherAsset_SubType1Specified categorization of an asset or operational use. Primary way to select and identify an asset, building or facility.C1Airport AirfieldC38Older Adult CenterC2Airport Terminal\HangerC81OtherC3Athletic Field\Soccer FieldC39Parking LotC68Athletic TrackC40Pavilion\ShelterC5Barn\StablesC41PierC87Baseball FieldC42Playground EquipmentC4Basketball CourtC45Police Operations\UnitC89Batting CageC43Police StationC6Bocci CourtC44Police Sub-StationC31Breezeway\Island\Managed AreaC46PoolC7BridgeC48Public Safety Training CenterC8City-Owned LandC47Radio\Cell TowerC9Compost\Recycling CenterC49Recreation BuildingC10Concessions\Retail\CafeC50Recreation CenterC11Detention Center AdultC51Recreation OtherC12Detention Center YouthC54Regional\Metro ParkC14Fire StationC55RestroomsC15Fire Station MarineC57Salt ShedC16FountainC65ShedC82Fuel PumpC58Skateboard ParkC17Garage\Maintenance BuildingC60Spray GroundC18Golf CourseC61Square\PlazaC13Golf Driving RangeC63Stage\StandsC19Greenhouse\NurseryC64Statue\MonumentC90Handball CourtC88Street Hockey Court\RinkC20Health CenterC67Tennis CourtC83HelipadC69TrailersC21Historic House\SiteC70Transfer StationC22Housing\Group QuartersC71Transit StationC23Ice RinkC85Volleyball CourtC86Judicial Court BuildingC73WarehouseC32KennelC75Waste Water Processing FacilityC24LaboratoryC74Waste Water StorageC25Library BranchC77Water Filter\Processing FacilityC26Library CentralC76Water Pumping StationC27Library OperationsC78Water StorageC28Library RegionalC79Watershed\Conservation ParkC29Library SpecializedC80Zoo\Animal HabitatC30Linear Park\ParkwayC91Recreation/Bike TrailC33Materials YardC92GeneratorC34Multi-Use\Office BuildingC35MuseumC36Neighborhood ParkC37Nursing HomeCityOwnedCity-owned building Yes or NoCityUse_DescDescription of city owned, leased or used by agreement. Non-city owned Capital investments sites are “Other” (e.g., The President’s House on federal land).OwnedCity OwnedLessorCity Owned, Lessor (leased to tenants)LesseeOther Ownership, City is LesseeUAOther Ownership, City Use AgreementOtherOther Ownership, Capital InvestmentOccupantPrimary city department or lessee occupying the site or building.Bldg_SQFTBuilding square footageBldg_YRYear building was constructedBldg_AgeAge of building from 2013MaintainedByCity dept or entity responsible for the building maintenance.EditNote1, EditDate, EditSource, EditSourceDateUsed by PCPC to track verification of the entry.CouncilDistCity Council District number. Based on redistricting effective March 2013PlanDistPlanning District nameCoordinate SystemNAD1983, PA Stateplane South U.S. FootOther Information1. Sites vs. individual buildings or assets:To account for individual buildings that exist at a particular site or campus (e.g., Police Academy) each individual asset is given its own Asset_ID and Asset_SubType1 values. All buildings and assets associated with a site are found by sorting on or querying the Site_Name field. Individual recreation centers can be tracked by querying Asset_SubType1 = “C50” or “Recreation Center.” All buildings and amenities at a center will be found under individual Asset_SubType1 codes such as “C42” “Playground Equipment”. This situation applies to all sites with multiple assets.2. Counting Assets:The Asset_Type field is a broad categorization of assets: buildings, equipment, structures, piers, etc. This field may be used to get an approximate count of buildings. As noted above (#1) the number of records in this feature class does not constitute a total count of buildings. There are cases where distinct operations within a single building are required to have separate Asset_IDs. Always check the SharedBldg_AssetID to remove duplicates for an accurate count of buildings.3. LeasesUse City_Buildings_Lease subtable to obtain available data on the nature of sites leased by the City and leased square footage. Join on Asset_ID fields. 4. Capital InvestmentsUse the City_Buildings_CapitalBudget subtable to obtain available data on six year Capital Program Expenditures. Join on Asset_ID fields. EXP_FY0010: aggregated expenditures FY2000-2010. REQ_FY1419: requested, not approved as of February 2013.5. Occupancy and Public UseUse the City_Buildings_Use subtable to obtain estimates and available data (2012) on building/site occupancy numbers, average hours of operation, and annual numbers of public served.SubTable MetadataCity_Buildings_CapitalBudgetFor use with City_Buildings_FixedAssets “Master Facility Database.”  Join table of known Capital Program expenditures by site, where available.Attributes Updated:   4/1/14Metadata Updated:  4/1/14Update Frequency:  AnnualJoin table to City_Buildings_FixedAssets documenting expenditures from the Philadelphia Capital Budget. Join using Asset_ID fields.  Total expenditures reflect only best available matches between relating site code values in the master facilities database and the City’s financial database. This table does not represent all Capital spending by the City for a specific fiscal year. Key Attribute FieldsSITE_CODE  – the Budget Office/Capital Program Division unique tracking number for assets designated for Capital funding.  In some instances Budget has retired a Site Code and replaced it. SITE_CODE2 - previous codes under which expenditures may have occurred.EXP_<fiscal year range> - aggregated expenditure values by Site Code. Fiscal year is denoted by abbreviation “FY” followed by 2-digit year as in FY10 for fiscal year 2010.City_Builidings_LeaseFor use with City_Buildings_FixedAssets “Master Facility Database.”  Join table of known buildings leased by the City, where data is available.Attributes Updated:   12/31/2012Metadata Updated:  2/15/13Update Frequency:  AnnuallyJoin table to City_Buildings_FixedAssets replicating lease information maintained by the Department of Public Property.  Join using Asset_ID fields.Key Attribute FieldsLeased_SQFT – leased square footage.Leased_CostSQFT – total cost per square foot.Leased _CostTotYR – total annual cost of lease including base sqft and other costs.Lease_CostOther – other costs separated from the annual total: taxes, utilities, maintenance fees, etc.Lease_Note – relevant information on lease. May include floors leased.City_Buildings_UseFor use with City_Buildings_FixedAssets “Master Facility Database.” Join table of facility operations including City staffing and frequency of public use, where available.Attributes Updated:   2/15/13Metadata Updated:  2/15/13Update Frequency:  AnnualJoin table to City_Buildings_FixedAssets documenting occupancy and public served figures for community-serving facilities.Key Attribute FieldsOccupant_Num – city employee or lessee average staffing numbers.  PPR department values may include part-time and season counts.HrsOp_Wk – average hours of operation as reported by occupant departments.Public_Serv_YR – 2012 annualized counts of public or clients served at a community-serving facility.
nan
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'ASSET_ADDR', 'type': 'esriFieldTypeString', 'alias': 'ASSET_ADDR', 'sqlType': 'sqlTypeOther', 'length': 75, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'SITE_NAME', 'type': 'esriFieldTypeString', 'alias': 'Site_Name', 'sqlType': 'sqlTypeOther', 'length': 90, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'GlobalID', 'type': 'esriFieldTypeGlobalID', 'alias': 'GlobalID', 'sqlType': 'sqlTypeOther', 'length': 38, 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}]
[{'name': 'PK__RW_Publi__F4B70D8531B4E265', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': 'clustered, unique, primary key', 'indexType': 'Attribute'}, {'name': 'user_9886.RW_PublicLandFacilitiesv10_2_3_Master_Facilities_Shape_sidx', 'fields': 'Shape', 'isAscending': False, 'isUnique': False, 'description': 'Shape Index', 'indexType': 'Spatial'}]
nan
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriSMS', 'style': 'esriSMSCircle', 'color': [168, 0, 168, 255], 'size': 4, 'angle': 0, 'xoffset': 0, 'yoffset': 0, 'outline': {'color': [0, 0, 0, 255], 'width': 1}}, 'label': '', 'description': ''}, 'transparency': 0, 'labelingInfo': None}
[]
[{'name': 'Master Facilities', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'SITE_NAME': None, 'ASSET_ADDR': None}}}]