In [1]:
#TABLE Parser
#Infers a table with arbitrary number of columns from reoccuring patterns in text lines
#Main assumptions Table identificatin:
#1) each row is either in one line or not a row at all [DONE]
#2) each column features at least one number (=dollar amount) [MISSING]
#2a) each column features at least one date-like string
#3) a table exists if rows are in narrow consecutive order and share similarities --> scoring algo [DONE]
#4) each column is separated by more than 2 consecutive whitespace indicators (e.g. ' ' or '..')
#Feature List:
#1) Acknowledge Footnotes / make lower meta-data available
#2) make delimiter length smartly dependent on number of columns (iteration)
#3) expand non canonical values in tables [DONE] .. but only to the extent that type matches
#4) UI: parameterize extraction on the show page on the fly
#5) more type inference (e.g. date)
In [128]:
import re
import os
import codecs
import string
from collections import OrderedDict
config = { "min_delimiter_length" : 3, "min_columns": 2, "min_consecutive_rows" : 3, "max_grace_rows" : 2,
"caption_reorder_tolerance" : 10.0, "meta_info_lines_above" : 8, "aggregate_captions_missing" : 0.5}
In [129]:
import json
import sys
from flask import Flask, request, redirect, url_for, send_from_directory
from werkzeug import secure_filename
from flask import jsonify, render_template, make_response
import numpy as np
import pandas as pd
from pyxley import UILayout
from pyxley.filters import SelectButton
from pyxley.charts.mg import LineChart, Figure, ScatterPlot, Histogram
from pyxley.charts.datatables import DataTable
In [3]:
#Regex tester online: https://regex101.com
#Contrast with Basic table parsing capabilities of http://docs.astropy.org/en/latest/io/ascii/index.html
tokenize_pattern = "[.]{%i,}|[\ \$]{%i,}|" % ((config['min_delimiter_length'],)*2)
tokenize_pattern = "[.\ \$]{%i,}" % (config['min_delimiter_length'],)
column_pattern = OrderedDict()
#column_pattern['large_num'] = ur"\d{1,3}(,\d{3})*(\.\d+)?"
column_pattern['large_num'] = ur"(([0-9]{1,3})(,\d{3})+(\.[0-9]{2})?)"
column_pattern['small_float'] = ur"[0-9]+\.[0-9]+"
column_pattern['integer'] = ur"^\s*[0-9]+\s*$"
column_pattern['other'] = ur"([a-zA-Z0-9]{2,}\w)"
column_pattern['other'] = ur".+"
subtype_indicator = OrderedDict()
subtype_indicator['dollar'] = r".*\$.*"
subtype_indicator['rate'] = r"[%]"
subtype_indicator['year'] = "(20[0-9]{2})|(19[0-9]{2})"
In [4]:
#import dateutil.parser as date_parser
#(type, subtype, value, leftover)
def tag_token(token, ws):
for t, p in column_pattern.iteritems():
result = re.search(p, token)
if result:
leftover = token[:result.start()] + token[result.end():]
value = token[result.start():result.end()]
#First match on left-overs
subtype = "none"
for sub, indicator in subtype_indicator.iteritems():
if re.match(indicator, leftover): subtype = sub
#Only if no indicator matched there, try on full token
if subtype == "none":
for sub, indicator in subtype_indicator.iteritems():
if re.match(indicator, token): subtype = sub
#Only if no indicator matched again, try on whitespace
if subtype == "none":
for sub, indicator in subtype_indicator.iteritems():
if re.match(indicator, ws): subtype = sub
#print token, ":", ws, ":", subtype
return t, subtype, value, leftover
return "unknown", "none", token, ""
def row_feature(line):
features = []
matches = re.finditer(tokenize_pattern, line)
start_end = [ (match.start(), match.end()) for match in matches]
if len(start_end) < 1:
return features
tokens = re.split(tokenize_pattern, line)
if tokens[0] == "":
tokens = tokens[1:]
else:
start_end = [(0,0)] + start_end
for se, token in zip(start_end, tokens):
t, subtype, value, _ = tag_token(token, line[se[0]:se[1]])
feature = {"start" : se[1], "value" : value, "type" : t, "subtype" : subtype}
features.append(feature)
return features
#date_parser.parse("asdf")
In [5]:
#Establish whether amount of rows is above a certain threshold and whether there is at least one number
def row_qualifies(row):
return len(row) >= config['min_columns'] and sum( 1 if c['type'] in ['large_num', 'small_float', 'integer'] else 0 for c in row) > 0
def row_equal_types(row1, row2):
max_len = max(len(row1), len(row2) )
same_types = sum (map(lambda t: 1 if t[0]==t[1] else 0, ((c1['type'], c2['type']) for c1, c2 in zip(row1, row2))))
return same_types == max_len
In [6]:
def filter_row_spans(row_features, row_qualifies):
min_consecutive = config["min_consecutive_rows"]
grace_rows = config['max_grace_rows']
last_qualified = None
consecutive = 0
underqualified = 0
i = 0
for row in row_features:
if row_qualifies(row):
underqualified = 0
if last_qualified is None:
last_qualified = i
consecutive = 1
else:
consecutive += 1
else:
underqualified += 1
if underqualified > grace_rows:
if consecutive >= min_consecutive:
yield last_qualified, i-underqualified+1
last_qualified = None
consecutive = 0
else:
last_qualified = None
consecutive = 0
underqualified = 0
#print i, underqualified, last_qualified, consecutive#, "" or row
i += 1
if consecutive >= min_consecutive:
yield last_qualified, i-underqualified
In [126]:
from collections import Counter
def readjust_cols(feature_row, slots):
feature_new = [{'value' : 'NaN'}] * len(slots)
for v in feature_row:
dist = [ abs((float(v['start'])) - s) for s in slots ]
val , idx = min((val, idx) for (idx, val) in enumerate(dist))
if val <= config['caption_reorder_tolerance']: feature_new[idx] = v
return feature_new
def normalize_rows(rows_in, structure):
slots = [c['start'] for c in structure]
nrcols = len(structure)
for r in rows_in:
if len(r) != nrcols:
if len(r)/float(nrcols) > config['aggregate_captions_missing']:
yield readjust_cols(r, slots)
else:
yield r
#TODO: make side-effect free
def structure_rows(row_features, meta_features):
#Determine maximum nr. of columns
lengths = [len(r) for r in row_features]
nrcols = max(lengths)
canonical = filter(lambda r: len(r) == nrcols , row_features)
#print canonical
structure = []
values = []
for i in range(nrcols):
col = {}
col['start'] = float (sum (c[i]['start'] for c in canonical )) / len(canonical)
types = Counter(c[i]['type'] for c in canonical)
col['type'] = types.most_common(1)[0][0]
subtypes = Counter(c[i]['subtype'] for c in canonical if c[i]['subtype'] is not "none")
subtype = "none" if len(subtypes) == 0 else subtypes.most_common(1)[0][0]
col['subtype'] = subtype
structure.append(col)
#Add the first non canonical rows to the meta_features above data
for r in row_features:
if r in canonical:
break
else:
meta_features.append(r)
row_features.remove(r)
#Try to find caption from first rows above the data, skip one empty row if necessary
#Todo: make two steps process cleaner and more general
if len(meta_features[-1]) == 0: meta_features = meta_features[:-1]
caption = meta_features[-1] if len(meta_features[-1])/float(nrcols) > config['aggregate_captions_missing'] else None
if caption:
slots = [c['start'] for c in structure]
meta_features = meta_features[:-1]
if len(caption) != nrcols: caption = readjust_cols(caption, slots)
if len(meta_features[-1])/float(nrcols) > config['aggregate_captions_missing']:
caption2 = readjust_cols(meta_features[-1], slots)
for c,c2 in zip(caption, caption2):
if c2['value'] != 'NaN':
c['value'] = c2['value'] + ' ' + c['value']
meta_features = meta_features[:-1]
#Assign captions as the value in structure
for i, c in enumerate(caption):
structure[i]['value'] = c['value']
headers = []
for h in meta_features:
if len(h) == 1:
headers.append(h[0]['value'])
#Expand all the non canonical rows with NaN values (Todo: if type matches)
normalized_data = [r for r in normalize_rows(row_features, structure)]
return structure, normalized_data, headers
In [115]:
def output_table_html(txt_path):
out = []
out.append("--------" + txt_path + "--------")
with codecs.open(txt_path, "r", "utf-8") as f:
lines = [l.encode('ascii', 'ignore').replace('\n', '') for l in f]
rows = [row_feature(l) for l in lines]
for b,e in filter_row_spans(rows, row_qualifies):
out.append("TABLE STARTING FROM LINE %i to %i" % (b,e))
table = rows[b:e]
structure, data, headers = structure_rows(table, rows[b-config['meta_info_lines_above']:b])
for h in headers: out.append(h)
if caption:
out.append("\t".join(caption))
else:
out.append('NO COLUMN NAMES DETECTED')
for f in rows[b:e]:
cols = "\t|\t".join([col['value']+" (%s, %s)" % (col['type'], col['subtype']) for col in f])
out.append("%i %s" % (len(f), cols) )
return out
def return_tables(txt_path):
#Uniquely identify tables by their first row
tables = OrderedDict()
with codecs.open(txt_path, "r", "utf-8") as f:
lines = [l.encode('ascii', 'ignore').replace('\n', '') for l in f]
rows = [row_feature(l) for l in lines]
for b,e in filter_row_spans(rows, row_qualifies):
table = {'begin_line' : b, 'end_line' : e}
data_rows = rows[b:e]
meta_rows = rows[b-config['meta_info_lines_above']:b]
structure, data, headers = structure_rows(data_rows, meta_rows)
#Construct df
captions = [(col['value'] if 'value' in col.keys() else "---") +" (%s, %s)" % (col['type'], col['subtype']) for col in structure]
table['captions'] = captions
table['data'] = data
table['header'] = " | ".join(headers)
tables[b] = table
return tables
In [124]:
TITLE = "docX - Table View"
scripts = [
"./bower_components/jquery/dist/jquery.min.js",
"./bower_components/datatables/media/js/jquery.dataTables.js",
"./bower_components/d3/d3.min.js",
"./bower_components/metrics-graphics/dist/metricsgraphics.js",
"./require.min.js",
"./bower_components/react/react.js",
"./bower_components/react-bootstrap/react-bootstrap.min.js",
"./bower_components/pyxley/build/pyxley.js",
]
css = [
"./bower_components/bootstrap/dist/css/bootstrap.min.css",
"./bower_components/metrics-graphics/dist/metricsgraphics.css",
"./bower_components/datatables/media/css/jquery.dataTables.min.css",
"./css/main.css"
]
UPLOAD_FOLDER = './'
ALLOWED_EXTENSIONS = set(['txt', 'pdf'])
app = Flask(__name__)
app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER
def get_extension(filename):
return '.' in filename and \
filename.rsplit('.', 1)[1]
def allowed_file(filename):
return get_extension(filename) in ALLOWED_EXTENSIONS
@app.route('/', methods=['GET', 'POST'])
def upload_file():
if request.method == 'POST':
file = request.files['file']
min_columns = request.form['min_columns']
if file and allowed_file(file.filename):
filename = secure_filename(file.filename)
extension = get_extension(file.filename)
file.save(os.path.join(app.config['UPLOAD_FOLDER'], extension, filename))
return redirect(url_for('uploaded_file',
filename=filename, min_columns=min_columns))
return '''
<!doctype html>
<title>docX - Table Extractor</title>
<h1>Upload a pdf or txt file</h1>
<form action="" method=post enctype=multipart/form-data>
<p><input type=file name=file>
<input type=submit value=Upload>
<p>
<h3>Select the minimum amount of <b>columns</b> tables should have</h3>
<select name="min_columns">
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
</select>
</form>
'''
all_charts = {}
all_uis = {}
@app.route('/show/<filename>')
def uploaded_file(filename):
extension = get_extension(filename)
path = os.path.join(app.config['UPLOAD_FOLDER'], extension, filename)
txt_path = os.path.join(app.config['UPLOAD_FOLDER'], 'txt', filename)
if extension == "pdf":
txt_path += '.txt'
if not os.path.isfile(txt_path):
#Layout preservation crucial to preserve clues about tabular data
cmd = "pdftotext -layout %s %s" % (path, txt_path)
os.system(cmd)
min_columns = request.args.get('min_columns')
tables = return_tables(txt_path)
#Construct histogram
lines_per_page = 80
nr_data_rows = []
for b, t in tables.iteritems():
e = t['end_line']
#print b, e
for l in range(b, e):
page = l / lines_per_page
if len(nr_data_rows) <= page:
nr_data_rows += ([0]*(page-len(nr_data_rows)+1))
nr_data_rows[page] += 1
dr = pd.DataFrame()
dr['value'] = nr_data_rows
dr['page'] = range(0, len(dr))
js_layout = filename+".js"
ui_show = UILayout(
"FilterChart",
"../static/bower_components/pyxley/build/pyxley.js",
"component_id",
filter_style="''")
if filename in all_charts:
print "old/update ui", filename
path_to_fig = '/show/line/'+filename
#del all_charts[filename]
#hFig = Figure(path_to_fig, "line")
#bc = LineChart(dr, hFig, "page", ["page"], "Rows containing Data per Page")
elif True:
print "new ui", filename
# Make a Button
cols = ["page"]
btn = SelectButton("Data", cols, "Data", "Data Rows per Page")
# Make a FilterFrame and add the button to the UI
ui_show.add_filter(btn)
# Now make a FilterFrame for the histogram
path_to_fig = '/show/line/'+filename
hFig = Figure(path_to_fig, "line")
hFig.layout.set_size(width=1000, height=300)
hFig.layout.set_margin(left=80, right=80)
#hFig.graphics.animate_on_load()
bc = LineChart(dr, hFig, "page", ["value"], "Rows containing Data per Page")
ui_show.add_chart(bc)
all_charts[filename] = bc
sb = ui_show.render_layout(app, "./static/ug/"+js_layout)
_scripts = ["ug/"+js_layout]
notices = ['Extraction Results for ' + filename, 'Ordered by lines']
dfs = (table_to_df(table).to_html() for table in tables.values())
headers = []
for t in tables.values():
if 'header' in t:
headers.append(t['header'])
else:
headers.append('-')
line_nrs = [('line %i-%i' % (t['begin_line'], t['end_line'])) for t in tables.values() ]
#headers = ['aslkdfjas', ' alsdkfjasoedf']
return render_template('index.html',
title=TITLE + ' - ' + filename,
base_scripts=scripts,
page_scripts=_scripts,
css=css, notices = notices, tables = dfs, headers=headers, line_nrs=line_nrs)
In [ ]:
app.run(debug=True, host='0.0.0.0')
In [123]:
def table_to_df(table):
df = pd.DataFrame()
for i, c in enumerate(table['captions']):
values = []
for r in table['data']:
values.append(r[i]['value'])
df[c] = values
return df
for file in os.listdir('txt'):
print ("--------" + file + "--------")
tables = return_tables('txt/'+file)
#print tables
#Construct histogram
lines_per_page = 80
nr_data_rows = []
for b, t in tables.iteritems():
e = t['end_line']
#print b, e
for l in range(b, e):
page = l / lines_per_page
if len(nr_data_rows) <= page:
nr_data_rows += ([0]*(page-len(nr_data_rows)+1))
nr_data_rows[page] += 1
dr = pd.DataFrame()
dr['value'] = nr_data_rows
dr['page'] = range(0, len(dr))
#print dr.head()
line_nrs = [('line %i-%i' % (t['begin_line'], t['end_line'])) for t in tables.values() ]
print line_nrs
for k, table in tables.iteritems():
df = table_to_df(table)
print k, ' !!! ', table['header'], ' -----------------'
print df.head()
#print dr
--------transcript_confirmation.pdf.txt--------
[]
--------ER862677-ER674128-ER1075876.pdf.txt--------
['line 80-100', 'line 218-262', 'line 270-306', 'line 576-596', 'line 659-671', 'line 730-736', 'line 749-754', 'line 1404-1421', 'line 1455-1461', 'line 1464-1469', 'line 1645-1657', 'line 1770-1779', 'line 1811-1818', 'line 1875-1881', 'line 1953-1974', 'line 1978-1993', 'line 2073-2080', 'line 2574-2582', 'line 3730-3734', 'line 3745-3749', 'line 3766-3770', 'line 3792-3795', 'line 3878-3888', 'line 3903-3919', 'line 3941-3948', 'line 3961-3972', 'line 3992-4003', 'line 4147-4165', 'line 4221-4232', 'line 4257-4278', 'line 4364-4371', 'line 4562-4577', 'line 4738-4763', 'line 5014-5024', 'line 5106-5115', 'line 5181-5219', 'line 5230-5261', 'line 5276-5303', 'line 5318-5349', 'line 5361-5387', 'line 5683-5688', 'line 5692-5696', 'line 5773-5781', 'line 5822-5841', 'line 5904-5930', 'line 5952-5976', 'line 5999-6021', 'line 6063-6074', 'line 6079-6090', 'line 6165-6176', 'line 6215-6222', 'line 6324-6327', 'line 6464-6471', 'line 6594-6608', 'line 6637-6646', 'line 9115-9148']
80 !!! (City of Anaheim Water System Project) | MATURITY SCHEDULE | 58,205,000 -----------------
Maturity Date (October 1) (integer, year) \
0 2015
1 2016
2 2017
3 2018
4 2019
Principal Amount (large_num, dollar) Interest Rate (small_float, rate) \
0 775,000 2.000
1 1,575,000 2.000
2 1,620,000 3.000
3 1,675,000 4.000
4 2,045,000 5.000
Yield (small_float, rate) CUSIP (other, none)
0 0.100 13048TTV5
1 0.300 13048TTW3
2 0.660 13048TTX1
3 0.930 13048TTY9
4 1.150 13048TTZ6
218 !!! TABLE OF CONTENTS | Page -----------------
--- (other, none) --- (integer, none)
0 INTRODUCTION 1
1 Purpose 1
2 Security and Sources of Payment for the Bonds 1
3 The City and the Water System 2
4 Continuing Disclosure 3
270 !!! i | TABLE OF CONTENTS | (continued) | Page -----------------
--- (other, none) --- (integer, none)
0 Labor Relations 33
1 Retirement Programs 34
2 ADEQUACY OF WATER SUPPLIES 35
3 Orange County Water District Groundwater Basin 35
4 Metropolitan Water District of Southern Califo... 37
576 !!! The 2008 Bonds to be refunded are more fully identified in the table below. | Refunded 2008 Bonds -----------------
Maturity Date (October 1) (integer, year) \
0 2019
1 2020
2 2021
3 2022
4 2023
Principal Amount (large_num, dollar) Interest Rate (small_float, rate) \
0 425,000 4.000
1 445,000 4.250
2 1,075,000 4.375
3 1,735,000 4.375
4 1,825,000 4.500
CUSIP (Base: 03255M) (other, none)
0 MK0
1 ML8
2 MM6
3 MN4
4 MP9
659 !!! 6 | ESTIMATED SOURCES AND USES OF FUNDS | The estimated sources and uses of funds in connection with the issuance of the Bonds are as | SOURCES: -----------------
--- (other, none) --- (large_num, dollar)
0 Principal Amount 95,885,000
1 Bond Premium 12,984,339
2 Other Available Funds(1) 6,600,643
3 Total Sources 115,469,982
4 Deposit to Acquisition Fund 41,000,000
730 !!! Bonds maturing October 1, 2040 -----------------
Redemption Date (October 1) (integer, year) \
0 2035
1 2036
2 2037
3 2038
4 2039
Redemption Amount (large_num, dollar)
0 4,740,000
1 4,925,000
2 5,125,000
3 5,330,000
4 2,160,000
749 !!! Bonds maturing October 1, 2045 -----------------
Redemption Date (October 1) (integer, year) \
0 2041
1 2042
2 2043
3 2044
4 2045
Redemption Amount (large_num, dollar)
0 2,360,000
1 2,490,000
2 2,620,000
3 2,765,000
4 2,910,000
1404 !!! The following table sets forth statistical information relating to the Water System during the five | TABLE 1 | WATER SYSTEM STATISTICS | Fiscal Year Ended June 30 -----------------
NaN (other, none) 2014 (large_num, none) \
0 NaN 2014
1 Anaheim Population Served 348,305
2 Population Served Outside City (Est.) 8,457
3 Total Population Served 356,762
4 Total Water Sales (Million Gallons) 20,740
2013 (large_num, none) 2012 (large_num, none) 2011 (large_num, none) \
0 2013 2012 2011
1 346,161 343,793 341,034
2 9,000 9,000 9,000
3 355,161 352,793 350,034
4 20,465 19,672 19,526
2010 (large_num, none)
0 2010
1 336,265
2 9,000
3 345,265
4 20,488
1455 !!! The following table indicates the total water pumped from Water System wells and purchases of | TABLE 2 | WATER PRODUCTION | (Millions of Gallons) | Fiscal Year Ended June 30 -----------------
NaN (other, none) 2014 (large_num, none) \
0 NaN 2014
1 Pumping from Groundwater Wells 15,422
2 In-lieu Program Water(1) --
3 CPTP Water(2) 1,327
4 Total Pumping from System Wells 16,749
2013 (large_num, none) 2011 (large_num, none) NaN (large_num, none) \
0 2013 2011 NaN
1 14,657 11,216 13,291
2 -- 2,735 575
3 -- -- --
4 14,657 13,951 13,866
2010 (large_num, none)
0 2010
1 13,552
2 --
3 --
4 13,552
1464 !!! -----------------
--- (other, none) --- (large_num, none)
0 Purchases, not including in-lieu water 7,086
1 CUP Program Water(3) 963
2 Total Purchases from MWD 8,049
3 Percentage of Total Supply 37%
4 Total Water Production(4) 21,601
1645 !!! 64.5 | 3.1 | table sets forth the volume of Water System sales by customer class and the corresponding revenues for | the five Fiscal Years shown: | TABLE 3 | WATER SALES | Fiscal Year Ended June 30 -----------------
NaN (other, none) 2014 (large_num, dollar) \
0 NaN 2014
1 Residential 12,189
2 Commercial and Industrial 8,294
3 Other 257
4 Total 20,740
2013 (large_num, dollar) 2012 (large_num, dollar) 2011 (large_num, dollar) \
0 2013 2012 2011
1 12,166 11,839 11,566
2 8,087 7,607 7,761
3 212 226 199
4 20,465 19,672 19,526
2010 (large_num, dollar)
0 2010
1 12,196
2 8,072
3 220
4 20,488
1770 !!! 26 | TABLE 5 | WATER RATE COMPARISON BY MONTHLY BILL | (as of February 1, 2015) | Average Residential Water Bill -----------------
Agency (other, none) (based on 20 hcf/month) (small_float, dollar)
0 Laguna Beach 88.16
1 Newport Beach 75.83
2 Tustin 70.71
3 Garden Grove 60.79
4 Santa Ana 58.04
1811 !!! 27 | TABLE 6 | OPERATING EXPENSES | (EXCLUDING DEPRECIATION AND AMORTIZATION) | (In Thousands) | Fiscal Year Ended June 30 -----------------
NaN (other, none) 2014 (large_num, dollar) 2013 (large_num, dollar) \
0 NaN 2014 2013
1 Purchased water 28,769 27,729
2 Treatment and pumping 8,433 6,896
3 administration 11,942 9,357
4 Right of way fee 902 855
2012 (large_num, dollar) 2011 (large_num, dollar) 2010 (large_num, dollar)
0 2012 2011 2010
1 28,088 27,042 27,227
2 5,739 6,166 6,448
3 10,788 11,204 11,556
4 823 836 750
1875 !!! The outstanding Qualified Obligations as of December 31, 2014 are summarized in the table | OUTSTANDING QUALIFIED OBLIGATIONS | Date of Installment -----------------
Issue (other, none) \
0 Anaheim Public Financing Authority
1 Anaheim Public Financing Authority Revenue
2 Anaheim Public Financing Authority Revenue
Purchase Agreement or Other Instrument (other, none) \
0 05/01/04
1 07/01/08
2 10/01/10
Principal Amount Outstanding (large_num, dollar)
0 590,000
1 48,040,000
2 34,280,000
1953 !!! 30 | TABLE 7 | CITY OF ANAHEIM WATER UTILITY FUND | FINANCIAL RESULTS OF THE WATER SYSTEM | ($ in Thousands) | Fiscal Year Ended June 30, -----------------
--- (other, none) --- (large_num, dollar)
0 NaN 2010
1 Residential 32,677
2 Commercial/Industrial 19,973
3 Other 1,808
4 Billed revenue from the sale of water 54,458
1978 !!! -----------------
Senior Bond debt service requirements (b) Deposits to Renewal and Replacement Account (other, none) \
0 SURPLUS REVENUES (c)
1 Qualified Obligations (d)(1)
2 PARITY DEBT SERVICE PAYMENTS
3 Transfers to Anaheim General Fund(2)
4 Transfers (to)/from other City funds
-- (358) (large_num, dollar) -- (41) (large_num, dollar) \
0 16,575 16,971
1 6,322 6,391
2 10,253 10,580
3 2,619 2,408
4 (297) (49)
-- (16) (large_num, dollar) -- (45) (large_num, dollar) \
0 13,876 11,642
1 6,392 5,340
2 7,484 6,302
3 2,374 2,063
4 (67) (795)
-- (152) (large_num, dollar)
0 11,654
1 5,219
2 6,435
3 2,380
4 784
2073 !!! TABLE 9 | Water System Capital Program | Fiscal Years 2014-15 through 2018-19 | Five-Year -----------------
Program/Project Category (other, none) \
0 Water Mains
1 Water Storage
2 Other Capital(1)
3 Treatment Facility Expansion
4 Wells
Project Costs (in $000s) (large_num, dollar) \
0 46,538
1 14,357
2 13,489
3 12,465
4 10,113
Cost as % of Total (small_float, rate)
0 44.1
1 13.6
2 12.8
3 11.8
4 9.6
2574 !!! The following table summarizes water rates under MWDs current rate structure. This table | MWD WATER RATES(1) | (Dollars per Acre-Foot) -----------------
NaN (other, none) Tier 1 (integer, dollar) Tier 2 (integer, dollar)
0 Supply Rate 156 290
1 System Access Rate 259 259
2 Water Stewardship Rate 41 41
3 System Power Rate 138 138
4 Untreated Full Service 594 728
3730 !!! The table below shows the funding progress of the three plans and is based on a June 30, 2011 -----------------
Plan (other, none) Assets (AVA) (large_num, dollar) \
0 Miscellaneous 823,258
1 Police Safety 453,318
2 Fire Safety 274,471
3 Total 1,551,047
Accrued Liability (large_num, dollar) (UL) (B)-(A) (large_num, dollar) \
0 1,004,444 181,186
1 548,400 95,082
2 335,781 61,310
3 1,888,625 337,578
AVA (A)/(B) (small_float, rate) Market Value (small_float, rate) \
0 82.0 72.6
1 82.7 73.7
2 81.7 72.6
3 82.1 72.9
Covered Payroll (large_num, dollar) of Payroll (C)/(E) (small_float, rate)
0 110,234 164.4
1 44,567 213.3
2 23,681 258.9
3 178,482 189.1
3745 !!! The table below shows the funding progress of the three plans and is based on a June 30, 2012 -----------------
Plan (other, none) Assets (AVA) (large_num, dollar) \
0 Miscellaneous 854,296
1 Police Safety 473,233
2 Fire Safety 283,211
3 Total 1,610,740
Accrued Liability (large_num, dollar) (UL) (B)-(A) (large_num, dollar) \
0 1,045,037 190,741
1 565,214 91,981
2 345,725 62,514
3 1,955,976 345,236
AVA (A)/(B) (small_float, rate) Market Value (small_float, rate) \
0 81.7 68.2
1 83.7 69.9
2 81.9 68.3
3 82.5 68.7
Covered Payroll (large_num, dollar) of Payroll (C)/(E) (small_float, rate)
0 105,544 180.7
1 43,205 212.9
2 22,967 272.2
3 171,716 201.1
3766 !!! A-6 -----------------
Plan (other, none) Assets (AVA) (large_num, dollar) \
0 Miscellaneous 786,278
1 Police Safety 435,595
2 Fire Safety 257,573
3 Total 1,479,446
Accrued Liability (large_num, dollar) (UL) (B)-(A) (large_num, dollar) \
0 1,101,160 314,882
1 586,151 150,556
2 352,186 94,613
3 2,039,497 560,051
AVA (A)/(B) (small_float, rate) Market Value (small_float, rate) \
0 71.4 71.4
1 74.3 74.3
2 73.1 73.1
3 72.5 72.5
Covered Payroll (large_num, dollar) of Payroll (C)/(E) (small_float, rate)
0 107,587 292.7
1 41,946 358.9
2 21,464 440.8
3 170,997 327.5
3792 !!! The Citys annual pension cost, the percentage of annual pension cost contributed to the plans, -----------------
Fiscal Year Ending (other, none) \
0 June 30, 2012
1 June 30, 2013
2 June 30, 2014
Annual Pension Cost (APC) (large_num, dollar) \
0 57,560
1 58,213
2 59,747
Percentage of APC Contributed (other, none) \
0 100%
1 100%
2 100%
Net Pension Obligation (integer, dollar)
0 0
1 0
2 0
3878 !!! A-8 | CITY OF ANAHEIM AND ORANGE COUNTY | Population | Calendar Year | Orange -----------------
Year(1) (integer, year) City Population (large_num, none) \
0 2005 331,458
1 2006 329,373
2 2007 329,780
3 2008 330,659
4 2009 332,120
County Population (large_num, none)
0 2,956,847
1 2,956,334
2 2,960,659
3 2,974,321
4 2,990,805
3903 !!! Total valuation of all building permits issued by the City Building Division was approximately | CITY OF ANAHEIM | Building Activities | Calendar Year -----------------
NaN (other, none) 2010 (large_num, dollar) \
0 NaN 2010
1 Total Valuation (thousands) 349,907
2 Total Permits Issued 2,731
3 Residential (thousands) 20,833
4 Permits 36
2011 (large_num, dollar) 2012 (large_num, dollar) 2013 (large_num, dollar) \
0 2011 2012 2013
1 225,693 179,941 338,956
2 2,798 2,560 2,885
3 19,107 37,906 54,033
4 35 102 55
2014 (large_num, dollar)
0 2014
1 609,443
2 3,609
3 213,731
4 80
3941 !!! ORANGE COUNTY | Employment, Unemployment and Labor Force(1) | Calendar Year Averages: 2009-2013 | (000s except for Unemployment Rates) -----------------
NaN (other, none) 2009 (small_float, rate) 2010 (small_float, rate) \
0 NaN 2009 2010
1 Employment 1,448 1,441
2 Unemployment 140.7 151.0
3 Civilian Labor Force 1,589 1,592
4 Unemployment Rate 8.9 9.5
2011 (small_float, rate) 2012 (small_float, rate) 2013 (small_float, rate)
0 2011 2012 2013
1 1,460 1,491 1,510
2 140.0 122.0 100.4
3 1,600 1,613 1,610
4 8.8 7.6 6.2
3961 !!! The table below lists the major manufacturing and non-manufacturing employers within the City. | CITY OF ANAHEIM | Top Ten Private Employers | Approximate | Number of -----------------
Company (other, none) Employees (integer, none) \
0 Disneyland Resort 25,000
1 Medical Center 6,040
2 Anaheim Regional Medical Center 1,300
3 Angels Baseball LP 1,140
4 Hilton Anaheim 980
Products/Purpose (other, none)
0 Theme Park
1 Medical Facilities
2 Medical Facilities
3 Sports and Entertainment Venue
4 Hotel
3992 !!! CITY OF ANAHEIM | Median Household Income | Calendar Years 2010 through 2013 | Median | 2010(1) -----------------
--- (other, none) --- (large_num, dollar)
0 City of Anaheim 54,157
1 California 57,708
2 City of Anaheim 56,858
3 California 57,287
4 City of Anaheim 55,464
4147 !!! A-13 | CITY OF ANAHEIM | TAXABLE TRANSACTION BY TYPE OF BUSINESS | Calendar Years 2009-2013(1) | ($000) -----------------
NaN (other, none) 2009 (large_num, dollar) \
0 NaN 2009
1 Motor Vehicle and Parts Dealers 369,366
2 Home Furnishings and Appliance 180,955
3 Bldg. Materials/Garden Equip & 309,593
4 Food and Beverage Stores 154,236
2010 (large_num, dollar) 2011 (large_num, dollar) 2012 (large_num, dollar) \
0 2010 2011 2012
1 435,643 451,156 530,891
2 184,425 176,255 183,903
3 327,140 382,268 404,376
4 156,388 159,163 162,166
2013(1) (large_num, dollar)
0 2013(1)
1 440,327
2 124,673
3 337,982
4 120,401
4221 !!! Assessed Valuation and Tax Collection Record | ($000) -----------------
Fiscal Year Ended June 30 (integer, year) \
0 2004
1 2005
2 2006
3 2007
4 2008
Assessed Valuation (large_num, dollar) \
0 22,114,199
1 23,450,861
2 25,198,349
3 28,950,188
4 29,672,033
Total City Tax Levy (large_num, dollar) \
0 25,780
1 28,106
2 30,123
3 33,897
4 34,283
Tax Levy Collections (large_num, dollar) Levy Collected (small_float, rate) \
0 25,118 97.4
1 27,452 97.7
2 29,187 96.9
3 32,324 95.4
4 32,798 95.7
Population (000s) (integer, none) Assessed Valuation (integer, dollar)
0 333 66
1 331 71
2 329 77
3 330 88
4 331 90
4257 !!! CITY OF ANAHEIM | 2014-15 Largest Local Secured Taxpayers | 2014-15 -----------------
Property Owner (other, none) Primary Land Use (other, none) \
0 Walt Disney World Company Theme Park
1 HHC HA Investments II Inc Commercial
2 PPC Anaheim Apartments LLC Apartments
3 Irvine Company LLC Apartments
4 Teachers Insurance & Annuity Association Industrial
Assessed Valuation (large_num, dollar) \
0 4,625,941,193
1 196,532,726
2 113,447,982
3 111,096,095
4 100,855,816
Percentage of 2014-15 Total (small_float, rate)
0 12.80
1 0.54
2 0.31
3 0.31
4 0.28
4364 !!! Page -----------------
--- (other, none) --- (integer, none)
0 Statements of Net Position 18
1 Statements of Revenues, Expenses, and Changes ... 20
2 Statements of Cash Flows 21
3 Notes to Financial Statements 23
4562 !!! Condensed statements of net position -----------------
NaN (other, none) 2014 (large_num, dollar) \
0 NaN 2014
1 Current and other assets 44,285
2 Net utility plant 319,010
3 Deferred outflows of resources 118
4 outflows of resources 363,413
2013 (large_num, none) 2012* (large_num, none)
0 2013 2012*
1 36,905 53,595
2 309,508 293,993
3 168 231
4 346,581 347,819
4738 !!! Condensed statements of | revenues, expenses, and changes in | net position -----------------
NaN (other, none) 2014 (large_num, dollar) 2013 (large_num, none) \
0 NaN 2014 2013
1 Sale of water, net 65,182 60,145
2 Other operating revenues 764 640
3 Interest income 988 788
4 Grants 45 276
2012 (large_num, none)
0 2012
1 57,041
2 707
3 1,119
4 463
5014 !!! -----------------
NaN (other, none) 2014 (large_num, dollar) \
0 NaN 2014
1 Source of water supply 44,142
2 Pumping plant 75,236
3 Transmission and distribution 301,791
4 General plant 8,061
2013 (large_num, none) 2012 (large_num, none)
0 2013 2012
1 43,350 43,350
2 50,003 50,008
3 283,984 280,609
4 7,985 7,030
5106 !!! Managements Discussion and Analysis | June 30, 2014 and 2013 | (In thousands) -----------------
NaN (other, none) 2014 (large_num, dollar) \
0 NaN 2014
1 Water revenue bonds 83,870
2 Notes payable and advances 7,486
3 Total long-term debt outstanding 91,356
4 Current portion 1,943
2013 (large_num, none) 2012 (large_num, none)
0 2013 2012
1 84,790 85,740
2 8,442 9,372
3 93,232 95,112
4 1,876 1,412
5181 !!! 17 | CITY OF ANAHEIM WATER UTILITY FUND | Statements of Net Position | June 30, 2014 and 2013 | (In thousands) -----------------
--- (other, none) --- (large_num, dollar) --- (large_num, none)
0 NaN 2014 2013
1 Source of water supply 44,142 43,350
2 Pumping plant 75,236 50,003
3 Transmission and distribution 301,791 283,984
4 General plant 8,061 7,985
5230 !!! CITY OF ANAHEIM WATER UTILITY FUND | Statements of Net Position | June 30, 2014 and 2013 | (In thousands) | Long-term liabilities: -----------------
--- (other, none) --- (large_num, dollar) \
0 NaN 2014
1 Long-term debt obligations, less current portion 89,787
2 Total long-term liabilities 89,787
3 Current portion of long-term debt 1,943
4 Arbitrage rebate liability 6
--- (large_num, none)
0 2013
1 91,820
2 91,820
3 1,876
4 9
5276 !!! 19 | CITY OF ANAHEIM WATER UTILITY FUND | Statements of Revenues, Expenses, and Changes in Net Position | Years ended June 30, 2014 and 2013 | (In thousands) -----------------
NaN (other, none) 2014 (large_num, dollar) 2013 (large_num, none)
0 NaN 2014 2013
1 Sales of water, net 65,182 60,145
2 Other operating revenues 764 640
3 Total operating revenues 65,946 60,785
4 Purchased water 28,769 27,729
5318 !!! 20 | CITY OF ANAHEIM WATER UTILITY FUND | Statements of Cash Flows | Years ended June 30, 2014 and 2013 | (In thousands) -----------------
NaN (other, none) 2014 (large_num, dollar) \
0 NaN 2014
1 Receipts from customers and users 65,840
2 Receipts from services provided to other fun... 341
3 Payments to suppliers 26,204
4 Payments to employees 13,441
2013 (large_num, none)
0 2013
1 59,728
2 330
3 28,616
4 13,028
5361 !!! CITY OF ANAHEIM WATER UTILITY FUND | Statements of Cash Flows | Years ended June 30, 2014 and 2013 | (In thousands) -----------------
--- (other, none) --- (large_num, dollar) \
0 NaN 2014
1 Operating income 6,268
2 Depreciation 10,534
3 Accounts receivable, net 2
4 Materials and supplies inventory 26
--- (large_num, none)
0 2013
1 7,061
2 9,742
3 (743)
4 (35)
5683 !!! 16429.1 | federal agencies, and government-sponsored enterprises; medium-term corporate notes; | certificates of deposit; bankers acceptances; commercial paper; LAIF; repurchase agreements; | reverse repurchase agreements; and money market mutual funds. | The Water Utility maintains cash equivalents and investments at June 30 with the following | carrying amounts: | Cash equivalents and investments pooled with -----------------
--- (other, none) --- (large_num, dollar) \
0 NaN 2014
1 the Treasurer 27,764
2 Cash equivalents and investments held with tru... 7,201
3 NaN 34,965
--- (large_num, none)
0 2013
1 20,600
2 6,967
3 27,567
5692 !!! Cash equivalents and investments pooled with | At June 30, the Water Utilitys cash equivalents and investments are recorded as follows: -----------------
NaN (other, none) 2014 (large_num, dollar) \
0 NaN 2014
1 Restricted assets cash equivalents and invest... 12,592
2 Unrestricted assets cash equivalents and inve... 22,373
3 NaN 34,965
2013 (large_num, none)
0 2013
1 11,979
2 15,588
3 27,567
5773 !!! GAAP requires disclosure of certain investments in any one issuer that exceeds five | percent concentration of the total investments. At June 30, the following investments | represent five percent or more of the Citys total investments: | Investment -----------------
--- (other, none) --- (large_num, dollar)
0 26% 113,988
1 14% 60,256
2 6% 26,161
3 7% 29,760
4 13% 55,981
5822 !!! At June 30, the following investments represent five percent or more of the Citys total | investments controlled by bond trustees: | Investment -----------------
--- (other, none) --- (large_num, dollar)
0 9% 35,926
1 8% 32,257
2 13% 51,620
3 11% 45,352
4 6% 23,029
5904 !!! Credit -----------------
NaN (other, none) (S&P/ (other, none) June 30, (integer, dollar) \
0 Investments Moodys) 2014
1 U.S. agency securities AA+/Aaa 14,277
2 Medium-term corporate notes AAA/Aaa 1,674
3 Medium-term corporate notes AA+/Aaa 326
4 Medium-term corporate notes A+/A1 1,003
12 months (large_num, none) 13 to 24 (large_num, none) \
0 or less months
1 2,166 1,157
2 NaN 1,204
3 NaN NaN
4 329 330
25 to 36 (large_num, none) 37 to 60 (large_num, none) \
0 months months
1 2,928 8,026
2 326 144
3 326 NaN
4 344 NaN
More than (unknown, none)
0 60 months
1
2
3
4
5952 !!! June 30, 2014 and 2013 | (In thousands) | Credit -----------------
NaN (other, none) (S&P/ (other, none) June 30, (integer, dollar) \
0 Investments Moodys) 2013
1 U.S. agency securities AA+/Aaa 10,557
2 Medium-term corporate notes A-/A3 244
3 Medium-term corporate notes A/A2 523
4 Medium-term corporate notes A+/A1 138
12 months (large_num, none) 13 to 24 (large_num, none) \
0 or less months
1 1,818 2,044
2 NaN NaN
3 NaN 291
4 NaN NaN
25 to 36 (large_num, none) 37 to 60 (large_num, none) \
0 months months
1 2,255 4,440
2 244 NaN
3 232 NaN
4 NaN 138
More than (unknown, none)
0 60 months
1
2
3
4
5999 !!! (In thousands) | The following is a summary of changes in capital assets: -----------------
Source of water supply Pumping plant (other, none) \
0 NaN
1 Source of water supply
2 Source of water supply Pumping plant
3 Transmission and distribution
4 General plant
43,350 50,008 (large_num, dollar) NaN (large_num, none) \
0 2012 Additions
1 43,350 NaN
2 43,350 50,008 NaN
3 280,609 4,313
4 7,030 1,031
(5) (large_num, none) 43,350 50,003 (large_num, none) \
0 Deletions 2013
1 NaN 43,350
2 (5) 43,350 50,003
3 (938) 283,984
4 (76) 7,985
798 25,313 (large_num, none) (6) (80) (large_num, none) \
0 Additions Deletions
1 798 (6)
2 798 25,313 (6) (80)
3 20,226 2,419
4 76 NaN
44,142 75,236 (large_num, none)
0 2014
1 44,142
2 44,142 75,236
3 301,791
4 8,061
6063 !!! 9,100 | fiscal year 2015 with the issuance of new bond financing. | The following is a summary of changes in long-term liabilities: -----------------
June 30, 2014 (other, none) of year (large_num, dollar) \
0 Water revenue bonds 84,790
1 Notes payable 8,442
2 NaN 93,232
3 Less current portion 1,876
4 premium 464
Retirements (large_num, none) End of year (large_num, none) \
0 (920) 83,870
1 (956) 7,486
2 1,876 91,356
3 1,943 1,876
4 NaN (90)
one year (integer, none)
0 960
1 983
2 1,943
3 1,943
4 374
6079 !!! Total long-term -----------------
June 30, 2013 (other, none) of year (large_num, dollar) \
0 Water revenue bonds 85,740
1 Notes payable 9,372
2 NaN 95,112
3 Less current portion 1,412
4 premium 558
Retirements (large_num, none) End of year (large_num, none) \
0 (950) 84,790
1 (930) 8,442
2 1,880 93,232
3 1,876 1,412
4 NaN (94)
one year (integer, none)
0 920
1 956
2 1,876
3 1,876
4 464
6165 !!! -----------------
NaN (integer, year) Principal (large_num, dollar) \
0 2015 1,943
1 2016 2,010
2 2017 2,083
3 2018 2,158
4 2019 2,233
Interest (large_num, none) Total (large_num, none)
0 4,380 6,323
1 4,310 6,320
2 4,238 6,321
3 4,166 6,324
4 4,091 6,324
6215 !!! primarily distribution assets. The Water Utilitys bonds are payable solely from water net | revenues and are payable through fiscal year 2041. As of June 30, 2014 and 2013, the annual | 28.8 | 5,137 | 17,867 | Restricted cash and investments include reserve provisions as well as undisbursed bond | proceeds at June 30 as follows: | Held by fiscal agent: -----------------
--- (other, none) --- (large_num, dollar) \
0 NaN 2014
1 Bond reserve fund 7,201
2 Bond service account 2,363
3 Renewal and replacement account 3,028
4 NaN 12,592
--- (large_num, none)
0 2013
1 6,967
2 2,342
3 2,670
4 11,979
6324 !!! of the Water Utility as of June 30, 2014 and 2013. | At June 30, 2014, the Water Utility had the following commitments with respect to | unfinished capital projects: | Estimated -----------------
Capital project (other, none) \
0 Water Main Relocation Tustin Avenue
1 Pressure Regulating Stations Rehabilitation
2 Well #58 at Anaheim Lake Equipping
Construction commitment (integer, dollar) completion date (integer, year)
0 267 2014
1 392 2015
2 1,432 2015
6464 !!! C-2 | Defeasance Securities means -----------------
--- (integer, none) --- (other, none)
0 1 U.S. Treasury Certificates, Notes and Bonds (i...
1 2 Direct obligations of the Treasury which have ...
2 3 Pre-refunded municipal bonds rated Aaa by Mood...
6594 !!! TIGRS) or obligations the principal of and interest on which are unconditionally | guaranteed by the United States of America. | of the following federal agencies and provided such obligations are backed by the full | faith and credit of the United States of America (stripped securities are only permitted if | they have been stripped by the agency itself): -----------------
--- (integer, none) --- (other, none)
0 1 U.S. Export-Import Bank (Eximbank)
1 2 Farmers Home Administration (FmHA)
2 3 Federal Financing Bank
3 4 Federal Housing Administration Debentures (FHA)
4 5 General Services Administration
6637 !!! Senior debt obligations | Participation Certificates | Senior debt obligations -----------------
--- (integer, none) --- (other, none)
0 3 Federal National Mortgage Association (FNMA or...
1 4 Student Loan Marketing Association (SLMA or Sa...
2 5 Resolution Funding Corp. (REFCORP) obligations
3 6 Farm Credit System
9115 !!! (2) -----------------
--- (integer, year) --- (large_num, dollar)
0 2015 5,792,073
1 2016 7,130,066
2 2017 8,143,910
3 2018 8,151,147
4 2019 8,148,847
--------4_Table_Missing.txt--------
[]
--------EP849915-EP657701-EP1059361.pdf.txt--------
['line 58-72', 'line 208-270', 'line 575-607', 'line 647-651', 'line 771-780', 'line 794-803', 'line 820-829', 'line 843-852', 'line 930-943', 'line 975-990', 'line 1009-1015', 'line 1029-1035', 'line 1052-1058', 'line 1079-1084', 'line 1108-1121', 'line 1174-1195', 'line 1202-1209', 'line 1500-1509', 'line 2318-2326', 'line 2348-2353', 'line 2382-2410', 'line 2430-2451', 'line 2504-2509', 'line 2523-2527', 'line 2545-2564', 'line 2586-2591', 'line 3946-4004', 'line 4013-4071', 'line 4080-4138', 'line 4147-4205', 'line 4214-4272', 'line 4281-4339', 'line 4348-4406', 'line 4415-4473', 'line 4482-4540', 'line 4549-4607', 'line 4616-4636']
58 !!! CITY OF PALM SPRINGS | LIMITED OBLIGATION REFUNDING IMPROVEMENT BONDS | CONSOLIDATED REASSESSMENT DISTRICT NO. 2015-1 | MATURITY SCHEDULE | (Base CUSIP 696661) | 5,855,000 -----------------
Maturity Date September 2 (integer, year) \
0 2017
1 2018
2 2019
3 2020
4 2021
Principal Amount (large_num, dollar) Interest Rate (small_float, rate) \
0 380,000 2.00
1 385,000 2.00
2 385,000 2.00
3 395,000 2.00
4 405,000 2.50
Reoffering Yield (small_float, rate) CUSIP (other, none)
0 1.31 HD2
1 1.79 HE0
2 2.12 HF7
3 2.43 HG5
4 2.59 HH3
208 !!! Los Angeles, California | Verification Agent | Grant Thornton LLP | Minneapolis, Minnesota | TABLE OF CONTENTS -----------------
INTRODUCTION (other, none) 1 (integer, none) \
0 INTRODUCTION 1
1 The City 1
2 The District 1
3 Security and Sources of Repayment for the NaN
4 Bonds 1
Other Possible Claims Upon the Value of a (other, none) NaN (integer, none)
0 Other Possible Claims Upon the Value of a NaN
1 Reassessment Parcel 29
2 Risks Related to Availability of Mortgage NaN
3 Loans NaN
4 Foreclosure and Sale Proceedings 29
575 !!! 6 -----------------
Interest Payment Date (other, none) Principal (large_num, dollar) \
0 9/2/2015 420,000.00
1 3/2/2016 NaN
2 9/2/2016 370,000.00
3 3/2/2017 NaN
4 9/2/2017 380,000.00
Interest (large_num, dollar) Semi-Annual Debt Service (large_num, dollar) \
0 73,403.13 493,403.13
1 86,088.75 86,088.75
2 86,088.75 456,088.75
3 84,331.25 84,331.25
4 84,331.25 464,331.25
Annual Debt Service (large_num, dollar)
0 493,403.13
1 NaN
2 542,177.50
3 NaN
4 548,662.50
647 !!! -----------------
--- (other, none) --- (large_num, dollar)
0 Transfer to Escrow Bank 6,086,693.08
1 Reserve Fund (1) 274,331.25
2 Costs of Issuance Fund (2) 152,404.72
3 Total Uses 6,513,429.05
771 !!! 10 | TABLE NO. 1 | CONSOLIDATED REASSESSMENT DISTRICT NO. 2015-1 | HISTORICAL ASSESSED VALUES | AD 161 -----------------
Fiscal Year 2006/07 (other, year) \
0 Fiscal Year 2006/07
1 2007/08
2 2008/09
3 2009/10
4 2010/11
Assessed Value 102,871,975 (large_num, none) Change NaN (small_float, rate)
0 Assessed Value 102,871,975 NaN
1 108,029,048 5.0
2 107,364,943 0.6
3 88,538,128 17.5
4 81,029,776 8.5
794 !!! TABLE NO. 2 | CONSOLIDATED REASSESSMENT DISTRICT NO. 2015-1 | HISTORICAL ASSESSED VALUES | AD 162 | Villas in -----------------
Year 2006/07 (other, year) Assessed Value 19,058,898 (large_num, none) \
0 Year 2006/07 Assessed Value 19,058,898
1 2007/08 37,535,166
2 2008/09 37,254,145
3 2009/10 31,580,117
4 2010/11 27,921,384
Change Change NaN (small_float, rate) \
0 NaN
1 13.4
2 3.2
3 24.8
4 12.4
Assessed Value 25,300,765 (large_num, none)
0 Assessed Value 25,300,765
1 28,694,096
2 27,787,915
3 20,908,000
4 23,501,193
820 !!! 11 | TABLE NO. 3 | CONSOLIDATED REASSESSMENT DISTRICT NO. 2015-1 | HISTORICAL ASSESSED VALUES | AD 164 -----------------
Fiscal Year 2006/07 (other, year) \
0 Fiscal Year 2006/07
1 2007/08
2 2008/09
3 2009/10
4 2010/11
Assessed Value 28,570,320 (large_num, none) Change NaN (small_float, rate)
0 Assessed Value 28,570,320 NaN
1 73,088,811 255.8
2 67,609,387 7.5
3 52,080,322 23.0
4 46,462,102 10.8
843 !!! TABLE NO. 4 | CONSOLIDATED REASSESSMENT DISTRICT NO. 2015-1 | HISTORICAL ASSESSED VALUES | COMBINED AD 161, AD 162 AND AD 164 | Total All | Assessment Districts -----------------
Fiscal Year 2006/07 (other, year) \
0 Fiscal Year 2006/07
1 2007/08
2 2008/09
3 2009/10
4 2010/11
Assessed Value 175,801,958 (large_num, none) Change NaN (small_float, rate)
0 Assessed Value 175,801,958 NaN
1 247,347,121 40.6
2 240,016,390 3.0
3 193,106,567 19.5
4 178,914,455 7.3
930 !!! CITY OF PALM SPRINGS | CONSOLIDATED REASSESSMENT DISTRICT NO. 2015-1 | SUMMARY LIEN TO ASSESSED VALUE RATIO | (VALUES AS OF JANUARY 1, 2014) -----------------
Value-to-Lien Category (other, none) of Parcels (integer, none) \
0 Watermarke Homes (2) 8
1 Individual (Recent Sale) (3) 1
2 Individual (Recent Sale) (3) 1
3 Individual (Recent Sale) (3) 1
4 Individual (Recent Sale) (3) 1
Assessed Value (large_num, dollar) of the Bonds (large_num, dollar) \
0 398,459 105,331
1 49,807 15,838
2 49,807 15,838
3 49,807 15,838
4 49,807 12,671
Value- To-Lien (1) (small_float, none) % of Total (small_float, rate)
0 3.78 1.6
1 3.14 0.2
2 3.14 0.2
3 3.14 0.2
4 3.93 0.2
975 !!! TABLE NO. 6 | LARGEST PROPERTY OWNERSHIP -----------------
Owner (other, none) of Parcels (integer, none) \
0 Botros Nabil & Botros Asphahan 5
1 H&E Vista Prop 2
2 Habibipour Saied & Habibipour Cynthia 2
3 Karamanoukian Alber 4
4 Kertenian Daniel & Kertenian Suzy 2
Assessed Value (large_num, dollar) of the Bonds (large_num, dollar) \
0 1,349,515 64,384
1 711,212 22,973
2 729,633 27,325
3 929,311 44,426
4 627,869 20,037
% of Total (small_float, rate)
0 1.0
1 0.3
2 0.4
3 0.7
4 0.3
1009 !!! TABLE NO. 7 | AD 161 TAX LEVIES AND COLLECTIONS -----------------
Year (other, none) Levy (large_num, dollar) \
0 2009/10 360,402
1 2010/11 359,737
2 2011/12 355,108
3 2012/13 359,038
4 2013/14 365,595
as of June 30 Year Levied (large_num, dollar) NaN (small_float, rate) \
0 12,082 0.00
1 7,424 0.28
2 7,707 0.56
3 13,520 0.89
4 5,425 1.48
to 6/30/14 as of 6/30/14 as of 6/30/14 (large_num, dollar) \
0 12,082
1 6,434
2 5,708
3 10,312
4 -
NaN (large_num, dollar) NaN (integer, dollar) 12/9/2014 (integer, none)
0 - - -
1 990 - -
2 1,999 496 1
3 3,208 661 1
4 5,425 881 1
1029 !!! TABLE NO. 8 | AD 162 TAX LEVIES AND COLLECTIONS -----------------
Assessment Assessment Year (other, year) Levy (large_num, dollar) \
0 2009/10 107,776
1 2010/11 113,410
2 2011/12 110,491
3 2012/13 108,650
4 2013/14 114,973
Delinquent Delinquent In Collections Delinquent as of June 30 Year Levied (integer, dollar) \
0 1,945
1 676
2 644
3 1,986
4 880
Delinquent NaN (small_float, rate) \
0 0.00
1 0.00
2 0.00
3 0.00
4 0.77
to 6/30/14 as of 6/30/14 as of 6/30/14 (large_num, dollar) \
0 1,945
1 676
2 644
3 1,986
4 -
Delinquent NaN (other, dollar) 12/9/2014 (other, dollar) \
0 - -
1 - -
2 - -
3 - -
4 880 -
Currently Delinquent (other, none)
0 -
1 -
2 -
3 -
4 -
1052 !!! 16 | TABLE NO. 9 | AD 164 TAX LEVIES AND COLLECTIONS -----------------
Assessment Assessment Year (other, year) Levy (large_num, dollar) \
0 2009/10 288,867
1 2010/11 284,988
2 2011/12 285,985
3 2012/13 286,703
4 2013/14 293,565
Delinquent Delinquent In Collections Delinquent as of June 30 Year Levied (large_num, dollar) \
0 8,088
1 4,985
2 18,181
3 18,373
4 3,049
Delinquent NaN (small_float, rate) \
0 0.00
1 0.00
2 0.00
3 0.00
4 1.04
to 6/30/14 as of 6/30/14 as of 6/30/14 (large_num, dollar) \
0 8,088
1 4,985
2 18,181
3 18,373
4 -
Delinquent NaN (other, dollar) Delinquent 12/9/2014 (other, dollar) \
0 - -
1 - -
2 - -
3 - -
4 3,049 -
Currently Delinquent (other, none)
0 -
1 -
2 -
3 -
4 -
1079 !!! TABLE NO. 10 | SUMMARY OF DELINQUENCIES AS OF DECEMBER 9, 2014 | No. of -----------------
APN (other, none) District (integer, none) Owner (other, none) \
0 669-530-015 161 Karamanoukian
1 669-560-022 161 Mackenzie
2 669-560-074 161 Untarya NaN
Delinquency (small_float, dollar) Installments (integer, none) \
0 661.05 1
1 881.46 2
2 NaN 1
Due Date(s) (other, none)
0 4/10/2013
1 4/10/2014
2 4/10/2012
1108 !!! TABLE NO. 11 | CONSOLIDATED REASSESSMENT DISTRICT NO. 2015-1 | FISCAL YEAR 2014/15 TAX RATES -----------------
APN (other, year) \
0 Year Purchased
1 2014/15 Assessed Value
2 Homeowners Exemption
3 Net Assessed Value for Ad Valorem Taxes
4 Ad Valorem Tax Rate (1)
AD 161 669-560-003 (large_num, rate) AD 162 508-103-045 (large_num, rate) \
0 2005 2010
1 196,000 323,000
2 7,000 7,000
3 189,000 316,000
4 1.22485 1.22485
AD 164 669-640-004 (large_num, rate)
0 2013
1 294,000
2 7,000
3 287,000
4 1.22485
1174 !!! TABLE NO. 12 | CITY OF PALM SPRINGS | CONSOLIDATED REASSESSMENT DISTRICT NO. 2015-1 | DIRECT AND OVERLAPPING DEBT -----------------
DIRECT AND OVERLAPPING TAX AND ASSESSMENT DEBT: (other, none) \
0 Desert Community College District General Obli...
1 Palm Springs Unified School District General O...
2 City of Palm Springs Assessment District No. 161
3 City of Palm Springs Assessment District No. 162
4 City of Palm Springs Assessment District No. 164
% Applicable (small_float, rate) Debt 1/1/15 (large_num, dollar)
0 0.289 906,793
1 0.791 2,845,394
2 100 3,280,000
3 100 915,000
4 100 2,910,000
1202 !!! Excludes reassessment bonds to be sold. | Excludes tax and revenue anticipation notes, enterprise revenue, mortgage revenue and non-bonded capital | lease obligations. -----------------
--- (other, dollar) --- (small_float, rate)
0 7,105,000 3.61
1 Total Direct and Overlapping Tax and Assessme... 5.51
2 Gross Combined Total Debt 7.84
3 Net Combined Total Debt 7.84
4 Total Overlapping Tax Increment Debt 1.95
1500 !!! -----------------
Tax Roll (other, year) Percentage (small_float, rate)
0 1981/82 1.000
1 1995/96 1.190
2 1996/97 1.110
3 1998/99 1.853
4 2004/05 1.867
2318 !!! TABLE NO. A-1 | CHANGE IN POPULATION | PALM SPRINGS, SURROUNDING CITIES AND RIVERSIDE COUNTY | 2010 2014 -----------------
Year 2010 (integer, year) Population 44,480 (large_num, none) \
0 Year 2010 Population 44,480
1 2011 44,829
2 2012 45,415
3 2013 45,724
4 2014 46,135
Change Change NaN (small_float, rate) \
0 NaN
1 1.2
2 1.3
3 1.0
4 1.1
Population Change 142,359 (large_num, none) \
0 Population Change 142,359
1 144,996
2 147,004
3 147,790
4 148,758
Population 2,179,692 (large_num, none)
0 Population 2,179,692
1 2,205,731
2 2,234,209
3 2,255,653
4 2,279,967
2348 !!! TABLE NO. A-2 | PER CAPITA INCOME | CITY OF PALM SPRINGS, RIVERSIDE COUNTY, CALIFORNIA AND UNITED STATES (1) | 2009 2013 -----------------
Year (integer, year) Palm Springs (large_num, dollar) \
0 2009 28,883
1 2010 35,974
2 2011 36,875
3 2012 37,498
4 2013 36,920
Riverside County (large_num, dollar) \
0 29,651
1 29,612
2 31,196
3 32,354
4 33,278
State of California (large_num, dollar) United States (large_num, dollar)
0 41,587 39,379
1 42,282 40,144
2 44,749 42,332
3 47,505 44,200
4 48,434 44,765
2382 !!! TABLE NO. A-3 | CITY OF PALM SPRINGS | CIVILIAN LABOR FORCE, EMPLOYMENT AND UNEMPLOYMENT | ANNUAL AVERAGES -----------------
Year (other, none) Labor Force (large_num, none) \
0 City of Palm Springs 26,300
1 Riverside County 917,100
2 California 18,220,100
3 United States 154,142,000
4 City of Palm Springs 26,900
Employment (large_num, none) Unemployment (large_num, none) \
0 23,600 2,700
1 794,400 122,800
2 16,155,000 2,065,100
3 139,877,000 14,265,000
4 23,800 3,100
Rate (small_float, rate)
0 10.4
1 13.4
2 11.3
3 9.3
4 11.3
2430 !!! TABLE NO. A-4 | RIVERSIDE-SAN BERNARDINO-ONTARIO MSA | WAGE AND SALARY WORKERS BY INDUSTRY (1) | (in thousands) -----------------
--- (other, none) --- (small_float, year)
0 Industry 2014
1 Government 231.0
2 Other Services 38.5
3 Leisure and Hospitality 143.2
4 Educational and Health Services 192.9
2504 !!! CITY OF PALM SPRINGS | TOTAL TAXABLE TRANSACTIONS | 2008 2012 -----------------
Year 2008 (integer, year) ($000s) 648,728 (large_num, none) \
0 Year 2008 ($000s) 648,728
1 2009 579,183
2 2010 610,488
3 2011 662,012
4 2012 728,329
% Change % Change NaN (small_float, rate) Permits 1,059 (large_num, none) \
0 NaN Permits 1,059
1 7.6 1,298
2 5.7 1,320
3 9.2 1,409
4 8.6 1,459
($000s) 826,056 (large_num, none) Permits 2,043 (large_num, none)
0 ($000s) 826,056 Permits 2,043
1 763,354 1,865
2 806,540 1,869
3 880,426 1,973
4 955,731 2,036
2523 !!! TABLE NO. A-7 | CHANGE IN TOTAL TAXABLE TRANSACTIONS | PALM SPRINGS AND SURROUNDING CITIES | 2008 2012 | % Change From -----------------
--- (other, none) --- (large_num, dollar) --- (small_float, rate)
0 City 2012 2008 - 2012
1 PALM SPRINGS 955,731 15.7
2 Cathedral City 648,817 0.1
3 Palm Desert 1,470,982 1.6
2545 !!! TABLE NO. A-8 | CITY OF PALM SPRINGS | TAXABLE TRANSACTIONS BY TYPE OF BUSINESS | 2008 2012 -----------------
--- (other, none) --- (large_num, dollar)
0 NaN 2012
1 Accessories Stores 39,934
2 NaN (1)
3 Food and Beverage Stores 49,225
4 Food Services and Drinking Places 193,066
2586 !!! TABLE NO. A-9 | CITY OF PALM SPRINGS | BUILDING ACTIVITY AND VALUATION | 2009/10 - 2013/14 -----------------
NaN (other, none) 2009/10 (large_num, dollar) \
0 Residential 26,296,601
1 Commercial 29,845,959
2 Total Valuation 56,142,560
3 Number of New Residential Units 40
2010/11 (large_num, dollar) 2011/12 (large_num, dollar) \
0 34,155,766 32,659,420
1 63,200,296 46,516,379
2 97,356,062 79,175,799
3 92 111
2012/13 (large_num, dollar) 2013/14 (large_num, dollar)
0 63,187,869 71,555,885
1 36,836,647 55,640,146
2 NaN 127,196,031
3 162 172
3946 !!! D-1 | CITYOFPALMSPRINGSREASSESSMENTDISTRICTNO.20151 | Reassessment -----------------
APN (integer, none) OwnerName (other, none) \
0 669530001 WATERMARKEHOMES
1 669530002 FARLOWCRAIGLEWIS
2 669530003 SHUTAKANDREWM&SHUTAKJANETA
3 669530004 TORREANOROBERT&DENEENKURTIS
4 669530005 HAWARAZAHERM&HAWARARIAM
Land Value Structure Value (large_num, dollar) NaN (large_num, dollar) \
0 49,808 49,808
1 61,000 182,000
2 78,972 184,271
3 82,000 272,000
4 96,058 288,176
Total Value (small_float, none)
0 4.3
1 21.2
2 22.9
3 30.8
4 33.5
4013 !!! D2 | CITYOFPALMSPRINGSREASSESSMENTDISTRICTNO.20151 | Reassessment -----------------
APN (integer, none) OwnerName (other, none) \
0 669540013 KIEUJEFFREYQ&ROHRINGBRETTF
1 669540014 WEECHCRAIGM
2 669540015 CASAGRANDEMARKR&CASAGRANDEDEBORAH
3 669540016 KOLASADANIELJ&KOLASAHELENA
4 669540017 DERSARKISSIANZAREH&DERSARKISSIANANOU
Land Value (large_num, none) Structure Value (large_num, none) \
0 70,545 211,636
1 72,391 217,177
2 62,758 188,275
3 83,000 248,000
4 78,279 234,850
Total Value (large_num, none) Lien (large_num, none) \
0 282,181 11,486
1 289,568 11,486
2 251,033 11,486
3 331,000 11,486
4 313,129 11,486
Value-to-Lien (small_float, none)
0 24.6
1 25.2
2 21.9
3 28.8
4 27.3
4080 !!! D3 | CITYOFPALMSPRINGSREASSESSMENTDISTRICTNO.20151 | Reassessment -----------------
APN (integer, none) OwnerName (other, none) \
0 669550038 MORGANMICHAEL&BOTROSSHERINE
1 669550039 NICHOLSJAMESL
2 669550040 OLSONCLIFFORDG
3 669550041 MORRISKENNETHE&HOSTERMANJAMES
4 669550042 SCHEIDELLTHEODOREF&PAHOLSKILORINM
Land Value (large_num, none) Structure Value (large_num, none) \
0 62,000 188,000
1 44,571 133,714
2 71,000 213,000
3 47,213 142,644
4 62,000 188,000
Total Value (large_num, none) Lien (large_num, none) \
0 250,000 8,551
1 178,285 8,551
2 284,000 8,551
3 189,857 8,551
4 250,000 8,551
Value-to-Lien (small_float, none)
0 29.2
1 20.8
2 33.2
3 22.2
4 29.2
4147 !!! D4 | CITYOFPALMSPRINGSREASSESSMENTDISTRICTNO.20151 | Reassessment -----------------
APN (integer, none) OwnerName (other, none) \
0 669560051 GEZUBEUYUKIANPUZANT&GEZUBEUYUKIANNVA
1 669560052 SALIBLABIBA&SALIBMAGGIEALR
2 669560053 SALIBLABIBA&SALIBNABILAS
3 669560054 POURZANDSAIED&POURZANDSOUMIAB
4 669560055 VASQUEZROBERT
Land Value (large_num, none) Structure Value (large_num, none) \
0 62,000 188,000
1 51,993 155,983
2 65,815 197,457
3 71,250 213,750
4 63,000 187,000
Total Value (large_num, none) Lien (large_num, none) \
0 250,000 8,551
1 207,976 8,551
2 263,272 8,551
3 285,000 8,551
4 250,000 8,551
Value-to-Lien (small_float, none)
0 29.2
1 24.3
2 30.8
3 33.3
4 29.2
4214 !!! D5 | CITYOFPALMSPRINGSREASSESSMENTDISTRICTNO.20151 | Reassessment -----------------
APN (integer, none) OwnerName (other, none) \
0 669570032 JAMESJOYCEANN
1 669570033 PAVELAKJOHNWALTER&PAVELAKKRISTINEA
2 669570034 SPENCERRONALDDAVID&SPENCERBEVERLYB
3 669570035 ALFANOMADELYN
4 669570036 NAPOLIMICHAELJ
Land Value (large_num, none) Structure Value (large_num, none) \
0 97,000 293,000
1 55,249 163,740
2 96,058 293,701
3 53,767 161,303
4 98,000 309,000
Total Value (large_num, none) Lien (large_num, none) \
0 390,000 11,486
1 218,989 11,486
2 389,759 11,486
3 215,070 11,486
4 407,000 11,486
Value-to-Lien (small_float, none)
0 34:1
1 19.1
2 33.9
3 18.7
4 35.4
4281 !!! D6 | CITYOFPALMSPRINGSREASSESSMENTDISTRICTNO.20151 | Reassessment -----------------
APN (integer, none) OwnerName (other, none) \
0 669580047 RENTZSTEPHENB&RENTZWANDAL
1 669580048 TROSTKATHERINE
2 669580049 ADAMSJONROBERTS
3 669580050 MCBAINJOHNT&BLOCHOWSKIKENNETHR
4 669580051 WILLIAMSBRIANA
Land Value (large_num, none) Structure Value (large_num, none) \
0 107,485 321,452
1 91,664 274,992
2 96,000 287,000
3 121,500 283,500
4 59,428 178,285
Total Value (large_num, none) Lien (large_num, none) \
0 428,937 11,486
1 366,656 11,486
2 383,000 11,486
3 405,000 11,486
4 237,713 11,486
Value-to-Lien (small_float, none)
0 37.3
1 31.9
2 33.3
3 35.3
4 20.7
4348 !!! D7 | CITYOFPALMSPRINGSREASSESSMENTDISTRICTNO.20151 | Reassessment -----------------
APN (integer, none) OwnerName (other, none) \
0 508103044 CLARKGREGORYALAN&CLARKMARLYSRAE
1 508103045 BECKETMACDONALDGEORGE
2 508103046 SOUTHPALMHOLDINGS
3 508103047 DOUGLASTHOMASR
4 508103048 SUEROMANUELGUILLERMO&SANCHEZJOSEPH
Land Value (large_num, none) Structure Value (large_num, none) \
0 98,000 296,000
1 81,000 242,000
2 156,000 469,000
3 103,000 311,000
4 82,000 309,000
Total Value (large_num, none) Lien (large_num, none) \
0 394,000 4,587
1 323,000 4,587
2 625,000 4,587
3 414,000 4,587
4 391,000 4,587
Value-to-Lien (small_float, none)
0 85.9
1 70.4
2 136.3
3 90.3
4 85.2
4415 !!! D8 | CITYOFPALMSPRINGSREASSESSMENTDISTRICTNO.20151 | Reassessment -----------------
APN (integer, none) OwnerName (other, none) \
0 669630004 GERACITANOATHENAMARIE
1 669630005 BOTROSNABIL&BOTROSASPHAHANSHAFIK
2 669630006 DUMPITBENIGNOA&DUMPITCORAZONR
3 669630007 ADOBEOILDEVCORP
4 669630008 ACERACHRISTOPHERL&ACERASHAWNAR
Land Value (large_num, none) Structure Value (large_num, none) \
0 80,625 241,875
1 70,545 211,636
2 57,248 171,753
3 44,939 134,820
4 51,000 153,000
Total Value (large_num, none) Lien (large_num, none) \
0 322,500 15,838
1 282,181 15,838
2 229,001 12,671
3 179,759 12,671
4 204,000 12,671
Value-to-Lien (small_float, none)
0 20.4
1 17.8
2 18.1
3 14.2
4 16.1
4482 !!! D9 | CITYOFPALMSPRINGSREASSESSMENTDISTRICTNO.20151 | Reassessment -----------------
APN (integer, none) OwnerName (other, none) Land Value (large_num, none) \
0 669630062 GUPTAMADHUSUDHANT 67,000
1 669630063 GRACIADAVID 72,000
2 669630064 NAIMAKAYLA 99,000
3 669630065 YEECRAIG&CARROLZOANNA 96,905
4 669630066 GUEMIKSIZIANELIZABETHLISA 89,000
Structure Value (large_num, none) Total Value (large_num, none) \
0 202,000 269,000
1 218,000 290,000
2 296,000 395,000
3 290,722 387,627
4 268,000 357,000
Lien (large_num, none) Value-to-Lien (small_float, none)
0 12,671 21.2
1 12,671 22.9
2 15,838 24.9
3 15,838 24.5
4 15,838 22.5
4549 !!! D10 | CITYOFPALMSPRINGSREASSESSMENTDISTRICTNO.20151 | Reassessment -----------------
APN (integer, none) OwnerName (other, none) \
0 669650007 BARELAEDMUNDG
1 669650008 PHILLIPSRICHARDN&PHILLIPSJULIEI
2 669650009 WEINSTOCKDENISE
3 669650010 PATELANARJ
4 669650011 REEDANNL
Land Value (large_num, none) Structure Value (large_num, none) \
0 68,000 228,000
1 66,343 199,033
2 90,000 260,000
3 50,008 150,026
4 88,000 283,000
Total Value (large_num, none) Lien (large_num, none) \
0 296,000 12,671
1 265,376 15,838
2 350,000 15,838
3 200,034 12,671
4 371,000 15,838
Value-to-Lien (small_float, none)
0 23.4
1 16.8
2 22.1
3 15.8
4 23.4
4616 !!! D11 | CITYOFPALMSPRINGSREASSESSMENTDISTRICTNO.20151 | Reassessment -----------------
APN (integer, none) OwnerName (other, none) \
0 669650069 DELISOVICTOREMIL&LOVERSOANTHONYJOH
1 669650070 IADEVAIARUSSELL&GOODRICHSAMUEL
2 669650071 ALLENJASONT
3 669650072 SAHMOEDINIMOHAMMADHADI&SAHMOEDINIS
4 669650073 LABUSFELIPEG&ARROYOFEP
Land Value (large_num, none) Structure Value (large_num, none) \
0 94,503 304,009
1 82,000 248,000
2 62,000 208,000
3 64,000 192,000
4 99,000 296,000
Total Value (large_num, none) Lien (large_num, none) \
0 398,512 15,838
1 330,000 15,838
2 270,000 12,671
3 256,000 12,671
4 395,000 15,838
Value-to-Lien (small_float, none)
0 25.2
1 20.8
2 21.3
3 20.2
4 24.9
--------ER588705-ER457598-ER860368.txt--------
['line 73-93', 'line 212-250', 'line 431-435', 'line 572-575', 'line 578-583', 'line 606-667', 'line 687-718', 'line 814-822', 'line 863-884', 'line 915-937', 'line 969-991', 'line 1050-1057', 'line 1101-1107', 'line 1152-1171', 'line 1624-1629', 'line 1793-1837', 'line 1861-1894', 'line 2529-2535', 'line 2843-2874', 'line 2877-2887', 'line 3135-3147', 'line 3150-3154', 'line 3181-3201', 'line 3229-3240', 'line 3252-3261', 'line 3302-3310', 'line 3330-3337', 'line 3424-3447', 'line 3467-3498', 'line 3514-3518', 'line 3521-3533', 'line 3551-3554', 'line 3568-3574', 'line 3591-3629', 'line 3652-3655', 'line 3725-3731', 'line 4212-4215', 'line 4218-4222', 'line 4331-4337', 'line 4356-4372', 'line 4376-4383', 'line 4424-4428', 'line 4457-4463', 'line 4474-4479', 'line 4520-4533', 'line 4559-4566', 'line 4576-4585', 'line 4649-4657', 'line 4751-4760', 'line 4923-4930', 'line 4964-4988', 'line 5036-5055', 'line 5059-5063', 'line 5118-5123', 'line 5129-5135', 'line 5156-5160', 'line 5166-5172', 'line 5189-5209', 'line 5222-5241', 'line 5298-5301', 'line 5304-5307', 'line 5310-5316', 'line 5328-5331', 'line 5335-5338', 'line 5341-5347', 'line 5366-5370', 'line 5373-5378', 'line 5381-5391', 'line 5403-5407', 'line 5411-5429', 'line 5644-5653', 'line 5660-5681', 'line 5874-5880', 'line 6037-6055', 'line 6076-6083', 'line 6266-6275', 'line 6278-6283', 'line 6286-6311', 'line 6314-6331', 'line 6473-6480', 'line 6483-6496', 'line 6499-6509', 'line 6920-6931', 'line 7057-7060', 'line 7074-7095', 'line 7110-7166', 'line 7173-7228', 'line 7236-7291', 'line 7299-7351', 'line 7613-7643', 'line 7652-7658', 'line 7687-7718', 'line 7723-7750']
| 289,309.10 -----------------
Maturity Date (August 1) (integer, year) \
0 2020
1 2021
2 2022
3 2023
4 2024
Initial Principal Amount (large_num, dollar) \
0 5,725.80
1 5,095.95
2 6,047.20
3 6,727.50
4 7,184.70
Accretion Rate (small_float, rate) Reoffering Yield* (small_float, rate) \
0 12.000 3.190
1 12.000 3.500
2 12.000 3.790
3 12.000 4.100
4 12.000 4.390
Maturity Value (large_num, dollar) CUSIP\r Suffix\r (other, none)
0 15,000.00 BK5\r
1 15,000.00 BL3\r
2 20,000.00 BM1\r
3 25,000.00 BN9\r
4 30,000.00 BP4\r
-----------------
--- (other, none) --- (integer, none)
0 INTRODUCTION 1\r
1 THE BONDS 1\r
2 Authority for Issuance; Purpose 1\r
3 Form and Registration 2\r
4 Payment of Principal and Interest 2\r
-----------------
Redemption Date (August 1) (integer, year) \
0 2039
1 2040
2 2041
3 2042
Principal Amount\r To be Redeemed\r (large_num, dollar)
0 245,000
1 480,000
2 520,000
3 565,000
-----------------
--- (other, none) --- (large_num, dollar)
0 Principal Amount 2,099,309.10
1 Original Issue Premium 234,391.95
2 Total Sources: 2,333,701.05
-----------------
--- (other, none) --- (large_num, dollar)
0 Deposit to Building Fund 2,099,309.10
1 Deposit to Debt Service Fund 57,895.01
2 Underwriters Discount 31,489.64
3 Costs of Issuance (1) 145,007.30
4 Total Uses: 2,333,701.05
-----------------
Aug. 1, 2019 Feb. 1, 2020 (other, none) NaN (large_num, dollar) \
0 Feb. 1, 2013 NaN
1 Aug. 1, 2013 NaN
2 Feb. 1, 2014 NaN
3 Aug. 1, 2014 NaN
4 Feb. 1, 2015 NaN
37,331.25 37,331.25 (large_num, dollar) 74,662.50 \r (large_num, dollar)
0 57,033.85 \r
1 37,331.25 94,365.10
2 37,331.25 \r
3 37,331.25 74,662.50
4 37,331.25 \r
-----------------
August 1 (integer, year) Other Outstanding Bonds (large_num, dollar) \
0 2013 642,642.50
1 2014 610,242.50
2 2015 633,642.50
3 2016 656,067.50
4 2017 677,517.50
The Bonds (large_num, dollar) \
0 94,365.10
1 74,662.50
2 74,662.50
3 74,662.50
4 74,662.50
Total Annual Debt Service\r (large_num, dollar)
0 737,007.60
1 684,905.00
2 708,305.00
3 730,730.00
4 752,180.00
-----------------
NaN (other, year) Secured (large_num, dollar) Utility (integer, dollar) \
0 2004-05 661,307,474 0
1 2005-06 727,573,481 0
2 2006-07 800,976,316 0
3 2007-08 880,555,032 0
4 2008-09 927,160,085 0
Unsecured (large_num, dollar) Total\r (large_num, dollar)
0 17,468,414 678,775,888
1 18,916,620 746,490,101
2 19,602,574 820,578,890
3 22,004,786 902,559,818
4 21,785,256 948,945,341
-----------------
NaN (other, none) 2011-12 Assessed Valuation (1) (large_num, dollar) \
0 Agricultural/Forest 119,140,929
1 Industrial 50,136,272
2 Commercial 16,532,658
3 Hotel 4,363,236
4 Recreational 1,950,367
% of Total (small_float, rate) No. of Parcels (integer, none) \
0 13.22 277
1 5.56 22
2 1.84 40
3 0.48 5
4 0.22 16
% of\r Total\r (small_float, rate)
0 6.38
1 0.51
2 0.92
3 0.12
4 0.37
915 !!! -----------------
2011-12 Assessed Valuation (large_num, dollar) \
0 24,999
1 25,000
2 50,000
3 75,000
4 100,000
No. of Parcels (1) (integer, none) % of Total (small_float, rate) \
0 207 0.481
1 191 1.053
2 147 1.415
3 157 2.072
4 139 2.384
Cumulative % of Total (small_float, rate) \
0 7.756
1 14.912
2 20.420
3 26.302
4 31.510
Total Valuation (large_num, dollar) \
0 3,155,811
1 6,904,208
2 9,275,089
3 13,581,536
4 15,628,360
Cumulative\r % of Total\r (small_float, rate)
0 0.481
1 1.535
2 2.949
3 5.021
4 7.405
-----------------
NaN (integer, none) NaN (other, none) \
0 1 Kistler Vineyards LLC
1 2 Canyon Rock Co. Inc
2 3 Sonoma-Cutrer Vineyards
3 4 Hartford-Jackson LLC
4 5 Silverado Sonoma Vineyards LLC
Primary Land Use (other, none) Assessed Valuation (large_num, dollar) \
0 Winery/Vineyards 16,261,005
1 Sand & Gravel 9,547,113
2 Winery/Vineyards 9,049,926
3 Winery/Vineyards 8,969,572
4 Winery/Vineyards 6,058,406
Total (1)\r (small_float, rate)
0 1.80
1 1.06
2 1.00
3 1.00
4 0.67
-----------------
NaN (other, none) 2007-08 (integer, dollar) \
0 General 1.0000
1 Warm Springs Dam 0070
2 Palm Drive Health Care 0099
3 Forestville Union School District 0320
4 West Sonoma County Union High School District 0115
2008-09 (integer, dollar) 2009-10 (integer, dollar) \
0 1.0000 1.0000
1 0070 0070
2 0055 0054
3 0320 0320
4 0115 0115
2010-11 (integer, dollar) 2011-12\r (integer, dollar)
0 1.0000 1.0000
1 0070 0070\r
2 0055 0055\r
3 0320 0633\r
4 0115 0155\r
-----------------
Fiscal Year (other, year) Secured Tax Charge (large_num, dollar) \
0 2004-05 520,989,000
1 2005-06 564,879,000
2 2006-07 624,236,000
3 2007-08 673,897,000
4 2008-09 688,750,000
June 30 (large_num, dollar) June 30\r (small_float, rate)
0 8,856,000 1.70
1 13,557,000 2.40
2 18,103,000 2.90
3 27,630,000 4.28
4 30,305,000 4.40
-----------------
DIRECT AND OVERLAPPING TAX AND ASSESSMENT DEBT: (other, none) \
0 Sonoma County Joint Community College District
1 West Sonoma County Union High School District
2 Forestville Union School District
3 Palm Drive Health Care District
4 TOTAL DIRECT AND OVERLAPPING TAX AND ASSESSME...
% Applicable (small_float, rate) Debt 3/1/12\r (large_num, dollar)
0 1.559 3,081,020
1 14.319 2,282,961
2 100.000 7,225,111
3 13.440 3,233,664
4 NaN 15,822,756
-----------------
Fiscal Year (other, year) Average Daily Attendance\r (integer, none)
0 2007-08 461\r
1 2008-09 424\r
2 2009-10 408\r
3 2010-11 401\r
4 2011-12(1) 361\r
-----------------
--- (other, none) --- (large_num, dollar)
0 Revenue Limit Sources 2,476,271
1 Federal 240,039
2 Other State 530,478
3 Other Local 488,222
4 Total Revenues 3,735,010
-----------------
--- (other, none) --- (large_num, dollar)
0 State Aid 301,994
1 Property Tax 2,157,329
2 Federal 205,233
3 Other State 450,274
4 Local 353,084
-----------------
Series Name (other, year) Year of Issue (integer, year) \
0 Election 2001, Series 2002 2002
1 Election 2001, Series 2005 2005
2 Election 2001, Series 2006 2006
3 Election 2010, Series 2011 2011
4 2011 General Obligation Refunding 2011
Initial Principal (large_num, dollar) Principal\r (large_num, dollar)
0 3,000,000 1,675,000
1 1,099,588 791,343
2 1,000,358 688,768
3 3,000,000 3,000,000
4 1,070,000 1,070,000
2843 !!! -----------------
--- (other, none) --- (integer, none)
0 Independent Auditors' Report 2\r
1 Management's Discussion and Analysis 4\r
2 Statement of Net Assets 13\r
3 Statement of Activities 14\r
4 Governmental Funds Balance Sheet 15\r
-----------------
--- (other, none) --- (integer, none)
0 an Audit of Financial Statements Performed in ... 62\r
1 Effect on State Programs 64\r
2 Summary of Auditors' Results 67\r
3 Financial Statement Findings 68\r
4 Federal Award Findings and Questioned Costs 69\r
-----------------
--- (other, none) --- (large_num, dollar)
0 NaN 2010\r
1 Cash and investments 2,059,823
2 Other current assets 684,704
3 Capital assets, net 4,204,305
4 Total Assets 6,948,832
-----------------
--- (other, none) --- (large_num, dollar)
0 net of related debt 1,025,865
1 Restricted 1,109,832
2 Unrestricted 940,997
3 Total Net Assets 1,024,964
-----------------
--- (other, none) --- (large_num, dollar)
0 Charges for services 77,318
1 Operating grants and contributions 454,335
2 Federal and State aid not restricted 736,851
3 Property taxes 2,545,357
4 Other general revenues 353,651
-----------------
NaN (other, none) 2011 (large_num, dollar) \
0 NaN 2011
1 Instruction 2,359,140
2 Instruction-Related Services 353,388
3 Pupil Services 72,554
4 General Administration 279,438
2010\r (large_num, dollar)
0 2010\r
1 2,005,567
2 356,611
3 72,048
4 293,458
-----------------
NaN (other, none) July 1, 2010 (large_num, dollar) \
0 General 886,638
1 Cafeteria 3,356
2 Deferred Maintenance 80,660
3 Building 456,505
4 Capital Facilities 11,622
Revenues (large_num, dollar) Expenditures (large_num, dollar) \
0 4,116,139 4,001,936
1 117,894 119,552
2 49,652 64,091
3 3,003,307 462,766
4 13,331 6,788
June 30, 2011\r (large_num, dollar)
0 1,000,841
1 1,698
2 66,221
3 2,997,046
4 18,165
-----------------
NaN (other, none) 2011 (large_num, dollar) \
0 NaN 2011
1 Land 76
2 Construction in progress 458,926
3 Building and improvements 7,481,905
4 Equipment 92,313
2010\r (large_num, dollar)
0 2010\r
1 76\r
2 6,570
3 7,476,569
4 87,080
-----------------
NaN (other, none) 2011 (large_num, dollar) \
0 NaN 2011
1 General obligation bonds 8,017,180
2 Net OPEB obligation 38,926
3 Compensated absences 296,397
4 Bond premiums, net of amortization 416,273
2010\r (large_num, dollar)
0 2010\r
1 5,082,958
2 36,246
3 -\r
4 147,212
-----------------
--- (other, none) --- (large_num, dollar)
0 Deposits and investments 4,338,255
1 Receivables 499,065
2 Prepaid Expenses 415,755
3 Capital assets not depreciated 8,033,220
4 Less: Accumulated depreciation 3,557,814
-----------------
Functions/Programs (other, none) Expenses (large_num, dollar) \
0 Instruction 2,799,549
1 Supervision of instruction 82,571
2 and technology 20,895
3 School site administration 269,324
4 Home-to-school transportation 9,644
Services and Contributions Contributions (other, dollar) \
0 18,251
1 -
2 -
3 3
4 -
Grants and NaN (large_num, dollar) \
0 2,359,140
1 82,571
2 7,644
3 263,173
4 9,644
Governmental\r Activities\r (other, dollar)
0 -
1 -
2 -
3 -
4 -
3514 !!! -----------------
NaN (other, none) General Fund (large_num, dollar) \
0 Deposits and investments 692,629
1 Receivables 490,728
2 Due from other funds 7,464
3 Total Assets 1,190,821
Building Fund (large_num, dollar) Governmental Funds (large_num, dollar) \
0 3,001,257 644,369
1 - 8,337
2 - -
3 3,001,257 652,706
Governmental\r Funds\r (large_num, dollar)
0 4,338,255
1 499,065
2 7,464
3 4,844,784
3521 !!! -----------------
--- (other, none) --- (large_num, dollar)
0 Accounts payable 187,429
1 Due to other funds 7,464
2 Deferred revenue 7,075
3 Total Liabilities 201,968
4 Nonspendable 2,000
3551 !!! -----------------
--- (other, none) --- (large_num, dollar)
0 The cost of capital assets is 8,033,220
1 Accumulated deprecation is 3,557,814
2 Net Capital Assets 4,475,406
3568 !!! -----------------
--- (other, none) --- (large_num, dollar)
0 Bonds payable 8,017,180
1 Bond premium, net of amortization 416,273
2 STRs Golden Handshake 296,397
3 Other postemployment benefits 38,926
4 Total Long-Term Obligations 8,768,776
3591 !!! -----------------
NaN (other, none) General Fund (large_num, dollar) \
0 Revenue limit sources 2,495,209
1 Federal sources 351,306
2 Other State sources 568,868
3 Other local sources 404,359
4 Total Revenues 3,819,742
Building Fund (other, dollar) Governmental Funds (large_num, dollar) \
0 - -
1 - 64,218
2 - 58,348
3 3,307 395,588
4 3,307 518,154
Governmental\r Funds\r (large_num, dollar)
0 2,495,209
1 415,524
2 627,216
3 803,254
4 4,341,203
3652 !!! -----------------
--- (other, none) --- (large_num, dollar)
0 Capital outlay 462,925
1 Depreciation expense 191,824
2 Net Expense Adjustment 271,101
-----------------
--- (other, none) --- (large_num, dollar)
0 Deposits and investments 32,887
1 Total Assets 32,887
2 Due to student groups 32,887
3 Total Liabilities 32,887
4212 !!! -----------------
--- (other, none) --- (large_num, dollar)
0 Governmental activities 4,338,255
1 Fiduciary funds 32,887
2 Total Deposits and Investments 4,371,142
4218 !!! -----------------
--- (other, none) --- (large_num, dollar)
0 Cash on hand and in banks 32,887
1 Cash in revolving accounts 2,000
2 Investments 4,336,255
3 Total Deposits and Investments 4,371,142
-----------------
NaN (other, none) Fund (large_num, dollar) Funds (other, dollar) \
0 Categorical aid 120,588 8,337
1 Categorical aid 113,967 -
2 Apportionment 222,831 -
3 Other State 33,342 -
4 Total 490,728 8,337
Total\r (large_num, dollar)
0 128,925
1 113,967
2 222,831
3 33,342
4 499,065
4356 !!! -----------------
--- (other, none) --- (large_num, dollar) --- (other, dollar)
0 Land 76\r -
1 Construction in Progress 458,926 -
2 Not Being Depreciated 459,002 -
3 Buildings and Improvements 7,481,905 -
4 Furniture and Equipment 92,313 -
-----------------
--- (other, none) --- (large_num, dollar)
0 Instruction 135,010
1 School site administration 11,572
2 Home-to-school transportation 9,644
3 Food services 16,310
4 All other administration 3,858
-----------------
NaN (other, none) General Fund (large_num, dollar) \
0 Due to grantor governenment 65,373
1 Salaries and benefits 78,100
2 All Other Payables 39,432
3 Total 182,905
Governmental\r Fund (large_num, dollar) Funds (integer, dollar) \
0 - -
1 - 313
2 4,211 -
3 4,211 313
Total\r (large_num, dollar)
0 65,373
1 78,413
2 43,643
3 187,429
4457 !!! -----------------
NaN (other, none) July 1, 2010 (large_num, dollar) \
0 General obligation bonds 5,082,958
1 Net OPEB obligation 36,246
2 STRS Golden Handshake -
3 NaN 5,119,204
4 Premiums, net of amortization 147,212
Additions (large_num, dollar) Deductions (large_num, dollar) \
0 3,108,963 174,741
1 2,680 -
2 296,397 -
3 3,408,040 174,741
4 278,019 8,958
June 30, 2011 (large_num, dollar) One Year\r (large_num, dollar)
0 8,017,180 195,233
1 38,926 -\r
2 296,397 37,051
3 8,352,503 232,284
4 416,273 8,958
4474 !!! -----------------
Issue Date (other, none) Maturity Date (other, year) \
0 4/1/2002 2003-2027
1 8/2/2005 2006-2031
2 10/26/2006 2007-2020
3 6/23/2011 2012-2037
Interest Rate (small_float, none) Original Issue (large_num, dollar) \
0 5.00 3,000,000
1 2.60 1,099,588
2 4.00 1,000,358
3 3.00 3,000,000
Outstanding July 1, 2010 (large_num, dollar) \
0 2,915,000
1 1,110,674
2 1,057,284
3 -
Additions/ Accretions (large_num, dollar) Redeemed (large_num, dollar) \
0 - 65,000
1 56,029 29,428
2 52,934 80,313
3 3,000,000 -
Outstanding\r June 30, 2011\r (large_num, dollar)
0 2,850,000
1 1,137,275
2 1,029,905
3 3,000,000
-----------------
Fiscal Year (integer, year) Principal (large_num, dollar) \
0 2012 195,233
1 2013 223,956
2 2014 264,574
3 2015 230,061
4 2016 249,935
Maturity (large_num, dollar) Total\r (large_num, dollar)
0 181,164 376,397
1 297,977 521,933
2 371,599 636,173
3 374,367 604,428
4 376,881 626,816
4559 !!! -----------------
Fiscal Year (integer, year) Total\r (large_num, dollar)
0 2012 37,051
1 2013 37,051
2 2014 37,051
3 2015 37,051
4 2016 37,051
-----------------
--- (other, none) --- (large_num, dollar) \
0 Revolving cash 2,000
1 Other fund activities 7,955
2 Other commitments 3,640,277
3 Reserve for Economic Uncertainty 185,000
4 Undesignated 807,584
--- (other, dollar)
0 -
1 -
2 2,997,046
3 -
4 -
4649 !!! -----------------
--- (other, none) --- (large_num, dollar)
0 Annual required contribution 78,322
1 Interest on net OPEB obligation 1,812
2 Adjustment to annual required contribution -\r
3 Annual OPEB cost (expense) 80,134
4 Contributions made 77,454
4751 !!! -----------------
--- (other, none) --- (large_num, dollar)
0 General Liability 20,000,000
1 Auto Liability 20,000,000
2 Auto Physical Damage Actual Cash Value\r
3 Employee Dishonesty 500,000
4 Boiler and Machinery 2,500,000
-----------------
Type of Position (other, none) Age (integer, none) \
0 Teacher 59
1 Teacher 64
2 Teacher 63
3 Teacher 64
4 Teacher 61
Service Credit (integer, none) Plus Any Interest (large_num, dollar) \
0 26 43,352
1 40 56,066
2 26 53,975
3 15 50,211
4 25 51,166
Postemployment Benefits (large_num, dollar) \
0 13,044
1 5,645
2 13,044
3 2,258
4 -
Salary and Benefits (large_num, dollar) \
0 193,342
1 159,960
2 172,016
3 159,960
4 159,960
Benefits\r Savings\r (large_num, dollar)
0 49,896
1 105,373
2 85,119
3 80,892
4 52,390
-----------------
NaN (other, none) (GAAP Basis) Original (large_num, dollar) \
0 Revenue limit sources 2,436,378
1 Federal sources 241,366
2 Other State sources 466,926
3 Other local sources 443,482
4 Total Revenues 3,588,152
Final (large_num, dollar) Actual (GAAP Basis) (large_num, dollar) \
0 2,486,068 2,495,209
1 342,569 351,306
2 522,722 568,868
3 383,537 404,359
4 3,734,896 3,819,742
Final to\r Actual\r (large_num, dollar)
0 9,141
1 8,737
2 46,146
3 20,822
4 84,846
-----------------
--- (other, none) --- (small_float, none) \
0 ARRA: Title I Basic Grants Low Income and Negl... 84.389
1 Title I - Basic Grants Low-Income and Neglected 84.010
2 Title III - Limited English Proficiency 84.365
3 Title III - Immigrant Education Program 84.365
4 Title II - Teacher Quality 84.367
--- (integer, none) --- (large_num, dollar)
0 15005 2,021
1 14329 104,870
2 14346 2,617
3 15146 2,764
4 14341 36,981
-----------------
--- (other, none) --- (small_float, none) --- (integer, none) \
0 National School Lunch 10.555 13396
1 School Breakfast Program 10.553 13526
--- (large_num, none)
0 58,048
1 6,170
5118 !!! -----------------
NaN (other, none) Annual\r Report\r (integer, none) NaN (integer, none)
0 Kindergarten 32 33\r
1 First through third 37 37\r
2 Fourth through sixth 1 -\r
3 Special education 4 4\r
4 Total Elementary 74 74\r
-----------------
--- (other, none) --- (integer, none)
0 First through third 74\r
1 Fourth through sixth 147\r
2 Seventh and eighth 104\r
3 Total Elementary 325\r
4 Average Daily Attendance Totals 399\r
5156 !!! -----------------
Grade Level (other, none) Actual Minutes (large_num, none) \
0 Kindergarten 52,935
1 Grade 1 49,000
2 Grade 2 49,000
3 Grade 3 49,000
Adjusted & Reduced (large_num, none) \
0 30,625
1 42,933
2 42,933
3 42,933
Minutes Requirement Reduced (large_num, none) \
0 36,000
1 50,400
2 50,400
3 50,400
Adjusted & NaN (large_num, none) \
0 35,000
1 49,000
2 49,000
3 49,000
Traditional Multitrack\r Calendar (integer, none) Calendar (other, none) \
0 178 N/A
1 178 N/A
2 178 N/A
3 178 N/A
Status\r (other, none)
0 Complied\r
1 Complied\r
2 Complied\r
3 Complied\r
5166 !!! -----------------
Grade Level (other, none) Actual Minutes (other, none) \
0 Grade 3 N/A
1 Grade 4 N/A
2 Grade 5 N/A
3 Grade 6 N/A
4 Grade 7 N/A
Adjusted & Reduced (other, none) \
0 N/A
1 N/A
2 N/A
3 N/A
4 N/A
Minutes Requirement Reduced (large_num, none) \
0 50,400
1 54,000
2 54,000
3 54,000
4 54,000
Adjusted & NaN (large_num, none) Actual Minutes (large_num, none) \
0 49,000 51,185
1 52,500 55,515
2 52,500 55,515
3 52,500 57,268
4 52,500 57,268
Traditional Multitrack\r Calendar (integer, none) Calendar (other, none) \
0 178 N/A
1 178 N/A
2 178 N/A
3 178 N/A
4 178 N/A
Status\r (other, none)
0 Complied\r
1 Complied\r
2 Complied\r
3 Complied\r
4 Complied\r
5189 !!! -----------------
--- (other, none) --- (large_num, dollar)
0 Balance, June 30, 2011, Unaudited Actuals 4,660,424
1 Construction in progress 43,650
2 Land improvements 5,336
3 Buildings and improvements 5,233
4 Accumulated depreciation 191,824
-----------------
NaN (other, none) 2012 1 (large_num, dollar) 2011 (large_num, dollar) \
0 NaN 2012 1 2011
1 Revenues 3,398,189 3,819,742
2 Other sources - 296,397
3 and Other Sources 3,398,189 4,116,139
4 Expenditures 3,489,950 3,981,216
2010 (large_num, dollar) 2009\r (large_num, dollar)
0 2010 2009\r
1 3,735,010 4,137,226
2 - -\r
3 3,735,010 4,137,226
4 3,574,776 3,946,319
5298 !!! -----------------
NaN (other, none) Cafeteria Fund (large_num, dollar) \
0 Deposits and investments 1,138
1 Receivables 8,337
2 Total Assets 9,475
Maintenance Fund (large_num, dollar) Facilities\r Fund\r (large_num, dollar)
0 66,221 18,165
1 - -\r
2 66,221 18,165
5304 !!! -----------------
--- (other, none) --- (large_num, none)
0 -\r 313
1 -\r 7,464
2 -\r 7,777
5310 !!! -----------------
Nonspendable Restricted (other, none) - - (large_num, dollar) \
0 Committed 66,221
1 Assigned -
2 Unassigned -
3 Total Fund Balance 66,221
4 Fund Balances 66,221
-\r -\r (large_num, dollar)
0 18,165
1 -\r
2 -\r
3 18,165
4 18,165
-----------------
and Redemption Projects (large_num, dollar) Fund (large_num, dollar) \
0 139,029 419,816
1 - -
2 139,029 419,816
Governmental\r Funds\r (large_num, dollar)
0 644,369
1 8,337
2 652,706
5335 !!! -----------------
--- (other, none) --- (large_num, none)
0 - 313\r
1 - 7,464
2 - 7,777
5341 !!! -----------------
- - (large_num, dollar) -\r -\r (large_num, dollar)
0 419,816 643,231
1 - -\r
2 - 1,698
3 419,816 644,929
4 419,816 652,706
5366 !!! -----------------
NaN (other, none) Cafeteria Fund (large_num, dollar) \
0 Federal sources 64,218
1 Other State sources 5,407
2 Other local sources 27,549
3 Total Revenues 97,174
Maintenance Fund (large_num, dollar) Facilities\r Fund\r (large_num, dollar)
0 - -\r
1 49,308 -\r
2 344 13,331
3 49,652 13,331
-----------------
--- (other, none)
0 -\r
1 -\r
2 3,412
3 -\r
4 3,376
5381 !!! -----------------
Principal Interest (other, none) - - (large_num, dollar) \
0 Total Expenditures 64,091
1 Over Expenditures 14,439
2 Transfers in -
3 Transfers out -
4 Net Financing Sources (Uses) -
-\r -\r (large_num, dollar)
0 6,788
1 6,543
2 -\r
3 -\r
4 -\r
-----------------
and Redemption Projects (integer, dollar) Fund (large_num, dollar) \
0 - -
1 - 3,633
2 884 353,480
3 884 357,113
Governmental\r Funds\r (large_num, dollar)
0 64,218
1 58,348
2 395,588
3 518,154
5411 !!! -----------------
--- (other, dollar) --- (large_num, dollar)
0 - 112,088
1 - 7,464
2 - 67,503
3 - -\r
4 - 3,376
5644 !!! -----------------
NaN (other, none) Procedures in Audit Guide (integer, none) \
0 Attendance reporting 8
1 Kindergarten continuance 3
2 Independent Study 23
3 Continuation education 10
4 School districts 6
Procedures\r Performed\r (other, none)
0 Yes\r
1 Yes\r
2 No, see below\r
3 Not applicable\r
4 Yes\r
-----------------
NaN (other, none) \
0 Ratios of Administrative Employees to Teachers
1 Classroom Teacher Salaries
2 Early retirement incentive
3 Gann limit calculation
4 School Accountability Report Card
Procedures in Audit Guide (integer, none) \
0 1
1 1
2 4
3 1
4 3
Procedures\r Performed\r (other, none)
0 Yes\r
1 Yes\r
2 Yes\r
3 Yes\r
4 Yes\r
-----------------
--- (integer, none) --- (other, none)
0 1 The Bonds constitute valid and binding obligat...
1 2 The Paying Agent Agreement has been duly and l...
2 3 The Board of Supervisors of the County has pow...
6037 !!! -----------------
--- (integer, none) --- (other, none)
0 1 Principal and interest payment delinquencies;\r
1 2 Unscheduled draws on debt service reserves ref...
2 3 Unscheduled draws on credit enhancements refle...
3 4 Substitution of credit or liquidity providers,...
4 5 Adverse tax opinions or issuance by the Intern...
-----------------
--- (integer, none) --- (other, none)
0 2 Modifications to rights of Bond holders;\r
1 3 Optional, unscheduled or contingent Bond calls;\r
2 4 Release, substitution, or sale of property sec...
3 5 Non-payment related defaults;\r
-----------------
(a) (other, none) Safety of Capital (other, none) 1 (integer, none) \
0 Standards of Care NaN 1
1 (a) Safety of Capital 1
2 (b) Liquidity 1
NaN (unknown, none)
0 NaN
1 NaN
2
6278 !!! -----------------
Implementation 2 (integer, none) NaN (other, none) \
0 Implementation 2 NaN
1 5 Participants
2 (a) Statutory Participants
NaN (integer, none)
0 NaN
1 2
2 2
6286 !!! -----------------
6 (integer, none) Authorized Persons 3 (other, none) NaN (integer, none)
0 6 Authorized Persons 3 NaN
1 7 Authorized Investments 3
2 8 Prohibited Investments 3
3 9 Investment Criteria 4 NaN
4 10 Bankers Acceptance 5
6314 !!! -----------------
NaN (integer, none) Voluntary Participants 7 (other, none)
0 7 Delivery & Safekeeping
1 NaN Apportionment of Interest & Costs 7
2 8 Review, Monitoring and Reporting of the Portfolio
3 NaN Limits on Honoraria, Gifts and Gratuities 8
4 Audits 8
6473 !!! -----------------
--- (other, none) --- (integer, none)
0 N/A\r 100
1 N/A\r 100
2 N/A\r 100
-----------------
--- (other, none) --- (integer, none)
0 N/A\r 40
1 A-1/F-1/P-1\r 40
2 N/A\r 30
3 N/A\r 100
4 N/A\r 20
-----------------
--- (other, none) --- (integer, none)
0 A\r 30
1 Aaa & AAAm\r 20
2 AA\r 20
3 N/A\r 20
-----------------
--- (other, none) --- (large_num, dollar)
0 BEGINNING FUND BALANCE (10/01/2011) 1,319,155,124
1 ENDING FUND BALANCE 1,434,401,800
2 AVERAGE DAILY FUND BALANCE 1,334,068,767
3 TOTAL INTEREST EARNED (after fees) 2,955,646
4 INTEREST RATE (after fees) 0.879
7057 !!! 0.50 | 0.00 -----------------
NaN (other, none) Mar-07 (small_float, rate) Jun-07 (small_float, rate) \
0 Pool 4.91 4.99
1 Fed Fund 5.25 5.25
2 LAIF 5.18 5.24
Sep-07 (small_float, rate) Dec-07 (small_float, rate) \
0 5.10 4.88
1 4.75 4.25
2 5.24 4.97
Mar-08 (small_float, rate) Jun-08 (small_float, rate) \
0 4.30 3.25
1 2.25 2.00
2 4.18 3.11
Sep-08 (small_float, rate) Dec-08 (small_float, rate) \
0 3.04 2.84
1 2.00 0.25
2 2.78 2.53
Mar-09 (small_float, rate) ... \
0 2.06 ...
1 0.25 ...
2 1.92 ...
Sep-09 (small_float, rate) Dec-09 (small_float, rate) \
0 1.19 0.94
1 0.25 0.25
2 0.90 0.60
Mar-10 (small_float, rate) Jun-10 (small_float, rate) \
0 1.03 0.93
1 0.25 0.25
2 0.56 0.56
Sep-10 (small_float, rate) Dec-10 (small_float, rate) \
0 0.94 0.70
1 0.25 0.25
2 0.51 0.47
Mar-11 (small_float, rate) Jun-11 (small_float, rate) \
0 0.74 0.70
1 0.25 0.25
2 0.52 0.38
Sep-11 (small_float, rate) Dec-11\r (small_float, rate)
0 0.99 1.00
1 0.25 0.25
2 0.39 0.39
[3 rows x 21 columns]
-----------------
--- (other, none) --- (large_num, dollar)
0 CHECKS AND WARRANTS IN TRANSIT 0\r
1 CASH IN VAULT 107,105
2 CASH IN BANK 29,803,482
3 TREASURY BILLS AND NOTES 190,252,216
4 BANKERS ACCEPTANCES 0\r
-----------------
--- (other, none) --- (integer, year) --- (large_num, none)
0 03/22/2011 21595 50,017,375.63
1 04/08/2011 22073 15,005,177.86
2 04/14/2011 20115 15,021,643.42
3 03/24/2011 36896 40,050,589.30
4 12/14/2011 05983 20,056,136.15
-----------------
--- (other, none) --- (small_float, none) --- (large_num, none)
0 10/06/2011 76104 4,998,429.06
1 12/05/2011 1.00339 9,999,024.64
2 12/22/2011 77845 9,997,522.81
3 12/22/2011 77000 5,000,000.00
4 12/23/2011 82500 5,000,000.00
-----------------
--- (other, none) --- (small_float, none) --- (large_num, none)
0 10/24/2011 1.70000 15,000,000.00
1 10/25/2011 1.50000 10,000,000.00
2 10/26/2011 1.25000 5,000,000.00
3 10/26/2011 1.25000 15,325,000.00
4 10/26/2011 1.25000 10,000,000.00
-----------------
--- (other, none) --- (small_float, none) --- (large_num, none)
0 04/01/2010 3.00000 1,944,735.78
1 05/03/2010 3.00000 1,475,955.95
2 06/01/2010 3.00000 1,809,427.04
3 06/30/2010 3.00000 1,575,351.95
4 08/02/2010 3.00000 1,798,373.82
-----------------
Date (other, none) 08/01/2020 12% (large_num, none) \
0 4/26/2012 1,908.60
1 8/1/2012 1,968.20
2 2/1/2013 2,086.30
3 8/1/2013 2,211.50
4 2/1/2014 2,344.15
08/01/2021 12% (large_num, none) 08/01/2022 12% (large_num, none) \
0 1,698.65 1,511.80
1 1,751.70 1,559.00
2 1,856.80 1,652.55
3 1,968.20 1,751.70
4 2,086.30 1,856.80
08/01/2023 12% (large_num, none) 08/01/2024 12% (large_num, none) \
0 1,345.50 1,197.45
1 1,387.50 1,234.85
2 1,470.75 1,308.95
3 1,559.00 1,387.50
4 1,652.55 1,470.75
08/01/2025 12% (large_num, none) 08/01/2026 12% (large_num, none) \
0 1,065.75 948.50
1 1,099.05 978.15
2 1,164.95 1,036.80
3 1,234.85 1,099.05
4 1,308.95 1,164.95
08/01/2027 12% (large_num, none) 08/01/2028 12% (large_num, none) \
0 844.15 751.30
1 870.55 774.75
2 922.75 821.25
3 978.15 870.55
4 1,036.80 922.75
08/01/2029\r 12%\r (large_num, none)
0 668.65
1 689.55
2 730.90
3 774.75
4 821.25
-----------------
Date (other, none) 08/01/2027 12% (large_num, none) \
0 2/1/2027 4,716.95
1 8/1/2027 5,000.00
2 2/1/2028 NaN
3 8/1/2028 NaN
08/01/2028 12% (large_num, none) 08/01/2029\r 12%\r (large_num, none)
0 4,198.05 3,736.25
1 4,449.95 3,960.45
2 4,716.95 4,198.05
3 5,000.00 4,449.95
-----------------
NaN (other, none) CAB Bond 08/01/2030 (large_num, none) \
0 Date 12%
1 4/26/2012 595.10
2 8/1/2012 613.70
3 2/1/2013 650.50
4 8/1/2013 689.55
CAB Bond 08/01/2031 (large_num, none) CAB Bond 08/01/2032 (large_num, none) \
0 12% 12%
1 529.65 471.35
2 546.15 486.10
3 578.95 515.25
4 613.70 546.15
CAB Bond 08/01/2033 (small_float, none) \
0 12%
1 419.50
2 432.60
3 458.55
4 486.10
CAB Bond 08/01/2034 (small_float, none) \
0 12%
1 373.35
2 385.00
3 408.10
4 432.60
CAB Bond 08/01/2035 (small_float, none) \
0 12%
1 332.30
2 342.65
3 363.25
4 385.00
CAB Bond 08/01/2036 (small_float, none) \
0 12%
1 295.75
2 304.95
3 323.25
4 342.65
CAB Bond 08/01/2037 (small_float, rate) \
0 9.05
1 534.30
2 546.95
3 571.70
4 597.55
CAB Bond 08/01/2038 (large_num, rate) \
0 5.98
1 1,063.80
2 1,080.50
3 1,112.80
4 1,146.05
CAB Bond\r 08/01/2039\r (large_num, rate)
0 5.99
1 1,000.30
2 1,016.00
3 1,046.40
4 1,077.75
-----------------
NaN (other, none) CAB Bond 08/01/2030 (large_num, none) \
0 Date 12%
1 2/1/2027 3,325.25
2 8/1/2027 3,524.80
3 2/1/2028 3,736.25
4 8/1/2028 3,960.45
CAB Bond 08/01/2031 (large_num, none) CAB Bond 08/01/2032 (large_num, none) \
0 12% 12%
1 2,959.45 2,633.90
2 3,137.05 2,791.95
3 3,325.25 2,959.45
4 3,524.80 3,137.05
CAB Bond 08/01/2033 (large_num, none) CAB Bond 08/01/2034 (large_num, none) \
0 12% 12%
1 2,344.15 2,086.30
2 2,484.80 2,211.50
3 2,633.90 2,344.15
4 2,791.95 2,484.80
CAB Bond 08/01/2035 (large_num, none) CAB Bond 08/01/2036 (large_num, none) \
0 12% 12%
1 1,856.80 1,652.55
2 1,968.20 1,751.70
3 2,086.30 1,856.80
4 2,211.50 1,968.20
CAB Bond 08/01/2037 (large_num, rate) CAB Bond 08/01/2038 (large_num, rate) \
0 9.05 5.98
1 1,973.95 2,539.10
2 2,063.30 2,615.00
3 2,156.65 2,693.20
4 2,254.25 2,773.75
CAB Bond\r 08/01/2039\r (large_num, rate)
0 5.99
1 2,390.90
2 2,462.50
3 2,536.25
4 2,612.25
--------6_Unable_to_extract_header_or_table_values.txt--------
[]
--------bw_1054558.pdf.txt--------
[]
--------ER866175-ER676833-ER1078611.pdf.txt--------
['line 79-96', 'line 205-254', 'line 258-297', 'line 561-566', 'line 773-778', 'line 829-851', 'line 993-1002', 'line 1109-1115', 'line 1191-1222', 'line 1332-1341', 'line 1521-1541', 'line 1825-1846', 'line 1877-1928', 'line 1945-1955', 'line 1967-1995', 'line 2014-2081', 'line 2100-2115', 'line 3282-3289', 'line 3347-3352', 'line 5288-5293', 'line 5312-5323', 'line 5342-5356', 'line 5369-5389', 'line 5410-5423', 'line 5438-5451', 'line 5658-5664', 'line 5695-5706', 'line 5713-5725']
79 !!! MATURITY SCHEDULE FOR THE 2015 REFUNDING BONDS -----------------
(September 1) (integer, year) Amount (large_num, dollar) \
0 2017 150,000
1 2018 165,000
2 2019 190,000
3 2020 215,000
4 2021 245,000
Rate (small_float, rate) Yield (small_float, rate) \
0 4.000 1.020
1 5.000 1.300
2 5.000 1.580
3 5.000 1.750
4 5.000 1.960
Price (small_float, none) CUSIP(1) No. (other, none)
0 106.804 769697 HH9
1 111.970 769697 HJ5
2 114.214 769697 HK2
3 116.428 769697 HL0
4 117.976 769697 HM8
205 !!! TABLE OF CONTENTS | Page -----------------
--- (other, year) --- (integer, none)
0 INTRODUCTORY STATEMENT 1
1 The Authority 1
2 The District 1
3 The 2015 Refunding Bonds 2
4 Continuing Disclosure 6
258 !!! i -----------------
--- (other, none) --- (integer, none)
0 Maximum Rates 36
1 Exempt Properties 36
2 Special Taxes Are Not Personal Obligations 37
3 Depletion of Reserve Fund 37
4 Disclosure to Future Property Owners 38
561 !!! The Bonds described in the following table, collectively referred to herein as the Senior Lien -----------------
Name of Prior Senior Lien Bond Issue (other, none) \
0 RNR School Financing Authority Community Facil...
1 RNR School Financing Authority Community Facil...
2 Totals
Principal Amount (large_num, dollar)
0 20,595,000
1 8,420,000
2 29,015,000
773 !!! -----------------
Redemption Date (September 1) (integer, year) \
0 2032
1 2033
2 2034
3 2035
4 2036 (maturity)
Principal Amount To Be Redeemed (large_num, dollar)
0 1,915,000
1 2,060,000
2 2,220,000
3 2,480,000
4 4,470,000
829 !!! The following schedule sets forth the estimated debt service requirements with respect to the | Table 1 | Debt Service Schedule -----------------
(September 1) 2016 (integer, year) Payments NaN (large_num, dollar) \
0 (September 1) 2016 NaN
1 2017 150,000.00
2 2018 165,000.00
3 2019 190,000.00
4 2020 215,000.00
Payments 1,260,181.67 (large_num, dollar) \
0 Payments 1,260,181.67
1 957,100.00
2 951,100.00
3 942,850.00
4 933,350.00
Debt Service 1,260,181.67 (large_num, dollar)
0 Debt Service 1,260,181.67
1 1,107,100.00
2 1,116,100.00
3 1,132,850.00
4 1,148,350.00
993 !!! The Fiscal Agent will apply the proceeds from the sale of the 2015 Refunding Bonds and certain | Table 2 | Estimated Sources and Uses of Funds | Source of Funds -----------------
--- (other, none) --- (large_num, dollar)
0 Principal Amount of 2015 Refunding Bonds 19,560,000.00
1 Less: Underwriters Discount 176,040.00
2 Plus: Net Original Issue Premium 2,550,554.30
3 Plus: Transferred Moneys from Funds for 2006 B... 367,663.99
4 Total Sources 22,302,178.29
1109 !!! Table 3 | RNR School Financing Authority | Community Facilities District No. 92-1 | Maximum Special Tax Rates for Developed and Approved Property | (Fiscal Years 2014-15 and 2015-16) -----------------
Designation (other, none) Zoned Use (other, none) \
0 Developed Single-Family Detached
1 (Entitled) Multiple Residential or Mobile Home
2 Developed Single-Family Detached
3 (Not Entitled) Multiple Residential or Mobile Home
4 NaN Commercial / Industrial
Annual Special Tax [1] (small_float, dollar)
0 451.39
1 170.04
2 606.02
3 228.78
4 0.0534
1191 !!! Community Facilities District No. 92-1 | Estimated Debt Service Coverage -----------------
Date (September 1) (integer, year) \
0 2015
1 2016
2 2017
3 2018
4 2019
from Developed Property (1) (large_num, dollar) \
0 7,047,566.00
1 7,463,534.67
2 7,614,805.36
3 7,769,101.47
4 7,926,483.50
Senior Lien Bonds Debt Service (small_float, dollar) \
0 1,518,254.00
1 902,043.76
2 936,043.76
3 962,843.76
4 991,068.76
Bonds Debt Service (2) (large_num, dollar) \
0 3,247,932.39
1 3,313,318.78
2 2,991,918.78
3 2,704,268.78
4 2,758,668.78
Bonds Debt Service (large_num, dollar) \
0 0.00
1 1,260,181.67
2 1,107,100.00
3 1,116,100.00
4 1,132,850.00
Bonds and Subordinate Bonds (large_num, dollar) \
0 4,766,186.15
1 5,475,544.21
2 5,035,062.54
3 4,783,212.54
4 4,882,587.54
Bonds and Subordinate Bonds (small_float, rate)
0 147.87
1 136.31
2 151.24
3 162.42
4 162.34
1332 !!! Table 5 | RNR School Financing Authority | Community Facilities District No. 92-1 | Outstanding Foreclosure Actions | (As of March 1, 2015) -----------------
Fiscal Year of Special Tax Levy (other, year) \
0 2004-05
1 2005-06
2 2006-07
3 2007-08
4 2008-09
Number of Parcels (integer, none) \
0 1
1 1
2 1
3 2
4 2
Total Amount Foreclosed (large_num, dollar)
0 487.43
1 497.18
2 507.12
3 1,034.88
4 1,055.20
1521 !!! Table 6 | RNR School Financing Authority | Community Facilities District No. 92-1 | Assessed Property Values | (Fiscal Year 2014-15) | Developed | Developed | Developed -----------------
NaN (other, none) Entitled (other, none) 0 (integer, none) \
0 NaN Entitled 0
1 NaN Non-Entitled 119,472
2 NaN Commercial/Industrial 25,910
3 NaN Approved 0
4 NaN Totals 145,382
0 (large_num, none)
0 442,982,824
1 1,541,713,277
2 2,685,657
3 77,461,876
4 2,064,843,634
1825 !!! RNR School Financing Authority | Community Facilities District No. 92-1 | Top 20 Special Tax Payers Within the District | (Fiscal Year 2014-15) -----------------
Owner (1) (other, none) Approved Parcels (integer, none) \
0 Lennar Homes Of California Inc. (4) 64
1 Castle & Cooke California Inc. (4) 62
2 Polo Villas Partners LLC 0
3 Symbolic Inv & Operating Co LLC (4) 46
4 Estancia Valley LLC (4) 39
Approved Acreage (2) (small_float, none) Developed Parcels (integer, none) \
0 11.71 297
1 9.9 55
2 0.00 1 (5)
3 7.36 47
4 9.53 40
Total Parcels (integer, none) Special Tax Levy (3) (large_num, dollar) \
0 361 60,593.30
1 117 34,177.22
2 1 30,950.64
3 93 27,220.13
4 79 25,209.24
2014-15 Special Tax Levy (small_float, rate)
0 0.81
1 0.46
2 0.42
3 0.37
4 0.34
1877 !!! History of Special Tax Levies | (July 1 Through June 30, | Fiscal Years 2005-06 Through 2014-15) | % of Fiscal -----------------
--- (other, none) --- (large_num, dollar) --- (small_float, rate)
0 Entitled 1,021,398 24.90
1 Non-Entitled 3,013,053 73.44
2 Approved 68,085 1.66
3 Sub Total 4,102,535 100.00
4 Entitled 1,232,188 24.29
1945 !!! RNR School Financing Authority | Community Facilities District No. 92-1 | Special Tax Collections and Delinquencies | (Fiscal Years 2005-06 Through 2014-15) | Remaining -----------------
Fiscal Year (other, none) Amount Levied (large_num, dollar) \
0 2005-06 4,102,535.42
1 2006-07 5,072,573.00
2 2007-08 5,421,503.00
3 2008-09 5,939,093.00
4 2009-10 6,081,587.06
Parcels Levied (large_num, none) Amount Collected (large_num, dollar) \
0 592 3,897,905.34
1 12,280 4,902,647.29
2 12,668 5,167,693.50
3 13,482 5,741,962.14
4 13,470 5,941,543.55
Amount Delinquent (large_num, dollar) \
0 205,128.95
1 169,925.71
2 253,809.50
3 197,130.86
4 140,043.51
Parcels Delinquent Delinquent (integer, none) \
0 851
1 503
2 713
3 650
4 384
Percent NaN (small_float, rate) \
0 5.00
1 3.35
2 4.68
3 3.32
4 2.30
Delinquent as of June 30, 2014 (large_num, dollar) \
0 497.18
1 507.12
2 1,067.51
3 2,469.73
4 6,493.41
Delinquent as of June 30, 2014 (small_float, rate)
0 0.01
1 0.01
2 0.02
3 0.04
4 0.11
1967 !!! The following table sets forth a representative property tax bill for a single-family detached unit | within the District for Fiscal Year 2014-15. | Table 10 | RNR School Financing Authority | Community Facilities District No. 92-1 | Representative Property Tax Bill for Fiscal Year 2014-15 | Ad Valorem Property Taxes -----------------
--- (other, none) --- (small_float, rate) \
0 Assessed Value [1] NaN
1 Homeowner's Exemption NaN
2 Net Assessed Value NaN
3 General Purposes 1.00000
4 Kern Delta Water District Zone 7 0.02478
--- (small_float, dollar)
0 NaN
1 NaN
2 NaN
3 1,930.70
4 47.84
2014 !!! The following table sets forth the direct and overlapping debt for the District as of | Table 11 | RNR School Financing Authority | Community Facilities District No. 92-1 | Direct and Overlapping Debt -----------------
Description on Tax Bill (other, none) Type Total Parcels (other, year) \
0 Description on Tax Bill Type Total Parcels
1 All Ad Valorem Charges AVALL
2 City of Bakersfield AD No. 01-1 1915
3 City of Bakersfield AD No. 01-3 1915
4 City of Bakersfield AD No. 02-1 1915
NaN (large_num, dollar) Total Levy (large_num, dollar) \
0 NaN Total Levy
1 385,635 608,912,882
2 550 164,134
3 1,324 366,943
4 556 143,486
% Applicable (small_float, rate) Parcels (integer, none) \
0 % Applicable Parcels
1 7.67266 15,572
2 38.01945 154
3 63.04097 810
4 75.52446 381
Levy (large_num, dollar)
0 Levy
1 46,719,819.68
2 62,402.76
3 231,324.30
4 108,367.12
2100 !!! Table 11 | RNR School Financing Authority | Community Facilities District No. 92-1 | Direct and Overlapping Debt | (Continued) -----------------
Outstanding Direct and Overlapping Bonded Debt (other, none) \
0 Fruitvale School District GOB 1994
1 Fruitvale School District GOB 2006
2 Kern Community College District SRID GOB 2002
3 Kern High School District GOB 1990
4 Kern High School District GOB 2004
Type (other, none) Issued (large_num, dollar) \
0 GOB 14,500,000
1 GOB 15,871,159
2 GOB 179,996,081
3 GOB 97,500,000
4 GOB 190,151,209
Outstanding (large_num, dollar) % Applicable (small_float, rate) \
0 5,935,000 0.01387
1 14,472,409 0.01387
2 143,629,533 4.79666
3 57,730,000 8.65329
4 128,881,209 8.65329
Parcels (large_num, none) Amount (large_num, dollar)
0 1 823
1 1 2,007
2 15,572 6,889,415
3 15,572 4,995,546
4 15,572 11,152,468
3282 !!! TABLE I | Maximum Annual Special Taxes for Developed Property | Not Classified as Entitled Property | Community Facilities District No. 92-1 | (Fiscal Year 1992-93) | Zones | Mobile Home Zones -----------------
--- (integer, none) --- (other, none) \
0 1 392.00
1 2 148.00
2 3 Commercial/Industrial Property
--- (other, dollar)
0 NaN
1 NaN
2 0348 per sq. ft. of Gross Floor Area
3347 !!! that period are: -----------------
Fiscal Year NaN (other, none) \
0 1992-93
1 1993-94
2 1994-95
Annual Special Tax (Zoning Class 1) (small_float, dollar) \
0 0.00
1 200.00
2 200.00
Annual Special Tax (Zoning Class 2) (small_float, dollar)
0 0.00
1 75.00
2 75.00
5288 !!! Table D-1 | Population Data | Bakersfield and the County -----------------
Year (integer, year) City of Bakersfield (large_num, none) \
0 2010 (1) 347,483
1 2011 350,020
2 2012 354,471
3 2013 360,633
4 2014 367,315
Unincorporated Area of County (large_num, none) \
0 297,932
1 300,559
2 303,788
3 307,436
4 310,213
Incorporated Area of County (large_num, none) Kern County (large_num, none)
0 541,699 839,631
1 543,921 844,480
2 546,194 849,982
3 553,428 861,164
4 562,879 873,092
5312 !!! Table D-2 | Kern County | Civilian Labor Force, Employment, and Unemployment | Annual Averages | (Calendar Years 2004-2014) -----------------
Year (integer, year) Labor Force (large_num, none) \
0 2004 315,800
1 2005 327,500
2 2006 336,900
3 2007 345,700
4 2008 359,700
Employment (large_num, none) Unemployment (large_num, none) \
0 284,400 31,300
1 299,900 27,600
2 311,500 25,400
3 317,400 28,300
4 324,500 35,100
Rate (small_float, rate)
0 9.9
1 8.4
2 7.5
3 8.2
4 9.8
5342 !!! Table D-3 | Kern County Labor Market | Wage and Salary Employment | Annual Averages | (2010 to 2014) -----------------
--- (other, none) --- (large_num, year)
0 Industry 2014 (1)
1 Agriculture (Farm) 55,700
2 Mining and Logging 12,700
3 Construction 19,300
4 Manufacturing 14,600
5369 !!! The major employers within the County as of January 2015 are listed in the following table. | Table D-4 | Kern County Major Employers | (as of January 1, 2015) -----------------
Company (other, none) Business Type (other, none) \
0 Edwards Air Force Base Federal Government National Security
1 Grimmway Farms Agriculture
2 U.S. Naval Air Warfare Center Federal Government National Security
3 U.S. Navy Public Affairs Office Federal Government National Security
4 American Honda Motor Co Automotive Manufacturing
Number of Employees (large_num, none)
0 10,000
1 5,000
2 5,000
3 5,000
4 1,000
5410 !!! City of Bakersfield | Assessed Valuation of Principal Taxpayers | (June 30, 2014) | 2013-14 -----------------
Taxpayer (1) (other, none) Assessed Valuation (large_num, dollar) \
0 Chevron USA Inc 201,845,664
1 Nestle Holdings Inc 196,422,345
2 Valley Plaza Mall LP 125,013,540
3 WalMart Real Estate BSNS Trust 90,072,683
4 California Water Service Company 83,735,182
Percentage of Total Assessed Valuation (small_float, rate)
0 0.89
1 0.86
2 0.55
3 0.40
4 0.37
5438 !!! 5,954,794,000 | Table D-6 | City of Bakersfield | Taxable Retail Sales 2009 through 2012 | (000s) -----------------
NaN (other, none) 2009 (large_num, dollar) \
0 NaN 2009
1 Motor Vehicles and Parts Dealers 631,773
2 Home Furnishings and Appliance Stores 170,486
3 Bldg. Materials and Garden Equip. and Supplies 268,924
4 Food and Beverage Stores 212,056
2010 (large_num, dollar) 2011 (large_num, dollar) 2012 (large_num, dollar)
0 2010 2011 2012
1 694,631 862,869 1,067,814
2 166,364 188,226 203,522
3 261,174 290,507 310,438
4 204,016 211,361 222,062
5658 !!! any other Subordinate Bonds Outstanding. | E-2 -----------------
--- (integer, none) --- (other, none)
0 2 Balance in the Reserve Fund (including all Sen...
1 3 Special Tax delinquency rate for the most rece...
2 4 Concerning delinquent parcels:
5695 !!! Section 5. Reporting of Significant Events. -----------------
--- (integer, none) --- (other, none)
0 1 Principal and interest payment delinquencies.
1 2 Non-payment related defaults, if material.
2 3 Unscheduled draws on debt service reserves ref...
3 4 Unscheduled draws on credit enhancements refle...
4 5 Substitution of any credit or liquidity provid...
5713 !!! or final determinations of taxability, Notices of Proposed Issue (IRS Form 5701-TEB), or other | material notices or determination with respect to the tax status of the security or other material | events affecting the tax status of the security. | E-3 -----------------
--- (integer, none) --- (other, none)
0 7 Modifications to rights of security holders, i...
1 8 Bond calls, if material, and tender offers.
2 9 Defeasances.
3 10 Release, substitution, or sale of property sec...
4 11 Rating changes.
--------1_File_Too_Small.txt--------
[]
In [ ]:
test_string ="""
The following table sets forth statistical information relating to the Water System during the five
Fiscal Years shown.
TABLE 1
WATER SYSTEM STATISTICS
Fiscal Year Ended June 30
2014 2013 2012 2011 2010
Anaheim Population Served .................................. 348,305 346,161 343,793 341,034 336,265
Population Served Outside City (Est.) ................... 8,457 9,000 9,000 9,000 9,000
Total Population Served ........................... 356,762 355,161 352,793 350,034 345,265
Total Water Sales (Million Gallons) ................... 20,740 20,465 19,672 19,526 20,488
Capacity (Million Gallons Per Day)
From MWD Connections ................................... 110 110 110 110 110
From Water System Wells (Average) ............... 79 86 88 81 75
Total Supply Capacity ............................. 189 196 198 191 185
Treatment Plant Capacity .................................. 15 15 15 15 15
Peak Day Distribution (Million Gallons) ............... 82.2 78.7 79.2 87.2 87.2
Average Daily Distribution (Million Gallons) ....... 60.3 58.9 57.3 59.4 56.1
Average Daily Sales Per Capita (Gallons) ............. 159.3 157.9 152.8 152.8 162.6
__________________
Source: Anaheim
Existing Facilities
""".decode('ascii', 'ignore').split("\n")
In [ ]:
rows = [row_feature(l) for l in test_string]
tables = [rows[b:e] for b,e in filter_row_spans(rows, row_qualifies)]
table = tables[0]
s = structure_rows(table, rows[b-4:b])
print s[0]
In [ ]:
test_string ="""
CALIFORNIA MUNICIPAL FINANCE AUTHORITY
Revenue Bonds, Series 2015-A
(City of Anaheim Water System Project)
MATURITY SCHEDULE
$58,205,000 Serial Bonds
Maturity Date Principal Interest
(October 1) Amount Rate Yield CUSIP†
2015 $ 775,000 2.000% 0.100% 13048TTV5
2016 1,575,000 2.000 0.300 13048TTW3
2017 1,620,000 3.000 0.660 13048TTX1
2018 1,675,000 4.000 0.930 13048TTY9
2019 2,045,000 5.000 1.150 13048TTZ6
2020 2,155,000 5.000 1.320 13048TUA9
2021 2,250,000 4.000 1.520 13048TUB7
2022 2,610,000 5.000 1.670 13048TUC5
2023 2,730,000 4.000 1.810 13048TUD3
2024 2,875,000 5.000 1.920 13048TUE1
2025 3,025,000 5.000 2.030(c) 13048TUF8
2026 3,190,000 5.000 2.200(c) 13048TUG6
2027 3,355,000 5.000 2.320(c) 13048TUH4
2028 3,520,000 5.000 2.450(c) 13048TUJ0
2029 3,700,000 5.000 2.520(c) 13048TUK7
2030 3,880,000 5.000 2.600(c) 13048TUL5
2031 4,055,000 4.000 3.140(c) 13048TUM3
2032 4,220,000 4.000 3.190(c) 13048TUN1
2033 4,390,000 4.000 3.230(c) 13048TUP6
2034 4,560,000 4.000 3.270(c) 13048TUQ4
$24,535,000 4.000% Term Bonds due October 1, 2040 – Yield: 3.400%(c); CUSIP†: 13048TUR2
$13,145,000 5.250% Term Bonds due October 1, 2045 – Yield: 2.970%(c); CUSIP†: 13048TUS0
""".decode('ascii', 'ignore').split("\n")
In [ ]:
for file in os.listdir('txt'):
print ("--------" + file + "--------")
with codecs.open('txt/'+file, "r", "utf-8") as f:
lines = [l.encode('ascii', 'ignore').replace('\n', '') for l in f]
rows = [row_feature(l) for l in lines]
for b,e in filter_row_spans(rows, row_qualifies):
print "TABLE STARTING AT LINE", b
table = rows[b:e]
structure, data, headers = structure_rows(table, rows[b-config['meta_info_lines_above']:b])
print headers
captions = [(col['value'] if 'value' in col.keys() else "---") +" (%s, %s)" % (col['type'], col['subtype']) for col in structure]
print captions
for r in data:
cols = [col['value']+" (%s, %s)" % (col['type'], col['subtype']) for col in r]
print len(cols), cols
In [ ]:
rstr ="""
Population Served Outside City (Est.) ................... 8,457 9,000 9,000 9,000 9,000
Total Population Served ........................... 356,762 355,161 352,793 350,034 345,265
""".decode('ascii', 'ignore').split("\n")
for r in rstr:
print "split", re.split(tokenize_pattern, r)
print "token", [v['value'] for v in row_feature(r)], row_feature(r)
In [ ]:
#subtype_indicator['test'] = r'.*\$.*'
for sub, indicator in subtype_indicator.iteritems():
print sub, indicator, re.match(indicator, " .......................................................... $ ")
In [ ]:
Content source: ahirner/TabulaRazr-OS
Similar notebooks: