Pushcart Vendors (PushcartVendPt)

Metadata also available as

Metadata:


Identification_Information:
Citation:
Citation_Information:
Originator: DC Department of Consumer and Regulatory Affairs (DCRA)
Publication_Date: 20070820
Title: Pushcart Vendors (PushcartVendPt)
Geospatial_Data_Presentation_Form: vector digital data
Publication_Information:
Online_Linkage:
Description:
Abstract:
Current Vendor Points (Pushcart Vendors)
The Current Vendor dataset identifies the site locations of all food and merchandise vendirs within the District of Columbia. The vendor types include Sidewalk, Roadway, Pushcart, and other vendors who have not yet been categorized (currently called "Pending").
This dataset is created and maintained by the Department of Consumer and Regulatory Affairs (DCRA). It was created as an extract of DCRA's Basic Business License (BBL) database in November 2006. At the time, it contained all vendors licensed to work within the District.
The data has not been verified against other source material.
All DC GIS data is stored and exported in Maryland State Plane coordinates NAD 83 meters.
METADATA CONTENT IS IN PROCESS OF VALIDATION AND SUBJECT TO CHANGE.
Purpose:
This dataset is used for the planning and management of Washington D.C. by local government agencies.
Time_Period_of_Content:
Time_Period_Information:
Single_Date/Time:
Calendar_Date: 20070820
Currentness_Reference: publication date
Status:
Progress: In work
Maintenance_and_Update_Frequency: As needed
Spatial_Domain:
Bounding_Coordinates:
West_Bounding_Coordinate: -77.194102
East_Bounding_Coordinate: -77.190276
North_Bounding_Coordinate: 38.924597
South_Bounding_Coordinate: 38.916746
Keywords:
Theme:
Theme_Keyword_Thesaurus: None.
Theme_Keyword: Vending
Theme_Keyword: Vendor
Theme_Keyword: Endorsement
Theme_Keyword: Sidewalk
Theme_Keyword: Roadway
Theme_Keyword: Pushcart
Place:
Place_Keyword_Thesaurus: None.
Place_Keyword: Washington DC
Place_Keyword: District of Columbia
Place_Keyword: DC
Place_Keyword: DC GIS
Place_Keyword: DCGIS
Use_Constraints:
For data terms and conditions, go to <http://dc.gov/page/terms-and-conditions-use-district-data>
Point_of_Contact:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization:
Department of Consumer and Regulatory Affairs, Office of Information Systems
Contact_Person: GIS Data Coordinator
Contact_Address:
Address_Type: mailing and physical address
Address: 941 N Capitol St, Suite 3600
City: Washington
State_or_Province: DC
Postal_Code: 20002
Country: USA
Contact_Voice_Telephone: 202-442-8340
Hours_of_Service: 8:30am - 5:30pm
Data_Set_Credit: DC Department of Consumer and Regulatory Affairs
Native_Data_Set_Environment:
Microsoft Windows XP Version 5.1 (Build 2600) Service Pack 2; ESRI ArcCatalog 9.1.0.780

Data_Quality_Information:
Attribute_Accuracy:
Attribute_Accuracy_Report:
Data believed to be complete and accurate, subject to change. Digital version compared with original source data for accuracy and completeness. Validated by source and/or responsible agency
Positional_Accuracy:
Horizontal_Positional_Accuracy:
Horizontal_Positional_Accuracy_Report: In process of validation by source and/or responsible agency.
Vertical_Positional_Accuracy:
Vertical_Positional_Accuracy_Report: N/A
Lineage:
Source_Information:
Source_Citation:
Citation_Information:
Originator: Department of Consumer and Regulatory Affairs (DCRA)
Publication_Date: November 2006
Title: Basic Business License (BBL) database
Source_Time_Period_of_Content:
Time_Period_Information:
Single_Date/Time:
Calendar_Date: 20070820
Source_Currentness_Reference: publication date
Process_Step:
Process_Description:
Raw Data Extract
Raw database extract from DCRA's Basic Business License (BBL) database.
Included Vendor identification number, name, and mailing address.
Rudimentary vending location data associated with Vendor Name. Coarse geo-location of vendor sites.
Process_Date: November 2006
Process_Contact:
Contact_Information:
Contact_Person_Primary:
Contact_Person: Sam Williams
Contact_Organization: Department of Consumer and Regulatory Affairs (DCRA)
Contact_Position: Vending Coordinator
Contact_Address:
Address_Type: mailing and physical address
Address: 200 I Street SE, 5th Floor
City: Washington
State_or_Province: DC
Postal_Code: 20002
Country: USA
Hours_of_Service: 8:30 am - 5:00 pm
Process_Step:
Process_Description:
Data Validation and Verification Process
Creation and Placement of Vendor location points based upon both Vendor input and on site verification.
At least five different validation processes were performed. Different procedural tools included on-site validation, GIS validation, MAR address attribution, Vendor Wares attribution, GIS mapping, Vendor input, and periodic database clean-up.
Dataset was contained in Personal Geodatabase called SiteLocations.mdb Update process was accomplished within the DCGIS Citrix environment to track versions and enable multiple user access.
By the end of the validation process, four types of vendor locations were identified: 1) Sidewalk Vendors - with locations within the District 2) Pushcart Vendors - with sites outside the District 3) Roadway Vendors - outside the District 4) Pending Vendors - outside the District
Sidewalk are to be used for the standard dataset. Pushcart Vendors will eventually be incorporated, Pending Vendors do not have enough information to process accurately (they also contain identified problems), and Roadway Vendors will be retired.
Process_Date: November 2006 - May 2007
Process_Contact:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: Department of Consumer and Rergulatory Affairs (DCRA)
Contact_Address:
Address_Type: mailing and physical address
Address: 200 I Street SE, 5th Floor
Address: 200 I Street SE, 5th Floor
City: Washington
State_or_Province: DC
Postal_Code: 20002
Country: USA
Contact_Voice_Telephone: 202-442-8340
Hours_of_Service: 8:30 am - 5:00 pm
Process_Step:
Process_Description:
Final Data Cleanup & Restructure
1) Rename dataset from SiteLocations.mdb to CurrentVendors.mdb. 2) Added new field [VendorType] to classify Vendor Type. Values include: "Sidewalk", "Pushcart", "Roadway", and "Pending". 2) Performed MAR Address Validation (Checked that identified MAR address closest and on same side of street). Identified discrepancies between Current Vendor sites and DDOT Permit addresses. 5) After the MAR Address field was updated, its value was checked against the [DdotPermitAddr] field. In those places where there was a difference between the fields, [MarAddress] and [DdotPermitAddr], the Vendor MAR Address was placed in the [txtDdotAddrDiff] field which will be used to help identify discrepancies between DDOT Permit addresses and Current Vendor locations. 6) Removed extraneous and useless fields, renamed others for clarity, reordered fields to group related field names (Vendor ID/Endorsement/Address), DDOT Permit-related, Vendor Personal, other miscellaneous).
Process_Date: May 2007 - June 2007
Process_Contact:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: Department of Consument and Regulatory Affairs
Contact_Address:
Address_Type: mailing and physical address
Address: 200 I Street SE, 5th Floor
Address: 200 I Street SE, 5th Floor
City: Washington
State_or_Province: DC
Postal_Code: 20002
Country: USA
Contact_Voice_Telephone: 202-442-8340
Hours_of_Service: 8:30 am - 5:00 pm
Process_Step:
Process_Description:
Metadata and Data Source Parsing
Metadata was added to the full Vendor dataset "Current Vendor Points (All)". This included fieldname descriptions and process steps.
The full data source was exported into individual data sources based upon the VendorType field values. The breakdown included:
1) SidewalkVendPt Sidewalk Vendors - 298 Validated and Verified sites 2) PushcartVendPt Pushcart Vendors - 9 Vendors 3) RoadwayVendPt Roadway Vendors - 219 Vendors 4) Pending_wErrors Unvalidated & unresolved - 93 Vendors
Load Metadata into parsed data sources. Modify as appropriate.
Process_Date: August 2007
Process_Contact:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: Department of Consumer and Regulatory Affairs
Contact_Address:
Address_Type: mailing and physical address
Address: 200 I Street SE, 5th Floor
Address: 200 I Street SE, 5th Floor
City: Washington
State_or_Province: DC
Postal_Code: 20002
Country: USA
Contact_Voice_Telephone: 202-442-8340
Hours_of_Service: 8:30 am - 5:00 pm

Spatial_Data_Organization_Information:
Direct_Spatial_Reference_Method: Vector
Point_and_Vector_Object_Information:
SDTS_Terms_Description:
SDTS_Point_and_Vector_Object_Type: Entity point
Point_and_Vector_Object_Count: 9

Spatial_Reference_Information:
Horizontal_Coordinate_System_Definition:
Planar:
Grid_Coordinate_System:
Grid_Coordinate_System_Name: State Plane Coordinate System 1983
State_Plane_Coordinate_System:
SPCS_Zone_Identifier: 1900
Lambert_Conformal_Conic:
Standard_Parallel: 38.300000
Standard_Parallel: 39.450000
Longitude_of_Central_Meridian: -77.000000
Latitude_of_Projection_Origin: 37.666667
False_Easting: 400000.000000
False_Northing: 0.000000
Planar_Coordinate_Information:
Planar_Coordinate_Encoding_Method: coordinate pair
Coordinate_Representation:
Abscissa_Resolution: 0.001000
Ordinate_Resolution: 0.001000
Planar_Distance_Units: meters
Geodetic_Model:
Horizontal_Datum_Name: North American Datum of 1983
Ellipsoid_Name: Geodetic Reference System 80
Semi-major_Axis: 6378137.000000
Denominator_of_Flattening_Ratio: 298.257222
Vertical_Coordinate_System_Definition:
Altitude_System_Definition:
Altitude_Resolution: 1.000000
Altitude_Encoding_Method:
Explicit elevation coordinate included with horizontal coordinates

Entity_and_Attribute_Information:
Detailed_Description:
Entity_Type:
Entity_Type_Label: DCGIS.PushcartVendPt
Entity_Type_Definition: Current Vendor Points (Pushcart Vendors)
Entity_Type_Definition_Source: DCRA
Attribute:
Attribute_Label: Comments
Attribute_Definition: Comments
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: VENDORID
Attribute:
Attribute_Label: VENDORNAME
Attribute:
Attribute_Label: VENDORTYPE
Attribute:
Attribute_Label: ENDORSEMENT
Attribute:
Attribute_Label: VENDORWARES
Attribute:
Attribute_Label: MARSTREET
Attribute:
Attribute_Label: MARZIP
Attribute:
Attribute_Label: CHKDDOTPERMIT
Attribute:
Attribute_Label: DATDDOTPERMIT
Attribute:
Attribute_Label: DDOTPERMITADDR
Attribute:
Attribute_Label: TXTDDOTLOCDIFF
Attribute:
Attribute_Label: MODIFICATIONDATE
Attribute:
Attribute_Label: CHKNEWVALIDATION
Attribute:
Attribute_Label: CHKPROBLEMFLAG
Attribute:
Attribute_Label: PROBLEMREASON
Attribute:
Attribute_Label: HOMEADDR
Attribute:
Attribute_Label: HOMESTREET
Attribute:
Attribute_Label: HOMECITY
Attribute:
Attribute_Label: HOMEPHONE
Attribute:
Attribute_Label: HOMECELL
Attribute:
Attribute_Label: HOMEEMAIL
Attribute:
Attribute_Label: VENDLOC1
Attribute:
Attribute_Label: VENDLOC2
Attribute:
Attribute_Label: BADGE
Attribute:
Attribute_Label: PICTURELIN
Attribute:
Attribute_Label: CHKVERIFIED
Attribute:
Attribute_Label: CHKPERMITTABLE
Attribute:
Attribute_Label: VendorID
Attribute_Definition: Vendor Identification Number
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: VendorName
Attribute_Definition: Vendor Name
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: OBJECTID
Attribute_Definition: Internal feature number.
Attribute_Definition_Source: ESRI
Attribute_Domain_Values:
Unrepresentable_Domain:
Sequential unique whole numbers that are automatically generated.
Attribute:
Attribute_Label: SHAPE
Attribute_Definition: Feature geometry.
Attribute_Definition_Source: ESRI
Attribute_Domain_Values:
Unrepresentable_Domain: Coordinates defining the features.
Attribute:
Attribute_Label: VendorType
Attribute_Definition: Vendor Type
Attribute_Definition_Source: DCRA
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: Sidewalk
Enumerated_Domain_Value_Definition: Sidewalk Vendor
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: Roadway
Enumerated_Domain_Value_Definition: Roadway Vendor
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: Pushcart
Enumerated_Domain_Value_Definition: Pushcart Vendor
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: Pending
Enumerated_Domain_Value_Definition: Unknown or Error Value
Enumerated_Domain_Value_Definition_Source: DCRA
Attribute:
Attribute_Label: Endorsement
Attribute_Definition: Vending Endorsement
Attribute_Definition_Source: DCRA
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: ACZ
Enumerated_Domain_Value_Definition: Food Vendor - Central Zone
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: ANH
Enumerated_Domain_Value_Definition: Food Vendor - Neighbohood Zone
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: ARW
Enumerated_Domain_Value_Definition: Food Vendor - Roadway
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: BCZ
Enumerated_Domain_Value_Definition: Merchandise Vendor - Central Zone
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: BNH
Enumerated_Domain_Value_Definition: Merchandise Vendor - Neighborhood Zone
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: BRW
Enumerated_Domain_Value_Definition: Merchandise Vendor - Roadway
Enumerated_Domain_Value_Definition_Source: DCRA
Attribute:
Attribute_Label: VendorWares
Attribute_Definition: Product Types Sold
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: MarStreet
Attribute_Definition: Site Street Address - Closest MAR point
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: MarZip
Attribute_Definition: Site Zipcode
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: chkDdotPermit
Attribute_Definition: DDOT Permit Flag
Attribute_Definition_Source: DCRA
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: 0
Enumerated_Domain_Value_Definition: No DDOT Permit
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: 1
Enumerated_Domain_Value_Definition: DDOT Permit
Enumerated_Domain_Value_Definition_Source: DCRA
Attribute:
Attribute_Label: datDdotPermit
Attribute_Definition: DDOT Permit Date
Attribute_Definition_Source: DCRA
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: 01/29/2007
Enumerated_Domain_Value_Definition: First DDOT Permitting Session
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: 02/15/2007
Enumerated_Domain_Value_Definition: Second DDOT Permitting Session
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: 03/27/2007
Enumerated_Domain_Value_Definition: Third DDOT Permitting Session - Day 1
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: 03/28/2007
Enumerated_Domain_Value_Definition: Third DDOT Permitting Session - Day 2
Enumerated_Domain_Value_Definition_Source: DCRA
Attribute:
Attribute_Label: DdotPermitAddr
Attribute_Definition: DDOT Permit Address
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: txtDdotLocDiff
Attribute_Definition: Variation between DDOT Address and Site MAR Address
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: ModificationDate
Attribute_Definition: Modification Date
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: chkNewValidation
Attribute_Definition: Validation Flag
Attribute_Definition_Source: DCRA
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: 0
Enumerated_Domain_Value_Definition: Unvalidated
Enumerated_Domain:
Enumerated_Domain_Value: 1
Enumerated_Domain_Value_Definition: Validated
Attribute:
Attribute_Label: chkProblemFlag
Attribute_Definition: Problem / Issue Flag
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: ProblemReason
Attribute_Definition: Problem Description
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: HomeAddr
Attribute_Definition: Vendor Home Address Number
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: HomeStreet
Attribute_Definition: Vendor Home Address Street
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: HomeCity
Attribute_Definition: Vendor Home Address City
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: HomePhone
Attribute_Definition: Vendor Home Phone Number
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: HomeCell
Attribute_Definition: Vendor Home Cell Phone Number
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: HomeEmail
Attribute_Definition: Vendor Email Address
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: VendLoc1
Attribute_Definition: Original Vending Street Location 1
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: VendLoc2
Attribute_Definition: Original Vending Street Location 2
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: COMMENTS
Attribute_Definition: Comments
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: Badge
Attribute_Definition: Badge Number
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: PictureLin
Attribute_Definition: Photograph File Location
Attribute_Definition_Source: DCRA
Attribute:
Attribute_Label: chkVerified
Attribute_Definition: Verification Flag
Attribute_Definition_Source: DCRA
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: 0
Enumerated_Domain_Value_Definition: Unverified
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: 1
Enumerated_Domain_Value_Definition: Verified
Enumerated_Domain_Value_Definition_Source: DCRA
Attribute:
Attribute_Label: chkPermittable
Attribute_Definition: Permittable Flag (DDOT)
Attribute_Definition_Source: DCRA
Attribute_Domain_Values:
Enumerated_Domain:
Enumerated_Domain_Value: 0
Enumerated_Domain_Value_Definition: Not Permittable
Enumerated_Domain_Value_Definition_Source: DCRA
Enumerated_Domain:
Enumerated_Domain_Value: 1
Enumerated_Domain_Value_Definition: Permittable
Enumerated_Domain_Value_Definition_Source: DCRA
Overview_Description:
Entity_and_Attribute_Overview:
The Endorsement field is a three letter shorthand code used to describe the type of product vended and where it is sold. It has the format TLL, where T corresponds to product type and LL corresponds to location. Look-up tables for the two codes are listed below:
Type Location A - Food CZ - Central Zone B - Merchandise NH - Neighborhood Zone D - Photographs RW - Roadway BB - Boot Black
Thus, an endorsement of ACZ would be for a Food vendor in the Central Zone. There may be more than one Endorsement for a single vendor to describe the various places and types of wares vended.

Distribution_Information:
Distributor:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: OCTO
Contact_Person: GIS Data Coordinator
Contact_Address:
Address_Type: mailing and physical address
Address: 200 I Street SE, 5th Floor
City: Washington
State_or_Province: DC
Postal_Code: 20001
Country: USA
Contact_Facsimile_Telephone: 202-727-5660
Contact_Electronic_Mail_Address: dcgis@dc.gov
Hours_of_Service: 8:30am - 5pm
Resource_Description: Downloadable Data
Distribution_Liability:
For data terms and conditions, go to <http://dc.gov/page/terms-and-conditions-use-district-data>
Standard_Order_Process:
Digital_Form:
Digital_Transfer_Information:
Transfer_Size: 512.507
Ordering_Instructions: All data is available at <http://opendata.dc.gov>

Metadata_Reference_Information:
Metadata_Date: 20071213
Metadata_Contact:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: OCTO
Contact_Person: GIS Data Coordinator
Contact_Address:
Address_Type: mailing and physical address
Address: 200 I Street SE, 5th Floor
City: Washington
State_or_Province: DC
Postal_Code: 20001
Country: USA
Contact_Voice_Telephone:
REQUIRED: The telephone number by which individuals can speak to the organization or individual.
Contact_Facsimile_Telephone: 202-727-5660
Contact_Electronic_Mail_Address: dcgis@dc.gov
Hours_of_Service: 8:30am - 5pm
Metadata_Standard_Name: FGDC Content Standards for Digital Geospatial Metadata
Metadata_Standard_Version: FGDC-STD-001-1998
Metadata_Time_Convention: local time
Metadata_Extensions:
Online_Linkage: <http://www.esri.com/metadata/esriprof80.html>
Profile_Name: ESRI Metadata Profile

Generated by mp version 2.9.12 on Thu Jun 25 15:29:24 2015