assessor

README

NOLA Tax Assessor Data

This is a DataSource containing tax data on ~160,000 properties in New Orleans. I heard the assessor's office was unwilling to share the data with the city's open data initiative so I'm releasing it here. I've scraped this data from the tax assessor's web site.

Here is an example page of a single property.

Tables

• assessor.properties
• assessor.property_sales
• assessor.property_values

Documentation

Index

• Constants
• type AsssessorId
• type IdScraper
  • func NewIdScraper() *IdScraper
  • func (s *IdScraper) Configure(pool *pgxpool.Pool) (err error)
  • func (s *IdScraper) EnqueueJobs() ([]infra.Job, error)
  • func (s *IdScraper) HandleResponse(j infra.Job, resp *http.Response, httpErr error) (*infra.Job, error)
  • func (s *IdScraper) MakeRequest(j infra.Job) (*http.Request, error)
• type JobMetadata
• type Property
  • func ParseProperty(doc *goquery.Document) *Property
• type PropertyPage
• type PropertySale
  • func ParseSales(doc *goquery.Document) []*PropertySale
• type PropertyScraper
  • func NewPropertyScraper() *PropertyScraper
  • func (s *PropertyScraper) Configure(pool *pgxpool.Pool) (err error)
  • func (s *PropertyScraper) EnqueueJobs() ([]infra.Job, error)
  • func (s *PropertyScraper) HandleResponse(_ infra.Job, resp *http.Response, err error) (*infra.Job, error)
  • func (s *PropertyScraper) MakeRequest(j infra.Job) (*http.Request, error)
• type PropertyValue
  • func ParseValues(doc *goquery.Document) []*PropertyValue
• type Repo
  • func NewRepo(conn *pgxpool.Pool) *Repo
  • func (c *Repo) AllAssesorIds(action func(string) error)
  • func (c *Repo) Close()
  • func (c *Repo) FindProperty(id string) (*Property, error)
  • func (c *Repo) FindUnseenAssessorIds(ids []string) ([]string, error)
  • func (c *Repo) StoreNewProperties(properties []*Property) error
  • func (c *Repo) StorePropertyPage(page *PropertyPage) error

Constants

const (
	IdScraperName = "ASSESSOR-IDS"
)

const (
	PropertyScraperName = "ASSESSOR-PROPERTIES"
)

Types

type AsssessorId

type AsssessorId struct {
	AsssessorId string
	InsertedAt  *time.Time
	ScrapedAt   *time.Time
}

type IdScraper

type IdScraper struct {
	// contains filtered or unexported fields
}

func NewIdScraper

func NewIdScraper() *IdScraper

func (*IdScraper) Configure

func (s *IdScraper) Configure(pool *pgxpool.Pool) (err error)

func (*IdScraper) EnqueueJobs

func (s *IdScraper) EnqueueJobs() ([]infra.Job, error)

func (*IdScraper) HandleResponse

func (s *IdScraper) HandleResponse(j infra.Job, resp *http.Response, httpErr error) (*infra.Job, error)

func (*IdScraper) MakeRequest

func (s *IdScraper) MakeRequest(j infra.Job) (*http.Request, error)

type JobMetadata

type JobMetadata struct {
	Term  string
	Begin int
}

type Property

type Property struct {
	Id               int
	AssessorId       string
	OwnerName        string
	LocationAddress  string
	MailingAddress   string
	PropertyClass    string
	TaxBillNumber    string
	ParcelNo         string
	AssessmentArea   string
	LandAreaSqFt     *int
	BuildingAreaSqFt *int
	LngLatPoint      postgis.PointS
	InsertedAt       time.Time
	UpdatedAt        time.Time
}

func ParseProperty

func ParseProperty(doc *goquery.Document) *Property

type PropertyPage

type PropertyPage struct {
	// contains filtered or unexported fields
}

type PropertySale

type PropertySale struct {
	Grantor               string
	Grantee               string
	NotarialArchiveNumber string
	InstrumentNumber      string
	Date                  string
	Price                 *int
	InsertedAt            time.Time
	UpdatedAt             time.Time
}

func ParseSales

func ParseSales(doc *goquery.Document) []*PropertySale

type PropertyScraper

type PropertyScraper struct {
	// contains filtered or unexported fields
}

func NewPropertyScraper

func NewPropertyScraper() *PropertyScraper

func (*PropertyScraper) Configure

func (s *PropertyScraper) Configure(pool *pgxpool.Pool) (err error)

func (*PropertyScraper) EnqueueJobs

func (s *PropertyScraper) EnqueueJobs() ([]infra.Job, error)

func (*PropertyScraper) HandleResponse

func (s *PropertyScraper) HandleResponse(_ infra.Job, resp *http.Response, err error) (*infra.Job, error)

func (*PropertyScraper) MakeRequest

func (s *PropertyScraper) MakeRequest(j infra.Job) (*http.Request, error)

type PropertyValue

type PropertyValue struct {
	Year                    *int
	LandValue               *int
	BuildingValue           *int
	TotalValue              *int
	AssessedLandValue       *int
	AssessedBuildingValue   *int
	TotalAssessedValue      *int
	HomesteadExemptionValue *int
	TaxableAssessment       *int
	AgeFreeze               *int
	DisabilityFreeze        *int
	AssessmentChange        *int
	TaxContract             *int
	InsertedAt              time.Time
	UpdatedAt               time.Time
}

func ParseValues

func ParseValues(doc *goquery.Document) []*PropertyValue

type Repo

type Repo struct {
	// contains filtered or unexported fields
}

func NewRepo

func NewRepo(conn *pgxpool.Pool) *Repo

func (*Repo) AllAssesorIds

func (c *Repo) AllAssesorIds(action func(string) error)

func (*Repo) Close

func (c *Repo) Close()

func (*Repo) FindProperty

func (c *Repo) FindProperty(id string) (*Property, error)

func (*Repo) FindUnseenAssessorIds

func (c *Repo) FindUnseenAssessorIds(ids []string) ([]string, error)

func (*Repo) StoreNewProperties

func (c *Repo) StoreNewProperties(properties []*Property) error

func (*Repo) StorePropertyPage

func (c *Repo) StorePropertyPage(page *PropertyPage) error