{ "culture": "en-US", "name": "", "guid": "", "catalogPath": "", "snippet": "This dataset represents all street lights in Redlands, CA that were audited by Tanko Lighting, as well as which of these were converted to LED. Attributes of...", "description": "
Field Name<\/SPAN><\/SPAN><\/P><\/TD> | Alias<\/SPAN><\/SPAN><\/P><\/TD> | Description<\/SPAN><\/SPAN><\/P><\/TD><\/TR> MUNI_PN<\/SPAN><\/SPAN><\/P><\/TD> Municipal Pole Number<\/SPAN><\/SPAN><\/P><\/TD> Municipally owned and installed pole number<\/SPAN><\/SPAN><\/P><\/TD><\/TR> FIELD_PN<\/SPAN><\/SPAN><\/P><\/TD> Audited Pole Number<\/SPAN><\/SPAN><\/P><\/TD> Primary pole number found during field audit<\/SPAN><\/SPAN><\/P><\/TD><\/TR> ADDTNL_PN<\/SPAN><\/SPAN><\/P><\/TD> Additional Pole Numbers<\/SPAN><\/SPAN><\/P><\/TD> Additional pole numbers found during field audit<\/SPAN><\/SPAN><\/P><\/TD><\/TR> FIXTURTYPE<\/SPAN><\/SPAN><\/P><\/TD> Fixture Type<\/SPAN><\/SPAN><\/P><\/TD> Current fixture type<\/SPAN><\/SPAN><\/P><\/TD><\/TR> DECO<\/SPAN><\/SPAN><\/P><\/TD> Decorative Classification<\/SPAN><\/SPAN><\/P><\/TD> Decorative type (e.g. post top, pendant, wall-mount)<\/SPAN><\/SPAN><\/P><\/TD><\/TR> SB_POLE_SH<\/SPAN><\/SPAN><\/P><\/TD> Shoebox Pole Shape<\/SPAN><\/SPAN><\/P><\/TD> If fixture is a shoebox, the shape of the pole it is mounted to<\/SPAN><\/SPAN><\/P><\/TD><\/TR> CONTROL<\/SPAN><\/SPAN><\/P><\/TD> Control Device<\/SPAN><\/SPAN><\/P><\/TD> Indicates control device present on the fixture (e.g. photocell, control node, etc.)<\/SPAN><\/SPAN><\/P><\/TD><\/TR> HEADS<\/SPAN><\/SPAN><\/P><\/TD> Number of Heads on Pole<\/SPAN><\/SPAN><\/P><\/TD> Number of fixture heads mounted to a single pole<\/SPAN><\/SPAN><\/P><\/TD><\/TR> CURNT_LAMP<\/SPAN><\/SPAN><\/P><\/TD> Current Lamp Type<\/SPAN><\/SPAN><\/P><\/TD> Current lamp type<\/SPAN><\/SPAN><\/P><\/TD><\/TR> CURNT_WATT<\/SPAN><\/SPAN><\/P><\/TD> Current Wattage<\/SPAN><\/SPAN><\/P><\/TD> Current wattage<\/SPAN><\/SPAN><\/P><\/TD><\/TR> OLD_LAMP<\/SPAN><\/SPAN><\/P><\/TD> Old Lamp Type<\/SPAN><\/SPAN><\/P><\/TD> Old lamp type prior to LED conversion<\/SPAN><\/SPAN><\/P> HPS = High Pressure Sodium, MV = Mercury Vapor, MH = Metal Halide, IND = Induction, LPS = Low Pressure Sodium<\/SPAN><\/SPAN><\/P><\/TD><\/TR> OLD_WATT<\/SPAN><\/SPAN><\/P><\/TD> Old Wattage<\/SPAN><\/SPAN><\/P><\/TD> Old wattage prior to LED conversion<\/SPAN><\/SPAN><\/P><\/TD><\/TR> ALONEVDIST<\/SPAN><\/SPAN><\/P><\/TD> Standalone or Distribution<\/SPAN><\/SPAN><\/P><\/TD> Indicates whether the fixture is on a standalone pole or a distribution pole<\/SPAN><\/SPAN><\/P><\/TD><\/TR> FEED<\/SPAN><\/SPAN><\/P><\/TD> Feed Type<\/SPAN><\/SPAN><\/P><\/TD> Indicates whether fixture is powered with an overhead or underground electrical feed<\/SPAN><\/SPAN><\/P><\/TD><\/TR> POLEMAT<\/SPAN><\/SPAN><\/P><\/TD> Pole Material<\/SPAN><\/SPAN><\/P><\/TD> Pole material<\/SPAN><\/SPAN><\/P><\/TD><\/TR> HANDHOLE<\/SPAN><\/SPAN><\/P><\/TD> Handhole Present<\/SPAN><\/SPAN><\/P><\/TD> Indicates whether a handhole is present on the pole<\/SPAN><\/SPAN><\/P><\/TD><\/TR> ARM_LENGTH<\/SPAN><\/SPAN><\/P><\/TD> Arm Length<\/SPAN><\/SPAN><\/P><\/TD> Approximate length of arm in feet<\/SPAN><\/SPAN><\/P><\/TD><\/TR> ARM_ANGLE<\/SPAN><\/SPAN><\/P><\/TD> Arm Angle<\/SPAN><\/SPAN><\/P><\/TD> Arm angle in relation to the street<\/SPAN><\/SPAN><\/P><\/TD><\/TR> LIGHT_DIR<\/SPAN><\/SPAN><\/P><\/TD> Light Directed At<\/SPAN><\/SPAN><\/P><\/TD> If fixture is not lighting the right of way, indicates what the fixture is lighting<\/SPAN><\/SPAN><\/P><\/TD><\/TR> DIST_TO_ST<\/SPAN><\/SPAN><\/P><\/TD> Pole Distance to Street<\/SPAN><\/SPAN><\/P><\/TD> Approximate distance from pole to street in feet<\/SPAN><\/SPAN><\/P><\/TD><\/TR> ST_WIDTH<\/SPAN><\/SPAN><\/P><\/TD> Street Width<\/SPAN><\/SPAN><\/P><\/TD> Approximate width of the street in feet<\/SPAN><\/SPAN><\/P><\/TD><\/TR> MOUNT_HT<\/SPAN><\/SPAN><\/P><\/TD> Mounting Height<\/SPAN><\/SPAN><\/P><\/TD> Approximate mounting height of fixture in feet<\/SPAN><\/SPAN><\/P><\/TD><\/TR> STREETDESN<\/SPAN><\/SPAN><\/P><\/TD> Specialized Street Design<\/SPAN><\/SPAN><\/P><\/TD> Indicates whether fixture location has a specialized street design (e.g. intersection, cul-de-sac, safety light, etc.)<\/SPAN><\/SPAN><\/P><\/TD><\/TR> CROSSWALK<\/SPAN><\/SPAN><\/P><\/TD> Crosswalk<\/SPAN><\/SPAN><\/P><\/TD> Indicates whether the fixture is located near a crosswalk<\/SPAN><\/SPAN><\/P><\/TD><\/TR> ATTACHMNTS<\/SPAN><\/SPAN><\/P><\/TD> Device Attachments<\/SPAN><\/SPAN><\/P><\/TD> Indicates the presence of other devices on the fixture, arm, or pole<\/SPAN><\/SPAN><\/P><\/TD><\/TR> VOLTAGE<\/SPAN><\/SPAN><\/P><\/TD> Voltage<\/SPAN><\/SPAN><\/P><\/TD> Voltage recorded at installation<\/SPAN><\/SPAN><\/P><\/TD><\/TR> TRANSFORMR<\/SPAN><\/SPAN><\/P><\/TD> Transformer<\/SPAN><\/SPAN><\/P><\/TD> Step up or step down transformer used<\/SPAN><\/SPAN><\/P><\/TD><\/TR> ISSUES<\/SPAN><\/SPAN><\/P><\/TD> Field Issues<\/SPAN><\/SPAN><\/P><\/TD> Issues found at time of field audit and installation<\/SPAN><\/SPAN><\/P><\/TD><\/TR> OWNERSHIP<\/SPAN><\/SPAN><\/P><\/TD> Ownership<\/SPAN><\/SPAN><\/P><\/TD> Indicates who owns the fixture<\/SPAN><\/SPAN><\/P><\/TD><\/TR> RATE_CODE<\/SPAN><\/SPAN><\/P><\/TD> Rate Code<\/SPAN><\/SPAN><\/P><\/TD> Current utility billing rate code for the fixture<\/SPAN><\/SPAN><\/P><\/TD><\/TR> LED_STATUS<\/SPAN><\/SPAN><\/P><\/TD> LED Conversion Status<\/SPAN><\/SPAN><\/P><\/TD> Indicates whether fixture was converted to LED by Tanko Lighting<\/SPAN><\/SPAN><\/P><\/TD><\/TR> MANUFCTR<\/SPAN><\/SPAN><\/P><\/TD> Manufacturer<\/SPAN><\/SPAN><\/P><\/TD> Manufacturer of new LED fixture<\/SPAN><\/SPAN><\/P><\/TD><\/TR> DESFIXT<\/SPAN><\/SPAN><\/P><\/TD> LED Fixture - Part Number<\/SPAN><\/SPAN><\/P><\/TD> New LED fixture wattage, distribution type, and part number<\/SPAN><\/SPAN><\/P><\/TD><\/TR> UTIL_PN<\/SPAN><\/SPAN><\/P><\/TD> Utility Pole Number<\/SPAN><\/SPAN><\/P><\/TD> Pole number listed in corresponding utility record<\/SPAN><\/SPAN><\/P><\/TD><\/TR> UTIL_ADDR<\/SPAN><\/SPAN><\/P><\/TD> Utility Address<\/SPAN><\/SPAN><\/P><\/TD> Address listed in corresponding utility record<\/SPAN><\/SPAN><\/P><\/TD><\/TR> LOC_NAME<\/SPAN><\/SPAN><\/P><\/TD> Location Name<\/SPAN><\/SPAN><\/P><\/TD> If fixture is not in the right of way, name of location<\/SPAN><\/SPAN><\/P><\/TD><\/TR> LOC_TYPE<\/SPAN><\/SPAN><\/P><\/TD> Location Type<\/SPAN><\/SPAN><\/P><\/TD> If fixture is not in the right of way, type of location (e.g. school, park, parking lot)<\/SPAN><\/SPAN><\/P><\/TD><\/TR> RATE_SUB<\/SPAN><\/SPAN><\/P><\/TD> Rate Change Submission Date<\/SPAN><\/SPAN><\/P><\/TD> Date of rate change submission to utility<\/SPAN><\/SPAN><\/P><\/TD><\/TR> AUDIT_DATE<\/SPAN><\/SPAN><\/P><\/TD> Audit Date<\/SPAN><\/SPAN><\/P><\/TD> Date fixture was visited in Tanko Lighting's field audit<\/SPAN><\/SPAN><\/P><\/TD><\/TR> INSDATE<\/SPAN><\/SPAN><\/P><\/TD> Installation Date<\/SPAN><\/SPAN><\/P><\/TD> Date new LED fixture was installed<\/SPAN><\/SPAN><\/P><\/TD><\/TR> APPRX_ADDR<\/SPAN><\/SPAN><\/P><\/TD> Approximate Address<\/SPAN><\/SPAN><\/P><\/TD> Approximate street address generated with ESRI reverse geocoding tool<\/SPAN><\/SPAN><\/P><\/TD><\/TR> LATITUDE<\/SPAN><\/SPAN><\/P><\/TD> Latitude<\/SPAN><\/SPAN><\/P><\/TD> Latitude in WGS 84<\/SPAN><\/SPAN><\/P><\/TD><\/TR> LONGITUDE<\/SPAN><\/SPAN><\/P><\/TD> Longitude<\/SPAN><\/SPAN><\/P><\/TD> Longitude in WGS 84<\/SPAN><\/SPAN><\/P><\/TD><\/TR> LAT_LONG<\/SPAN><\/SPAN><\/P><\/TD> Latitude, Longitude<\/SPAN><\/SPAN><\/P><\/TD> Latitude, Longitude in WGS 84<\/SPAN><\/SPAN><\/P><\/TD><\/TR> TANKO_ID<\/SPAN><\/SPAN><\/P><\/TD> Tanko ID<\/SPAN><\/SPAN><\/P><\/TD> Unique identifier created by Tanko Lighting for each record<\/SPAN><\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE> <\/P><\/DIV><\/DIV>",
"summary": "This dataset represents all street lights in Redlands, CA that were audited by Tanko Lighting, as well as which of these were converted to LED. Attributes of...",
"title": "sde_Pub10.SDE.rLights",
"tags": [],
"type": "",
"typeKeywords": [],
"thumbnail": "",
"url": "",
"minScale": 150000000,
"maxScale": 5000,
"spatialReference": "",
"accessInformation": "Maeve Hanafin\nProject Manager\nmaeve@tankolighting.com\n\nPaolo Salvoni\nLead Analyst\npaolo@tankolighting.com",
"licenseInfo": ""
} |