View In:
ArcGIS Online Map Viewer
Name: Manholes
Display Field: structtype
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Service Item Id: da3f359a214a4ba9b765e92fccc1e6e5
Copyright Text:
Default Visibility: true
MaxRecordCount: 2000
MaxSelectionCount: 0
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.0
Max Scale: 0.0
Supports Advanced Queries: true
Supports Statistics: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
XMin: 475055.37359999865
YMin: 204952.21660000086
XMax: 503905.77899999917
YMax: 225290.7767000012
Spatial Reference: 26985
(26985)
LatestVCSWkid(0)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: structtype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: N/A
UniqueValueInfos:
-
Value: BLOWOFF
Label: Blowoff
Description: N/A
Symbol:
-
Value: MANHOLE
Label: Manhole
Description: N/A
Symbol:
-
Value: OUTFALL
Label: Outfall
Description: N/A
Symbol:
-
Value: ABANDONED
Label: Abandoned Manhole
Description: N/A
Symbol:
-
Value: AIR RELEASEVALVE
Label: Air Release Valve
Description: N/A
Symbol:
-
Value: SHUTOFF VALVE
Label: Shutoff Valve
Description: N/A
Symbol:
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Calibri
Font Style: italic
Font Weight: bold
Font Decoration: none
Min. Scale: 0.0
Max. Scale: 0.0
Feature Draw Order:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: true
HasM: true
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: structtype
Fields:
-
objectid
(
nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID
)
-
coord_y
(
modelName: coord_y, nullable: true, editable: true, defaultValue: null, alias: COORD_Y, type: esriFieldTypeDouble
)
-
coord_x
(
modelName: coord_x, nullable: true, editable: true, defaultValue: null, alias: COORD_X, type: esriFieldTypeDouble
)
-
coord_z
(
modelName: coord_z, nullable: true, editable: true, defaultValue: null, alias: COORD_Z, type: esriFieldTypeDouble
)
-
manhole_id
(
modelName: manhole_id, nullable: true, editable: true, defaultValue: null, alias: MANHOLE_ID, type: esriFieldTypeDouble
)
-
down
(
modelName: down, nullable: true, editable: true, defaultValue: null, alias: DOWN, type: esriFieldTypeDouble
)
-
structurei
(
modelName: structurei, nullable: true, editable: true, defaultValue: null, alias: STRUCTUREI, type: esriFieldTypeDouble
)
-
structtype
(
modelName: structtype, nullable: true, editable: true, defaultValue: null, length: 16, alias: STRUCTTYPE, type: esriFieldTypeString
)
-
structdesc
(
modelName: structdesc, nullable: true, editable: true, defaultValue: null, length: 40, alias: STRUCTDESC, type: esriFieldTypeString
)
-
date1
(
modelName: date1, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: DATE1, type: esriFieldTypeDate
)
-
time1
(
modelName: time1, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: TIME1, type: esriFieldTypeDate
)
-
weather
(
modelName: weather, nullable: true, editable: true, defaultValue: null, length: 16, alias: WEATHER, type: esriFieldTypeString
)
-
strctconst
(
modelName: strctconst, nullable: true, editable: true, defaultValue: null, length: 16, alias: STRCTCONST, type: esriFieldTypeString
)
-
crew
(
modelName: crew, nullable: true, editable: true, defaultValue: null, length: 50, alias: CREW, type: esriFieldTypeString
)
-
flowdepth
(
modelName: flowdepth, nullable: true, editable: true, defaultValue: null, alias: FLOWDEPTH, type: esriFieldTypeDouble
)
-
location
(
modelName: location, nullable: true, editable: true, defaultValue: null, length: 16, alias: LOCATION, type: esriFieldTypeString
)
-
address
(
modelName: address, nullable: true, editable: true, defaultValue: null, length: 150, alias: ADDRESS, type: esriFieldTypeString
)
-
scharge
(
modelName: scharge, nullable: true, editable: true, defaultValue: null, alias: SCHARGE, type: esriFieldTypeSmallInteger
)
-
scharge_de
(
modelName: scharge_de, nullable: true, editable: true, defaultValue: null, alias: SCHARGE_DE, type: esriFieldTypeDouble
)
-
dsilt
(
modelName: dsilt, nullable: true, editable: true, defaultValue: null, alias: DSILT, type: esriFieldTypeSmallInteger
)
-
dsilt_dept
(
modelName: dsilt_dept, nullable: true, editable: true, defaultValue: null, alias: DSILT_DEPT, type: esriFieldTypeDouble
)
-
rehabilita
(
modelName: rehabilita, nullable: true, editable: true, defaultValue: null, alias: REHABILITA, type: esriFieldTypeSmallInteger
)
-
dryweather
(
modelName: dryweather, nullable: true, editable: true, defaultValue: null, alias: DRYWEATHER, type: esriFieldTypeSmallInteger
)
-
immediate_
(
modelName: immediate_, nullable: true, editable: true, defaultValue: null, alias: IMMEDIATE_, type: esriFieldTypeSmallInteger
)
-
ph
(
modelName: ph, nullable: true, editable: true, defaultValue: null, alias: PH, type: esriFieldTypeDouble
)
-
temp
(
modelName: temp, nullable: true, editable: true, defaultValue: null, alias: TEMP, type: esriFieldTypeDouble
)
-
lastrain
(
modelName: lastrain, nullable: true, editable: true, defaultValue: null, length: 16, alias: LASTRAIN, type: esriFieldTypeString
)
-
infiltrati
(
modelName: infiltrati, nullable: true, editable: true, defaultValue: null, length: 16, alias: INFILTRATI, type: esriFieldTypeString
)
-
inrate_gpm
(
modelName: inrate_gpm, nullable: true, editable: true, defaultValue: null, alias: INRATE_GPM, type: esriFieldTypeDouble
)
-
activeflow
(
modelName: activeflow, nullable: true, editable: true, defaultValue: null, alias: ACTIVEFLOW, type: esriFieldTypeSmallInteger
)
-
erosion_ma
(
modelName: erosion_ma, nullable: true, editable: true, defaultValue: null, length: 16, alias: EROSION_MA, type: esriFieldTypeString
)
-
erosion_ob
(
modelName: erosion_ob, nullable: true, editable: true, defaultValue: null, alias: EROSION_OB, type: esriFieldTypeSmallInteger
)
-
developmen
(
modelName: developmen, nullable: true, editable: true, defaultValue: null, length: 254, alias: DEVELOPMEN, type: esriFieldTypeString
)
-
street_nam
(
modelName: street_nam, nullable: true, editable: true, defaultValue: null, length: 254, alias: STREET_NAM, type: esriFieldTypeString
)
-
address_pr
(
modelName: address_pr, nullable: true, editable: true, defaultValue: null, length: 50, alias: ADDRESS_PR, type: esriFieldTypeString
)
-
address_su
(
modelName: address_su, nullable: true, editable: true, defaultValue: null, length: 50, alias: ADDRESS_SU, type: esriFieldTypeString
)
-
mwo_genera
(
modelName: mwo_genera, nullable: true, editable: true, defaultValue: null, alias: MWO_GENERA, type: esriFieldTypeSmallInteger
)
-
cancelled_
(
modelName: cancelled_, nullable: true, editable: true, defaultValue: null, length: 68, alias: CANCELLED_, type: esriFieldTypeString
)
-
datalink
(
modelName: datalink, nullable: true, editable: true, defaultValue: null, alias: DATALINK, type: esriFieldTypeInteger
)
-
structur_1
(
modelName: structur_1, nullable: true, editable: true, defaultValue: null, alias: STRUCTUR_1, type: esriFieldTypeDouble
)
-
map_id
(
modelName: map_id, nullable: true, editable: true, defaultValue: null, alias: MAP_ID, type: esriFieldTypeInteger
)
-
meta_id
(
modelName: meta_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: META_ID, type: esriFieldTypeString
)
-
media_id
(
modelName: media_id, nullable: true, editable: true, defaultValue: null, length: 25, alias: MEDIA_ID, type: esriFieldTypeString
)
-
coord_id
(
modelName: coord_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: COORD_ID, type: esriFieldTypeString
)
-
dispostn_d
(
modelName: dispostn_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: DISPOSTN_D, type: esriFieldTypeString
)
-
use_d
(
modelName: use_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: USE_D, type: esriFieldTypeString
)
-
type_d
(
modelName: type_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: TYPE_D, type: esriFieldTypeString
)
-
mat_d
(
modelName: mat_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: MAT_D, type: esriFieldTypeString
)
-
no_pipes
(
modelName: no_pipes, nullable: true, editable: true, defaultValue: null, alias: NO_PIPES, type: esriFieldTypeSmallInteger
)
-
mh_width
(
modelName: mh_width, nullable: true, editable: true, defaultValue: null, alias: MH_WIDTH, type: esriFieldTypeDouble
)
-
mh_length
(
modelName: mh_length, nullable: true, editable: true, defaultValue: null, alias: MH_LENGTH, type: esriFieldTypeDouble
)
-
mh_dia
(
modelName: mh_dia, nullable: true, editable: true, defaultValue: null, alias: MH_DIA, type: esriFieldTypeDouble
)
-
dim_u_d
(
modelName: dim_u_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: DIM_U_D, type: esriFieldTypeString
)
-
rim_elv
(
modelName: rim_elv, nullable: true, editable: true, defaultValue: null, alias: RIM_ELV, type: esriFieldTypeDouble
)
-
invert_elv
(
modelName: invert_elv, nullable: true, editable: true, defaultValue: null, alias: INVERT_ELV, type: esriFieldTypeDouble
)
-
elv_u_d
(
modelName: elv_u_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: ELV_U_D, type: esriFieldTypeString
)
-
drain_ty_d
(
modelName: drain_ty_d, nullable: true, editable: true, defaultValue: null, length: 16, alias: DRAIN_TY_D, type: esriFieldTypeString
)
-
manuf_id
(
modelName: manuf_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: MANUF_ID, type: esriFieldTypeString
)
-
model_no
(
modelName: model_no, nullable: true, editable: true, defaultValue: null, length: 12, alias: MODEL_NO, type: esriFieldTypeString
)
-
basin_id
(
modelName: basin_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: BASIN_ID, type: esriFieldTypeString
)
-
reportdate
(
modelName: reportdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ReportDate, type: esriFieldTypeDate
)
-
strcrating
(
modelName: strcrating, nullable: true, editable: true, defaultValue: null, length: 254, alias: StrcRating, type: esriFieldTypeString
)
-
jointrting
(
modelName: jointrting, nullable: true, editable: true, defaultValue: null, length: 254, alias: JointRting, type: esriFieldTypeString
)
-
i_i_rating
(
modelName: i_i_rating, nullable: true, editable: true, defaultValue: null, length: 254, alias: I_I_Rating, type: esriFieldTypeString
)
-
srchgerate
(
modelName: srchgerate, nullable: true, editable: true, defaultValue: null, length: 254, alias: SrchgeRate, type: esriFieldTypeString
)
-
rootrating
(
modelName: rootrating, nullable: true, editable: true, defaultValue: null, length: 254, alias: RootRating, type: esriFieldTypeString
)
-
maintrting
(
modelName: maintrting, nullable: true, editable: true, defaultValue: null, length: 254, alias: MaintRting, type: esriFieldTypeString
)
-
repairdate
(
modelName: repairdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: RepairDate, type: esriFieldTypeDate
)
-
repairdesc
(
modelName: repairdesc, nullable: true, editable: true, defaultValue: null, length: 254, alias: RepairDesc, type: esriFieldTypeString
)
-
contractor
(
modelName: contractor, nullable: true, editable: true, defaultValue: null, length: 254, alias: Contractor, type: esriFieldTypeString
)
-
yearbuilt
(
modelName: yearbuilt, nullable: true, editable: true, defaultValue: null, length: 254, alias: YearBuilt, type: esriFieldTypeString
)
-
notes
(
modelName: notes, nullable: true, editable: true, defaultValue: null, length: 254, alias: Notes, type: esriFieldTypeString
)
-
photolink
(
modelName: photolink, nullable: true, editable: true, defaultValue: null, length: 254, alias: PHOTOLINK, type: esriFieldTypeString
)
-
sde_link
(
modelName: sde_link, nullable: true, editable: true, defaultValue: null, length: 254, alias: SDE_LINK, type: esriFieldTypeString
)
-
localphoto
(
modelName: localphoto, nullable: true, editable: true, defaultValue: null, length: 254, alias: LocalPhoto, type: esriFieldTypeString
)
-
nguid
(
modelName: nguid, nullable: true, editable: true, defaultValue: null, length: 255, alias: NGUID, type: esriFieldTypeString
)
-
globalid
(
nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID
)
-
asbuilts
(
modelName: asbuilts, nullable: true, editable: true, defaultValue: null, length: 255, alias: AsBuilts, type: esriFieldTypeString
)
Types:
ID: BLOWOFF
Name: Blowoff
Domains:
Templates:
-
Name: BLOWOFF
Description:
Prototype:
drain_ty_d: null
notes: null
infiltrati: null
erosion_ob: null
structtype: BLOWOFF
repairdesc: null
datalink: null
use_d: null
no_pipes: null
strcrating: null
down: null
flowdepth: null
model_no: null
maintrting: null
time1: null
mh_length: null
rootrating: null
weather: null
media_id: null
manuf_id: null
scharge: null
strctconst: null
dim_u_d: null
i_i_rating: null
repairdate: null
cancelled_: null
developmen: null
localphoto: null
lastrain: null
mh_dia: null
contractor: null
erosion_ma: null
address_pr: null
elv_u_d: null
reportdate: null
nguid: null
basin_id: null
crew: null
type_d: null
mwo_genera: null
photolink: null
map_id: null
scharge_de: null
rim_elv: null
srchgerate: null
street_nam: null
jointrting: null
immediate_: null
inrate_gpm: null
structurei: null
mh_width: null
temp: null
coord_id: null
address: null
address_su: null
dsilt_dept: null
meta_id: null
structdesc: null
manhole_id: null
activeflow: null
mat_d: null
coord_x: null
coord_y: null
date1: null
structur_1: null
dryweather: null
yearbuilt: null
dispostn_d: null
coord_z: null
dsilt: null
ph: null
invert_elv: null
sde_link: null
location: null
asbuilts: null
rehabilita: null
Drawing Tool: esriFeatureEditToolPoint
ID: MANHOLE
Name: Manhole
Domains:
Templates:
-
Name: MANHOLE
Description:
Prototype:
drain_ty_d: null
notes: null
infiltrati: null
erosion_ob: null
structtype: MANHOLE
repairdesc: null
datalink: null
use_d: null
no_pipes: null
strcrating: null
down: null
flowdepth: null
model_no: null
maintrting: null
time1: null
mh_length: null
rootrating: null
weather: null
media_id: null
manuf_id: null
scharge: null
strctconst: null
dim_u_d: null
i_i_rating: null
repairdate: null
cancelled_: null
developmen: null
localphoto: null
lastrain: null
mh_dia: null
contractor: null
erosion_ma: null
address_pr: null
elv_u_d: null
reportdate: null
nguid: null
basin_id: null
crew: null
type_d: null
mwo_genera: null
photolink: null
map_id: null
scharge_de: null
rim_elv: null
srchgerate: null
street_nam: null
jointrting: null
immediate_: null
inrate_gpm: null
structurei: null
mh_width: null
temp: null
coord_id: null
address: null
address_su: null
dsilt_dept: null
meta_id: null
structdesc: null
manhole_id: null
activeflow: null
mat_d: null
coord_x: null
coord_y: null
date1: null
structur_1: null
dryweather: null
yearbuilt: null
dispostn_d: null
coord_z: null
dsilt: null
ph: null
invert_elv: null
sde_link: null
location: null
asbuilts: null
rehabilita: null
Drawing Tool: esriFeatureEditToolPoint
ID: OUTFALL
Name: Outfall
Domains:
Templates:
-
Name: OUTFALL
Description:
Prototype:
drain_ty_d: null
notes: null
infiltrati: null
erosion_ob: null
structtype: OUTFALL
repairdesc: null
datalink: null
use_d: null
no_pipes: null
strcrating: null
down: null
flowdepth: null
model_no: null
maintrting: null
time1: null
mh_length: null
rootrating: null
weather: null
media_id: null
manuf_id: null
scharge: null
strctconst: null
dim_u_d: null
i_i_rating: null
repairdate: null
cancelled_: null
developmen: null
localphoto: null
lastrain: null
mh_dia: null
contractor: null
erosion_ma: null
address_pr: null
elv_u_d: null
reportdate: null
nguid: null
basin_id: null
crew: null
type_d: null
mwo_genera: null
photolink: null
map_id: null
scharge_de: null
rim_elv: null
srchgerate: null
street_nam: null
jointrting: null
immediate_: null
inrate_gpm: null
structurei: null
mh_width: null
temp: null
coord_id: null
address: null
address_su: null
dsilt_dept: null
meta_id: null
structdesc: null
manhole_id: null
activeflow: null
mat_d: null
coord_x: null
coord_y: null
date1: null
structur_1: null
dryweather: null
yearbuilt: null
dispostn_d: null
coord_z: null
dsilt: null
ph: null
invert_elv: null
sde_link: null
location: null
asbuilts: null
rehabilita: null
Drawing Tool: esriFeatureEditToolPoint
ID: ABANDONED
Name: Abandoned Manhole
Domains:
Templates:
-
Name: ABANDONED
Description:
Prototype:
drain_ty_d: null
notes: null
infiltrati: null
erosion_ob: null
structtype: ABANDONED
repairdesc: null
datalink: null
use_d: null
no_pipes: null
strcrating: null
down: null
flowdepth: null
model_no: null
maintrting: null
time1: null
mh_length: null
rootrating: null
weather: null
media_id: null
manuf_id: null
scharge: null
strctconst: null
dim_u_d: null
i_i_rating: null
repairdate: null
cancelled_: null
developmen: null
localphoto: null
lastrain: null
mh_dia: null
contractor: null
erosion_ma: null
address_pr: null
elv_u_d: null
reportdate: null
nguid: null
basin_id: null
crew: null
type_d: null
mwo_genera: null
photolink: null
map_id: null
scharge_de: null
rim_elv: null
srchgerate: null
street_nam: null
jointrting: null
immediate_: null
inrate_gpm: null
structurei: null
mh_width: null
temp: null
coord_id: null
address: null
address_su: null
dsilt_dept: null
meta_id: null
structdesc: null
manhole_id: null
activeflow: null
mat_d: null
coord_x: null
coord_y: null
date1: null
structur_1: null
dryweather: null
yearbuilt: null
dispostn_d: null
coord_z: null
dsilt: null
ph: null
invert_elv: null
sde_link: null
location: null
asbuilts: null
rehabilita: null
Drawing Tool: esriFeatureEditToolPoint
ID: AIR RELEASEVALVE
Name: Air Release Valve
Domains:
Templates:
-
Name: AIR RELEASEVALVE
Description:
Prototype:
drain_ty_d: null
notes: null
infiltrati: null
erosion_ob: null
structtype: AIR RELEASEVALVE
repairdesc: null
datalink: null
use_d: null
no_pipes: null
strcrating: null
down: null
flowdepth: null
model_no: null
maintrting: null
time1: null
mh_length: null
rootrating: null
weather: null
media_id: null
manuf_id: null
scharge: null
strctconst: null
dim_u_d: null
i_i_rating: null
repairdate: null
cancelled_: null
developmen: null
localphoto: null
lastrain: null
mh_dia: null
contractor: null
erosion_ma: null
address_pr: null
elv_u_d: null
reportdate: null
nguid: null
basin_id: null
crew: null
type_d: null
mwo_genera: null
photolink: null
map_id: null
scharge_de: null
rim_elv: null
srchgerate: null
street_nam: null
jointrting: null
immediate_: null
inrate_gpm: null
structurei: null
mh_width: null
temp: null
coord_id: null
address: null
address_su: null
dsilt_dept: null
meta_id: null
structdesc: null
manhole_id: null
activeflow: null
mat_d: null
coord_x: null
coord_y: null
date1: null
structur_1: null
dryweather: null
yearbuilt: null
dispostn_d: null
coord_z: null
dsilt: null
ph: null
invert_elv: null
sde_link: null
location: null
asbuilts: null
rehabilita: null
Drawing Tool: esriFeatureEditToolPoint
ID: SHUTOFF VALVE
Name: Shutoff Valve
Domains:
Templates:
-
Name: SHUTOFF VALVE
Description:
Prototype:
drain_ty_d: null
notes: null
infiltrati: null
erosion_ob: null
structtype: SHUTOFF VALVE
repairdesc: null
datalink: null
use_d: null
no_pipes: null
strcrating: null
down: null
flowdepth: null
model_no: null
maintrting: null
time1: null
mh_length: null
rootrating: null
weather: null
media_id: null
manuf_id: null
scharge: null
strctconst: null
dim_u_d: null
i_i_rating: null
repairdate: null
cancelled_: null
developmen: null
localphoto: null
lastrain: null
mh_dia: null
contractor: null
erosion_ma: null
address_pr: null
elv_u_d: null
reportdate: null
nguid: null
basin_id: null
crew: null
type_d: null
mwo_genera: null
photolink: null
map_id: null
scharge_de: null
rim_elv: null
srchgerate: null
street_nam: null
jointrting: null
immediate_: null
inrate_gpm: null
structurei: null
mh_width: null
temp: null
coord_id: null
address: null
address_su: null
dsilt_dept: null
meta_id: null
structdesc: null
manhole_id: null
activeflow: null
mat_d: null
coord_x: null
coord_y: null
date1: null
structur_1: null
dryweather: null
yearbuilt: null
dispostn_d: null
coord_z: null
dsilt: null
ph: null
invert_elv: null
sde_link: null
location: null
asbuilts: null
rehabilita: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query
Sync Can Return Changes: true
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: true
Supports ApplyEdits By Upload Id: true
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Child Resources:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Top Features
Query Bins
Append
Validate SQL
Generate Renderer
Return Updates
Metadata
Update Metadata