energov
Integration and data conversion code for the Energov Community Development deployment.
Science Score: 18.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
✓CITATION.cff file
Found CITATION.cff file -
○codemeta.json file
-
○.zenodo.json file
-
○DOI references
-
○Academic publication links
-
○Academic email domains
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (3.8%) to scientific vocabulary
Repository
Integration and data conversion code for the Energov Community Development deployment.
Basic Info
- Host: GitHub
- Owner: City-of-Bloomington
- Language: PHP
- Default Branch: main
- Size: 168 KB
Statistics
- Stars: 0
- Watchers: 5
- Forks: 0
- Open Issues: 1
- Releases: 0
Metadata Files
README.md
Post Migration
After running the migration, we need to manually add some information that could not be migrated programmatically.
Unused Contacts
- rowbondcompanies_234 - City of Bloomington
Rental Payments for unpaid bills
We migrated all the unpaid bills, but a few of them might have some portion already paid. We'll need to manually enter the payments for the not-fully-paid bills. Last time I checked, there was only one bill, but that could change over time.
sql
select b.bid, b.id, count(*)
from rental.registr r
join rental.reg_bills b on b.bid=(select max(bid) from rental.reg_bills where id=r.id)
join rental.REG_PAID p on b.bid=p.bid
where b.status!='Paid'
and r.inactive is null
group by b.bid, b.id;
Rental Properties with multiple addresses
There are around 200 rental properties with multiple addresses. Most of these can be identified by having multiple buildings; since each building usually gets it's own address.
The multiple addresses will need to be added to manually to the permit.
sql
select r.id, count(*)
from rental.registr r
join rental.rental_structures s on r.id=s.rid
where r.inactive is null
group by r.id having count(*)>1;
Owner
- Name: City of Bloomington, Indiana
- Login: City-of-Bloomington
- Kind: organization
- Email: dev@bloomington.in.gov
- Location: Bloomington, IN
- Website: http://bloomington.in.gov
- Repositories: 132
- Profile: https://github.com/City-of-Bloomington
Information & Technology Services department
Citation (citation.sql)
-----------------------------------
-- contact
-----------------------------------
select a.cite_id, count(c.id) as x
from citation_agents a
left join citations c on a.cite_id=c.id
group by cite_id having x=0;
select o.cite_id, count(c.id) as x
from citation_owners o
left join citations c on o.cite_id=c.id
group by 1 having x=0;
select t.cite_id, count(c.id) as x
from tenants t
left join citations c on t.cite_id=c.id
group by 1 having x=0;
-----------------------------------
-- code_case
-----------------------------------
select c.id as case_number,
'citation' as case_type,
c.status as case_status,
-- as district,
c.date_writen as open_date,
-- as case_description,
c.compliance_date as closed_date,
u.fullname as assigned_to_user
-- as created_by_user,
-- as last_update_date,
-- as last_update_user,
-- as project_number,
-- as parent_permit_number,
-- as parent_plan_number
from citations c
left join users u on u.id=c.inspector_id;
-----------------------------------
-- code_case_violation
-----------------------------------
select c.id as violation_number,
c.id as case_number,
v.name as violation_code,
c.status as violation_status,
c.citation as violation_priority,
c.note as violation_note,
-- as corrective_action_memo,
c.date_writen as citation_date,
c.compliance_date as compliance_date,
c.date_complied as resolved_date
from citations c
join violation_types v on v.id=c.violation